Ashwini

Ashwini

  • NA
  • 147
  • 140k

Stored procedure for listbox items

Sep 26 2011 7:55 AM
Hi, i have developed one windows form application in that i have two list boxes,in 1st list box iam binding column headings of table by writing stored procedure. i have add and remove buttons, if i click on add the item from 1st listbox should be added to 2nd list box,if i click remove it should removed from 2nd list box. now my problem is, in 2nd list box suppose i have 2 items means i have to write stored procedure for fetching data from database for those two column names and bind to datagrid. if i have 3 or 4 items in 2nd listbox again i have to write stored procedure for fetching 4 column values. here for this problem i have to write only one stored procedure for fetching number of column values data depending upon number of items in 2nd list box how to do write stored procedure for this, please help me regarding this. Thanks in advance.

Answers (16)