Update my DataSet definition when I change DB Schema

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Visual Studio 2003 C# SQL Server 2000

I have a dataset on my form. I have added some fields to the database table
that this dataset uses, how do i update my dataset to show these extra fields?

Thanks

Steve
 
If you are using the wizards to create data adapters and datasets, etc,
you can go through the wizard again. However, it is easier to just
manually add the fields to the dataset schema. Or, you can manually
change the select statements/stored procedures for the data adapter and
then right click the dataadapter, select generate dataset and overwrite
your currrent one. Unfortunately, there is not an automatic refresh of
the schema when database changes are made.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read (and Visualize) DB Schema from SQL Server 8
Generate Dataset: retrieving schema failed 1
Can I sync a typed dataset schema with database schema easily? 1
Copying one dataset to another 5
My Typed datasets change character 2
Crystal Reports and DataSets 1
database wont update 1
Crystal Reports and VS Express 3

Back
Top