Solved

Populating Text Boxes From a select SQL query

Posted on 2012-04-08
2
334 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
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…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

734 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