update dataset

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

Guest

Hi to all,
I've a sqlserver 2005 database and an application developed with vb.net 2005.
To manage data I used typed datasets created by the wizard.
Now I need to change the data type of a db field from interger to floating.
When I change the data type the dataset is not updated and I' m not able to
see the contents of the fields in my application. I see only blank.
How can I update the dataset?
Thank you
Antonello
 
Hello antonello,
Hi to all,
I've a sqlserver 2005 database and an application developed with
vb.net 2005.
To manage data I used typed datasets created by the wizard.
Now I need to change the data type of a db field from interger to
floating.
When I change the data type the dataset is not updated and I' m not
able to
see the contents of the fields in my application. I see only blank.
How can I update the dataset?
Thank you
Antonello
Click to expand...

I usually remove all columns except teh primary key from the dataset by hand
and then rightclick it and reconfigure teh datasource. Missing columns will
be re-added. Existing columns will be ignored.

Another option is to remove the table altogether and drag it back onto the
designer surface.
 
Jesse Houwing said:
Hello antonello,


I usually remove all columns except teh primary key from the dataset by hand
and then rightclick it and reconfigure teh datasource. Missing columns will
be re-added. Existing columns will be ignored.

Another option is to remove the table altogether and drag it back onto the
designer surface.
Click to expand...

Thank you Jesse, it works fine.
I chose removing the columns and reconfigure the dataset.
Bye
Antonello
 
Back
Top