Advertisement
Guest User

Untitled

a guest
Sep 11th, 2019
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. SqlDataAdapter mydataAdapter = new SqlDataAdapter();
  2. string vSQLRefresh = "SELECT * from dbo.usermaster";
  3. mydataAdapter.SelectCommand = new SqlCommand(vSQLRefresh, cnn);
  4.  
  5. DataTable table = new DataTable();
  6. mydataAdapter.Fill(table);
  7.  
  8. BindingSource bSource = new BindingSource();
  9. bSource.DataSource = table;
  10. dataGridView1.DataSource = bSource;
  11. dataGridView1.Refresh();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement