Why does drag and drop not work in vs 2005 with a dataset?

If done a clean install of visualstudio 2005 professional and i already have problems with the drop and drag. so
I created a new project (windows application) there i created a new database with vs2005 (im running sql server 2005 express) i created tables and then i added a dataset with the wizard.

when that was done i draged and droped my table from the datasources window to the form. vs2005 created the navigater, bindingsourse and table adapter + the dataset on to the form.

now i runned the application and when i changed a value and saved it it should be saved in the.mdf file (database) but it issen't. when the application is running the changes are done but when closing the application and restarting there is nothing saved in the database. when i use an database of access i have the same problem.

I also looked at the learing video of Bob Tabor (lesson 09 for vs2005) i did the same then him and it was not working. I even downloaded his solution and i tryed it but that diden't work.

Can anybody help me with this problem?

thx

tim

[1183 byte] By [FLIPKE] at [2007-12-25]
# 1

hey ,

I found the problem, it seems when you import your database into the project the drag and drop does not work but when you do not import the the database : access or sql express then the drag and drop works!

a bug in the studio?

does anyone know how we can solve this problem?

thx

FLIPKE at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 2

Hi,

i found te solution.


When i imported the Database in VS2005 then when you run the application h will copy everytime the database to the debug folder so every time you run the app you will have a copy in the debug folder of the imported database

so on the solution explorer select the database and then properties

The property "copy to outpu...." you have to select "copy if newer data"

greetz

FLIPKE at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Database Engine...

SQL Server

Site Classified