|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Search button to filter a DatasetI hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my database has been made in MSDE. I have a 'View Resources' page, the purpose of which is to show all employees, taken from that table in the database. This works fine, up to a point. I have a DataGrid, which is done with a DataSet and a DataAdapter. I now want the user to be able to 'filter' the DataGrid, using a text box for input, and a 'search' button. I have tried different ways of doing this but can't get it to work. I imagine that it is achieved by running some kind of different SQL statement (with a % LIKE % operator) in the btnSearch_Click method, and re-binding the Data Grid after the filter has finished. So for example the user could enter 'John' in the 'First Name' text box and click 'search', and the Data Grid would refresh accordingly with all records LIKE 'John'. My Page_Load code looks like this currently ------------------------------------------------------------------------- this.sqlDataAdapter1.Fill(this.dsResources1); DataGrid1.DataBind(); sqlConnection2.Close(); this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.GridPageIndexChanged); -------------------------------------------------------------------------------------------- Hope someone can help, I'm sure the btnSearch_Click method is where I need to put the code. Thanks in advance, Al Use DataView as data source:
DataView dv = ds.Tables[0].DefaultView; dv.RowFilter = "FirstName like '%John%'"; datagrid.DataSource = dv; datagrid.DataBind(); HTH Elton Wang Show quote "thebison" wrote: > Hi all, > > I hope someone can help with this relatively simple problem. > I am building a timesheet application using ASP.NET C# with Visual > Studio 2003.As it is only a protoype application, my database has been > made in MSDE. > > I have a 'View Resources' page, the purpose of which is to show all > employees, taken from that table in the database. This works fine, up > to a point. I have a DataGrid, which is done with a DataSet and a > DataAdapter. I now want the user to be able to 'filter' the DataGrid, > using a text box for input, and a 'search' button. I have tried > different ways of doing this but can't get it to work. I imagine that > it is achieved by running some kind of different SQL statement (with a > % LIKE % operator) in the btnSearch_Click method, and re-binding the > Data Grid after the filter has finished. > > So for example the user could enter 'John' in the 'First Name' text box > and click 'search', and the Data Grid would refresh accordingly with > all records LIKE 'John'. > > My Page_Load code looks like this currently > ------------------------------------------------------------------------- > this.sqlDataAdapter1.Fill(this.dsResources1); > DataGrid1.DataBind(); > sqlConnection2.Close(); > > this.DataGrid1.PageIndexChanged += new > System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.GridPageIndexChanged); > -------------------------------------------------------------------------------------------- > > Hope someone can help, I'm sure the btnSearch_Click method is where I > need to put the code. > > Thanks in advance, > > Al > > Hi,
Thanks for replying so quickly. Is it possible to change this code so that it does the search based on whatever text the user has entered into the search textbox...? I imagine something like this: dv.RowFilter = "FirstName like '%'+txtFirstname.text+'%'"; This doesn't seem to work though? Thanks again for your help! Al dv.RowFilter = "FirstName like '%'+txtFirstname.text+'%'";
basically is correct. What I 'm not sure is FirstName. The dataview.RowFilter property works like sql query condition (without WHERE). I just assume your column name is FirstName. It should be what ever it is. HTH Show quote "thebison" wrote: > Hi, > Thanks for replying so quickly. > Is it possible to change this code so that it does the search based on > whatever text the user has entered into the search textbox...? > > I imagine something like this: > > dv.RowFilter = "FirstName like '%'+txtFirstname.text+'%'"; > > This doesn't seem to work though? > > Thanks again for your help! > > Al > > Thebison,
Just simple > dv.RowFilter = "FirstName = '" + txtFirstname.text> dv.RowFilter = "FirstName like '%'+txtFirstname.text+'%'"; > See yourself what the like command does in this, or even if it exist. The like is everywhere else implemented, it is showed with the wildcards which are * http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatacolumnclassexpressiontopic.asp I hope this helps, Cor Hi again,
Thanks for your quick reply. I have tried that code, with some variations but still cannot quite get the search button to have any effect on my Data Grid when pressed? In the code below, I have simplified the requirement to simply return all records with a DeptID less than 2. Unfortunately it still returns all records in the table? (Note I am running the Search on the 'Dept' table now, not 'Resource') ------------------------------------------------------------------- private void btnSearch_Click(object sender, System.EventArgs e) { DataView dv = dsDept1.Tables[0].DefaultView; dv.RowFilter = "DeptID <2"; DataGrid1.DataSource = dv; DataGrid1.DataBind(); } ---------------------------------------------------------------------------- Any suggestions? I'm sure I am close to getting it to work! Is it something to do with the fact I have another DataGrid1.DataBind(); in my Page_Load section of the code? Thanks again! TheBison,
> Any suggestions? I'm sure I am close to getting it to work! Is it Probably. The databind is that what you do as the last thing in your > something to do with the fact I have another DataGrid1.DataBind(); in > my Page_Load section of the code? program. Why did you not just tried? Cor  |
|||||||||||||||||||||||
Other interesting topics