How do I search data of a datagridview using a textbox and if it matches add its data to the second datagridview

Question

5.00/5 (1 vote)

See more:

This is the link of the app
https://imgur.com/a/sB1eE[^]

I have a form with two datagridview the first one is to add items from csv or manually from textbox. What i want to do is i want to search for a item in the first gridview using the search button and the textbox and add quantity of that item and if the item matches the data from the first gridview it must add the item name , category,quantity and price of the item into the second gridview and calculate the total which is Price * Quantity how do i do this i just did a basic validation if the textbox's data is matching the gridview or not.

What I have tried:

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

            {

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

                {

                    if (dataGridView1.Rows[i].Cells[j].Value != null && 
                       searchTextBox.Text == 
                     dataGridView1.Rows[i].Cells[j].Value.ToString())

                    {

                        MessageBox.Show("The value already existed in DataGridView.");
                        searchTextBox.Text = "";

                        break;

                    }

                }

Posted 5-Jan-18 17:18pm

MaddoxSt

Updated 5-Jan-18 18:37pm

v3

Add a Solution

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)

Karthik_Mahalingam · Answer 1 · 2018-01-05T18:37:00

try this, modify it according to your need

public class SearchItem
      {
          public string Item_Name { get; set; }
          public string Category { get; set; }
          public double Price { get; set; }
          public double Quantity { get; set; }
          public double Total { get; set; }
      }

      private void btnSearch_Click(object sender, EventArgs e)
      {
          string search = txtkeyword.Text.Trim();
          double quantity;
          if (!double.TryParse(txtQty.Text.Trim(), out quantity))
          {
              MessageBox.Show("Please enter a valid quantity");
              return;
          }

          foreach (DataGridViewRow row in dataGridView1.Rows)
          {
              string item_Name = row.Cells[0].Value.ToString();
              if (search == item_Name)
              {
                  SearchItem item = new SearchItem()
                  {
                      Item_Name = item_Name,
                      Category = row.Cells[1].Value.ToString(),
                      Quantity = quantity,
                      Price = Convert.ToInt32(row.Cells[2].Value.ToString())
                  };
                  item.Total = item.Quantity * item.Price;
                  dataGridView2.Rows.Add(item.Item_Name, item.Category, item.Quantity, item.Price, item.Total);
                  break;
              }
          }

      }