我的代码如下:
private void button1_Click(object sender, EventArgs e)
{
string sqlstr = "insert into try(id,name,tele) values(@nid,@nam,@tele)";
int n;
SqlDataAdapter datadapter = new SqlDataAdapter();
SqlCommand command = new SqlCommand(sqlstr, conn);
datadapter.InsertCommand = command;
datadapter.InsertCommand.Parameters.Add("@nid",SqlDbType.Char);
datadapter.InsertCommand.Parameters.Add("@nam",SqlDbType.Char);
datadapter.InsertCommand.Parameters.Add("@tele",SqlDbType.Char);
datadapter.InsertCommand.Parameters["@nid"].SourceVersion = DataRowVersion.Current;
datadapter.InsertCommand.Parameters["@nid"].SourceColumn = "id";
datadapter.InsertCommand.Parameters["@nam"].SourceColumn = "name";
datadapter.InsertCommand.Parameters["@nam"].SourceVersion = DataRowVersion.Current;
datadapter.InsertCommand.Parameters["@tele"].SourceVersion = DataRowVersion.Current;
datadapter.InsertCommand.Parameters["@tele"].SourceColumn = "tele";
datadapter.InsertCommand.Parameters["@nid"].Value = "10";
datadapter.InsertCommand.Parameters["@nam"].Value = "16";
datadapter.InsertCommand.Parameters["@tele"].Value = "1234565";
n = datadapter.Update(dataset1, "try");
}
这个程序没有报错可是一直没有办法更新数据源,这是为什么!还有我希望不要使用SqlCommandBuilder!请各位高手帮忙一下!谢谢了!
private void button1_Click(object sender, EventArgs e)
{
string sqlstr = "insert into try(id,name,tele) values(@nid,@nam,@tele)";
int n;
SqlDataAdapter datadapter = new SqlDataAdapter();
SqlCommand command = new SqlCommand(sqlstr, conn);
datadapter.InsertCommand = command;
datadapter.InsertCommand.Parameters.Add("@nid",SqlDbType.Char);
datadapter.InsertCommand.Parameters.Add("@nam",SqlDbType.Char);
datadapter.InsertCommand.Parameters.Add("@tele",SqlDbType.Char);
datadapter.InsertCommand.Parameters["@nid"].SourceVersion = DataRowVersion.Current;
datadapter.InsertCommand.Parameters["@nid"].SourceColumn = "id";
datadapter.InsertCommand.Parameters["@nam"].SourceColumn = "name";
datadapter.InsertCommand.Parameters["@nam"].SourceVersion = DataRowVersion.Current;
datadapter.InsertCommand.Parameters["@tele"].SourceVersion = DataRowVersion.Current;
datadapter.InsertCommand.Parameters["@tele"].SourceColumn = "tele";
datadapter.InsertCommand.Parameters["@nid"].Value = "10";
datadapter.InsertCommand.Parameters["@nam"].Value = "16";
datadapter.InsertCommand.Parameters["@tele"].Value = "1234565";
n = datadapter.Update(dataset1, "try");
}
这个程序没有报错可是一直没有办法更新数据源,这是为什么!还有我希望不要使用SqlCommandBuilder!请各位高手帮忙一下!谢谢了!
command.ExecuteNonQuery();
{
conn = DB.createCon();
da = new OleDbDataAdapter("select * from SerialPortSelectionTable", conn);
da.Fill(ds, "SerialPortSelectionTable"); OleDbCommand cmd;
OleDbParameter parNew;
string updateStr; updateStr = "UPDATE SerialPortSelectionTable SET [SerialPort]=@SerialPort";
cmd = new OleDbCommand(updateStr, conn);
parNew = cmd.Parameters.Add("@SerialPort", OleDbType.Char);
parNew.SourceColumn = "SerialPort"; dv = new DataView(ds.Tables["SerialPortSelectionTable"], "", "", DataViewRowState.CurrentRows);
DataRowView drv;
drv = dv[0];
drv["SerialPort"] = SerialPortValue; da.UpdateCommand = cmd;
da.Update(ds, "SerialPortSelectionTable");
}