新手求教login控件的登陆实现问题

[bear7717]

以前学的DELPHI，现在学ASP.NET和C#,语言转换的头有点大，请高手们教教我
我使用的是SQL2000和VISUAL STUDIO 2005
数据库连接字符串为"Data Source=PC-03131253;Initial Catalog=CPGL;Persist Security Info=True;User ID=sa"
我有一个用户数据表userinfo,里面有字段username,password,.....
现在加入了一个login控件，我想通过查询userinfo表中用户的username和password数据实现用户的登陆功能
请哪位高手指教下，请用c#的语句，麻烦了
顺便请教下假设登陆成功，怎么样让以后的页面知道是哪个用户登陆的

[bear7717]

求教啊~~~神啊，帮帮我吧

[sssjjjpppsjp]

protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
string username=login1.username;
string pwd = Login1.Password;
SqlConnection con=new SqlConnection("Data Source=PC-03131253;Initial Catalog=CPGL;Persist Security Info=True;User ID=sa");
con.Open();
SqlCommand cmd = new SqlCommand("select username,password from userinfo where username='"+username+"' and password='"+pwd+"'", con);
SqlDataReader dr =cmd.EndExecuteReader();
if(dr.HasRows)
{

Session["userid"] = username;//记录是哪个用户登录的
Response.Redirect("default.aspx"); //转向登录成功页面

}
con.Close();
}

[sssjjjpppsjp]

protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
string username=login1.username;
string pwd = Login1.Password;
SqlConnection con=new SqlConnection(Data Source=PC-03131253;Initial Catalog=CPGL;Persist Security Info=True;User ID=sa"
);
SqlCommand cmd = new SqlCommand("select username,password from userinfo where username='"+username+"' and password='"+pwd+"'", con);
SqlDataReader dr =cmd.EndExecuteReader();
if (dr.Rows.Count > 0)
{

Session["userid"] = username;//记录是哪个用户登录的
Response.Redirect("default.aspx"); //转向登录成功页面

}

}

[sssjjjpppsjp]

记得要打开数据库,可改成：
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
string username=login1.username;
string pwd = Login1.Password;
SqlConnection con=new SqlConnection(Data Source=PC-03131253;Initial Catalog=CPGL;Persist Security Info=True;User ID=sa"
);
con.Open();
SqlCommand cmd = new SqlCommand("select username,password from userinfo where username='"+username+"' and password='"+pwd+"'", con);
SqlDataReader dr =cmd.EndExecuteReader();
while (dr.Rows.Count > 0)
{

Session["userid"] = username;//记录是哪个用户登录的
Response.Redirect("default.aspx"); //转向登录成功页面

}
con.Close();
}

[bear7717]

太感谢了，你是神，啊门~~~~~~~~

[bear7717]

非常感谢哈~~

[bear7717]

顺便再问下在SqlDataReader dr =cmd.EndExecuteReader()；后面
我想获得每一行的各列的数据，程序应该怎么写啊？

[sssjjjpppsjp]

用一个循环嵌套语句
while(dr.read())//循环行数
{
for(int i=0;i<dr.FieldCount;i++)//循环列数
{
Response.Write(dr.GetValue(i));//输出列值
}
}

[sssjjjpppsjp]

SqlDataReader dr =cmd.EndExecuteReader()；
改成
SqlDataReader dr =cmd.ExecuteReader()；