Comments by Glen Childs (Top 29 by date)

Dim COUNT As Integer = dt.Rows.Count

For r As Integer = 0 To COUNT - 1

For Each column As DataColumn In dt.Columns

If column("AccountNo") = FrmSearch.txtCustID1.Text Then

Dim output As String = DataColumn.ToString().ElementAt(r)

dtValue.Rows.Add(output)

End If
Next

Changed it to this but now column isnt accessible due to being a 'friend'

Thanks that has solved the error, now I am getting a slightly different error... No default member found for type 'DataColumn'. Errors on the IF statement

Dim COUNT As Integer = dt.Rows.Count

For Each DataColumn In dt.Columns

For r As Integer = 0 To COUNT - 1

If DataColumn("AccountNo") = FrmSearch.txtCustID1.Text Then

Dim output As String = DataColumn.ToString().ElementAt(r)

dtValue.Rows.Add(output)

End If
Next
Next

Thanks removing them worked, but how can I add the keys back? As my C# app isnt now able to access the data in those tables.

I couldn't drop the PK - Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_Customer'. Cannot insert duplicate key in object 'dbo.Customer'. The duplicate key value is (105).
The statement has been terminated.
Msg 3725, Level 16, State 0, Line 6
The constraint 'PK_Customer' is being referenced by table 'Accounts', foreign key constraint 'FK_CustomerID'.
Msg 3727, Level 16, State 0, Line 6
Could not drop constraint. See previous errors

Labelout put is a string, it does appear though that the while loop is being skipped.. .

Hello Richard, the custID was in the Accounts as an Numeric(16,0) and CustId variable was a string.. So I have changed the variable to be an Integer and this has solved the problem thanks:)

Quick question I have added FrmCustomerAccounts.lblPoints.Text = LabelOutput into the While under 'labeloutput = reader (0)' however this isnt adding the number into the label's text, what have I done wrong?

Thanks Phil.o, Im getting another error though - cannot await string. But if I take the keyword await out the error - cannot implicitly convert string to list<string>

Thanks phil.o, however when I take the string prefix out from the _wordList, It errors saying that you cannot convert type of string to list. However if you specify that _wordList is a string I am receiving an error on the last two lines: 1. int i = r.Next(0, _wordList.Count - 1); - operator '-' cannot be applied to method group and int 2.: string doesnt contain an elementat and no extension accepting a first argument of type string could be found.

I thought it was the FileIO.ReadText async that read the contents of the file to the _wordList list.

Oops good point! When I changed from OleDB to ODBC it works fine!

Thanks for your help Modestas! :-)

Rick,

How would I be able to get your top solution to be able to convert all the sheets in the workbook?

Regards,

Glen

Thanks Modestas, dont suppose you can help, I have tried the above and I am getting the following error: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'. this error is happening on the following line of code: var cnn = new OleDbConnection(cnnStr);

Any suggestions?

Cheers,

Glen.

Rik, the code for some reason has decided to throw up an error : "External table is not in the correct format". I have been researching on the Internet but haven't found a solution. The forums seem to suggest that it is the connection string for excel however the connection string and the rest of the code is the same or similar as yours above.

Any suggestions?

But the error occurs with either line of code.

Brilliant, works! Thanks ever so much for your help Rick!

Cheers

Cheers

Thanks :)

Works fantastic, Cheers

Oh right ok.

Something like this possibly?
DateTime time = DateTime.Now;
string format = "mm hh"

The console beep and the message box doesn't run, I'm not sure if the code is at fault or whether it is the way I'm inputting the time into the text box on the form.

I have been searching for a while and I havent been able to find a way to get the app to create a folder on the desktop or for it to be able to copy the contents of the dvd to the folder.

Cheers,