Visual Basic 2005
I used DataSet Designer to add a column called "Case#" to an existing SQL table.
The table is used by a DataGridView in a VB 2005 program.
I got it working on my development computer in debug mode.
Then, when I installed it, I got an exception "Case# is an invalid column" and none of my data records appeared.

Adding the following statement did not help:
PatientDataSet.Patient.Columns.Add("Case#")


[Edited by furjaw on 22-04-2007 at 11:11 AM GMT]

hmmn.. is the # symbol a permitted character in column names?

____________________________
Been busy trying to take a second degree <--it's not working out...