datagridview in window form

thanx for reply Ramesh..this is the code which didn,t work

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace Lease_Managment_System12

{

public partial class Sale_info : Form

{

SqlConnection con = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=lease managment;Integrated Security=True;Pooling=False");

//private DataGridView d;

private int index;

public Sale_info()

{

InitializeComponent();

}

private void label2_Click(object sender, EventArgs e)

{

}

private void Sale_info_Load(object sender, EventArgs e)

{

con.Open();

SqlCommand cmd = con.CreateCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = "SELECT [Name], [select_category], [sub_category], [company_name], [unit_price],[quantity] FROM product_info ";

DataTable dt = new DataTable();

dt.Load(cmd.ExecuteReader());

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

dataGridView1.DataSource = dt;

con.Close();

}

private void label3_Click(object sender, EventArgs e)

{

}

private void textBox3_TextChanged(object sender, EventArgs e)

{

}

private void textBox1_TextChanged(object sender, EventArgs e)

{

con.Open();

SqlCommand cmd = con.CreateCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = "select * from product_info where [Name] like('" + textBox1.Text + "%')";

DataTable dt = new DataTable();

dt.Load(cmd.ExecuteReader());

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

dataGridView1.DataSource = dt;

foreach(DataRow item in dt.Rows)

{

int n = dataGridView1.Rows.Add();

dataGridView1.Rows[n].Cells[1].Value = item["Name"].ToString();

dataGridView1.Rows[n].Cells[2].Value = item["select_category"].ToString();

dataGridView1.Rows[n].Cells[3].Value = item["sub_category"].ToString();

dataGridView1.Rows[n].Cells[4].Value = item["company_name"].ToString();

dataGridView1.Rows[n].Cells[5].Value = item["unit_price"].ToString();

dataGridView1.Rows[n].Cells[6].Value = item["quantity"].ToString();

}

con.Close();

}

private void pictureBox2_Click(object sender, EventArgs e)

{

}

private void textBox4_TextChanged(object sender, EventArgs e)

{

}

private void label4_Click(object sender, EventArgs e)

{

}

private void label2_Click_1(object sender, EventArgs e)

{

}

private void button1_Click(object sender, EventArgs e)

{

}

private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)

{

//DataRow r = dataGridView1.Rows[e.RowIndex];

//Pass_To_Grid2(r); // Send to Other Grid View.

}

private void dataGridView1_SelectionChanged(object sender, EventArgs e)

{

//if (index > 0) {

// int selectedIndex = dataGridView1.SelectedRows[0].Index;

//CopyColumns();

//for (int i = 0; i < dataGridView1.Columns.Count; i++)

// dataGridView2.Rows[0].Cells[i].Value = dataGridView1.Rows[selectedIndex].Cells[i].Value;

//}

}

//void CopyColumns()

//{

// for (int i = 0; i < dataGridView1.Columns.Count; i++)

// dataGridView2.Columns.Add(i.ToString(), dataGridView1.Columns[i].HeaderText);

//}

private void dataGridView1_CellEnter(object sender, DataGridViewCellEventArgs e)

{

}

private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)

{

dataGridView2.Rows.Clear();

foreach (DataGridViewRow item in dataGridView1.Rows)

{

if ((bool)item.Cells[0].Value == false)

{

int n = dataGridView2.Rows.Add();

dataGridView2.Rows[n].Cells[0].Value = item.Cells[1].Value.ToString();

dataGridView2.Rows[n].Cells[1].Value = item.Cells[2].Value.ToString();

dataGridView2.Rows[n].Cells[2].Value = item.Cells[3].Value.ToString();

dataGridView2.Rows[n].Cells[3].Value = item.Cells[4].Value.ToString();

dataGridView2.Rows[n].Cells[4].Value = item.Cells[5].Value.ToString();

dataGridView2.Rows[n].Cells[5].Value = item.Cells[6].Value.ToString();

}

private void dataGridView2_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)

{

}

private void dataGridView2_Enter(object sender, EventArgs e)

{

}

private void dataGridView1_MouseClick(object sender, MouseEventArgs e)

{

if ((bool)dataGridView1.SelectedRows[0].Cells[0].Value == false)

{

dataGridView1.SelectedRows[0].Cells[0].Value = true;

}

else

{

dataGridView1.SelectedRows[0].Cells[0].Value = false;

}

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bharathi Raja8y ago
try
{
dataGridView2.Rows.Clear();
for (int i = 0; i < dataGridView2.Rows.Count; i++)
{
if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value) == true)
{
dataGridView2.Rows.Add();
dataGridView2.Rows[i].Cells[0].Value = true;
dataGridView2.Rows[i].Cells[1].Value = dataGridView1.Rows[i].Cells[1].Value;
}
}
}
catch (Exception ) { }
Željko Perić8y ago
If You want simply to copy data from one data grid view to another one here is the code :
DataGridView gridview1 = new DataGridView();

