Add null values to the Database table

Question

Hi I have a group box that contains 5 text boxes and 5 masked textboxes. I wrote the code when user enters the data into all controls than user clicks button the data saved into database table. Here is my problem: when the user doesnt want to enter data into some textboxes.I want to add it into the database with out any error. Actually my present code giving me error if user leaves one text box also. How can i do it? Darma

Vulpes · Answer

You'll need to convert to strings to avoid this problem: (DateTime.TryParse(maskedTextBox1.Text out dtparsedDate) ? dtparsedDate.ToString() : null) Notice that it's never necessary to explicitly test whether a bool expression is true. Notice also that it's not necessary to convert dtParsedDate to a DateTime as it's a DateTime already.

darma teja · Answer

Hi Vulpes Santhosh thanks allot for your fast replies. If i don't convert null to datetime it is giving me error. because: you can check this one: if i write like this it is giving me error of can not implicit conversion between system.datetime and null (DateTime.TryParse(maskedTextBox1.Text out dtparsedDate) == true ? Convert.ToDateTime(dtparsedDate) : null) Darma

Vulpes · Answer

darma If you use Convert.ToDateTime(null) when building your SQL command then you'll end with a string containing this: 01/01/0001 00:00:00 which may be an invalid value for the corresponding column in the database. Santhosh's point is that you should use null instead which should then be translated to NULL in the database assuming (Hemant's point) that the column allows nulls.

Santhosh Kumar Jayaraman · Answer

Then check whether the columns tyou are tring to insert allow null values. also check whether any integer columns.IIf there are integer columns then check and do conversion before insert

darma teja · Answer

Hi Santhosh If user does not enters the date it is working well. Only my problem with textboxes only. Darma

Santhosh Kumar Jayaraman · Answer

Why you are converting null to datetime..Just save it as null. No conversion needed

darma teja · Answer

Hi Here is my code: DateTime dtparsedDate = new DateTime(); string insertsql = insert into Table1 (ProjectId ID PID Nr note Out Target Delivery name Out1 Target1 Delivery1 Notes)  + values (' + CmbProjectid.Text + ' ' + ID.SelectedItem + ' ' + textBox1.Text + ' ' + textBox2.Text + ' ' + textBox3.Text + ' ' + (DateTime.TryParse(maskedTextBox1.Text out dtparsedDate) == true ? Convert.ToDateTime(dtparsedDate) : Convert.ToDateTime(DBNull.Value)) + ' ' + (DateTime.TryParse(maskedTextBox2.Text out dtparsedDate) == true ? Convert.ToDateTime(dtparsedDate) : Convert.ToDateTime(null)) + ' ' + (DateTime.TryParse(maskedTextBox3.Text out dtparsedDate) == true ? Convert.ToDateTime(dtparsedDate) : Convert.ToDateTime(null)) + ' ' + textBox4.Text + ' ' + (DateTime.TryParse(maskedTextBox4.Text out dtparsedDate) == true ? Convert.ToDateTime(dtparsedDate) : Convert.ToDateTime(null)) + ' ' + (DateTime.TryParse(maskedTextBox5.Text out dtparsedDate) == true ? Convert.ToDateTime(dtparsedDate) : Convert.ToDateTime(null)) + ' ' + (DateTime.TryParse(maskedTextBox6.Text out dtparsedDate) == true ? Convert.ToDateTime(dtparsedDate) : Convert.ToDateTime(null)) + ' ' + textBox4.Text + ');; SqlCommand insertcmd = new SqlCommand(insertsql con1); insertcmd.ExecuteNonQuery(); MessageBox.Show(Data Added Successfully Information MessageBoxButtons.OK MessageBoxIcon.Information); Is user does not enter data in one textbox than it is giving error. Whatever user does not enter the data that should save in the table1 as nulls. Darma

Santhosh Kumar Jayaraman · Answer

Show us ur c# code

Hemant Kumar · Answer

You have to alter the table column property as Allow Null =True.Then you can insert the null values also.