How do I put specific rows together in datagridview?

Question

0.00/5 (No votes)

See more:

Hi,

I created a DataGridView control to list down a couple of stuff. However, I want to put specific rows together (NOT putting them all inside a row) based on a condition from the textBox. For example, when I type "Fruit" in the textBox. All the rows that contain a type of fruit will automatically line up on one another, starting at the first row like this:

1 Pear
2 Banana
3 Orange
4 Mango

The same goes for the rest of rows that contain a type of meat when the word "Meat" is typed in the textBox.

Thank you!

What I have tried:

C#

DataTable table = new DataTable();

        private void Form1_Load(object sender, EventArgs e)
        {
            // populate dgv from datatable

            // add columns
            table.Columns.Add("Number", typeof(int));
            table.Columns.Add("Food", typeof(string));

            // add rows
            table.Rows.Add(1, "BBQ");
            table.Rows.Add(2, "Pear");
            table.Rows.Add(3, "Eggs");
            table.Rows.Add(4, "Banana");
            table.Rows.Add(5, "Noodle");
            table.Rows.Add(6, "Orange");
            table.Rows.Add(7, "Mango");
            table.Rows.Add(8, "Beef");

            dataGridView1.DataSource = table;
        }

        private void Button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "Fruit" )
            {

            }
        }

Posted 9-Jul-19 15:51pm

whateves

Updated 10-Jul-19 17:32pm

v2

Add a Solution

Comments

BillWoodruff 9-Jul-19 23:25pm

So far, you haven't taken any steps toward sorting, changing the view. There's nothing in your Table that tells you which Items are 'Fruit.

2 solutions

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)

MadMyche · Answer 1 · 2019-07-09T17:36:00

What you need is to create a collection<type>, which would contain all of the food items, along with an additional property for food type. This collection could be populated with a database at sometime.

C#

public class Food {
  public int FoodID { get; set; }
  public string FoodTyoe { get; set; }
  public string FoodName { get; set; }

  public Food() {}
  public Food(int foodID, string foodType, string foodName) {
    FoodID = foodID;
    FoodType = foodType;
    FoodName = foodName;
  }

  public Collection<Food> LoadAllFood() {
    Collection<Food> foods = new Collection<Food>();

    foods.Add(new Food(1, "Meat", "BBQ"));
    foods.Add(new Food(2, "Fruit", "Pear"));
    // and so on with other items

    return foods;
  }
}

So now you have all your foods. Now you need to filter that down by the FoodType. This is easily achieved using a lambda expression in your Button method:

C#

private void Button1_Click(object sender, EventArgs e) {
  table.Rows.Clear();

  // get all the foods
  Collection<Food> AllFoods = new Food().LoadAllFoods();

  // filtered
  Collection<Food> SomeFoods = AllFoods.Where(f => f.Type == textBox1.Text);

  // populate your table
  foreach(Food item in SomeFoods) {
     table.Rows.Add(item.FoodID, item.FoodName);
  }

  // refresh your DGV
  dataGridView1.Refresh();
}

Now this is hastily written and could be a lot more compact and efficient. I thought this would give you a start on how to use Object Orientated Programming.

BillWoodruff · Answer 2 · 2019-07-10T17:32:00

As MadMyche points out, you have to incorporate the category data into your code.

Adding another Column with category data is the logical choice.

Assuming you've added a Column named 'Category as the third Column, you can sort the DataTable:

string cat = textBox1.Text;

table = table.AsEnumerable()
    .OrderByDescending(r => r.Field<string>(2).StringCaseIndependentEq(cat))
    .CopyToDataTable();

dataGridView1.DataSource = table;
dataGridView1.Refresh();

This code makes use of a simple case-independent string comparison Extension Method:

public static class StringExtensions
{
    // see: [<a href="http://cc.davelozinski.com/c-sharp/fastest-way-to-compare-strings" target="_blank" title="New Window">^</a>] 
    public static bool StringCaseIndependentEq(this string s1, string s2)
    {
        return String.Compare(s1, s2, StringComparison.OrdinalIgnoreCase) == 0;
    }
}

How do I put specific rows together in datagridview?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0