Dear All,
May i know how to filtering data from table with different dropdownlist ?
For the example, if first select the dropdownlist from the categories of computer, then the second dropdownlist will show the details related with computer such as mouse , keyboard.
As below code, first dropdownlist i query WMItemType.Items.Clear() from the Table
second dropdownlist i query as
WHERE ITEM_TYPE = '" + WMItemType.SelectedItem.Value + "' ";
but it doesnt work, kindly advise, thank you.
private void FillItemType()
{
WMItemType.Items.Clear();
string selectSQL = "SELECT INV_TYPE,INV_TYPE_DESC,INV_SYS FROM [CIMProRPT01].[dbo].[OTH_INV_CATEGORY] WHERE INV_SYS = 'WM'";
SqlConnection con = new SqlConnection(System.Configura ...
Go to the complete details ...