数据UPDATE了以后怎样更新数据?还有更新了后怎么刷新?
s98 2004-08-28 02:34:35 string updateSql = "update foodsort set sort1='"+
str2+"',sort2='"+str3+"',sort3='"+str4+"' where code='"+str1+"'";
MessageBox.Show(updateSql);
OleDbCommand myCommand = new OleDbCommand(updateSql,oleDbConnection1);
myCommand.ExecuteNonQuery();
myAdapter.Update(dataSet1.Tables[0]);//现在这两句就不起作用。我这样写是对的吗?
this.dataGrid1.Refresh();//还有就是怀疑我的SQL有问题
this.oleDbConnection1.Close();