C# DataGridView Binding - SQL Server dataset

The DataGridView can display data in Bound mode, unbound mode and Virtual mode . Bound mode is suitable for managing data using automatic interaction with the data store. One very common use of the DataGridView control is binding to a table in a database. Unbound mode is suitable for displaying relatively small amounts of data that you manage programmatically. Virtual mode gives you a higher degree of control by allowing you to wait until a cell is actually being displayed to provide the value it will contain.

The following C# program shows how to bind a SQL Server dataset to a DataGridView.

Full Source C#
using System; using System.Data; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True"; string sql = "SELECT * FROM Authors"; SqlConnection connection = new SqlConnection(connectionString); SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection); DataSet ds = new DataSet(); connection.Open(); dataadapter.Fill(ds, "Authors_table"); connection.Close(); dataGridView1.DataSource = ds; dataGridView1.DataMember = "Authors_table"; } } }







Related Topics
  1. C# DataGridView Binding - OLEDB dataset
  2. C# DataGridView Sorting and Filtering
  3. C# DataGridView Add Columns and Rows
  4. C# DataGridView Hide Columns and Rows
  5. C# DataGridView Read Only Columns and Rows
  6. Add Button to C# DataGridView
  7. Add CheckBox to C# DataGridView
  8. Add ComboBox to C# DataGridView
  9. Add Image to C# DataGridView
  10. Add ViewLink to C# DataGridView
  11. C# DataGridView Paging
  12. C# DataGridView Formatting
  13. C# DataGridView Template
  14. C# DataGridView Printing
  15. C# DataGridView Export to Excel
  16. C# DataGridView Loading data from Excel
  17. C# DataGridView Database Operations
  18. Delete row from datagridview by right click
  19. DataGridView Autocomplete TextBox in C#