---
title: "Working with DataGridView in VC#"
description: "Here in this article I will show you that how to perform certain operation such as Inert and Delete in datagridview. For completing this article I had"
author: "Anonymous User"
published: 2011-08-12
updated: 2019-09-07
canonical: https://www.mindstick.com/articles/607/working-with-datagridview-in-vc-sharp
category: "c#"
tags: ["c#"]
reading_time: 5 minutes
---
# Working with DataGridView in VC#
Here in this article I will show you that how to perform certain operation such as Inert and Delete in datagridview. For completing this article I had used VisualStudio 2008 and SQL Server 2008 on windows7 64 bit platform.\
```
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient; namespace WindowsFormsApplication3{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } /// /// Create 3 variables which have a name da of type SqlDataAdapter class /// which used to execute SelectCommand, ds of type DataSet class which /// store all the tables of select command and _rowIndex of type int which /// store rowindex of datagrid view when rows or cells of gridview is /// clicked. /// SqlDataAdapter da; DataSet ds; int _rowIndex; /// /// At the load event of form establish connection with sqlserver and fetch /// records in dataset and then bind records of that dataset to datagridview /// as below I had done. Then close the connection. /// private void Form1_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); //Creating object of SqlConnection class. con.ConnectionString = "Data Source=aaa;User Id=bbb; Password =ccc;Initial Catalog=Workbook"; //Passing connection string to sqlconnection class object. con.Open(); //Opening connection. da = new SqlDataAdapter("select * from Student", con); //Passing select query to SqlDataAdapter object. ds = new DataSet(); //Creating a dataset object. da.Fill(ds); //Filling record in dataset by calling Fill() method of SqlDataAdapter class. dataGridView1.DataSource = ds.Tables[0]; //Binding records of a dataset in datagrid view. con.Close(); //Closing connection with sqlserver. } /// /// At the click event of cell retrive row index of the clickable /// cell and store it in _rowIndex variable. Then finnaly display /// value of that row in the textbox as I doing it in below code. /// private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { _rowIndex = e.RowIndex; //Retriving row index on which cell is clicked. if (_rowIndex == -1) //if _rowIndex is -1 then break the execution. return; DataGridViewRow rowData = dataGridView1.Rows[_rowIndex]; //Creating DataGridViewRow object of particlular index. //Displaying values of rowData object in textbox. textBox1.Text = rowData.Cells[0].Value.ToString(); textBox2.Text = rowData.Cells[1].Value.ToString(); textBox3.Text = rowData.Cells[2].Value.ToString(); textBox4.Text = rowData.Cells[3].Value.ToString(); } /// /// In this method I had written code to clear data of /// textbox control and making textbox control editable /// by setting ReadOnly property of textbox control to /// true and enabling Update In DataGridView button. /// private void insert_Click(object sender, EventArgs e) { TextBox[] tempTextBox = { textBox1, textBox2, textBox3, textBox4 }; foreach (TextBox temp in tempTextBox) { temp.Clear(); temp.ReadOnly = false; } button3.Enabled = true; } /// /// In this event I had written code to delete record from datagridview. /// For performing this task I need _rowIndex of specified record which /// I get when we click on cell of datagrid view. Then by calling /// RemoveAt(_rowIndex) method of DataGridView.Rows we can delete that /// rows. /// private void delete_Click(object sender, EventArgs e) { //By this condition I can check whether datagridview have //records or not. if (dataGridView1.Rows.Count <= 0) { MessageBox.Show("There is no records in grid view."); return; } //Here we check that textbox have values or not. if (string.IsNullOrEmpty(textBox1.Text) || string.IsNullOrEmpty(textBox2.Text) || string.IsNullOrEmpty(textBox3.Text) || string.IsNullOrEmpty(textBox4.Text)) { MessageBox.Show("Please click on datagrid view rows to delete."); return; } //If rowindex is less than 0 then break method execution. if (_rowIndex < 0) return; //Here I show a confirmation message for record deleting. if (!(MessageBox.Show("Record deleted warning.", "Are you sure want to delete the record!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)) return; //By execution of this method record is being deleted. dataGridView1.Rows.RemoveAt(_rowIndex); dataGridView1.Refresh(); TextBox[] tempTextBox = { textBox1, textBox2, textBox3, textBox4 }; foreach (TextBox temp in tempTextBox) temp.Clear(); } /// /// At this event I insert new record in datagridview. /// private void update_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(textBox1.Text) || string.IsNullOrEmpty(textBox2.Text) || string.IsNullOrEmpty(textBox3.Text) || string.IsNullOrEmpty(textBox4.Text)) { MessageBox.Show("Please fill all the fields."); return; } if (ds != null && ds.Tables.Count > 0) { DataRow _newRow = ds.Tables[0].NewRow(); //Create an object of DataRow by calling NewRow() method of DataTable class. //Insert values in DataRow. _newRow[0] = textBox1.Text; _newRow[1] = textBox2.Text; _newRow[2] = textBox3.Text; _newRow[3] = textBox4.Text; //Add newly created rows in table. ds.Tables[0].Rows.Add(_newRow); dataGridView1.Refresh(); } //Clear all the fields of textbox control. TextBox[] tempTextBox = { textBox1, textBox2, textBox3, textBox4 }; foreach (TextBox temp in tempTextBox) { temp.Clear(); temp.ReadOnly = true; } button3.Enabled = false; } }}
```
When form is loaded it display values from database
When we click on cell of datagridview then content of that cell comes in textbox.
When I click on Delete Record button then confirmation message will display.
When I click on yes button then record is deleted.
Similarly you can perform rest of operation in this article.
---
Original Source: https://www.mindstick.com/articles/607/working-with-datagridview-in-vc-sharp
Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.