Access Datasource Select Arguments and DataViews
The following example shows how to pass arguments to AcccessDataSource/Sql Datasource Select Method. DataView dataView = new DataView(); AccessDataSource2.SelectParameters[0].DefaultValue = "23233"; dataView = (DataView)AccessDataSource1.Select(DataSourceSelectArguments.Empty); //Iterate Dataview foreach (DataRowView p in dataView) { ID = Convert.ToInt32(p[0]); Parent = Convert.ToString(p[1]); Child = Convert.ToString(p[2]); Status = Convert.ToString(p[3]); ParentRev = Convert.ToString(p[4]); BubbleNo = Convert.ToString(p[5]); }