Skip to content

Instantly share code, notes, and snippets.

@tedliou

tedliou/【Visual C#】連線本機SQL Server

Created December 12, 2015 08:23
Show Gist options
  • Save tedliou/e47cad4eac30770af09a to your computer and use it in GitHub Desktop.
Save tedliou/e47cad4eac30770af09a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
【Visual C#】連線本機SQL Server
//資料庫
string cmdsql = "SQL指令";
SqlConnection sql = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\資料庫名稱.mdf;Integrated Security=True;Connect Timeout=30");
SqlCommand cmd = new SqlCommand(cmdsql, sql);
sql.Open();
cmd.ExecuteNonQuery();
sql.Close();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment