Skip to content

Instantly share code, notes, and snippets.

@tedliou

tedliou/DELETE SQL.cs

Last active April 6, 2016 15:27
Show Gist options
  • Save tedliou/1301846ad89ac4e2a115 to your computer and use it in GitHub Desktop.
Save tedliou/1301846ad89ac4e2a115 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DELETE SQL.cs
SqlConnection sql = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;Connect Timeout=30");
SqlCommand cmd = new SqlCommand("delete from [Table]", sql);
sql.Open();
cmd.ExecuteNonQuery();
sql.Close();
listView1.Items.Clear();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment