Set CheckListBox to Checked Based on Database Query

[obrienkev]

Hi,

I want to mark the CheckListBox items as Checked based on a database query.

So the CheckListBox items should be checked if each item matches fundsAffected field from the below query...

SELECT DISTINCT fundsAffected as myFunds FROM myFunds AS f
INNER JOIN myDetails AS d
ON d.corpID = f.corpID
WHERE d.securityID = securityID

How is this done? Thanks.

[Frinavale]

Hi,

I want to mark the CheckListBox items as Checked based on a database query.

So the CheckListBox items should be checked if each item matches fundsAffected field from the below query...

SELECT DISTINCT fundsAffected as myFunds FROM myFunds AS f
INNER JOIN myDetails AS d
ON d.corpID = f.corpID
WHERE d.securityID = securityID

How is this done? Thanks.

Once you've retrieved all of the records from your database and stored them into a SqlDataReader, grab the "fundsAffected" field value and see if it is true or false...set your checkListBox accordingly.

Please see the .Net article on how to use a database in your program for help on how to loop through the DataReader.

-Frinny