Datagridview problem removing blank space in C#.NET

Question

0.00/5 (No votes)

See more:

Hai. I'm having a problem on this code. i tried to check if the data is empty or not in order to bind it to datagridview. this is the code so far

C#

dbSumMetName.RowCount = form3.dbMetName.RowCount;
         foreach (DataGridViewRow row in form3.dbMetName.Rows)
         {
             foreach (DataGridViewColumn col in form3.dbMetName.Columns)
             {
                 {
                     dbSumMetName.Rows[row.Index].Cells[col.Name].Value = row.Cells[col.Name].Value;
                 }
             }
         }

For this code, i try to make it like this

C#

dbSumMetName.RowCount = form3.dbMetName.RowCount;
         foreach (DataGridViewRow row in form3.dbMetName.Rows)
         {
             foreach (DataGridViewColumn col in form3.dbMetName.Columns)
             {
                 {
                     if (row.Cells[col.Name].Value != null)
                     dbSumMetName.Rows[row.Index].Cells[col.Name].Value = row.Cells[col.Name].Value;
                 }
             }
         }

it still showing the empty space.

Posted 2-Mar-14 3:17am

arave0521

Add a Solution

Comments

Krunal Rohit 2-Mar-14 9:20am

So you want to remove the column that has null value, right ? So what if there are 3 columns which contains null value ?

-KR

arave0521 2-Mar-14 9:22am

yes. the first form actually allowed user to add how many row he want. but when it comes to second form which showing the datagridview which only allowed user to edit and not allowed him to add at all.

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)

OriginalGriff · Accepted Answer · 2014-03-02T03:36:00

Well... um.
Let's look at this logically:

C#

foreach (DataGridViewRow row in form3.dbMetName.Rows)
{
...
}

Looks at every row

C#

foreach (DataGridViewColumn col in form3.dbMetName.Columns)
{
...
}

Looks at every column in every row.
And then:

C#

if (row.Cells[col.Name].Value != null)
dbSumMetName.Rows[row.Index].Cells[col.Name].Value = row.Cells[col.Name].Value;

So...what value are you putting in a cell if the value you don't want to put in the cell is null?

Nothing at all.

Otherwise known as null...so if the "new" value is null, you leave the old, null value...
Perhaps, you want something like this:

C#

foreach (DataGridViewRow row in form3.dbMetName.Rows)
{
    foreach (DataGridViewColumn col in form3.dbMetName.Columns)
    {
        if (row.Cells[col.Name].Value != null)
        {
            dbSumMetName.Rows[row.Index].Cells[col.Name].Value = row.Cells[col.Name].Value;
        }
        else
        {
            dbSumMetName.Rows[row.Index].Cells[col.Name].Value = "????";
        }
    }
}

"how to remove 1 whole row if let say there are two column and two column has no value. some sort like this code"

C#

DataGridView1.Rows.Remove(_row);

Well...first thing is: you can't use foreach. It would require modifying the collection, and that is not allowed within a foreach.
So, if you want to get rid of the whole row if all it's columns are empty:

C#

for (int i = form3.dbMetName.Rows.Count - 1; i >= 0; i--)
    {
    bool isBlank = true;
    DataGridViewRow row = form3.dbMetName.Rows[i];
    foreach (DataGridViewCell cell in row.Cells)
        {
        if (cell.Value != null && cell.Value.ToString() != "")
            {
            isBlank = false;
            break;
            }
        }
    if (isBlank)
        {
        form3.dbMetName.Rows.Remove(row);
        }
    }

Going down from the last row to the first is safer than going up, as you remove rows and shuffle ones you have checked!

Krunal Rohit · Accepted Answer · 2014-03-02T05:03:00

Okay, I might be wrong, I mean it can't be exact solution as you want but still I'm trying.
See this code will eliminate all the column which contains null values.

C#

public DataTable CheckDataTableColumn(DataTable dt)
{
    bool flag = false;
    int counter = 0;

EXIT:
    for (int i = counter; i < dt.Columns.Count; i++)
    {
        for (int x = 0; x < dt.Rows.Count; x++)
        {
            if (string.IsNullOrEmpty(dt.Rows[x][i].ToString()))
                flag = true;    // empty value
            else
            {
                flag = false;
                counter = i + 1;

                goto EXIT;
            }
        }
        if (flag)
        {
            dt.Columns.Remove(dt.Columns[i]);
            i--;
        }
    }

    return dt;
}

Hope might be helpful to you.

-KR

Datagridview problem removing blank space in C#.NET

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0