SqlConnection myConn=new SqlConnection("Data Source=;User id=sa;pwd=thwilly;DataBase=northwind");
myConn.Open();
SqlDataAdapter myAdapter=new SqlDataAdapter("select CustomerID,CompanyName from Customers",myConn);
SqlCommandBuilder myCB=new SqlCommandBuilder(myAdapter);
DataSet myDataset=new DataSet();
myAdapter.Fill(myDataset,"Customers");
Console.WriteLine("name before count:{0}",myDataset.Tables["Customers"].Rows.Count);
DataRow myRow=myDataset.Tables["Customers"].NewRow();
myRow["CustomerID"]="CZWLOVE";
myRow["CompanyName"]="Tien-Hu Knitte Limited";
myDataset.Tables["Customers"].Rows.Add(myRow);
Console.WriteLine("name after count:{0}",myDataset.Tables["Customers"].Rows.Count);
myAdapter.Update(myDataset,"Customers");
myConn.Close();
Console.WriteLine("Program finished,press Enter/Return to contiute...");
Console.ReadLine();
上面的代碼執行後出現下圖出錯資訊,什麽原因????

SqlConnection myConn=new SqlConnection("server=服务器名;User id=sa;pwd=thwilly;DataBase=northwind");

"Data Source=;"為空值是表示本機相當於"Localhost",這是正確的!

提示有錯誤在這一行上:
myAdapter.Update(myDataset,"Customers");

加个 try~~~~catch~~~看看会说是什么错.

找到原因了:

是因為Customers表中的CustomerID字段的數據長度為5,而要寫入的數據"CZWLOVE"有6個位,以致不能寫入到表中
在SQL中把CustomerID字段改為10後問題解決!!