a problem with DataView

[CLRBOY]

how do i filter rows comparing them to a variable ?

 

this works

// Filter the dataview

DataView myDataView = myDataSet.Tables["Customers"].DefaultView;

myDataView.RowFilter = "Country = 'Argentina' ";

 

this doesn't work

// Filter the dataview

string arg = "Argentina";

DataView myDataView = myDataSet.Tables["Customers"].DefaultView;

myDataView.RowFilter = "Country = arg ";

 

i just got a (The variable 'arg' is assigned but its value is never used)

warning.....

[PlausiblyDamp]

myDataView.RowFilter = "Country = '" + arg + "'";

[CLRBOY]

myDataView.RowFilter = "Country = '" + arg + "'";

 

 

thank you !!!! ;) :-\ :D

 

i checked this out here but it didn't help :mad:

 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadataviewclassrowfiltertopic.asp

[Nerseus]

Not sure what you're doing with the DataView after you apply the filter, but...

If you want to get at a particular row and it's data (and not for binding), then the Select method is quite a bit faster:

 

DataRow[] rows = myDataSet.Tables["Customers"].Select("Country = 'Argentina'");

if (rows.Length > 0)
{
   // Found at least one match:
   foreach(DataRow row in rows)
   {
       // Do something with each matching row
       // Don't delete in here, this is a foreach :)
   }
}