How to insert bit type value in database?

Question

hello guys how r u ?

my question is that, i am trying this code...

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using DataSet1TableAdapters;

public partial class _Default : System.Web.UI.Page 

{

    UsersTableAdapter insertUser;

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void btnSubmit_Click(object sender, EventArgs e)

    {

        insertUser = new UsersTableAdapter();

        insertUser.Insert(txtUserName.Text, txtPassword.Text, txtSuperPassword.Text, ddlActive.SelectedItem.Text, Convert.ToBoolean(ddlActive.SelectedValue.ToString()));

        Response.Write("inserted...");

    }

}

but data is not being insert into database 

what is the problem  kindly guide me ...


Reply Soon

Thanks