datagridview in window form

Question

i want to transfer values of one gridview1 to gridview2 without using any button but its not working..i try alot but it didn't work

Željko Perić · Answer

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 Sahoo · Answer

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 Ahmed · Answer

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 Palanivel · Answer

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 Ahmed · Answer

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 Palanivel · Answer

Hi Adeel the problem due to converting your name into boolean value. You can convert value to boolean if the value is TrueFalse or 10. 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 Ahmed · Answer

Working with 2 gridviews in same signle form ..and transfering data on enter event of gridview

Adeel Ahmed · Answer

okk

Ramesh Palanivel · Answer

Hi Adeel Please share some screen shots.

Adeel Ahmed · Answer

thanx for reply Ramesh..this is the code which didnt 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 // dataGridView2.Rows[0].Cells[i].Value = dataGridView1.Rows[selectedIndex].Cells[i].Value; //} } //void CopyColumns() //{ // for (int i = 0; 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 Palanivel · Answer

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.