数据库中有一张表 userlist 要插入一行结果插入不成功
想不明白 求救各位大侠了
if(quxianconn.State.ToString()=="Closed")
quxianconn.Open(); //SqlCommand cmd=new SqlCommand();
//cmd.Connection=quxianconn;
SqlDataAdapter sda=new SqlDataAdapter("select * from userlist",quxianconn);
DataSet sds=new DataSet();
sda.Fill(sds,"userlist");
DataTable dt=new DataTable("userlist"); DataRow dr=dt.NewRow();
dr[0]=qxname;
dr[1]=qxpsd;
dr[2]=qxpow;
dt.Rows.Add(dr);
sda.Update(sds,"userlist"); quxianconn.Close();
想不明白 求救各位大侠了
if(quxianconn.State.ToString()=="Closed")
quxianconn.Open(); //SqlCommand cmd=new SqlCommand();
//cmd.Connection=quxianconn;
SqlDataAdapter sda=new SqlDataAdapter("select * from userlist",quxianconn);
DataSet sds=new DataSet();
sda.Fill(sds,"userlist");
DataTable dt=new DataTable("userlist"); DataRow dr=dt.NewRow();
dr[0]=qxname;
dr[1]=qxpsd;
dr[2]=qxpow;
dt.Rows.Add(dr);
sda.Update(sds,"userlist"); quxianconn.Close();
sqlcommandbuilder sqlcmbuid=new sqlcommandbuilder(sda)
加上这一句应该就可以了!
方法必须要定义好
DataAdapter的SelectCommand.CommandText,
InsertCommand.CommandText
及所在新增的列的参数
例如
SelectCommand.CommandText="Select * From TableName";
InsertCommand.CommandText="Insert Into TableName(F1,F2,F3) Values (@F1,@F2,@F3)";
InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@F1",System.Data.SqlDbType.VarChar, 24, "F1"));
InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@F2", System.Data.SqlDbType.VarChar, 30, "F2"));
InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@F3", System.Data.SqlDbType.VarChar, 24, "F3"));DataAdapter.Fill(DataSet,"TableName");
DataRow NewDR;
NewDR=DataSet.Tables["TableName"].NewRows();
NewDR["F1"]="F1";
NewDR["F2"]="F2";
NewDR["F3"]="F3";
DataSet.Tables["TableName"].Rows.Add(NewDR);
DataAdapter.Update(DataSet,"TableName");