Solved

Populating Text Boxes From a select SQL query

Posted on 2012-04-08
2
329 Views
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.?
0
Comment
Question by:jaytechnology
2 Comments
 
LVL 20

Accepted Solution

by:
BuggyCoder earned 500 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:-

http://msdn.microsoft.com/en-us/magazine/cc337898.aspx
http://msdn.microsoft.com/en-us/library/bb398790.aspx
0
 

Author Closing Comment

by:jaytechnology
ID: 37821754
Thank you Ilooked all day.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
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…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

706 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now