Gridview show/refresh based on listboxes
Posted on 2007-11-18
I have many listboxes set with the select multiple option on and what I want to do is show/refresh upon a button a query based on those selections in a gridview.
I have set my gridview datasource to :
SELECT * FROM [CatalogApp] WHERE (([PRODUCT TYPE] = ?) AND ([DIAMETER] = ?) AND ([LENGTH] = ?) AND ([GRADE] = ?) AND ([THREAD] = ?) AND ([PLATING] = ?) AND ([PAKAGING] = ?)) ORDER BY [PRODUCT CODE]
where all parameters are set to ListBox.SelectedValue.
What should be VB the code in my button ? Is my datasource set correctly ? Thanks