> 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

"Jesse Houwing" wrote:

> 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
>
> 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
> jesse.houwing at sogeti.nl
>
>
>