471,328 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,328 software developers and data experts.

Update my DataSet definition when I change DB Schema

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?


Jul 22 '05 #1
1 5823
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.

Jul 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by PAUL | last post: by
2 posts views Thread by Henrik | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.