RSS

Re: Adding a column to an SQL database

Please support our VB.NET advertiser: Programming Forums

Adding a column to an SQL database

•

Join Date: Oct 2006

Location: somewhere in West-Africa

Posts: 202

Reputation: jamello is an unknown quantity at this point

Rep Power: 3

Solved Threads: 6

jamello

Offline

Posting Whiz in Training

Re: Adding a column to an SQL database

Apr 25th, 2007

Hey! Methinks the use of a character like "#" is the problem.
Do not include this kind of character or any of the following in your table name(*&%$#@!). It should work. Please get back to me.

•

Originally Posted by furjaw

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#")

DaniWeb Home > Forums > Software Development > VB.NET > Adding a column to an...

Re: Adding a column to an SQL database

Adding a column to an SQL database

Re: Adding a column to an SQL database