changing a column type in database

Computing.Net > Forums > Programming > changing a column type in database

changing a column type in database

Original Message

Name: wt (by think)
Date: October 16, 2007 at 19:25:49 Pacific
Subject: changing a column type in database
OS: xp
CPU/Ram: ?
Model/Manufacturer: ?

Comment:

Hello,
I'm currently using Visual studio 2005 and MS SQL server 2005, and have this problem:
I changed a column's type in MS SQL from int to decimal. Recompile my program and also recompile by going through the steps in the visual studio's Table Adapter. e.g right click on car's table adapter, then choose configure, etc.
But some how the program still refers to the old type (int) when i use this column.
Any help would be great. thanks!!
Or any good web link is appreciated. (google gives too many links).

Report Offensive Message For Removal

Response Number 1

Name: Razor2.3
Date: October 17, 2007 at 20:05:24 Pacific

Reply: (edit)

You've given little to no information, so it's hard to give you any advice. However, I do suggest you avoid the wizard and manually make your changes.

Report Offensive Follow Up For Removal


Really need a help (VB and database SQL Adding tabs in a string in vb.net incompatible types in assignment? Appending the timestamp as a column AI...just a question	help in GW BASIC Place a Check Box in Flexigrid Primitive data types in C Ghost *.Bat File With Auto Naming? A simple program in C/C++

Nooby Question yay!

Delete Oldest file * batc...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: changing a column type in database

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 6 Days.
Discuss in The Lounge

DVD-ROM Problems

Reverse Proxy

Help setting up Apache and PHP

DVD Menus in Windows Movie Maker

After installin SP3, NTDLR not foun

All Posts Awaiting Replies