如何显示不同登录用户的数据? [英] How to display data of different logged in users?
问题描述
我在asp.net c#中做一个项目(网站)。我正在使用visual studio 2005和SQL server 2005.我需要知道的是,当学生使用他们的用户名和密码登录时,他们应该从数据库中显示他们的特定信息(如姓名,dob,班级,部门,联系人来自SQL)到不同的网页。我能够只显示一个用户的数据。那么当不同的用户使用他的用户名和密码登录时,如何显示不同的用户数据。
我正在使用两页一页用于登录,另一页用于显示当前用户登录信息。
登录页面代码:
i am doing a project(website) in asp.net c#. I am using visual studio 2005 and SQL server 2005.What I need to know is when a student logs in using their username and password they should have their specific information displayed from the database (like name,dob,class,department, contactno from the SQL) on to a different web page. i am able to display the data for only one user.So how can i display different users data when different user logs in with his username and password.
I am using two pages one for login and other studentinf which displays the information of current user login.
code for login page:
public partial class _Default : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;
SqlDataAdapter da;
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection("Data Source=localhost;Initial Catalog=knm;Integrated Security=SSPI");
con.Open();
}
protected void Button1_Click(object sender, EventArgs e)
{
bool temp = false;
String qry=" Select * from user_login where username='" + TextBox1.Text+"' and password='" +TextBox2.Text+"'";
cmd=new SqlCommand(qry,con);
dr=cmd.ExecuteReader();
if(dr.Read())
{
Label3.Text="Logged in successfull";
Response.Redirect("studenthome.aspx");
}
else
Label3.Text="invalid user";
dr.Close();
}
}
studentinf页面代码:
code for studentinf page:
public partial class _Default : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;
SqlDataAdapter da;
protected void Page_Load(object sender, EventArgs e)
{
bool temp = false;
con = new SqlConnection("Data Source=localhost;Initial Catalog=knm;Integrated Security=SSPI");
String std = "SELECT* FROM user_login";
con.Open();
cmd = new SqlCommand("select * from studentinf ", con);
da = new SqlDataAdapter("select * from studentinf ", con);
DataSet ds = new DataSet();
da.Fill(ds, "studentinf");
TextBox1.Text = ds.Tables["studentinf"].Rows[0]["name"].ToString();
TextBox2.Text = ds.Tables["studentinf"].Rows[0]["dob"].ToString();
TextBox3.Text = ds.Tables["studentinf"].Rows[0]["class"].ToString();
TextBox4.Text = ds.Tables["studentinf"].Rows[0]["department"].ToString();
TextBox5.Text = ds.Tables["studentinf"].Rows[0]["contact"].ToString();
}
}
推荐答案
查看我对 this [ ^ ]问题。 使用相同的技术来解决您的问题。
/ ravi
See my reply to this[^] question. Use the same technique to solve your problem.
/ravi
这篇关于如何显示不同登录用户的数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!