Connection string for C# winapp with a SQL Server database file

Question

This is not the first time I have used databases using the C# in asp.net, but I can't seem to make it work in a Winforms app.

This is a test face, so there is not a real database but a SQL Server database file that I created.

What I have is this:

public AddControl SaveResearcher(string name) 
{
   using(SqlConnection conn = new SqlConnection("")){
      SqlCommand cmd = new SqlCommand("INSERT INTO Personell VALUES (@name, @function)", conn);
      cmd.Parameters.Add("name",SqlDbType.VarChar).Value = name;
      cmd.Parameters.Add("function", SqlDbType.VarChar).Value = "Researcher";
      conn.Open();
      cmd.ExecuteNonQuery();
   }

   return AddControl.OK;
}

What do I have to put in the connection string?

Thanks in advance.

linquize · Accepted Answer · 2012-02-23 10:47:51Z

2

The connection string for at sql server db file without username/password

Server=.\SQLExpress;AttachDbFilename=c:\pathtodb\mydbfile.mdf;Database=dbname; Trusted_Connection=Yes;

You may find more connection string options at http://www.connectionstrings.com/sql-server-2008

answered Feb 23, 2012 at 10:47

linquize

20.5k10 gold badges68 silver badges84 bronze badges

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

Comments

Thit Lwin Oo · Accepted Answer · 2012-02-23 10:46:27Z

1

You can check there,

Connection strings for SQL Server 2005

answered Feb 23, 2012 at 10:46

Thit Lwin Oo

3,4283 gold badges22 silver badges23 bronze badges

Comments

CatchingMonkey · Accepted Answer · 2012-02-23 10:48:02Z

1

Do you mean soemthing like this?

"Data Source[SERVER_NAME];Initial Catalog=[DATABASE_NAME];Integrated Security=True;MultipleActiveResultSets=True"

answered Feb 23, 2012 at 10:48

CatchingMonkey

1,3912 gold badges14 silver badges37 bronze badges

Comments

Darrin Lynn · Accepted Answer · 2012-02-29 14:17:26Z

0

connectionString="Data Source=computerName\sqlexpress;Initial Catalog=DatabaseName;Integrated Security=True"

edited Feb 29, 2012 at 14:17

answered Feb 23, 2012 at 10:50

Darrin Lynn

1589 bronze badges

1 Comment

marc_s Over a year ago

If you post code, XML or data samples, PLEASE highlight those lines in the text editor and click on the "code samples" button ( { } ) on the editor toolbar to nicely format and syntax highlight it!

Collectives™ on Stack Overflow

Connection string for C# winapp with a SQL Server database file

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related