public void Phone_Delete(object source, DataGridCommandEventArgs e)
{
string strUserName = GetCookie(); string strName = e.Item.Cells[0].Text;
string strConn = ConfigurationSettings.AppSettings["strConnection"]; SqlConnection myCn = new SqlConnection(strConn);
SqlCommand myCmd = new SqlCommand("Delete from PhoneBook where UserName=strUserName and Name=strName",myCn);
try
{
myCn.Open();
myCmd.ExecuteNonQuery();
}
catch(Exception error)
{
throw error;
}
finally
{
myCmd.Dispose();
myCn.Close();
}
DataGridDataBind();
PhoneMessage.Text = "已删除";
}
执行到SqlCommand myCmd = new SqlCommand("Delete from PhoneBook where UserName=strUserName and Name=strName",myCn);时提示出错
说我没有strUserName strName列
我数据库里是UserName和Name
想删除UserName=strUserName and Name=strName的数据
请问哪里错了?
{
string strUserName = GetCookie(); string strName = e.Item.Cells[0].Text;
string strConn = ConfigurationSettings.AppSettings["strConnection"]; SqlConnection myCn = new SqlConnection(strConn);
SqlCommand myCmd = new SqlCommand("Delete from PhoneBook where UserName=strUserName and Name=strName",myCn);
try
{
myCn.Open();
myCmd.ExecuteNonQuery();
}
catch(Exception error)
{
throw error;
}
finally
{
myCmd.Dispose();
myCn.Close();
}
DataGridDataBind();
PhoneMessage.Text = "已删除";
}
执行到SqlCommand myCmd = new SqlCommand("Delete from PhoneBook where UserName=strUserName and Name=strName",myCn);时提示出错
说我没有strUserName strName列
我数据库里是UserName和Name
想删除UserName=strUserName and Name=strName的数据
请问哪里错了?
SqlCommand myCmd = new SqlCommand(strSQL,myCn);
SqlCommand myCmd = new SqlCommand(strSQL,myCn);编译错误 & 无法用于string和string的操作
{
string strUserName = GetCookie(); string strName = e.Item.Cells[0].Text;
string strConn = ConfigurationSettings.AppSettings["strConnection"];
SqlConnection myCn = new SqlConnection(strConn);
SqlCommand myCmd = new SqlCommand("Delete from PhoneBook where UserName='"+ strUserName +"' and [Name]='"+ strName +"'",myCn);
try
{
myCn.Open();
myCmd.ExecuteNonQuery();
}
catch(Exception error)
{
throw error;
}
finally
{
myCmd.Dispose();
myCn.Close();
}
DataGridDataBind();
PhoneMessage.Text = "已删除";
}已删除 打印出来了
但是没有删除数据