BindingSource question, help me
-
Hi, I want to filter the productID that starts with "MDF", so I use
bindingsource1.filter = "productID like 'MDF%'"(look like sql query), but it's not working. Somebody could correct the code will be appreciated. Thanks in advance.It seem to be a solution or an answer.
-
Hi, I want to filter the productID that starts with "MDF", so I use
bindingsource1.filter = "productID like 'MDF%'"(look like sql query), but it's not working. Somebody could correct the code will be appreciated. Thanks in advance.It seem to be a solution or an answer.
Do you want a sql query for this? if so then here it is
select fieldNames/* from tableName where productID like 'MDF%';
This would select all/several fields from the table name where the productID begins with MDF% You can use connection/command/dataReader accordingly depending upon the database you are using.
Keshav Kamat :) India
-
Hi, I want to filter the productID that starts with "MDF", so I use
bindingsource1.filter = "productID like 'MDF%'"(look like sql query), but it's not working. Somebody could correct the code will be appreciated. Thanks in advance.It seem to be a solution or an answer.
-
Do you want a sql query for this? if so then here it is
select fieldNames/* from tableName where productID like 'MDF%';
This would select all/several fields from the table name where the productID begins with MDF% You can use connection/command/dataReader accordingly depending upon the database you are using.
Keshav Kamat :) India
It will be OK if I use sql query to filter the productID begins with MDF. But, what I need is bindingsource1.filter = "productID like 'MDF%'" is correct or not ? I mean that "productID like 'MDF%'" string is correct or not. If not, How must I make it correct ?
It seem to be a solution or an answer.