How to cleare or make empty entire row of datagridview

Question

0.00/5 (No votes)

See more:

Hi
Below code cleare value of one cell of datagridview row

Dgv.Rows(Rno).Cells("ColItemCode1").Value = ""

If i want to cleare entire row that is make entire row empty is there any single code other then clearing each cell.

What I have tried:

Dgv.Rows(Rno).Cells("ColItemCode1").Value = ""

Posted 30-Apr-20 11:31am

pravin9455

Updated 1-May-20 0:53am

Add a Solution

Comments

CHill60 1-May-20 5:33am

How do you populate your datagridview - do you use data binding?

Also - is this winforms, wpf, what?

2 solutions

Solution 1

if you need remove specific row you can use this code

Dim dgvDelRow As DataGridViewRow = Dgv.Rows(Rno)
    Dgv.Rows.RemoveAt(dgvDelRow)
    Dgv.Refresh()

if you need add new row you can use this code

Dgv.Rows.Add("", "", "", "")

or

Dgv.Rows.Insert("", "", "", "", "")

I hope it helps you
Greetings

Posted 30-Apr-20 23:56pm

Mohamed Aboelkheer

Comments

CHill60 1-May-20 6:44am

None of this will blank an existing row which is what the OP asked for

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)

CHill60 · Accepted Answer · 2020-05-01T00:54:00

As this already has an incorrect solution here are my comments

If your datagridview has not been populated with databinding then you will need to blank out each cell in the row you want to clear. It's not hard though, and you don't need to know how many cells there are e.g.

C#

foreach(DataGridViewCell cell in Dgv.Rows(Rno).Cells)
{
    cell.Value = string.Empty;
}

You might want to experiment with cells of different types (e.g. dates, hyperlinks, checkboxes)

However, if your datagridview is databound then you will need to blank those values in the source - whatever that might be, and rebind the datasource to the datagridview. Without explicit detail on how you are populating the DGV I can't really give you more