Dataset DB problem

Question

Dataset DB problem

George-937187

SSC Rookie

Points: 48
More actions
November 14, 2008 at 10:51 am

#196075

Hi,
I have taken over an app from a former employee. I have a grid I want to update back to the DB. I have tried several things (Below) to connect to the DB. The grid is loaded by the DB so I kow that part is correct. I do not know what I am doing wrong. I can connect through C# Tools connect to DB that is fine. Here is what I have tried
string conStr = @"Server = .\sqlexpress;
Integrated Security = true;
DataBase=PROTOTYP_DB";
qlConnection conn = new SqlConnection(conStr);
daPROTOTYPDB = new SqlDataAdapter("select * from Property", conn);
SqlCommandBuilder cmdBldr = new SqlCommandBuilder(daPROTOTYPDB);
daPROTOTYPDB.Fill(dsProperty, "Property");
The name of the db is PROTOTYP_DB.mdf and the path to it is D:\pm_demo\PM.Runtime.Demo\PROTOTYP_DB.mdf
Any help would be greatly appreciated

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

aftabsatti SSC Enthusiast Points: 173 More actions · Answer 1

the connection string you are using is not correct. There is nothing like 'Database name' in connection string. Use 'Initial catalog' instead of this, or for more information about connection strings visit this.

http://www.connectionstrings.com

Jack Corbett SSC Guru Points: 184388 More actions · Answer 2

aftabsatti (11/14/2008)

the connection string you are using is not correct. There is nothing like 'Database name' in connection string. Use 'Initial catalog' instead of this, or for more information about connection strings visit this.

http://www.connectionstrings.com[/quote%5D

Actually Database is an alternate property for connection strings, although Initial Catalog is preferred.

I think the issue is that you are never setting the UpdateCommand property of the DataAdapter.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

lrosales SSCommitted Points: 1821 More actions · Answer 3

Q. have you solved this problem? let me know. thanks :hehe:

"We never plan to Fail, We just fail to plan":)

lrosales SSCommitted Points: 1821 More actions · Answer 4

string conStr = @"Server = .\sqlexpress" _

& ";Integrated Security = true;" _

& ";DataBase=PROTOTYP_DB";

string strSQL = "Select * form Property"

qlConnection conn = new SqlConnection(conStr);

daPROTOTYPDB = new SqlDataAdapter(strsql, conn);

SqlCommandBuilder cmdBldr = new SqlCommandBuilder(daPROTOTYPDB);

daPROTOTYPDB.Fill(dsProperty, "Property");

Hope this helps.

"We never plan to Fail, We just fail to plan":)

lrosales SSCommitted Points: 1821 More actions · Answer 5

First of all I need to appologize for the wrong info I provide you with. that happens when switching from VB to CS.

Solution: Server=".\\DBName;" +

The "\\" well think of C++ and the + Equates to "_ & "

😛

thanks

and sorry!!

"We never plan to Fail, We just fail to plan":)