string sql="select username from smmuser where userid='"+user+"' and pwd='"+pass+"'"; string username1=getmc(0,sql); if(username1!="") { Response.Redirect("index.aspx?username="+username1+"&userid="+user); }
else { Label1.Text="User ID or Password is invalid."; } #region Web 字段返回代码 public string getmc(int i,string sql) { try { myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["strConnection"].ToString()); myConnection.Open(); string uname=""; SqlCommand command1=new SqlCommand(sql,myConnection); SqlDataReader reader = command1.ExecuteReader(); if(reader.Read()) { uname=reader.GetValue(i).ToString(); } reader.Close(); return uname; } catch(Exception e) { return null; } finally { myConnection.Close(); }
string username1=getmc(0,sql);
if(username1!="")
{ Response.Redirect("index.aspx?username="+username1+"&userid="+user);
}
else
{
Label1.Text="User ID or Password is invalid."; }
#region Web 字段返回代码
public string getmc(int i,string sql)
{
try
{
myConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["strConnection"].ToString());
myConnection.Open();
string uname="";
SqlCommand command1=new SqlCommand(sql,myConnection);
SqlDataReader reader = command1.ExecuteReader();
if(reader.Read())
{
uname=reader.GetValue(i).ToString();
}
reader.Close();
return uname;
}
catch(Exception e)
{
return null;
} finally
{
myConnection.Close();
}
}
#endregion