62,025
社区成员
发帖
与我相关
我的任务
分享
SqlDataReader dr = null;
try
{
dr = da.ExceRead(cmdtxt);
dr.Read();
if (dr.HasRows)
{
Session["admin"] = this.txtUid.Text.Trim();
Response.Redirect("admin_index.aspx");
}
else
{
Response.Write("<script>alert('帐号或密码错误!');</script>");
}
}
catch (SqlException ex)
{
Response.Write(ex.Message);
}
finally
{
if(dr != null)
dr.Close();
}
public SqlDataReader ExceRead(string SqlCom)
{
SqlConnection sqlcon = null;
SqlCommand sqlcom = null;
SqlDataReader read = null;
try
{
sqlcon = getconn();
sqlcon.Open();
sqlcom = new SqlCommand(SqlCom, sqlcon);
read = sqlcom.ExecuteReader();
}
catch (SqlException ex)
{
System.Web.HttpContext.Current.Response.Write(ex.Message);
}
finally
{
if(sqlcon!=null)
sqlcon.Close();
if(read!=null)
read.Close();
}
return read;
}
using(dr = da.ExceRead(cmdtxt))
{
dr.Read();
if (dr.HasRows)
{
Session["admin"] = this.txtUid.Text.Trim();
Response.Redirect("admin_index.aspx");
}
else
{
}
}
DataSet ds = null;
try
{
ds = ExceRead(cmdtxt);
if (ds.Tables[0].Rows.Count>0)
{
Session["admin"] = this.txtUid.Text.Trim();
Response.Redirect("admin_index.aspx");
}
else
{
Response.Write("<script>alert('帐号或密码错误!');</script>");
}
}
catch (SqlException ex)
{
Response.Write(ex.Message);
}
public DataSet ExceRead(string SqlCom)
{
SqlConnection sqlcon = null;
SqlDataAdapter da = null;
DataSet ds = null;
try
{
sqlcon = getconn();
sqlcon.Open();
da = new SqlDataAdapter(SqlCom, sqlcon);
da.Fill(ds);
}
catch (SqlException ex)
{
System.Web.HttpContext.Current.Response.Write(ex.Message);
}
finally
{
if (sqlcon != null)
sqlcon.Close();
}
return ds;
}