i want to insert data into database. but if there are no records and i click on the button.so no data should be inserted. please check my codes
What I have tried:
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=MYDB;Integrated Security=True");
con.Open();
SqlCommand cmd;
string query = "insert into Employee(ID,Name, Age, Department, Salary, DateOFBirth) values(@ID,@Name, @Age, @Department, @Salary, @DateOFBirth)";
cmd = new SqlCommand(query,con);
if (cmd.CommandText == "")
{
cmd.Parameters.AddWithValue("@ID",null);
cmd.Parameters.AddWithValue("@Name",null);
cmd.Parameters.AddWithValue("@Age",null);
cmd.Parameters.AddWithValue("@Department",null);
cmd.Parameters.AddWithValue("@Salary",null);
cmd.Parameters.AddWithValue("@DateOFBirth",null);
}
else
{
cmd.Parameters.AddWithValue("@ID", textBox1.Text);
cmd.Parameters.AddWithValue("@Name", textBox2.Text);
cmd.Parameters.AddWithValue("@Age", textBox3.Text);
cmd.Parameters.AddWithValue("@Department", textBox4.Text);
cmd.Parameters.AddWithValue("@Salary", textBox5.Text);
cmd.Parameters.AddWithValue("@DateOFBirth", textBox6.Text);
}
cmd.ExecuteNonQuery();
con.Close();