Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding a column to an existing SQL database table

Status
Not open for further replies.
furjaw

furjaw

Programmer
Mar 27, 2006
49
0
0
US
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#")
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
SORT msflexgrid column 1 with decimal number 1
Replies
4
Views
114
2009luca
2009luca
2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
192
strongm
strongm
2009luca
difficult to crteate a query very complicated 1
Replies
9
Views
621
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
TWO table with the same classname 1
Replies
3
Views
89
Andrzejek
Andrzejek
VisKataboman
  • Locked
  • Question
Linear Column Gauge measurement form on Visual Basic 6.0
Replies
1
Views
80
xwb
xwb

Part and Inventory Search

Sponsor

Back
Top