OLE Databinding
-
:confused: The following works if only one row & one column is returned in a function Dim ssql As String ssql = "select full_name from EMPLOYEE WHERE full_name = '" & usertoLookup & "'" Dim myCommand As New OleDb.OleDbCommand(ssql, OleDbConnection1) OleDbConnection1.Open() EngActivitiesToFind = myCommand.ExecuteScalar() myCommand.Dispose() OleDbConnection1.Close() The following works if dataset / dataview returns multiple rows to bind to datagrid in a function Dim myCommand As New OleDb.OleDbCommand(strsql, myConnection) Dim MyAdapter As New OleDb.OleDbDataAdapter(myCommand) myConnection.Open() MyActivityDataSet.Clear() MyAdapter.Fill(MyActivityDataSet, "dcr_track") EngActivityDataView.Table.Clear() DataGrid_DCR.Refresh() EngActivityDataView = MyActivityDataSet.Tables("dcr_track").DefaultView DataGrid_DCR.DataSource = EngActivityDataView But how do you handle it in a single function if sometimes your retrieve returns multiple rows and other times a single row dependent on a query that is dynamic and dependent on user input Thanks Milancie
-
:confused: The following works if only one row & one column is returned in a function Dim ssql As String ssql = "select full_name from EMPLOYEE WHERE full_name = '" & usertoLookup & "'" Dim myCommand As New OleDb.OleDbCommand(ssql, OleDbConnection1) OleDbConnection1.Open() EngActivitiesToFind = myCommand.ExecuteScalar() myCommand.Dispose() OleDbConnection1.Close() The following works if dataset / dataview returns multiple rows to bind to datagrid in a function Dim myCommand As New OleDb.OleDbCommand(strsql, myConnection) Dim MyAdapter As New OleDb.OleDbDataAdapter(myCommand) myConnection.Open() MyActivityDataSet.Clear() MyAdapter.Fill(MyActivityDataSet, "dcr_track") EngActivityDataView.Table.Clear() DataGrid_DCR.Refresh() EngActivityDataView = MyActivityDataSet.Tables("dcr_track").DefaultView DataGrid_DCR.DataSource = EngActivityDataView But how do you handle it in a single function if sometimes your retrieve returns multiple rows and other times a single row dependent on a query that is dynamic and dependent on user input Thanks Milancie
Use the "ExecuteReader" function to obtain a rataReader object. Then you can read the rows one at a time. Alternatively, you can instantiate a DataSet and "fill" it with your connection and then access the data in the dataset as you would any other database, or use it to fill your datagrid. There are actually lots of choices and I'm not sure which best fits your situation pxw