.net关于删除功能判断代码

来源：百度知道 编辑：UC知道 时间：2024/06/07 17:29:12
OleDbConnection oleCon = new OleDbConnection();
String dbpath = "F:\\班级通讯录管理系统\\App_Data\\j.mdb";
oleCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbpath;
oleCon.Open(); //打开数据库
OleDbCommand oleCmd = oleCon.CreateCommand();

//构造sql语句
String user = this.txtdel.Text.ToString();

String sqlStr = "delete * from zc where user='" + user + "' ";

//把SQL语句赋给oleCmd对象
oleCmd.CommandText = sqlStr;
//执行sql语句

OleDbDataReader oleDr = oleCmd.ExecuteReader();

---------------【if (oleDr.HasRows)//
{
Response.Write("有此管理员！");//
this.txtdel.Text = "";
}

else
{
Response.Write("无！");

//构造sql语句
String user = this.txtdel.Text.ToString().trim();

String sqlStr = "delete * from zc where user='" + user + "' ";

//把SQL语句赋给oleCmd对象
oleCmd.CommandText = sqlStr;
//执行sql语句

int flag = oleCmd.ExecuteNonQuery();

if(flag > 0)
{
Response.Write("成功！");
}
else
{
Response.Write("失败！");
}

//把SQL语句赋给oleCmd对象
oleCmd.CommandText = sqlStr;
//执行sql语句，并返回受影响的行数
int cnt = oleCmd.ExecuteNonQuery();
if(cnt>0)
{
Response.Write("有此管理员！");
}
else
{
Response.Write("无！");
}

没看懂，你是要判断什么事情

问题具体点

你这想让我们判断什么??是指你的代码不正确??还是??