使用SqlDataAdapter更新、插入数据的问题？

Question

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!

Answer 1

http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldataadapter(VS.80).aspx

Answer 2

你把代码改成：

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没有给定连接。

Answer 3

http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqldataadapter.selectcommand%28v=VS.80%29.aspx

---

Anything Is Possible !