public void Button1_click(object sender, System.EventArgs e)
{
Session["username"]=username.Text ;
string a=Session["username"];
string getpasw=pasw.Text ;
if (Session["username"]=="" || getpasw=="")
{
wel.Text="kashdfpkoahlkfj;lasdjf;lasjfl;ajsf;lajs;flkjas;lfkjas;lkfjaj";
/*wel.Text="请输入完整资料!";*/
return;}
string strConnection = "server=(local)\\NetSDK; Database=dotnet;UID=sa;PWD=";
string strSQL = "SELECT * FROM login where username='" + Session["username"]+ "'";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand =new OleDbCommand(strSQL, objConnection);
OleDbDataReader objDataReader ;
objCommand.Open();
objDataReader = objCommand.ExecuteReader();
if (objDataReader.Read() == false)
{
wel.Text = "该用户名还未注册!";
return;}
else if(objDataReader.GetString(2)!=getpasw)
{
wel.Text="密码错误!";
return;}
else
{
string times= objDataReader.GetValue(3).ToString() ; if (Session["username.text"] == "hasin" )
{
wel.Text = "欢迎" + Session["username"] + "重新登陆本站!";
return;}
else
wel.Text = "欢迎" + Session["username"] + "第" + times + "次登陆本站!";
string upsql = "UPDATE login SET visitime=visitime+1 where username='" + Session["username"] + "'";
OleDbCommand upcommand = new OleDbCommand(upsql, objConnection); objCommand.Connection.Close();
upcommand.Connection.Open();
upcommand.ExecuteNonQuery();
upcommand.Connection.Close();
Session["username.text"]= "hasin";
}
}
{
Session["username"]=username.Text ;
string a=Session["username"];
string getpasw=pasw.Text ;
if (Session["username"]=="" || getpasw=="")
{
wel.Text="kashdfpkoahlkfj;lasdjf;lasjfl;ajsf;lajs;flkjas;lfkjas;lkfjaj";
/*wel.Text="请输入完整资料!";*/
return;}
string strConnection = "server=(local)\\NetSDK; Database=dotnet;UID=sa;PWD=";
string strSQL = "SELECT * FROM login where username='" + Session["username"]+ "'";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand =new OleDbCommand(strSQL, objConnection);
OleDbDataReader objDataReader ;
objCommand.Open();
objDataReader = objCommand.ExecuteReader();
if (objDataReader.Read() == false)
{
wel.Text = "该用户名还未注册!";
return;}
else if(objDataReader.GetString(2)!=getpasw)
{
wel.Text="密码错误!";
return;}
else
{
string times= objDataReader.GetValue(3).ToString() ; if (Session["username.text"] == "hasin" )
{
wel.Text = "欢迎" + Session["username"] + "重新登陆本站!";
return;}
else
wel.Text = "欢迎" + Session["username"] + "第" + times + "次登陆本站!";
string upsql = "UPDATE login SET visitime=visitime+1 where username='" + Session["username"] + "'";
OleDbCommand upcommand = new OleDbCommand(upsql, objConnection); objCommand.Connection.Close();
upcommand.Connection.Open();
upcommand.ExecuteNonQuery();
upcommand.Connection.Close();
Session["username.text"]= "hasin";
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货