how to change the filter expresion at runtime ?
-
Hi, <asp:SqlDataSource ID="grid_source" runat="server" ConnectionString="Data Source=db;Initial Catalog=faq;User ID=sa;Password=mercury" ProviderName="System.Data.SqlClient" SelectCommand="SELECT [c_empcode], [c_name], [c_designation], [c_department], [c_emailid], [c_reportingPerson], [c_passwd], [n_status] FROM [Employee_Mst] where n_deleted =0" OnSelecting="grid_source_Selecting" FilterExpression="c_name like '{0}%' and c_department like '{1}%' " > <FilterParameters> <asp:ControlParameter Name="c_name" ControlID="txtname" PropertyName="Text" /> <asp:ControlParameter Name="c_department" ControlID="txtdepart" PropertyName="Text" /> </FilterParameters> </asp:SqlDataSource> This is my sqldatasource in that i used filter expression for filtering data . if txtdepart textbox is empty means its not filtering records according to what i entered in txtname texbox .if i am entering some datas in all two textbox's then its showing filtered records . can anyone tell me the solution for this ? also i need how to change the filter expresion at runtime according to these textboxes values . Thanks in advance
-
Hi, <asp:SqlDataSource ID="grid_source" runat="server" ConnectionString="Data Source=db;Initial Catalog=faq;User ID=sa;Password=mercury" ProviderName="System.Data.SqlClient" SelectCommand="SELECT [c_empcode], [c_name], [c_designation], [c_department], [c_emailid], [c_reportingPerson], [c_passwd], [n_status] FROM [Employee_Mst] where n_deleted =0" OnSelecting="grid_source_Selecting" FilterExpression="c_name like '{0}%' and c_department like '{1}%' " > <FilterParameters> <asp:ControlParameter Name="c_name" ControlID="txtname" PropertyName="Text" /> <asp:ControlParameter Name="c_department" ControlID="txtdepart" PropertyName="Text" /> </FilterParameters> </asp:SqlDataSource> This is my sqldatasource in that i used filter expression for filtering data . if txtdepart textbox is empty means its not filtering records according to what i entered in txtname texbox .if i am entering some datas in all two textbox's then its showing filtered records . can anyone tell me the solution for this ? also i need how to change the filter expresion at runtime according to these textboxes values . Thanks in advance
The SQLDataSource classes are not suitable for real world programming. If you're doing a professional project, you should not use them. What you're describing seems to me to be a bug in the classes tho, what have you turned up on google, I'd expect other people would have asked the same question.
Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )