C# data question

[narpet]

I'm pulling data from an Access database and filling fields on a form in an app that I'm developing using C# in Visual Studio 2005. I'm using the following code (at bottom of post) to clear the data and then get what I want.

Is there any way that when I do this fill I can filter the data based on a variable.

For instance lets say that the query that I'm pulling the data from (the one listed in the code) just pulls all the data and that I want to filter it by just getting the data that has a NumberCode (example table field) of 1.

Any ideas will be greatly appreciated... I'm pretty new to C#.

qry_ORMClaimInfoTableAdapter.ClearBeforeFill.ToString();
this.qry_ORMClaimInfoTableAdapter.Fill(this.getFTPdataVIEWSDataSet.qry_ORMClaimInfo);

NOTE: those spaces are not in my code... but I can't seem to get them out when entering the code here... very strange.

[dip_developer]

I'm pulling data from an Access database and filling fields on a form in an app that I'm developing using C# in Visual Studio 2005. I'm using the following code (at bottom of post) to clear the data and then get what I want.

Is there any way that when I do this fill I can filter the data based on a variable.

For instance lets say that the query that I'm pulling the data from (the one listed in the code) just pulls all the data and that I want to filter it by just getting the data that has a NumberCode (example table field) of 1.

Any ideas will be greatly appreciated... I'm pretty new to C#.

qry_ORMClaimInfoTableAdapter.ClearBeforeFill.ToString();
this.qry_ORMClaimInfoTableAdapter.Fill(this.getFTPdataVIEWSDataSet.qry_ORMClaimInfo);

NOTE: those spaces are not in my code... but I can't seem to get them out when entering the code here... very strange.

In my opinion just create a Dataview from table of your dataset....dataview can be Filtered according to your criteria.
Following is the sample code to filter a dataview.You can then bind your dataview with any control like Datagrid or Gridview or ListView.

 
         DataView dv = new DataView(myDataset.Tables("myTable"));
        dv.RowFilter = "NumberCode = 1";
       Datagrid1.DataSource = dv;
 

[narpet]

In my opinion just create a Dataview from table of your dataset....dataview can be Filtered according to your criteria.
Following is the sample code to filter a dataview.You can then bind your dataview with any control like Datagrid or Gridview or ListView.

 
         DataView dv = new DataView(myDataset.Tables("myTable"));
        dv.RowFilter = "NumberCode = 1";
       Datagrid1.DataSource = dv;
 

Thanks very much. I actually got the sort to work. It's based on a field on the form (we'll call it ID). The field has a variable name (we'll call it vID). When I do my filter I essentially do what you stated: "dv.RowFilter = "tableID = " + vID.Text;

This works the first time, grabbing the value of vID which is in the ID field on the form. But if I change the value in ID to something else it doesn't update and I still get the first sort.

How do I update the variable to insure that I get the proper value?

Any more help will be greatly appreciated.