sql数据库常用操作

 string connectionString = @"Data Source=(local)\sql2008r2;Initial Catalog=Movies;Uid=sa;Pwd=sql123$%^";

             SqlConnection conn = new SqlConnection();

             conn.ConnectionString = connectionString;

             conn.Open();

             string query = "select *from Movies";

             DataSet ds = new DataSet();

             SqlDataAdapter sda = new SqlDataAdapter(query,conn);

             sda.Fill(ds,"MoviesList");

             this.dataGridView1.DataSource = ds.Tables[];

             conn.Close();