在线论坛登录代码
private void Button1_Click(object sender, System.EventArgs e){if(username.Text=="" || password1.Text=="") this.RegisterClientScriptBlock("tz1","<script>window.alert('请输入完整。谢谢!')</script>"); else
{SqlConnection conn=new SqlConnection("server=localhost;database=zhidao;uid=sa;pwd=''");
conn.Open();
SqlCommand cmd=new SqlCommand("select id from users where username=@u and password1=@pass",conn);
cmd.Parameters.Add("@u",SqlDbType.Char,20);
cmd.Parameters.Add("@pass",SqlDbType.Char,20);
cmd.Parameters["@u"].Value=username.Text;
cmd.Parameters["@pass"].Value=password1.Text;
SqlDataReader r1=cmd.ExecuteReader();
if(r1.Read())
{Session["userlogin"]="1";
Session["userid"]=r1["id"].ToString();
r1.Close();
conn.Close();
Response.Redirect("index.aspx");
}else
{r1.Close();
conn.Close(); this.RegisterClientScriptBlock("tz1","<script>window.alert('用户名或密码错误。')</script>"); } }
--------------------编程问答-------------------- server=localhost;database=zhidao;uid=sa;pwd='',这个你确定可以? --------------------编程问答-------------------- protected void ImageButton1_Click(object sender, EventArgs e)
{
checkLogin(TextBox1.Text, TextBox2.Text);
}
public void checkLogin(string loginName, string loginPwd)
{
cmd.Connection = con;
cmd.CommandText = "select count(*) from T_UserInfo where LoginName=@loginName and Password=@loginPwd and State='已审核'";
cmd.Parameters.Add("@loginName", OleDbType.WChar, 50).Value = TextBox1.Text;
cmd.Parameters.Add("@loginPwd", OleDbType.WChar, 50).Value = zzz.MD5(TextBox2.Text);
con.Open();
int result = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Parameters.Clear();
con.Close();
if (result > 0)
{
string sql1 = "select Name,RoleCode,T_UserInfo.RoleID from T_UserInfo,T_Role where LoginName='" + TextBox1.Text + "' and T_UserInfo.RoleID=T_Role.RoleID";
DataTable dt1 = new DataTable();
dt1 = da.SelectSql(sql1).Tables[0];
Session["LoginName"] = dt1.Rows[0].ItemArray[0].ToString();
Session["RoleCode"] = dt1.Rows[0].ItemArray[1].ToString();
Session["RoleID"] = dt1.Rows[0].ItemArray[2].ToString();
Session["Login_Name"] = TextBox1.Text;
Response.Redirect("~/main.aspx");
}
else
{
Ext.MessageBox.Alert("提示信息", "登陆失败,请重新输入!").Show();
}
} --------------------编程问答-------------------- 楼主的代码哪里出现了问题?出现了什么问题 ? --------------------编程问答--------------------
这个应该可以啊 --------------------编程问答-------------------- 你放一段代码来,其余一句话都不说,你是要干什么? --------------------编程问答-------------------- 有错啊 我找不出来啊
补充:.NET技术 , C#