SQL Insert Data

1 usingSystem;2 usingSystem.Collections.Generic;3 usingSystem.Linq;4 usingSystem.Text;5 usingSystem.Threading.Tasks;6 usingSystem.Data.SqlClient;7 8 namespaceSQL Insert Data9 {Ten     class Program One     { A         Static voidMain (string[] args) -         { -             //Database String the             stringstr ="Data Source=.;i Nitial catalog=mysql;integrated security=true"; -            //SQL statements -             stringsql ="INSERT into student values (5, ' AAA ', ' sss ', ' DDD ')"; -             //connecting to a database +SqlConnection con =NewSqlConnection (str); - con. Open (); +             //Execute SQL command ASqlCommand cmd =NewSqlCommand (Sql,con); at            //determine if SQL was executed -             intn =-1; -n =cmd. ExecuteNonQuery (); -             if(n>0) -             { -Console.WriteLine ("execution finished! The number of rows affected is:"+n); in             } -             Else to             { +Console.WriteLine ("Execution failed! "); -             } the Console.readkey (); *             //Close the database $ con. Dispose ();Panax Notoginseng cmd. Dispose (); -         } the     } +}

SQL Insert Data