如何根据EmailAddress从数据库中读取数据 [英] how to read data from database based on EmailAddress

问题描述

嗨frnds，



我想从数据库中读取数据并填写文本框。



我有2页

Page1.aspx

Page2.aspx



在数据库中我有Userdetails表。其中所有数据都是根据电子邮件地址存储的。



我们需要从数据库中检索数据。当电子邮件输入并点击提交按钮时。

数据必须在page2.aspx中读取并显示



在page1.aspx我有文本框到输入emailaddress（TxtEmailAddress）并提交按钮以查看page2.aspx中输入的电子邮件地址详细信息。



在page2.aspx中我有文本框来填充数据。



所以，这是我的代码，



请你帮我，如何从数据库中读取数据依据在page1.aspx中输入电子邮件地址



我的代码

=======

hi frnds,

I want to read data from database and fill in textboxes.

I have 2 pages
Page1.aspx
Page2.aspx

In database I have Userdetails table. in which all the data is stored according to email address.

We need to retrieve data from database. when email entered and hits submit button.
Data must be read and displayed in page2.aspx

In page1.aspx i have textbox to enter emailaddress (TxtEmailAddress) and also submit button to view entered emailaddress details in page2.aspx.

In page2.aspx i have Textboxes to fill the data.

So, this is my code,

Please can you help me, how to read data from database according to enterd email address in page1.aspx

My code
=======

SqlConnection conFill = new SqlConnection(_connString);
conFill.Open();
SqlCommand cmdFill = new SqlCommand("SELECT * from Userdetails", conFill);

SqlDataReader drFill = cmdFill.ExecuteReader();

            if (drFill.Read())
            {
                TxtFirstName.Text = drFill["FirstName"].ToString();
                TxtLastName.Text = drFill["LastName"].ToString();
                TxtDepartment.Text = drFill["Department"].ToString();
                TxtCompany.Text = drFill["Company"].ToString();
                TxtMobileNo.Text = drFill["MobileNo"].ToString();
                TxtOfficeTelNo.Text = drFill["OfficeTelNo"].ToString();
                TxtEmailAddress.Text = drFill["EmailAddress"].ToString();


            }


            else
            {
                TxtFirstName.Text = "";
                TxtLastName.Text = "";
                TxtDepartment.Text = "";
                TxtCompany.Text = "";
                TxtMobileNo.Text = "";
                TxtOfficeTelNo.Text = "";
                TxtEmailAddress.Text = "";

            }

请帮助我。谢谢。

Please help me. Thankyou.

推荐答案

使用查询字符串非常容易解决这个问题。



什么时候进入第1页，您点击提交按钮，将其重定向到带有输入的电子邮件地址的page2.aspx。喜欢这个



点击按钮点击活动



Response.Redirect（page2 .aspx？email =+ txtEmail.Text.Trim（））;





在Page2 .aspx Page_Load方法获取电子邮件并运行sql查询。

very easy solution of this problem to use query string.

When ever in the page1 you are clicking the submit button redirect it to the page2.aspx with the inputted emailaddress. Like this

On button Click event

Response.Redirect("page2.aspx?email="+txtEmail.Text.Trim());


In the Page2.aspx Page_Load method grab the email and run the sql query.

Page_Load()
{
  if(Request.QueryString["email"]!=null)
  {
    string email=Request.QueryString["email"].ToString();
    // Now run your query with this email. Or you can put this in another method
    // one line change in the following line.
    SqlCommand cmdFill = new SqlCommand("SELECT * from Userdetails where Email='"+email+"'", conFill);
    // write rest of the part of code
  }
}

您也可以使用session来执行此操作，但查询字符串优于会话。

You also can use session to do this but query string is better than session.

您可以使用查询字符串。 .Page1.aspx

You can use Query String..Page1.aspx

Response.Redirect("page2.aspx?email="+txtEmail.Text.Trim());

或会话

or Session

Session["UserEmail"]=txtEmail.text.tostring();

page2.aspx

page2.aspx

if(Session["UserEmail"]!=null && Session["UserEmail"].tostring()!="")
{
string Email=session["UserEmail"].tostring();
SqlConnection conFill = new SqlConnection(_connString);
conFill.Open();
SqlCommand cmdFill = new SqlCommand("SELECT * from Userdetails where UserEmail='"+Email+"'", conFill);
 
SqlDataReader drFill = cmdFill.ExecuteReader();
 
            if (drFill.Read())
            {
                TxtFirstName.Text = drFill["FirstName"].ToString();
                TxtLastName.Text = drFill["LastName"].ToString();
                TxtDepartment.Text = drFill["Department"].ToString();
                TxtCompany.Text = drFill["Company"].ToString();
                TxtMobileNo.Text = drFill["MobileNo"].ToString();
                TxtOfficeTelNo.Text = drFill["OfficeTelNo"].ToString();
                TxtEmailAddress.Text = drFill["EmailAddress"].ToString();
 

            }
 

            else
            {
                TxtFirstName.Text = "";
                TxtLastName.Text = "";
                TxtDepartment.Text = "";
                TxtCompany.Text = "";
                TxtMobileNo.Text = "";
                TxtOfficeTelNo.Text = "";
                TxtEmailAddress.Text = "";
 
            }
}
else
{
//redirect to the page1.aspx on session End
Response.Redirect("page1.aspx);
}

这篇关于如何根据EmailAddress从数据库中读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！