Mega Code Archive

 

Categories / C# / ADO Database

 

Use SqlCommand to call SQL and insert data to database table

using System; using System.Data; using System.Data.SqlClient;    class CommandExampleCreate {       static void Main() {          SqlConnection thisConnection = new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI");          SqlCommand nonqueryCommand = thisConnection.CreateCommand();          try {             thisConnection.Open();             nonqueryCommand.CommandText = "CREATE TABLE MyrntsoftTable1 (intColumn integer)";             Console.WriteLine(nonqueryCommand.CommandText);             Console.WriteLine("Number of Rows Affected is: {0}", nonqueryCommand.ExecuteNonQuery());             nonqueryCommand.CommandText = "INSERT INTO MyrntsoftTable1 VALUES (99)";             Console.WriteLine(nonqueryCommand.CommandText);             Console.WriteLine("Number of Rows Affected is: {0}",                nonqueryCommand.ExecuteNonQuery());          }           catch (SqlException ex)           {             Console.WriteLine(ex.ToString());          }          finally           {               thisConnection.Close();  // close connection             Console.WriteLine("Connection Closed.");          }       }    }