How to validate null value in gridview using paging gridview

Question

0.00/5 (No votes)

See more:

My code as follows

private void SaveCheckedValues()
      {
          System.Collections.ArrayList userdetails = new System.Collections.ArrayList();
          int index = -1;
          foreach (GridViewRow gvrow in grdRpt.Rows)
          {
              int.Parse((string)grdRpt.DataKeys[gvrow.RowIndex].Value);

              bool result = ((CheckBox)gvrow.FindControl("chkselecdata")).Checked;

              // Check in the Session
              if (Session["CHECKED_ITEMS"] != null)
                  userdetails = (System.Collections.ArrayList)Session["CHECKED_ITEMS"];
              if (result)
              {
                  if (!userdetails.Contains(index))
                      userdetails.Add(index);
              }
              else
                  userdetails.Remove(index);
          }
          if (userdetails != null && userdetails.Count > 0)
              Session["CHECKED_ITEMS"] = userdetails;
      }

In gridview as follows

selectdata  transacteeid  totalprice   Qty   Isactive

 checkbox                    25         1        1
 checkbox      2355          10         2        1
 checkbox      1234           8         1        1

in the above gridview first row transacteeid value is empty.

when i run the above code shows error as follows

unable to caste object of type system.DBNull to type System.String.

The error shows in below line as follows

how to validate empty value in gridview row.

int.Parse((string)grdRpt.DataKeys[gvrow.RowIndex].Value);

how to solve this error.

What I have tried:

My code as follows

private void SaveCheckedValues()
      {
          System.Collections.ArrayList userdetails = new System.Collections.ArrayList();
          int index = -1;
          foreach (GridViewRow gvrow in grdRpt.Rows)
          {
              int.Parse((string)grdRpt.DataKeys[gvrow.RowIndex].Value);

              bool result = ((CheckBox)gvrow.FindControl("chkselecdata")).Checked;

              // Check in the Session
              if (Session["CHECKED_ITEMS"] != null)
                  userdetails = (System.Collections.ArrayList)Session["CHECKED_ITEMS"];
              if (result)
              {
                  if (!userdetails.Contains(index))
                      userdetails.Add(index);
              }
              else
                  userdetails.Remove(index);
          }
          if (userdetails != null && userdetails.Count > 0)
              Session["CHECKED_ITEMS"] = userdetails;
      }

In gridview as follows

selectdata  transacteeid  totalprice   Qty   Isactive

 checkbox                    25         1        1
 checkbox      2355          10         2        1
 checkbox      1234           8         1        1

in the above gridview first row transacteeid value is empty.

when i run the above code shows error as follows

unable to caste object of type system.DBNull to type System.String.

The error shows in below line as follows

how to validate empty value in gridview row.

int.Parse((string)grdRpt.DataKeys[gvrow.RowIndex].Value);

how to solve this error.

Posted 17-Jun-18 21:59pm

nar86

Updated 18-Jun-18 2:17am

User 7429338

v2

Add a Solution

Comments

Richard MacCutchan 18-Jun-18 11:51am

Why are you casting a Value to a string; the two are not compatible. You seem to be just writing random lines of code in the hope that something will magically do what you want.

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)

TSharma0407 · Answer 1 · 2018-06-18T02:11:00

int.Parse() is used to assign the value of another variable after parse the value.

No use of below line, so remove it from your code: -

C#

int.Parse((string)grdRpt.DataKeys[gvrow.RowIndex].Value);

Your problem will be resolved after removing this line.
check this link also: Int32.Parse Method (String) (System)[^]

TarunShrivastav · Answer 2 · 2018-06-18T02:18:00

I believe You might be storing

int.Parse((string)grdRpt.DataKeys[gvrow.RowIndex].Value)

into a custom object. If not then you can remove this line.

and if you want to use it as a check then

if (available.Where(x => x.id == gvForCheckBox.DataKeys[gvrow.RowIndex].Value.ToString()).Any())

How to validate null value in gridview using paging gridview

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0