When i run my website I am facing the error here which is Object cannot be cast from DBNull to other types the .aspx code is below
<ItemTemplate>
<asp:CheckBox ID="Checkedac" runat="server" Visible="true" OnCheckedChanged="Checkedac_OnCheckedChanged"
AutoPostBack="True" Checked='<%# Convert.ToBoolean(Eval("Active")) %>' yourID='<%#Eval("UserID") %>'
Text='<%# Eval("Active").ToString().Equals("True") ? " DeActive " : " Active " %>'></asp:CheckBox>
</ItemTemplate>
and the CS code is
public void Checkedac_OnCheckedChanged(object sender, EventArgs e)
{
CheckBox cb = sender as CheckBox;
string userid = cb.Attributes["yourID"];
bool status = cb.Checked;
string constr = ConfigurationManager.ConnectionStrings["WebPOS"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("UPDATE UserProfile SET Active = @Relocate WHERE UserID = @UserID"))
{
cmd.Connection = con;
cmd.Parameters.Add("@Relocate", SqlDbType.Bit).Value = status;
cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = Convert.ToInt32(userid);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
can any one help what i am missing?
Aucun commentaire:
Enregistrer un commentaire