c#.asp删除数据源数据

来源:百度知道 编辑:UC知道 时间:2024/05/31 00:49:32
OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder();
builder.Provider = "microsoft.jet.oledb.4.0";
builder.DataSource = "d:\\db1.mdb";
string coonstring = builder.ConnectionString;
OleDbConnection conn = new OleDbConnection(coonstring);
DataSet ds = new DataSet();
string selectcmd = "select * from xs ";

OleDbDataAdapter da = new OleDbDataAdapter(selectcmd, conn);
da.Fill(ds, "auto");
OleDbParameter parm = new OleDbParameter("@name", huoqu.Text );

parm.SourceVersion = DataRowVersion.Current;
string delete = "delete from xs where name=@name";

OleDbCommand deletecmd = new OleDbCommand(delete, conn);

deletecmd.Parameters.Add(parm);

da.DeleteCommand = deletecmd ;

"delete from [xs] where [name]=@name";
Access 数据库要加加括号

huoqu.Text。

界面上有名为huoqu的控件吗?

要在里边填上你要删的名字,然后才能删