string strconnection=(string)ConfigurationSettings.AppSettings[Global.CfgKeyConnString];
SqlConnection myconnection=new SqlConnection(strconnection);
DataSet ds=new DataSet ();
SqlDataAdapter adapter = new SqlDataAdapter();
string strsql="select * from jo_parts ";
adapter.SelectCommand = new SqlCommand(strsql , myconnection);
adapter.Fill (ds,"data");
string isql="INSERT INTO jo_parts VALUES('U526FASX','abc',3,'rrrrrrr',10,23)";
adapter.InsertCommand =new SqlCommand (isql,myconnection);
adapter.Update (ds,"data");
SqlConnection myconnection=new SqlConnection(strconnection);
DataSet ds=new DataSet ();
SqlDataAdapter adapter = new SqlDataAdapter();
string strsql="select * from jo_parts ";
adapter.SelectCommand = new SqlCommand(strsql , myconnection);
adapter.Fill (ds,"data");
string isql="INSERT INTO jo_parts VALUES('U526FASX','abc',3,'rrrrrrr',10,23)";
adapter.InsertCommand =new SqlCommand (isql,myconnection);
adapter.Update (ds,"data");
try
UpDate之前
DataRow dr = ds.Tables["data"].NewRow();
dr[...] = 值
ds.Tables["data"].Rows.Add(dr)
在线等啊/
{
string str="INSERT INTO jo_parts VALUES('U526FASX','abc',3,'rrrrrrr',10,23)";
SqlCommand cmd=new SqlCommand(str,conn);
try
{
conn.open();
cmd.ExecuteNonQuery();
}
catch
{
}
}
这样就可以了