gridview1 = gridview2;
All the best,
Željko Peric
Laxmidhar Sahoo8y ago
sir second grid should be dynamic colums

in button click event
1- )
gridview2.rows.add()

gridview2.rows[index].cells[index of colum].value = your value;
Adeel Ahmed8y ago
screen shots and working with local database of visual studio 2015 attached files were above 4.5 i need work with 4.5 framework or below
Ramesh Palanivel8y ago
What are the values you have to transfer from datagridview 1 to datagridview 2?

Please mention the column and tables details with screen shots. I will try to help you!..
Adeel Ahmed8y ago
thanku so much broo but i am getting value in gridview one from database and then transfering it to the gridview 2..need a little more help
Ramesh Palanivel8y ago
Hi Adeel,

the problem due to converting your name into boolean value. You can convert value to boolean if the value is "True","False" or 1,0.

But In your case, you are trying to converting your name to boolean. thats the reason you are getting error.

You want to move the selected row from datgridview1 to datagridview2? If yes, Please find the sample source code for your reference
Adeel Ahmed8y ago
Working with 2 gridviews in same signle form ..and transfering data on enter event of gridview
Adeel Ahmed8y ago
okk
Ramesh Palanivel8y ago
Hi Adeel,

Please share some screen shots.
Adeel Ahmed8y ago
thanx for reply Ramesh..this is the code which didn,t work
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Lease_Managment_System12
{
public partial class Sale_info : Form
{
SqlConnection con = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=lease managment;Integrated Security=True;Pooling=False");
//private DataGridView d;
private int index;
public Sale_info()
{
InitializeComponent();
}
private void label2_Click(object sender, EventArgs e)
{
}
private void Sale_info_Load(object sender, EventArgs e)
{

con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT [Name], [select_category], [sub_category], [company_name], [unit_price],[quantity] FROM product_info ";
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
private void label3_Click(object sender, EventArgs e)
{
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
}

private void textBox1_TextChanged(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from product_info where [Name] like('" + textBox1.Text + "%')";
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
foreach(DataRow item in dt.Rows)
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[1].Value = item["Name"].ToString();
dataGridView1.Rows[n].Cells[2].Value = item["select_category"].ToString();
dataGridView1.Rows[n].Cells[3].Value = item["sub_category"].ToString();
dataGridView1.Rows[n].Cells[4].Value = item["company_name"].ToString();
dataGridView1.Rows[n].Cells[5].Value = item["unit_price"].ToString();
dataGridView1.Rows[n].Cells[6].Value = item["quantity"].ToString();
}
con.Close();
}
private void pictureBox2_Click(object sender, EventArgs e)
{
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
}
private void label4_Click(object sender, EventArgs e)
{
}
private void label2_Click_1(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
}
private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
//DataRow r = dataGridView1.Rows[e.RowIndex];
//Pass_To_Grid2(r); // Send to Other Grid View.
}
private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
//if (index > 0) {
// int selectedIndex = dataGridView1.SelectedRows[0].Index;
//CopyColumns();
//for (int i = 0; i < dataGridView1.Columns.Count; i++)
// dataGridView2.Rows[0].Cells[i].Value = dataGridView1.Rows[selectedIndex].Cells[i].Value;
//}
}
//void CopyColumns()
//{
// for (int i = 0; i < dataGridView1.Columns.Count; i++)
// dataGridView2.Columns.Add(i.ToString(), dataGridView1.Columns[i].HeaderText);
//}
private void dataGridView1_CellEnter(object sender, DataGridViewCellEventArgs e)
{
}
private void dataGridView1_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
dataGridView2.Rows.Clear();
foreach (DataGridViewRow item in dataGridView1.Rows)
{
if ((bool)item.Cells[0].Value == false)
{
int n = dataGridView2.Rows.Add();
dataGridView2.Rows[n].Cells[0].Value = item.Cells[1].Value.ToString();
dataGridView2.Rows[n].Cells[1].Value = item.Cells[2].Value.ToString();
dataGridView2.Rows[n].Cells[2].Value = item.Cells[3].Value.ToString();
dataGridView2.Rows[n].Cells[3].Value = item.Cells[4].Value.ToString();
dataGridView2.Rows[n].Cells[4].Value = item.Cells[5].Value.ToString();
dataGridView2.Rows[n].Cells[5].Value = item.Cells[6].Value.ToString();
}
}

}

private void dataGridView2_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
{
}
private void dataGridView2_Enter(object sender, EventArgs e)
{
}
private void dataGridView1_MouseClick(object sender, MouseEventArgs e)
{
if ((bool)dataGridView1.SelectedRows[0].Cells[0].Value == false)
{
dataGridView1.SelectedRows[0].Cells[0].Value = true;
}
else
{
dataGridView1.SelectedRows[0].Cells[0].Value = false;
}
}
}
}
Ramesh Palanivel8y ago
Hi Adeel,

Surely you need some action to perform your task. Or Is there any logics to move date from gridview 1 to gridview 2? which mean depends on any field value change, move gridview 1 to gridview2.