Connecting VB.net to a Microsoft SQL Server database - what am I doing wrong ?

Question

I'm putting together a VB 2005 Express Edition application which use the built-in Microsoft SQL server to store data.

I've got my code almost working but it's not putting the data into the database (and it's not giving me any errors either)

Here's the code.

Dim da As New FrameworkDataSetTableAdapters.ProjectsTableAdapter()

Dim projects As FrameworkDataSet.ProjectsDataTable = da.GetData()
Dim row As FrameworkDataSet.ProjectsRow

row = projects.NewProjectsRow()

row.projectName = "Missing-Auctions.com"
row.linkText = "Missing-Auctions.com"
row.url = "http://www.missing-auctions.com"
row.description = "Find misspelled eBay auctions"
row.keywords = "ebay typos, auction typos"
row.name = "Missing Auctions"
row.email = "[e-mail]"

projects.AddProjectsRow(row)
projects.AcceptChanges()

Note that there's a ProjectID column in the table as well which is the table key.

So, what am I doing wrong ?

Answer 1

You have to set up a connection string to access any database.

Answer 2

I am no VB expert but I cannot see a connection string to the database defined anywhere....maybe that will help

Answer 3

Better u write a file handelling code.Which accesses SQLDMO object to stop server & allow u take a backup otherwise u mannually stop server then goto sql directory then data copy paste .mdf *& .LDF file & add it to archive