Insert checked rows records of datagridview into db

Satyapriyanayak
Posted by Satyapriyanayak under C# category on | Points: 40 | Views : 2430
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 Checked_record__datagridview
{
public partial class Form1 : Form
{
OleDbDataAdapter oledbda;
string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
string str;
OleDbCommand com;

public Form1()
{
InitializeComponent();
}

private void btn_insert_Click(object sender, EventArgs e)
{
int i = 0;
List<int> ChkedRow = new List<int>();

for (i = 0; i <= dataGridView1.RowCount - 1; i++)
{
if (Convert.ToBoolean(dataGridView1.Rows[i].Cells["chkcol"].Value) == true)
{
ChkedRow.Add(i);
}
}

if (ChkedRow.Count == 0)
{
MessageBox.Show("Select one checkbox");
return;
}

foreach (int j in ChkedRow)
{

str = @"INSERT INTO test1(Did,Dname) VALUES ('" + dataGridView1.Rows[j].Cells["Did"].Value + "', '" + dataGridView1.Rows[j].Cells["Dname"].Value + "');";
try
{
using (OleDbConnection con = new OleDbConnection(ConnectionString))
{
using (com = new OleDbCommand(str, con))
{
con.Open();
com.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
MessageBox.Show("Records successfully inserted");
}

private void Form1_Load(object sender, EventArgs e)
{

dataGridView1.AllowUserToAddRows = false;
dataGridView1.Columns.Clear();
DataGridViewCheckBoxColumn col1 = new DataGridViewCheckBoxColumn();
col1.Name = "chkcol";
col1.HeaderText = "CheckBox";
dataGridView1.Columns.Add(col1);
OleDbConnection con = new OleDbConnection(ConnectionString);
con.Open();
str = "select * from test ";
com = new OleDbCommand(str, con);
oledbda = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
oledbda.Fill(ds, "test");
dataGridView1.DataMember = "test";
dataGridView1.DataSource = ds;

}
}
}

Comments or Responses

Login to post response