I think that it was a mistake to add the column via DataSet Designer, so, I restored my project from a backup eliminating that step.
If the column must be edited by the user, then it will need to be in the dataset.
So, now the column does not exist in the database and I am back to square one.
Just incase you somehow missed the point i was making before; it matters not whether you put a column in a DataTable in the DataSet designer or not. It doesnt affect the database, it has nothing to do with the database, and there is no concept of "now the column doesnt exist in the database" because it never did!
I would like to add the column to the SQL tables via my app so that my various users can have it added to their databases. Every user has his own database.
Then you will need to issue a DDL statement, that looks something like:
ALTER TABLE myTab ADD CaseNbr
VARCHAR2(500)
The bold bit is the type of column, this is a 500 char string..
I know nothing about SQL.
I recommend you learn a very little bit, from
www.w3schools.com
There are no SQL statements in my app. Everything is done by TableAdapter
TableAdapters contain SQL statements. By default they take a simplistic route of selecting everything from a database, and can usually generate the relevant update commands if the table has a primary key.
Trust me, your app does use SQL, you jsut havent seen it. I recommend you do look at it, because downloading all 1000 records from a table, just because you want to look at the 3 whose FirstName start with "Smith" isnt wise
That's why I don't know how to add a column to the SQL table.
OK, well, a DDL is what you need, take a read of the w3schools link..
As for how you would get it into your program, i dont recommend you do. Instead, make a separate app that contains only the following code:
Dim cmd as New SqlCommand(
"ALTER TABLE myTable ADD CaseNbr VARCHAR2(500)", New SqlConnection
(conn_string))
cmd.ExecuteNonQuery
Ensure the sql is correct (see w3schools), and the conn_string can be replaced with whatever is in the settings of the other app..