作者sartsky (....)
看板C_Sharp
标题有关OleDbCommand的问题
时间Fri Nov 11 16:23:29 2005
我将Acess资料库的资料放到datagrid上...
希望能直接在datagrid上直接修改...
我的程式码如下:
public OleDbDataAdapter myadapter;
public DataSet mydataset=new DataSet();
private void Form1_Load(object sender, System.EventArgs e)
{
string connstring
="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=testupdate.mdb";
OleDbConnection conn=new OleDbConnection(connstring);
string selectCmd;
selectCmd="Select * From test1";
myadapter=new OleDbDataAdapter(selectCmd,conn);
label1.Text="";
int num=myadapter.Fill(mydataset,"测试");
label1.Text="共"+num+"笔资料";
datagrid1.SetDataBinding(mydataset,"测试");
OleDbCommand iCmd
= new OleDbCommand("Insert into test1 (姓名,现任职称) VALUES (?,?,?)", conn);
iCmd.Parameters.Add(new OleDbParameter("姓名", OleDbType.Char, 50));
iCmd.Parameters.Add(new OleDbParameter("现任职称", OleDbType.Char, 50));
myadapter.InsertCommand=iCmd;
OleDbCommand uCmd
= new OleDbCommand("Update test1 Set 姓名=?, 现任职称", conn);
uCmd.Parameters.Add(new OleDbParameter("姓名", OleDbType.Char, 50));
uCmd.Parameters.Add(new OleDbParameter("现任职称", OleDbType.Char, 50));
myadapter.UpdateCommand=uCmd;
OleDbCommand dCmd
= new OleDbCommand("DELETE FROM test1 WHERE 姓名=?", conn);
dCmd.Parameters.Add(new OleDbParameter("姓名", OleDbType.Char,50));
myadapter.DeleteCommand=dCmd;
}
private void update1_Click(object sender, System.EventArgs e)
{
int num=myadapter.Update(mydataset,"测试");
label1.Text="共"+num+"笔资料修改";
}
结果在run时却发生
类型 'System.Data.OleDb.OleDbException'
的未处理例外状况发生於 system.data.dll
我一直百思不解...请问各位高手这是什麽情况...谢谢高手们
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 59.105.116.11
1F：→ EricTsai:你没说哪一行啊 11/11 16:39
2F：推 liunate:把比较详细的错误讯息PO出来瞧瞧 11/11 20:42