Reputation: 4491
Have been learning ASP.NET (using C#) over the past few days.
I have made everything as I need it, now realised one of my datatypes in the database needs to change from an int
to a bigint
. I managed to change that fine in all the tables, but my queries that call Table Adapters still are looking for an int
not a long / bigint
.
Could someone tell me how to update the datatypes in a dataset / table adapter please to match the database schema.
(Not sure if it makes much difference but I am using Visual Studio 2010)
Thank you :)
Upvotes: 0
Views: 2501
Reputation: 14781
Set the DataType of the DataTable
's DataColumn
in your DataSet
to Int64.
Upvotes: 1
Reputation: 1824
It depends on how you created the dataadapters and the datasets.
If you did it using the wizard in Visual Studio, you can change the dataadapter by right-clicking it and select Configure Data Adapter
. To recreate the datasets, right-click the dataadapter and select Generate DataSet
.
Upvotes: 1