monadifard
دوشنبه 24 بهمن 1390, 12:59 عصر
سلام
چرا این ExecuteNonQuery ایراد میگیره!
public partial class Form1 : Form
{
SqlConnection con = new SqlConnection("Data Source=SMF-PC;Initial Catalog=a;Integrated Security=True");
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds =new DataSet() ;
private void Form1_Load(object sender, EventArgs e)
{
da = new SqlDataAdapter("select * from user", con);
ds.Clear();
da.Fill(ds,"user");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "user";
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SMF-PC;Initial Catalog=a;Integrated Security=True");
con.Open();
da = new SqlDataAdapter("select * from user",con);
SqlCommand comm = new SqlCommand("isert into user(code,name,family)values('" + Int32.Parse(textBox1.Text) + "','" + textBox2.Text + "','" + textBox3.Text + "')", con);
comm.ExecuteNonQuery();
con.Close();
چرا این ExecuteNonQuery ایراد میگیره!
public partial class Form1 : Form
{
SqlConnection con = new SqlConnection("Data Source=SMF-PC;Initial Catalog=a;Integrated Security=True");
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds =new DataSet() ;
private void Form1_Load(object sender, EventArgs e)
{
da = new SqlDataAdapter("select * from user", con);
ds.Clear();
da.Fill(ds,"user");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "user";
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SMF-PC;Initial Catalog=a;Integrated Security=True");
con.Open();
da = new SqlDataAdapter("select * from user",con);
SqlCommand comm = new SqlCommand("isert into user(code,name,family)values('" + Int32.Parse(textBox1.Text) + "','" + textBox2.Text + "','" + textBox3.Text + "')", con);
comm.ExecuteNonQuery();
con.Close();