username , password and other parameters in sqlserver connection string

Question

I'm new to C# and .net and just worked with php and mysql.
to connect to sqlserver express (in visual studio 2010) with c# we should provide a connection string that has lots of formats i found on the web specially in connectionstrings.
for example in standard format :
"Data Source=myServerAddress;Initial Catalog=myDataBase;UserId=myUsername;Password=myPassword;"

what is username and password? where can i find them? are they "root" and "" like in php mysql or something else?

as mentioned , i have created a database named "db.sdf" in sqlserver express in visual studio 2012.

I'm really confused. please help.

sdf is a SQL Server Compact Edition database.

Nasreddine
– Nasreddine

2012-09-02 15:49:40 +00:00
Commented Sep 2, 2012 at 15:49 — Nasreddine
– Nasreddine, Commented Sep 2, 2012 at 15:49

John Woo · Accepted Answer · 2012-09-02 16:20:25Z

4

If your database extension is SDF,you are creating SQL Server CE (Compact Edition) database file. Use this connection string

Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\MyData.sdf;Persist Security Info=False;

OR

Data Source=MyData.sdf;Persist Security Info=False;

More on this link.

UPDATE 1

You need the System.Data.SqlServerCe namespace.

SqlCeConnection conn = new SqlCeConnection("Data Source=\\Mobile\\Northwind.sdf;");
conn.Open();
.
.
.
conn.Close();

From MSDN:
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

edited Sep 2, 2012 at 16:20

answered Sep 2, 2012 at 15:47

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Aliweb Over a year ago

not working . when i add con.Open() , the rest of code dose not execute , but also no errors. i don't know why

John Woo Over a year ago

can you post your code?maybe you are using wrong dataprovider.

Aliweb Over a year ago

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SqlClient; namespace ConsoleApplication1 { class First { static void Main() { //string connectionString = ConsoleApplication1.Properties.Settings.Default.ConnectionString; SqlConnection con = new SqlConnection("Data Source=db.sdf;Persist Security Info=False;"); // 2. Open the connection con.Open(); Console.WriteLine("ok"); Console.ReadLine(); } } }

John Woo Over a year ago

You need to have included the System.Data.SqlServerCe namespace (not the System.Data.SqlClient). It's in the System.Data.SqlServerCe.dll.

John Woo Over a year ago

this link has provided a great tutorial for creating application that uses sqlce database file. it will even teach you how to add the assembly file you need :)

|

Collectives™ on Stack Overflow

username , password and other parameters in sqlserver connection string

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related