Populating Text Boxes From a select SQL query

Posted on 2012-04-08
Medium Priority
Last Modified: 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.?
Question by:jaytechnology
LVL 20

Accepted Solution

BuggyCoder earned 2000 total points
ID: 37821658
i suggest you use list view and then bind your data to listview, use Bind/Eval in textboxes to bind each textbox to particular data column.
here is a sample:-


Author Closing Comment

ID: 37821754
Thank you Ilooked all day.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Native ability to set a user account password via AD GPO was removed because the passwords can be easily decrypted by any authenticated user in the domain. Microsoft recommends LAPS as a replacement and I have written an article that does something …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question