Data set Filter

[Lost User]

Hi All, I am using Data set to get value from the data base using following code.

DataSet ds = new DataSet();
String connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(query, connectionString);
mySqlDataAdapter.Fill(ds);

once i get this i want filter with another query how to add do this. Thanks, Amit

[zeego]

You can either filter with a SQL query or use datatable's 'Select' method like DataRow[] dr=ds.Tables[0].Select("id="+yourid);

[Lost User]

hi I want like query like this way i am filling dataset in following way

SELECT O.name , study_uid_mask FROM study_org_mapping s INNER JOIN Organization O ON O.PK = S.ORG_FK"

ds.Tables[0].Select(myid + "LIKE 'study_uid_mask'";

but it seems it is not working Thanks, Amit

[zeego]

Would'nt it be study_uid_mask=your_value; DataRow[] foundRows=ds.Tables[0].Select("myid ="+study_uid_mask); ? More on filter expressions here http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx[^]