How to fill the particular column Empty cells with 0 in gridview

Question

0.00/5 (No votes)

See more:

Hi all..
I want to fill the empty cells in gridview with 0.and also that code is working for particular column only,i want like below..

current gridview:

_____________________________
name  |  amount  | date
-----------------------------
xxxx  |   200    |2-2-2012
yyyy  |   100    |3-3-2012
rrrr  |          |4-4-2012
tttt  |          |5-5-2012
_____________________________

i want like this:

_____________________________
name  |  amount  | date
-----------------------------
xxxx  |   200    |2-2-2012
yyyy  |   100    |3-3-2012
rrrr  |   0      |4-4-2012
tttt  |   0      |5-5-2012
_____________________________

pls send your code...

Posted 30-Aug-13 0:29am

sv sathish

Updated 30-Aug-13 0:38am

Nelek

v2

Add a Solution

3 solutions

Solution 2

Refer this code.

C#

Protected Sub yourgrid_RowDataBound(sender As Object, e As GridViewRowEventArgs)
   If e.Row.RowType = DataControlRowType.DataRow Then
	If String.IsNullOrEmpty(e.Row.Cells(1).Text) Then 
            e.Row.Cells(1).Text = "0"
	End If
   End If
End Sub

Regards..:)

Posted 30-Aug-13 1:12am

Thanks7872

Updated 30-Aug-13 1:19am

v5

Comments

sv sathish 30-Aug-13 7:49am

I am using vb.net sir so pls send vb.net code.

Thanks7872 30-Aug-13 7:50am

Do you mean to say windows application?

Solution 1

This is not how CP usually works. Most important goal here is to learn and help learning.
You are supposed to try it on your own, and come here when you got stuck with something, with a concrete question about your code, design, etc.
Please have a look to What have you tried?[^] to see a good explanation about what I mean.
Don't forget people here don't get payed. And besides, if we give you a ready-to-go solution, it is not going to help you because you are not going to learn anything from it.

P.S. Written as solution to avoid this "question" to be in the unanswered list

Posted 30-Aug-13 0:39am

Nelek

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)

sv sathish · Accepted Answer · 2013-08-30T03:11:00

Thank You form your helps...

i clear the problem myself,this is my code:

VB

Private Function Total() As Double
        Dim tot As Double = 0
        For i = 0 To DataGridView1.Rows.Count - 1
            If String.IsNullOrWhiteSpace(DataGridView1.Rows(i).Cells("TotalAmount").Value.ToString()) Then
                DataGridView1.Rows(i).Cells("TotalAmount").Value = 0
                tot = tot + Convert.ToDouble(DataGridView1.Rows(i).Cells("TotalAmount").Value)
            Else
                tot = tot + Convert.ToDouble(DataGridView1.Rows(i).Cells("TotalAmount").Value)
            End If
        Next i
        Return tot
    End Function

If you just call the Total() function in any where in your code window...:)
Thank you..