Advertisement
rakoczyn

SQL DataReader / SQLConnection

Jun 25th, 2012
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.83 KB | None | 0 0
  1. string connStr = @"Data Source=(localdb)\v11.0;Initial Catalog = Movies;User Id = moviesuser;Password = qwerty123";
  2.             SqlConnection conn = new SqlConnection(); ;
  3.             SqlCommand cmd = new SqlCommand();
  4.            
  5.             using (conn = new SqlConnection(connStr))
  6.             {
  7.                 //conn.Open();
  8.                 cmd = new SqlCommand("SELECT * FROM Videos", conn);
  9.  
  10.                 try
  11.                 {
  12.                     conn.Open();
  13.                     DataTable dt = new DataTable("Video");
  14.                     dt.Load(cmd.ExecuteReader());
  15.  
  16.                     dataGridView1.DataSource = dt;
  17.                     dt.WriteXml(@"C:\Users\Wojtek\Desktop\data.xml");
  18.                 }
  19.                 catch (Exception)
  20.                 {
  21.                     throw;
  22.                 }
  23.             }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement