Bind data to controls (SQL)

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 361,875 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,339 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 1405 | Replies: 1

•

Join Date: Mar 2007

Posts: 5

Reputation: Windows3.11 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Windows3.11 Windows3.11 is offline

Offline

Newbie Poster

Bind data to controls (SQL)

Mar 26th, 2007

I'm creating a web application in VB.NET 2003 that connects to a SQL database... how do I display the data in separate controls (TextBoxes, labels, etc) instead of in a data grid?

Thanks,
Windows 3.11

•

Join Date: Jan 2006

Location: Its the internet... i am everywhere lol

Posts: 274

Reputation: f1 fan is an unknown quantity at this point

Rep Power: 3

Solved Threads: 10

f1 fan

Offline

Posting Whiz in Training

Re: Bind data to controls (SQL)

Mar 27th, 2007

my vb and my VS2003 are very rusty so there may be a better way than this.

You just get the record from the dataset/datatable and set the textbox.text or label.text = to the rows cell for the relevent data.

eg dim arow as datarow
textbox1.text = arow("firstname")
label1.text = arow("DOB")
etc and do the reverse to update the data.

You could always set the databinding on a text box and label and then put the textbox and labels datasource to the row and call databind on it too but i am rusty with VS2003 to know whether it is available in that or just 2005.