Advertisement
wingman007

C# DataGridViewBindingToDataSet

Nov 13th, 2014
230
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.04 KB | None | 0 0
  1. // 11 http://csharp.net-informations.com/datagridview/csharp-datagridview-sql-server.htm
  2.  
  3. private void button1_Click(object sender, EventArgs e)
  4.         {
  5.  
  6.             //this.dataGridView1.Refresh();
  7.  
  8.             // DataGridView dg1 = new DataGridView();
  9.             // dg1.DataSource = src1;
  10.  
  11.             // Update Data in src1
  12.  
  13.             // string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";
  14.             string sql = "SELECT * FROM Users";
  15.             // OleDbConnection connection = new SqlConnection(connectionString);
  16.             OleDbDataAdapter dataadapter = new OleDbDataAdapter(sql, connection);
  17.             DataSet ds = new DataSet();
  18.             connection.Open();
  19.             dataadapter.Fill(ds, "users_table");
  20.             connection.Close();
  21.             dataGridView1.DataSource = ds;
  22.             dataGridView1.DataMember = "users_table";
  23.  
  24.  
  25.             // dataGridView1.DataSource = null;
  26.             // dataGridView1.DataSource = src1;
  27.             // dataGridView1.Refresh();
  28.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement