这种DataTable如何更新呀?
我的SQL SERVER 数据库有一个表:“UCUST”,两个字段:“CUSTNI”,“CUSTNAME”。下面是一段代码:
DataTable DT = new DataTable ("UCUST");
DataColumn myColumn;
DataRow myRow;
//-------------
myColumn = new DataColumn ();
myColumn.DataType =Type.GetType ("System.String");
myColumn.ColumnName ="ID";
myColumn=DT.Columns .Add ("CUSTNO",Type.GetType ("System.String"));
//--------------
myColumn = new DataColumn ();
myColumn.DataType =Type.GetType ("System.String");
myColumn.ColumnName ="CUSTNAME";
DT.Columns .Add (myColumn);
//----------------------------
myColumn = new DataColumn ();
myColumn.DataType =Type.GetType ("System.String");
myColumn.ColumnName ="TELEPHONE";
DT.Columns .Add (myColumn);
//----------------------------------------------
for (int i=0 ;i<10;i++)
{
myRow= DT.NewRow ();
myRow["CUSTNO"]="ID"+i;
myRow["CUSTNAME"]="NAME"+i;
myRow["TELEPHONE"]="ADDRESS" +i;
DT.Rows .Add (myRow);
}
然后用DT更新数据库里面的“UCUST”表,接下来该如何做?