|
VS 2005 ASP .NET Managed Code -- Roman --
My goal is to apply data entered in multiple text boxes as parameters for sqldatasource filter bound to a datagrid control I have created an asp .net web page. To the page I added datagrid control. The datagrid control getting it's data from sqldatasource. The sqldatasource is defined as a straight select against one table. I have, also, added textbox control to the same page. I have defined filter parameter for the sqldatasource as textbox1.text. The filter expression is yow_model_no like '%{0}%' . This works. If I try to add another text box and define another filter parameter. In the filter expression I specify yow_model_no like '%{0}%' and upc_code like '%{1}%'. This doesn't work. Could someone tell me where I went wrong here? Thanks in advance |