So I have the following:
oracle_da = New System.Data.Odbc.OdbcDataAdapter(strSQL, oracle_conn2)
oracle_da.Fill(oracle_ds, "All_Empl")
If I understand this correctly, it fills the table All_Empl in data set oracle_ds with the results from the sql statement. This so far has worked like I wanted. My question is how to filter this
I found that I can do this:
oracle_ds.Tables("All_Empl").Select("TYPE='MGMT'")
I would like to take those results and put them into a new table in dataset oracle_ds, but dont know how. I want to put the results of the filtered table into oracle_ds.Tables("Mgr_Lvl1").
What is the easiest way of doing this?
oracle_da = New System.Data.Odbc.OdbcDataAdapter(strSQL, oracle_conn2)
oracle_da.Fill(oracle_ds, "All_Empl")
If I understand this correctly, it fills the table All_Empl in data set oracle_ds with the results from the sql statement. This so far has worked like I wanted. My question is how to filter this
I found that I can do this:
oracle_ds.Tables("All_Empl").Select("TYPE='MGMT'")
I would like to take those results and put them into a new table in dataset oracle_ds, but dont know how. I want to put the results of the filtered table into oracle_ds.Tables("Mgr_Lvl1").
What is the easiest way of doing this?