Connecting to SQL Server Express 2008 from Visual Basic.Net

C

CAM

Hello,

I am using SQL Server Express 2008 for my database and Visual Studios 2008 -
Visual Basic.Net for my forms. I Gone into VS 2008 and specify the source
of data using the Data Sources Windows following the wizard. I have input
the Server name using Windows Authentication, select the database name and
tested the connection it works fine. I created a form in VS 2008 added
text boxes and the data navigator, table adapter. It all seems to work fine
I can add data, delete data from the DataSet, but it's not permanent. When
I look into the table in SQL nothing is updated. I just cannot update my
SQL table at all. I don't know what is missing. Can anyone help? Any tips
or website to visit I would appreciate. Thank you in advance.

Cheers
 
P

PvdG42

CAM said:
Hello,

I am using SQL Server Express 2008 for my database and Visual Studios
2008 -
Visual Basic.Net for my forms. I Gone into VS 2008 and specify the source
of data using the Data Sources Windows following the wizard. I have input
the Server name using Windows Authentication, select the database name and
tested the connection it works fine. I created a form in VS 2008 added
text boxes and the data navigator, table adapter. It all seems to work
fine
I can add data, delete data from the DataSet, but it's not permanent.
When
I look into the table in SQL nothing is updated. I just cannot update my
SQL table at all. I don't know what is missing. Can anyone help? Any
tips
or website to visit I would appreciate. Thank you in advance.

Cheers
Have you installed SP1 for your Visual Studio 2008?
It's my understanding that SP1 is required for SQL Server 2008 support.
 
C

CAM

Thanks PvdG42,
I Installed the latest service pack, but that doesn't seem to do the trick.
I appreicate your tip. Hopefully someone may have another tip. Thanks
again.

Cheers
 
C

CAM

Steve,

I beleive that is my problem I need to explicity saved back to the database,
I am not sure how to do that? Thanks for the insight.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top