jeudi 5 mai 2016

Object cannot be cast from DBNull to other types. ASP.net

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