Working With Datagridview CheckBox,Combobox and Button Column

In this article I perform some simple operations using a DataGridView CheckBox, Combobox and Button. The following is a summary of what this articloe does:

• We are creating the database and table in SQL.
• Create a class for the SQL connection.
• Create a class to get data and execute a query against the database table.
• Save, Update and Delete in a DataGridView on button click.
• Delete a row from the database in the DataGridView's current row button click.

Here we create a database for our project.



Then create the ConMgr Class for the database connection. This is a static class that returns the SQL connection. The Code for ConMgr.cs is:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient;

namespace dataGridCorner

{

class ConMgr

{

public static SqlConnection GetConnection()

{

SqlConnection con = new SqlConnection();

con.ConnectionString = @"Data Source=.\\SQLEXPRESS;Initial Catalog=CORNER_DB;Integrated Security=True;";

return con;

}

}

}

Now we are going to design a form for the project. This Project contains only one form. The main control of the form is a DataGridView and three buttons.

Using the show button we are going to show all records from the table. Using the save button we are performing save, update and delete operations.

After that we will create a method named "GridColumn". This method contains code for the DataGridView column and design. The code for this method is given below.

Creating checkbox column for DataGridView:

DataGridViewCheckBoxColumn chk = new ataGridViewCheckBoxColumn();

chk.HeaderText = "Select";

chk.Name = "chk";

chk.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;

chk.FlatStyle = FlatStyle.Standard;

chk.ThreeState = false;

Creaeting ComboBox Column for DataGridView:

DataGridViewComboBoxColumn combo = new DataGridViewComboBoxColumn();

combo.HeaderText = "Choose";

combo.FlatStyle = FlatStyle.Standard;

Adding Item to ComBoxColumn:

combo.Items.Add("SOFTWERE DEVELOPER");

combo.Items.Add("PROGRAMMER");

combo.Items.Add("SECURITY EXPRERT");

combo.Items.Add("DATABASE ADMINISTRATOR");

Adding button Column for DataGridView:

DataGridViewButtonColumn button = new DataGridViewButtonColumn();

button.HeaderText = "Delete";

button.FlatStyle = FlatStyle.Popup;

button.DefaultCellStyle.BackColor = Color.Red;

button.DefaultCellStyle.ForeColor = Color.White;

Adding All Column to DataGridView:

dataGridView1.Columns.Insert(0, chk);

dataGridView1.Columns.Add("", "Name");

dataGridView1.Columns.Add("", "Country");

dataGridView1.Columns.Insert(3, combo);

dataGridView1.Columns.Insert(4, button);

dataGridView1.Columns.Add("", "ID");

Hide ID Column:

dataGridView1.Columns[5].Visible = false;

Assign Width For Columns:

dataGridView1.Columns[0].Width = 70;
dataGridView1.Columns[1].Width = 205;
dataGridView1.Columns[2].Width = 120;
dataGridView1.Columns[3].Width = 190;
dataGridView1.Columns[4].Width = 90;

Color and Font Design For DataGridView:

dataGridView1.DefaultCellStyle.Font = new Font("Calibri", 10.25f, FontStyle.Regular);

dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Calibri", 11, FontStyle.Regular);

dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.BurlyWood;

dataGridView1.EnableHeadersVisualStyles = false;

dataGridView1.RowHeadersVisible = false;

dataGridView1.BackgroundColor = Color.White;

After creating this method our form looks like the following (design of the form):



Now we are going to create a class named "QueryClass", This class contains two methods, "GetData" and "ExcuteQuery". The GetData method takes the SQL Query and returns the dataset. In the dataset there is a table name "s" and the second method () is excecuting the query aginst the SQL database. This class also uses the GetConnection method of the conMgr class (the connection class already created).

The code of the "Queryclass" class:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

using System.Data;