How do I put specific rows together in datagridview?

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:

Number	Food
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!

Here's the code:

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" )

{

}

Hey how do you nkow that which food belongs to which category. For that you have to add a new column FoodType to the table. and search food type.

private void Form1_Load(object sender, EventArgs e)
{
DataTable table = new DataTable();
table.Columns.Add("Number", typeof(int));
table.Columns.Add("Food", typeof(string));
table.Columns.Add("FoodType", typeof(string));
table.Rows.Add(1, "BBQ", "XYZ");
table.Rows.Add(2, "Pear", "XYZ");
table.Rows.Add(3, "Eggs", "XYZ");
table.Rows.Add(4, "Banana", "FRUIT");
table.Rows.Add(5, "Noodle", "XYZ");
table.Rows.Add(6, "Orange", "FRUIT");
table.Rows.Add(7, "Mango", "FRUIT");
table.Rows.Add(8, "Beef", "XYZ");
dataGridView1.DataSource = table;
}
private void textSearch_TextChanged(object sender, EventArgs e)
{
if (dataGridView1.DataSource != null)
{
string whereClause = "FoodType Like '%" + textSearch.Text + "%'";
(dataGridView1.DataSource as DataTable).DefaultView.RowFilter = whereClause;
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty7y ago
Accepted answer
Hey how do you nkow that which food belongs to which category. For that you have to add a new column FoodType to the table. and search food type.
private void Form1_Load(object sender, EventArgs e)
{
    DataTable table = new DataTable();
    table.Columns.Add("Number", typeof(int));
    table.Columns.Add("Food", typeof(string));
    table.Columns.Add("FoodType", typeof(string));

    table.Rows.Add(1, "BBQ", "XYZ");
    table.Rows.Add(2, "Pear", "XYZ");
    table.Rows.Add(3, "Eggs", "XYZ");
    table.Rows.Add(4, "Banana", "FRUIT");
    table.Rows.Add(5, "Noodle", "XYZ");
    table.Rows.Add(6, "Orange", "FRUIT");
    table.Rows.Add(7, "Mango", "FRUIT");
    table.Rows.Add(8, "Beef", "XYZ");
    dataGridView1.DataSource = table;
}

private void textSearch_TextChanged(object sender, EventArgs e)
{
    if (dataGridView1.DataSource != null)
    {
        string whereClause = "FoodType Like '%" + textSearch.Text + "%'";
        (dataGridView1.DataSource as DataTable).DefaultView.RowFilter = whereClause;
    }
}