DataSet myDataSet = new DataSet();
SqlConnection myConnection = new SqlConnection("server=127.0.0.1;uid=sa;pwd=sa ;database=aa");
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("insert into mm values(2,22)", myConnection);
mySqlDataAdapter.Fill(myDataSet, "mm");
DataRow myDataRow2 = myDataSet.Tables["mm"].NewRow();
////////////上面这行出异常:“未将对象引用设置到对象的实例”,为什么啊?////////////
////////////mm表共有a,b两个字段,而且全是int数据据类型//////////////////////////
myDataRow2[0] = 23;
myDataRow2[1] = 22;
myDataSet.Tables["mm"].Rows.Add(myDataRow2);
mySqlDataAdapter.Update(myDataSet, "mm");
//////////请指教!!!///////////////
SqlConnection myConnection = new SqlConnection("server=127.0.0.1;uid=sa;pwd=sa ;database=aa");
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("insert into mm values(2,22)", myConnection);
mySqlDataAdapter.Fill(myDataSet, "mm");
DataRow myDataRow2 = myDataSet.Tables["mm"].NewRow();
////////////上面这行出异常:“未将对象引用设置到对象的实例”,为什么啊?////////////
////////////mm表共有a,b两个字段,而且全是int数据据类型//////////////////////////
myDataRow2[0] = 23;
myDataRow2[1] = 22;
myDataSet.Tables["mm"].Rows.Add(myDataRow2);
mySqlDataAdapter.Update(myDataSet, "mm");
//////////请指教!!!///////////////
DataSet myDataSet = new DataSet();
SqlConnection myConnection = new SqlConnection("server=127.0.0.1;uid=sa;pwd=sa ;database=aa");
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("select * from mm", myConnection);
mySqlDataAdapter.Fill(myDataSet, "mm");//insert的用法
SqlConnection myConnection = new SqlConnection("server=127.0.0.1;uid=sa;pwd=sa ;database=aa");
SqlCommand comm=new SqlCommand("insert into mm values(2,22)",myConnection);
myConnection.Open();
comm.ExecuteNonQuery();
myConnection.Close();
那要怎么弄呢?