gary.p.heath (3/5/2013)
I have a program of my own, for my own use, written in Excel VBA that I want to rewrite in VB2010 Express using SQLCE.It currently displays a Form as per the picture attached.
What is the best way of replicating something similar ? I know I can create individual Buttons & TextBoxes for each Row, but I am wondering if there is a better way. I tried using DataGridView, but (a) it's pretty ugly & (b) it doesn't let me use more than one Table !!!
I don't mind using a load individual Buttons & TextBoxes, but thought I would ask people who might know better, before doing so 😉 !!!
You need a lot more details before anybody has much chance of offering you any real help. I would think that a grid would be a good approach but it is awfully hard to tell what you are doing with nothing more than a screenshot of stuff. We can't tell what is going on with that.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/