grek laban

grek laban

  • NA
  • 1
  • 0

Using multiple checkedlistboxes and database..

Jul 5 2007 10:56 AM
Hi. I am trying to make an application in VS 2005 where I have 2 separate checkedListBoxes, one filled with companies from an .mdb access database, and the other filled with strings containing questions. What I want to do is to choose companies, and then choose what questions to compare in the other one.. The values for the questions in listbox2 is in the same mdbfile as the company list (one column for each question).. the comparison will then be output to a zedgraph-component graphpane listdiagram. I have had trouble in figuring out how I should write so that
foreach (object itemChecked in checkedListBox1.CheckedItems)

{
list.Add(1, y-val-for-selected-company-and-question)
}
etc..

the mdb file in short looks something like this:
Company Q1 Q2 Q3
ABC 3.44 3.67 3.1
ZYX 4.11 2.11 3.55

I'm happy for all help I can get.. Thank you..