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.
 
Back
Top