sql数据库常用操作 

 1 string connectionString = @"Data Source=(local)\sql2008r2;Initial Catalog=Movies;Uid=sa;Pwd=sql123$%^";
 2             SqlConnection conn = new SqlConnection();
 3             conn.ConnectionString = connectionString;
 4             conn.Open();
 5             string query = "select *from Movies";
 6             DataSet ds = new DataSet();
 7             SqlDataAdapter sda = new SqlDataAdapter(query,conn);
 8             sda.Fill(ds,"MoviesList");
 9             this.dataGridView1.DataSource = ds.Tables[0];
10             conn.Close();

 

posted @ 2013-07-02 18:46  楠楠IT  阅读(217)  评论(0)  编辑  收藏  举报