boysilent
جمعه 18 آذر 1390, 20:55 عصر
اقا سلام این مشکل برنامه منه همش اجرا میشه تا این قسمت nonquery
if (textBox3.Text != "" & textBox4.Text != "" & textBox5.Text != "" & textBox6.Text != "" & textBox7.Text != "" & textBox8.Text != "" & textBox9.Text != "")
{
con.ConnectionString = cs;
con.Open();
cmd.Connection = con;
da.SelectCommand = cmd;
cmd.CommandText = "INSERT INTO table_2 (name,ghj,fij,sod,ghkol,datep,datee,oper) VALUES (@nname,@nghj,@nfij,@nsod,@nghkol,@ndatep,@ndatee, @noper)";
cmd.Parameters.AddWithValue("@nname", textBox4.Text);
cmd.Parameters.AddWithValue("@nghj", textBox3.Text);
cmd.Parameters.AddWithValue("@nfij", textBox5.Text);
cmd.Parameters.AddWithValue("@nsod", textBox6.Text);
cmd.Parameters.AddWithValue("@nghkol",textBox7.Text);
cmd.Parameters.AddWithValue("@ndatep", textBox8.Text);
cmd.Parameters.AddWithValue("@ndatee", textBox9.Text);
cmd.Parameters.AddWithValue("@noper", comboBox2.Text);
>>ein ghesmat khatamide cmd.ExecuteNonQuery();
cmd.CommandText = "Select * From table_2";
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
if (textBox3.Text != "" & textBox4.Text != "" & textBox5.Text != "" & textBox6.Text != "" & textBox7.Text != "" & textBox8.Text != "" & textBox9.Text != "")
{
con.ConnectionString = cs;
con.Open();
cmd.Connection = con;
da.SelectCommand = cmd;
cmd.CommandText = "INSERT INTO table_2 (name,ghj,fij,sod,ghkol,datep,datee,oper) VALUES (@nname,@nghj,@nfij,@nsod,@nghkol,@ndatep,@ndatee, @noper)";
cmd.Parameters.AddWithValue("@nname", textBox4.Text);
cmd.Parameters.AddWithValue("@nghj", textBox3.Text);
cmd.Parameters.AddWithValue("@nfij", textBox5.Text);
cmd.Parameters.AddWithValue("@nsod", textBox6.Text);
cmd.Parameters.AddWithValue("@nghkol",textBox7.Text);
cmd.Parameters.AddWithValue("@ndatep", textBox8.Text);
cmd.Parameters.AddWithValue("@ndatee", textBox9.Text);
cmd.Parameters.AddWithValue("@noper", comboBox2.Text);
>>ein ghesmat khatamide cmd.ExecuteNonQuery();
cmd.CommandText = "Select * From table_2";
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();