Robert Walker

I can loop while the datatable is full, but get an error when it is empty. How do I know it's empty.

The following code is me loading a listbox with a table. I have no problem with the retrieving data if data has information, but if the field is empty I get a error. how can I check the field in a listbox first for DBnull? '***1. load listbox from table …

I have a list of 20 textboxes on a form. each textbox is a record in a table. I want to loop through the textboxes if posible: for x = 1 to 20 sStmt = "update list_table set" sStmt += " docu = '"+??textbox(x)??+"'" sStmt += " where id_code = …

Dim OraStr As String = "Data Source=Oracle8i;Integrated Security=yes" OR dim OraStr As String = "Provider=""MSDAORA.1"";User ID=dev;Data Source=testdb;Password=dev" I am using oracle8i but that should be provider shouldn't it? the MSDAORA.1 is for the OLEDB so I assume it is wrong also. Any Ideas?

when running program I can see all 9 items of data are loaded into myComboBox, but when it displays on the screen all I get is 9 instances of "Test1.Global+ListCodes". What do I need to use in the DisplayMember spot? I've tried original field name of "Name1", "test.codeName" PublicStructure ListCodes …

I have set up a form that I can load a Datatable in, but how do I return the index number so I know what the user selected. If possible I would rather not use a global variable.

Here's what I did myPath = "c:\Table.mdb" myQuery = "select * from table" Public Function Return_Access(ByVal myQuery As String, ByVal myPath As String) As DataSet Dim myConnStr As String = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=" + myPath Dim myConn As New OleDb.OleDbConnection(myConnStr) Dim myAdapt As New OleDb.OleDbDataAdapter(myQuery, myConn) Try myConn.Open() Dim myReader As …

I am trying to pass the OleDbDataReader to table that I can pass out of a function.