C#Sql Server接続(追加、削除、変更、検索)

//追加、削除、更新、照会共通

string MyConn = "server=127.0.0.1;uid=      ;pwd=  ;database=      ;Trusted_Connection=no";
SqlConnection MyConnection = new SqlConnection(MyConn);

1、増加

          string MyInsert = "     sql  ";
          SqlCommand MyCommand = new SqlCommand(MyInsert, MyConnection);
          MyConnection.Open();
          MyCommand.ExecuteNonQuery();
          MyConnection.Close();

2、削除

           string MyDelete = "     sql  ";
            SqlCommand MyCommand = new SqlCommand(MyDelete, MyConnection);
            MyConnection.Open();
            MyCommand.ExecuteNonQuery();
            MyConnection.Close();

3、更新

           string MyUpdate = "     sql  ";
            SqlCommand MyCommand = new SqlCommand(MyUpdate, MyConnection);
            MyConnection.Open();
            MyCommand.ExecuteNonQuery();
             MyConnection.Close();

4、照会

            MyConn.Open();
            SqlDataAdapter dap = new SqlDataAdapter("     sql  ",MyConn);
            DataSet ds = new DataSet();//   DataSet 
            dap.Fill(ds, "Table");//  SQL     
            dataGridView1.DataSource = ds.Tables[0].DefaultView;//