Populate a datagridview with sql query results

by

Here’s your code fixed up. Next forget bindingsource

 var select = "SELECT * FROM tblEmployee";
 var c = new SqlConnection(yourConnectionString); // Your Connection String here
 var dataAdapter = new SqlDataAdapter(select, c); 

 var commandBuilder = new SqlCommandBuilder(dataAdapter);
 var ds = new DataSet();
 dataAdapter.Fill(ds);
 dataGridView1.ReadOnly = true; 
 dataGridView1.DataSource = ds.Tables[0];

More Related Contents:

  1. Filtering DataGridView without changing datasource
  2. Copy DataGridView values to TextBox
  3. How to handle click event in Button Column in Datagridview?
  4. List vs BindingList Advantages/DisAdvantages
  5. How to detect DataGridView CheckBox event change?
  6. how I can show the sum of in a datagridview column?
  7. how to bind datatable to datagridview in c#
  8. C# DataGridView Checkbox checked event
  9. DataGridView checkbox column – value and functionality
  10. How to sort databound DataGridView column?
  11. Index of Currently Selected Row in DataGridView
  12. Show row number in row header of a DataGridView
  13. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  14. Search for value in DataGridView in a column
  15. Adding Text to DataGridView Row Header
  16. Show Loading animation during loading data in other thread
  17. Programmatically add new column to DataGridView
  18. Rows cannot be programmatically added to the datagridview’s row collection when the control is data-bound
  19. DataGridView with Button Control – Delete Row
  20. DataGridView AutoFit and Fill
  21. How do I change the datagridview selected row background color?
  22. Check/Uncheck a checkbox on datagridview
  23. Open dropdown(in a datagrid view) items on a single click
  24. Read nodes of a xml file in C#
  25. Datagridview full row selection but get single cell value
  26. DataGridView bound to BindingList does not refresh when value changed
  27. How to move focus on next cell in a datagridview on Enter key press event
  28. How to display an image in a datagridview column header?
  29. DataGridView not showing properites of objects which implement ICustomTypeDescriptor
  30. Triggering a checkbox value changed event in DataGridView

Leave a Comment