Populating Text Boxes From a select SQL query
Posted on 2012-04-08
I am using SQL server 2008 R2, VS2010 and I have an apllication that I have written where users go in and enter data. It is a free form, not a gridview or List or any control. All this data updates just fine.
What I need to do is return the data based off the link ID which I have no problem, but there are about 30 fields on the form. I want to keep them all on one page. Gridview or any of the assp.net components will not keep everything on one page. I actually want the user to view exactly what they posted when they search. SO if I have 5 text boxes on the first row, 7 check boxes on the the next three rows, that is how I want to display the data, and I have never tried to accomplish this outside a normal datasource and gridview.. The 30 colums go way off the age and that is not how I want it to display. Almost like filling out an adobe form, i want the data to be retrieved from SQL and displayed in no more than 4 columns and about 20 thin rows. What is the best way to approaach this.?