Binding A Table To Datagridview

Question

1.00/5 (3 votes)

See more:

I want to when i click on multiple rows in datagridview bind another table to another datagridview and i use cellclick property but it does not work:

C#

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
  foreach (DataGridViewRow dr in dataGridView1.Rows)
  {
    if (dr.Cells[0].Value != null)
    {
 
       CustomerID1 = Convert.ToString(dr.Cells[1].Value);
 
      SqlConnection cnn = new SqlConnection();
      SqlCommand cmd = new SqlCommand();
 
      cnn.ConnectionString = "server=USER-VAIO\\SQLEXPRESS;database=Northwind;      integrated security=true";
      cnn.Open();
 
      cmd.Connection = cnn;
      cmd.CommandType = CommandType.Text;
      cmd.CommandText = "select OrderID,CustomerID,OrderDate from Orders where CustomerID=@CustomerID";
 
      cmd.Parameters.Add("@CustomerID", SqlDbType.NChar).Value = CustomerID1;
 
      SqlDataReader dr1 = cmd.ExecuteReader();
      DataTable dt1 = new DataTable();
      dt1.Load(dr1);
      dataGridView2.DataSource = dt1;
 

     cnn.Close();
   }
  }
}

Posted 4-Mar-15 2:00am

Member 11414302

Updated 4-Mar-15 4:43am

Leo Chapiro

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Mar-15 8:34am

Not clear. Please explain more with codes.

Member 11414302 4-Mar-15 8:40am

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
foreach (DataGridViewRow dr in dataGridView1.Rows)
{
if (dr.Cells[0].Value != null)
{

CustomerID1 = Convert.ToString(dr.Cells[1].Value);

SqlConnection cnn = new SqlConnection();
SqlCommand cmd = new SqlCommand();

cnn.ConnectionString = "server=USER-VAIO\\SQLEXPRESS;database=Northwind;integrated security=true";
cnn.Open();

cmd.Connection = cnn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select OrderID,CustomerID,OrderDate from Orders where CustomerID=@CustomerID";

cmd.Parameters.Add("@CustomerID", SqlDbType.NChar).Value = CustomerID1;

SqlDataReader dr1 = cmd.ExecuteReader();
DataTable dt1 = new DataTable();
dt1.Load(dr1);
dataGridView2.DataSource = dt1;

cnn.Close();
}
}
}

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Mar-15 8:51am

Please improve your question with these codes. Please don't comment here.

Sergey Alexandrovich Kryukov 4-Mar-15 9:14am

I am curious how anyone could possibly click on multiple rows...
—SA

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Mar-15 13:19pm

Yes Sergey. :D

Kornfeld Eliyahu Peter 4-Mar-15 13:56pm

Not ANYONE, but Lucky Luke, who "shoot faster than his shadow"... :-)

Sergey Alexandrovich Kryukov 4-Mar-15 14:04pm

Probably Lucky Luke just was not familiar with special theory of relativity...
—SA

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

BacchusBeale · Answer 1 · 2015-03-04T14:53:00

The events for getting multiple selections and cell-click are different types of events.

DataGridView.SelectionChanged Event

is for getting all SelectedRows, whereas

DataGridView.OnCellClick Method

is triggered from a single cell, which means you will only get one row and column value.

If you are trying to link two DataGridView to 2 linked table in a database, it's easiest to create a DataSet with EntityFramework using Visual Studio designer.
After you build the project with your DataSet, the Forms Toolbox will have TableAdapters for binding to user controls like your two DataGridViews.

If you bind them correctly via the foreign key the data will automatically update.

Binding A Table To Datagridview

1 solution

Solution 1

Add your solution here

Preview 0

Binding A Table To Datagridview

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us