Avatar of zipnotic
zipnotic
Flag for United States of America asked on

Better way to bind hundreds of text boxes to datatable

I was asked to create a read only user interface to an old database where I'll need to display the data across multiple tab pages and a couple of hundred text boxes.  Ordinarily it's not a big deal to use the binding source and connect the boxes to the tables but I lost count around 200.   I poked around a little bit with creating all the boxes at run time looping through the columns to create them (and bind them) but I didn't care for the layout and it became more of a hassle.  Now I have this project with even more boxes to bind to datatables and I'm looking at dozens of hours.  Ok, maybe a day, but I still wonder if there's a more efficient way?

I'm using VB.net and Visual Studio 2017

Thanks for any thoughts
Visual Basic.NET.NET ProgrammingUI/UXDatabases

Avatar of undefined
Last Comment
zipnotic

8/22/2022 - Mon
Chinmay Patel

Hi zipnotic,

Can you clarify if this is a WinForm or WebForm/MVC project?

Regards,
Chinmay.
zipnotic

ASKER
My bad,  this is a winforms project.  Stacking the boxes vertically makes too scrolling and tabularizing is just ugly.  I also have to deal with the cryptic field names.  If I do something dynamic I might build a cross reference (lookup?) table so field inc_per_pk translates to human readable label on the field.  Doesn't seem like it save much work though for a static FB viewer.
ASKER CERTIFIED SOLUTION
zipnotic

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61