{"Cannot insert the value NULL into column 'name', table 'C:\\DOCUMENTS AND SETTINGS\\ADMINISTRATOR\\DESKTOP\\ARTICLE 17\\SIMPLE LOGIN PROJECT IN ASP.NET\\APP_DATA\\MYDB.MDF.dbo.myTb'; column does not allow nulls. INSERT fails.\r\nThe statement has been terminated."}
I have following MSSQL server database
*************************************
id int Unchecked
name varchar(100) Unchecked
username varchar(100) Unchecked
password varchar(100) Unchecked
emailid varchar(100) Unchecked
I am following code in Default.aspx page
*******************************************
InsertCommand="INSERT INTO myTb(name, username, password, emailid) VALUES (@name, @username, @password, @emailid)" SelectCommand="SELECT myTb.* FROM myTb">
I have following code in default.aspx.cs page
***************************************
protected void create_Click(object sender, EventArgs e)
{
SqlDataSource1.Insert();
}
Then, why I am facing the error like 'name' can not be null. Is something missing there?

Abhimanyu K VatsaPosted Jun 12, 2010, 3:03 AM
It is fixed now...........using
//Now we will set-up form fields
pram[0].Value = name;
pram[1].Value = username;
pram[2].Value = password;
pram[3].Value = emailid;