Databind sql data to textbox

[dude9er]

I am trying to data bind the data from a database to my textboxes in my form. I am trying to allow the user to update their profile information by goign to an EditProfile.aspx page. I have created a form that includes textboxes that are currently blank. How do I auto-fill the textboxes with the users current profile information.

Here is a sample of the text box field first name text box. Please help!!


<asp:TextBox ID="fName" runat="server" CssClass="inputBX"></asp:TextBox>


Here is the vb to update the textbox.


Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim UserID As String
UserID = Membership.GetUser.ProviderUserKey.ToString
SqlDataSource1.UpdateParameters("UserID").DefaultValue = UserID
SqlDataSource1.UpdateParameters("firstName").DefaultValue = fName.Text
SqlDataSource1.UpdateParameters("lastName").DefaultValue = lName.Text
SqlDataSource1.UpdateParameters("adr").DefaultValue = adr.Text
SqlDataSource1.UpdateParameters("city").DefaultValue = city.Text
SqlDataSource1.UpdateParameters("state").DefaultValue = state.Text
SqlDataSource1.UpdateParameters("zipcode").DefaultValue = zip.Text
SqlDataSource1.UpdateParameters("phone").DefaultValue = phone.Text
SqlDataSource1.UpdateParameters("fax").DefaultValue = fax.Text
SqlDataSource1.UpdateParameters("emailAdr").DefaultValue = emailAdr.Text
SqlDataSource1.UpdateParameters("repTitle").DefaultValue = reptitle.Text
SqlDataSource1.UpdateParameters("bio").DefaultValue = bio.Text
If SqlDataSource1.Update() = 0 Then
SqlDataSource1.InsertParameters("UserID").DefaultValue = UserID
SqlDataSource1.InsertParameters("firstName").DefaultValue = fName.Text
SqlDataSource1.InsertParameters("lastName").DefaultValue = lName.Text
SqlDataSource1.InsertParameters("adr").DefaultValue = adr.Text
SqlDataSource1.InsertParameters("city").DefaultValue = city.Text
SqlDataSource1.InsertParameters("state").DefaultValue = state.Text
SqlDataSource1.InsertParameters("zipcode").DefaultValue = zip.Text
SqlDataSource1.InsertParameters("phone").DefaultValue = phone.Text
SqlDataSource1.InsertParameters("fax").DefaultValue = fax.Text
SqlDataSource1.InsertParameters("emailAdr").DefaultValue = emailAdr.Text
SqlDataSource1.InsertParameters("repTitle").DefaultValue = reptitle.Text
SqlDataSource1.InsertParameters("bio").DefaultValue = bio.Text
SqlDataSource1.Insert()
End If
SqlDataSource1.SelectParameters("UserID").DefaultValue = UserID
FormView1.DataSource = SqlDataSource1
FormView1.DataBind()
End Sub