lethalMango
lethalMango

Reputation: 4491

ASP.NET - Update DataSet Table Adapter to match Database Data Type

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

Answers (2)

Akram Shahda
Akram Shahda

Reputation: 14781

Set the DataType of the DataTable's DataColumn in your DataSet to Int64.

Upvotes: 1

Nils Magne Lunde
Nils Magne Lunde

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

Related Questions