我在ASP.NET中用的是ACCESS数据库,删除时报无法从指定的数据表中删除.这是怎么回事..如果把B/S改为WINDOWS程序就可以...
string path =Server.MapPath("db1.mdb");
string cnstring ="Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source='"+ path +"'";
OleDbConnection cn = new OleDbConnection(cnstring);
try
{
cn.Open();
string sql ="delete from usetable where useid=2";
OleDbCommand deleCom = new OleDbCommand(sql,cn);
deleCom.ExecuteNonQuery();
Response.Write("<script>window.alert('删除成功!');</script>");
cn.Close();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
string path =Server.MapPath("db1.mdb");
string cnstring ="Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source='"+ path +"'";
OleDbConnection cn = new OleDbConnection(cnstring);
try
{
cn.Open();
string sql ="delete from usetable where useid=2";
OleDbCommand deleCom = new OleDbCommand(sql,cn);
deleCom.ExecuteNonQuery();
Response.Write("<script>window.alert('删除成功!');</script>");
cn.Close();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
是不是在IIS中把虚拟目录中的写入选中..,如果是就可写.