Insert records when enter data in datagridview

Question

Hi,

I want insert records when i enter data in datagridview cell. and also when click on cell then display combobox then i have select any one after insert records.
have attach screenshot for which view i want

Sam Hobbs · Answer

By default, a DataGridView has a row at the bottom of it for inserting records. Also, are you familiar with the DataGridViewComboBoxColumn Class?

shubhangi khandale · Answer

hello, thanks for code but I want when i click on datagridview cell then update or add records without other button

Satyapriya Nayak · Answer

Hi shubhangi, For your first part solution[insert records when i enter data in datagridview cell] 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.OleDb; namespace Update_delete_datagridview { public partial class Form1 : Form { OleDbDataAdapter oledbda; OleDbCommandBuilder olcb; DataTable dataTable; BindingSource bindingSource; string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "SELECT * FROM student"; oledbda = new OleDbDataAdapter(str, con); olcb = new OleDbCommandBuilder(oledbda); dataTable = new DataTable(); oledbda.Fill(dataTable); con.Close(); bindingSource = new BindingSource(); bindingSource.DataSource = dataTable; dataGridView1.DataSource = bindingSource; dataGridView1.Columns[0].Visible = false; } private void btnaddupdate_Click(object sender, EventArgs e) { try { oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show("Records updated"); } private void btndelete_Click(object sender, EventArgs e) { try { dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index); oledbda.Update(dataTable); } catch (Exception exceptionObj) { MessageBox.Show(exceptionObj.Message.ToString()); } MessageBox.Show("Records Deleted"); } } } Thanks If this post helps you mark it as answer

Insert records when enter data in datagridview

Answers (3)