Sql

Shows how to perform an SQL update or insert statement. The query must not return a recordset!

Download sqlnonquery.zip

Synopsis:

sqlnonquery.cs

sqlnonquery.cs Synopsis

using System.Data.SqlClient; class SqlSnippets { private void x() { string dbname = "test"; string svrname = "(local)"; SqlConnection conn = new SqlConnection("Initial Catalog="+dbname+";Data Source="+svrname+";User ID=sa;Password=;"); string query = "update xx "; //no select! SqlCommand cmd = new SqlCommand(query); cmd.Connection = conn; cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } }