Sql Database Schema Change

Question

3.00/5 (2 votes)

See more:

Hi,

I am using vb.net 2005 and I have a sql express database table I have named "Clients". Every so often I need to add a new column to the Clients database table programatically, which I can do ok.

The problem is getting the existing ClientsDataSet on the VB Form [Design] Screen to update programatically to include the new column in the Clients Table in the Dataset Designer, and to include the new column in the ClientsTableAdapter query.

I have searched the web and have worked out how to update the schema with Fillschema, but this is for newly created datasets and datatables, not existing.

Can someone please explain how to programatically update an existing dataset table and tableadapter attached to a VB Form, to include a new column added into a sql database table?

Thank you,

Peter.

Posted 1-Oct-12 12:53pm

PeterScaletti

Updated 2-Oct-12 13:50pm

v13

Add a Solution

Comments

Sergey Alexandrovich Kryukov 1-Oct-12 20:06pm

This is called "schema evolution", the whole issue. What did you find exactly, and what "cannot work"?
--SA

PeterScaletti 1-Oct-12 20:33pm

Hi Sergey, thank you for your comment. I am unable to get a table within an existing dataset and an existing tableadapter query, to update, to include a new column that has been added into a sql database.

Sergey Alexandrovich Kryukov 2-Oct-12 10:40am

Maybe, if you can produce a relevant short code sample, somebody or myself would be able to see what's wrong. You also need to describe what you expected to get and what exactly happened instead.
--SA

PeterScaletti 2-Oct-12 19:46pm

Hi Sergey, thank you for your reply.

This is what I have found,(where objConn is the sql connection string):

Dim daCients As New SqlDataAdapter("Select * From Clients", objConn)
Dim dsClients As New DataSet("Clients")
daClients.FillSchema(dsClients, SchemaType.Source, "Clients")

From this I have been able to create a new dataset and new tableadapter with the updated sql database schematics. What I require, and I am unable to do, is to update an existing dataset and tableadapter.

Thank you, Peter Scaletti

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)