Retrieve Information from Database & Display into ASP.NET Web Controls Textbox
 

I am creating a update member page. I would like the page to auto retrieve the information he or she originally used while registering on my site and display them into the individual textboxes of the update profile page, this is to prevent the hassle to rekey in every individual details and allow the user to edit what he or she wants before it is updated into the database.

I am having problem retrieving information from the database and displaying them into the individual asp.net web text boxes. I am trying to use SQL DataAdapter or SQL Reader, but both fails. Some help to resolve this problem please, an example with code snippets will be very much appreciated. :rolleyes:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load



 displayrecord()

        End If



 Private Sub displayrecord()

 SqlConnection1.Open()

        Dim SqlDataAdapter1 As New SqlDataAdapter("SELECT * FROM Member", SqlConnection1)

        Dim objReader As SqlDataReader

        Dim SqlCommand1 As New SqlCommand("SELECT * FROM Member", SqlConnection1)

        SqlDataAdapter1.Fill(dsMember)

        objReader = SqlCommand1.ExecuteReader()



        objReader.Read()

        txtbox_user.Text = objReader("MemberUserName")

        txtbox_password.Text = objReader("MemberPassword")

        txtbox_confirmpass.Text = objReader("MemberPassword")

        txtbox_name.Text = objReader("MemberName")

        txtbox_birthdate.Text = objReader("MemberDOB")

        txtbox_nric.Text = objReader("NRIC")

        txtbox_address.Text = objReader("MemberAddress")

        txtbox_contact.Text = objReader("MemberPhone")

        txtbox_email.Text = objReader("MemberEmail")

        Dropdown_Gender.SelectedValue = objReader("Gender")

        DropDown_Age.SelectedValue = objReader("Age")

        DropDown_Income.SelectedValue = objReader("Income")

        DropDown_Children.SelectedValue = objReader("NumofChildren")

        DropDown_HearUs.SelectedValue = objReader("HowDidYouKnowAboutUs")

        objReader.Close()

        SqlConnection1.Close()

    End Sub

Re: Retrieve Information from Database & Display into ASP.NET Web Controls Textbox
 

you can use data reader for this,

command = new SqlCommand("SELECT * FROM Member",sqlConnection );

command.CommandType = CommandType.StoredProcedure;

try

{

     sqlConnection.Open();

     reader=command.ExecuteReader();

     while (reader.Read())

{

//if it is a text box 

txtbox_user.Text=reader.IsDBNull(reader.GetOrdinal("MemberUserName"))? null: reader["MemberUserName"].ToString();

//if it is a dropdown put defalut value 0 or 1, what ever value you use.

DropDown_Children.SelectedValue=Convert.ToString(reader.IsDBNull(reader.GetOrdinal("NumofChildren")) ? (int)0 : (int)reader["NumofChildren"]);                                                

                                        

}

}

catch(Exception ex)

{

   throw new Exception(ex.Message);

}

finally

{

   reader.Close();

   sqlConnection.Close();

}

Re: Retrieve Information from Database & Display into ASP.NET Web Controls Textbox
 

Hi Aish,

I do not understand what is this line of code is doing except a rough guess that it is trying to read the column MemberUserName. Would you mind explaining it to me? In addition, i am writing this code using ASP.NET with VB. Would you mind tuning this part of the codes that i have quoted into ASP.NET with VB as i am having a hard time trying to fix it into that. :o

//if it is a text box
txtbox_user.Text=reader.IsDBNull(reader.GetOrdinal("MemberUserName"))? null: reader["MemberUserName"].ToString();
//if it is a dropdown put defalut value 0 or 1, what ever value you use.
DropDown_Children.SelectedValue=Convert.ToString(reader.IsDBNull(reader.GetOrdinal("NumofChildren")) ? (int)0 : (int)reader["NumofChildren"]);

Re: Retrieve Information from Database & Display into ASP.NET Web Controls Textbox
 

Naters,

I've seen an error already, look at the code.

Why do you have a closing "End If" on the Sub Page_Load were you don't have an opening If? That should be End Sub

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

displayrecord()
End If


Post the the SQL error message that way it is easy to troubleshoot.

Dexter Zafra
http://www.myasp-net.com

Re: Retrieve Information from Database & Display into ASP.NET Web Controls Textbox
 

Regarding this set of codes, can i know how to display the records using OleDbConnection, OleDbReader?