Binding Textboxes

[RubyRue]

Hi
I have a web form with a few textboxes, ie Ref number, requestor, service area and I'd like to bind those textboxes to the relevant columns in the Sql db but I'm not sure how. The idea is that a user can search the db by entering their ref number and their request is displayed via the textboxes. They can then edit their request and re-submit it. I'm using textboxes rather than a details view or gridview so we have more flexibility over the design.
How do I go about doing this? Any help/code samples would be great, I'm using (or trying to use ) C#.
thanks

[magicben]

The best way to do tis is to get your data in the C# code behind and add it to your component.
ie, you can write things like (for a TextBox):
string myData = MyDao.getMyData();
myTextBoxComponent.Text = myData;

Does it help you ?

MagicBen

[kato77]

Hi,

I would use the SqlDataReader object....

I don't know C# but hopefully you'll be able to see what's going on in this VB example to be able to do it in C# (btw, this is assuming you're only returning one record each time).

Code: Select all

'Build connection string using the ConnectionStrings property in web.config
Dim con as New SqlConnection(ConfigurationManager.ConnectionStrings("PropertyNameHere").ConnectionString)

'Create Command Object
Dim cmd as New SqlCommand("Select * from DBTableName", con)

'Open Connection
con.Open

'Create SQLDataReader
Dim reader as SqlDataReader = cmd.ExecuteReader

'Code inside IF shows how you can use column name or column ordinal (position) which is zero based
If reader.Read Then
   textbox1.text = reader("ColumnNamefromDatabase")
   textbox2.text = reader.GetString(2)
Else
   'No Data Returned
End If

reader.Close
con.Close

Hope this helps.