Data Grid View

To create DataGridView first of all we need to insert DataGridView tool from

toolbox.

 Data Grid View

Now, once the DataGrid is inserted we need to display data in it. To display data we

need to set its data source data table.

Example
           try
            {
string strConnection= 'Server=abc\\SQLEXPRESs;Database=Employee;Trusted_Connection=True';
            SqlConnection con = new SqlConnection(strConnection);
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter('select * from employee', con);
            DataSet ds = new DataSet();
            da.Fill(ds, 'Employee');
            DataTable dt = ds.Tables['Employee'];
            dgRecord.DataSource= dt;
//setting datasource of datagrid to a table of database ‘employee’
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
 
Here dgRecord is the name of DataGrid.

Data Grid View

Last updated:3/4/2020 3:48:15 AM
Uttam Misra

Uttam Misra

More than 18 years of working experience in IT sector. We are here to serve you best.

3 Comments

Chris Anderson
Chris Anderson

Hi,

You can bind columns initially by getting column names in DataTable. If you get whole data in DataTable and bind to datagridview, then it will display whole data present in DataTable. So in order to display columns initially:

1) First get column names by using select query and bind to DataTable.
2) Bind DataTable with datagridview.

Thanks.

Shrikant Mishra
Shrikant Mishra

Hi,

Your article is very helpful and important for a new developer.

Thank you for your posting.

Leave Comment