Search results for query: *

I'll give that a try, thanks. I used the CType method to try to convert the dataset to a string but that only worked when I drilled down to the individual dataset row items so it ended up being rather a long piece of code! Andrew

Yeah, I'm looking into trying that now. I've converted my code to read... ... Dim dsCounter AsInteger Dim ImportString, FItemArray, strTemp AsString With MyDataSet400.Tables(0) For dsCounter = 0 To .Rows.Count - 1 'loop strTemp = CType(MyDataSet400.Tables(0).Rows(dsCounter), String)...

Hi I have a dataset (MyDataSet400) which I use as input to a SQL table called tblDRAAS400. I use the following code to loop through the dataset to populate the table. This works fine until one of the fields in the dataset contains an single quote, i.e. “O’BRIEN”. Here’s my code: Dim...

Hi I’ve done some searching on DataGrids but I’m having trouble finding exactly what I need. Basically, I want to test each cell in a specific column for matching criteria and if matches, then change the colour of that cell. I have found out how to test all cells but I can’t pin down a...

Hi I have a listbox called lstTableNames, which returns a list of all of the tables in my database. When I select the table in the list box, I want a combo box to return all of the fields in the selected table. For example, if I select “company” (a table in my database) from the listbox, I...