My application uses a single (large) xml file as the source for many different reports. My on_load sub reads the xml into a dataset, and sets a datagridview.datasource to the dataset.
Here's a very simple table in order to explain my question. Let's say that this is what my datagridview looks like:
Name Type Addr
fred A 123
wilma B 456
barney C 789
The user then has many different options utilizing the data. For example: I need to find all of Type:B, then do something with Name and Addr.
So here are my questions:
1.) Should I query the dataset, or the datagridview, or is there a better approach?
2.) Depending on answer to #1... How?
Can sql query syntax be used somehow? I know how to run through all the rows in the datagridview, and this is how I've been doing it (but think there must be a better approach):
for r=0 to datagridview1.rowcount-1
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
DataGridView1.DataSource = DataSet1