Why cannot insert all the values in the database?

[karenkksh]

Hi,

The user_id is set as primary key.
"Cannot insert the value NULL into column 'user_id', table 'C:\DOCUMENTS AND SETTINGS\KAREN\MY DOCUMENTS\VISUAL STUDIO 2005\WEBSITES\WEBSITE1\APP_DATA\DB.MDF.dbo.users'; column does not allow nulls. INSERT fails.
The statement has been terminated." after debugging it.

protected void btnAdd_Click(object sender, EventArgs e)
{
SqlConnection MyConnection;
SqlCommand MyCommand;

MyConnection = new SqlConnection();
MyConnection.ConnectionString =
ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
MyConnection.Open();

MyCommand = new SqlCommand("StoredProcedure1", MyConnection);
MyCommand.CommandType = CommandType.StoredProcedure;
MyCommand.Parameters.Add("@user_login", txtUserLogin.Text);
MyCommand.Parameters.Add("@user_password", txtPassword.Text);
MyCommand.Parameters.Add("@user_name", txtName.Text);
MyCommand.Parameters.Add("@user_position", txtPosition.Text);
MyCommand.Parameters.Add("@user_hp", "+6" + txtHpA.Text + txtHpB.Text);
MyCommand.Parameters.Add("@user_email", txtEmail.Text);
MyCommand.Parameters.Add("@user_dept", txtDept.Text);
MyCommand.Parameters.Add("@user_date_added", DateTime.Today.ToString());

if (CBActive.Checked == true)
{
MyCommand.Parameters.Add("@user_is_approved", 1);
}
else
{
MyCommand.Parameters.Add("@user_is_approved", -1);
}

MyCommand.ExecuteScalar();

MyConnection.Close();
Response.Redirect("UserView.aspx?admin_id=" + Request.QueryString["admin_id"]);
}
Plz help.

Tq.

Karen

[Plater]

That seems pretty darn obvious to me.
That column is the primary key and is left null.
Don't leave it null and your insert should work fine.

[kunal pawar]

Hi,

Here userid_id is not passed so query try to insert column as NULL, and primary is not null. so it throw an exception. Please pass user_id or make autonumber

To make column autonumber in sql server set property identity as yes and
identity speed =1 and identity increment=1