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
I'm using VB.net and Visual Studio 2017
Thanks for any thoughts
Visual Basic.NET.NET ProgrammingUI/UXDatabases
Last Comment
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
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.
Can you clarify if this is a WinForm or WebForm/MVC project?
Regards,
Chinmay.