Passing values to datagridview in another form c# windows application

Question

0.00/5 (No votes)

See more:

Hello all,

I really want to know how can I pass a whole datagridview values to another datagridview in another form? using c# windows application.

i have two form ,

form1:
i have one search option which is have,
one text box and one search button,
when i type something related to the table field in my text box and click search button,

the corresponding data has displayed to another form datagridview, that means form2.

form2:

i have only datagridview.

please my code see below where i did mistake my code and let me know the solution please..

my code is:

form1:

C#

private void button1_Click(object sender, EventArgs e)
{
      try
      {
            if (textBox1.Text == "")
            {
                 MessageBox.Show("Please Enter the Input Key.", "Error Message");
            }
            else
            {
                 DataTable dataTable = new DataTable();
                 con = new SqlConnection(s);
                 con.Open();
                 cmd = new SqlCommand("select Destinations,TimeofDay,DialCode,EffectiveDate,NewOffer from RateSheets where Destinations='" + textBox1.Text + "'", con);
                 SqlDataReader sqlDataReader = cmd.ExecuteReader();
                 dataTable.Load(sqlDataReader);
                 con.Close();
                 form2 fm = new testing();
           
                 fm.Show();
                 dataGridView1.DataSource = dataTable;
             }                   
       }                   
       catch (Exception ex)
       {
             MessageBox.Show(ex.ToString());
       }
}

Thanks in advance...

Posted 26-Feb-13 2:29am

stellus

Updated 26-Feb-13 2:39am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

Orcun Iyigun 26-Feb-13 8:43am

maybe you may want to change your where statement with LIKE '%textbox1.text%' instead of equals. In your current code do you have any exceptions?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

**Orcun Iyigun** · Answer 1 · 2013-02-26T02:52:00

Solution 1

Well here are some links for how you can pass values between forms:

Passing Values between Forms in .NET 1.x with C# and VB.NET examples[^]
Using a delegate to pass data between two forms[^]
Passing Data between Windows Forms[^]
Passing Data Between Forms[^]

Good luck,
OI

Posted 26-Feb-13 2:52am

Orcun Iyigun

Comments

Member 9989542 18-Apr-13 0:54am

i have two tables sql (database name vijay)
table1 table2

name age sex name marks1 marks2 total
vijay 15 m vijay 50 45 95
ramu 14 m vijay 45 60 105
ram 15 m ram 50 45 95
lux 15 f ramu 50 45 95
ramu 50 55 105
lux 50 45 95

i make these two tables in two gridview in c# windows form
nw when i click the 1st gridview row (name) , i need to filter name which present in second gridview and show that data in secondgridview
i need a stored procedure and need to call that in c#...

ex
when i click name vijay in firstgridview i need like below in secondgridview
name marks1 marks2 total
vijay 50 45 95
vijay 45 60 105

Orcun Iyigun 18-Apr-13 2:36am

why would you need to do the binding in the stored procedure?? HAve a look at this link[^]. It is gridview's click events. You can use cell click event and on this event you can bind your second gridview to filter your results. It is more easier in my opinion.