Improve company productivity with a Business Account.Sign Up

x
?
Solved

vb.net - on page load controls populate based on MS SQL 2005 query

Posted on 2010-09-04
3
Medium Priority
?
332 Views
Last Modified: 2013-11-27
Looking for code that poulate checkboxes or radioboxes based on a query from ms sql 2005 query.

Select first_name from address where id = "us"

if the number returns 12 then populate the form with 12 checkboxes or radioboxes...

then a submit button at bottom of form so user can choose howmany firstnames they want to choose for the invite...
0
Comment
Question by:GlobaLevel
  • 2
3 Comments
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33604756
You can add a column in you SQL table with bit datatype.the bit when it is populated in a form (datagridview or details view) it gives a check box.then when you update your selections you automatically gain what you want
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33604762
Also you can have multiple selections only with checkboxes.
0
 
LVL 1

Accepted Solution

by:
supersugar earned 2000 total points
ID: 33623719
to generate checkbox dynamically:
For Each record in records
    dim checkbox as new checkbox
    checkbox.text=record("first_name")
   checkbox.potision=xx
   me.controls.add(checkbox)
...
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
SingleRun is a tool that ensures that only one instance of an application is started, running it again brings the application to focus.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…

589 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