ExecuteNonQuery在C#中不起作用 [英] ExecuteNonQuery not working in C#

问题描述

我正在使用Visual Studio 2008 c#构建数据库，而当我尝试向数据库中插入新记录时，似乎未初始化ExecuteNonQuery.我复制了我的代码，希望因为我是新手，任何人都可以帮助我.

I am building a database using Visual Studio 2008 c# and when I'm a trying to insert a new record into my database it appears that ExecuteNonQuery has not initialized. I copy my code, hope anyone can help me in this because I am new.

 private void button1_Click(object sender, EventArgs e)
 {
     SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Usuario\Documents\Visual Studio 2010\Projects\Nova\Nova\Database1.mdf;Integrated Security=True;User Instance=True");
     SqlCommand cmd = new SqlCommand();
     cn.Open();
     cmd.CommandText = "insert into Database1.mdf(Codigo,Nombre,Cantidad,Tipo) values('"+comboBox1.Text+"','"+textBox3.Text+"','"+textBox1.Text+"','"+comboBox2.Text+"')";
     cmd.ExecuteNonQuery();
     cmd.Clone();
     cn.Close();
     MessageBox.Show("Acabas de agregar un producto");
 }

推荐答案

您尚未设置与命令的连接:

You haven't set the connection to your command:

cmd.Connection = cn;

这篇关于ExecuteNonQuery在C#中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！