积极答复者
使用SqlDataAdapter更新、插入数据的问题?

问题
-
SqlDataAdapter有4个属性SelectCommand、InsertCommand,UpdateCommand,DeleteCommand,请问我将其的InsertCommand值设为一个插入数据的SqlCommand对象为什么数据插入不了?代码如下:
SqlConnection sqlConn = new SqlConnection("Data Source=NOTHING\\SQLEXPRESS; Initial Catalog=Sales; Integrated Security=SSPI;");
//插入语句
SqlCommand sqlCmd3 = new SqlCommand();
sqlCmd3.CommandText = "INSERT INTO Customers VALUES('Roshan', 'Stain', 99.99, '2099-1-2')";
sqlCmd3.CommandType = CommandType.Text;
sqlCmd3.Connection = sqlConn;
SqlDataAdapter sqlAdapter = new SqlDataAdapter();
sqlAdapter.InsertCommand = sqlCmd3;
sqlConn.Close();
Never bend, never break, never back down!
答案
-
你把代码改成:
SqlConnection sqlConn = new SqlConnection("Data Source=NOTHING\\SQLEXPRESS; Initial Catalog=Sales; Integrated Security=SSPI;");
//插入语句
SqlCommand sqlCmd3 = new SqlCommand();
sqlCmd3.CommandText = "INSERT INTO Customers VALUES('Roshan', 'Stain', 99.99, '2099-1-2')";
sqlCmd3.CommandType = CommandType.Text;
sqlCmd3.Connection = sqlConn;
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlConn );
sqlAdapter.InsertCommand = sqlCmd3;
sqlConn.Close();这样看看是不是就可以了,我感觉你的SqlDataAdapter没有给定连接。
全部回复
-
你把代码改成:
SqlConnection sqlConn = new SqlConnection("Data Source=NOTHING\\SQLEXPRESS; Initial Catalog=Sales; Integrated Security=SSPI;");
//插入语句
SqlCommand sqlCmd3 = new SqlCommand();
sqlCmd3.CommandText = "INSERT INTO Customers VALUES('Roshan', 'Stain', 99.99, '2099-1-2')";
sqlCmd3.CommandType = CommandType.Text;
sqlCmd3.Connection = sqlConn;
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlConn );
sqlAdapter.InsertCommand = sqlCmd3;
sqlConn.Close();这样看看是不是就可以了,我感觉你的SqlDataAdapter没有给定连接。