hi friends. i am using VS2005 to develop a windows application.
I have a datagrid bound to a dataset with only one database table in it.
I have added following query to data adapter :
SELECT MatNO, Descp, MatGrp, Type, Qlty, Unit
FROM material_master
WHERE (Descp LIKE '%' + @name1 + '%')
now when i run this query with query builder the result is ok.when i saved the quer with name " FillBy_Matname_ name(@name1)"
and then use to see the preview of data in datagrid with this query name the results are not displayed.but if i enter the exact Descp only then record is displayed .but not on entering a substring.
whereas i have written the query for substring
what could be the problem,in query builder its showing records
I have a datagrid bound to a dataset with only one database table in it.
I have added following query to data adapter :
SELECT MatNO, Descp, MatGrp, Type, Qlty, Unit
FROM material_master
WHERE (Descp LIKE '%' + @name1 + '%')
now when i run this query with query builder the result is ok.when i saved the quer with name " FillBy_Matname_ name(@name1)"
and then use to see the preview of data in datagrid with this query name the results are not displayed.but if i enter the exact Descp only then record is displayed .but not on entering a substring.
whereas i have written the query for substring
what could be the problem,in query builder its showing records