0
Answer

cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar).Value = Session["UserLogin"];

Session["UserLogin"] = HttpContext.Current.User.Identity.Name;

cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar).Value = Session["UserLogin"];

this is working but no data shown in table field.
tell how to do it.