Subject: Adding a column to an existing SQL database table · Posted: 2007-04-21, 06:24pm
Rank: ? (5)
Member #: 27402
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#")
