intid=(int)GVAdmins.DataKeys[e.RowIndex].Value;stringsql="deletefromAdminswhereAdminsID="+id;if(SqlHelper.ExecuteSqlGet(sql)==0){Response.Write("
int id = (int)GVAdmins.DataKeys[e.RowIndex].Value;
string sql = "delete from Admins where AdminsID=" + id;
if (SqlHelper.ExecuteSqlGet(sql) == 0)
{
Response.Write("!");
}
else
{
Response.Write("");
}
Bind();
if (SqlHelper.ExecuteSqlGet(sql) == 0)为什么执行sql删除语句等于0时,提示操作成功,而不是大于0 求详细解释。
SqlHelper.ExecuteSqlGet方法的代码:
public static int ExecuteSqlGet(string SQLString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(SQLString, connection);
try
{
connection.Open();
return Convert.ToInt32(cmd.ExecuteScalar());
}
catch (System.Data.SqlClient.SqlException e)
{
throw e;
}
finally
{
cmd.Dispose();
connection.Close();
}
}
}
展开