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