Ds issue when going to bind grid view

Question

0.00/5 (No votes)

See more:

I m going to bind the gridview in c#
when it comese to this

C#

if (ds.Tables.Count > 0)
                {
                    if (ds != null && ds.Tables.Count > 0)
                    ///if (ds.Tables[0].Rows.Count > 0)
                    {
                        gdvNotice.DataSource = ds.Tables[0];
                        Session["Get_Notice"] = ds.Tables[0];
                        gdvNotice.DataBind();

                    }
                    else
                    {
                        gdvNotice.DataSource = null;
                        gdvNotice.DataBind();
                    }
                }

Here returns 1 and

C#

if (ds.Tables.Count > 0)

in second if its false and go out of the block

C#

if (ds.Tables[0].Rows.Count > 0)

What I have tried:

if (ds.Tables.Count > 0)
{

if (ds.Tables[0].Rows.Count > 0)
{
gdvNotice.DataSource = ds.Tables[0];
Session["Get_Notice"] = ds.Tables[0];
gdvNotice.DataBind();

}
else
{
gdvNotice.DataSource = null;
gdvNotice.DataBind();
}
}

Posted 7-Sep-16 3:36am

faisal23

Updated 7-Sep-16 4:12am

Add a Solution

Comments

ZurdoDev 7-Sep-16 9:53am

If there are no rows then either your sql is not running or your sql is returning now rows. See what is happening in sql.

faisal23 7-Sep-16 10:00am

hello,
in first if case it return 1 and second if case condition is false and throw out the block

ZurdoDev 7-Sep-16 10:01am

I do not understand what you are asking.

faisal23 7-Sep-16 10:04am

plz see my code in first if block means
if (ds.Tables.Count > 0)
it return true means 1
in second if block means
if (ds.Tables[0].Rows.Count > 0)
it become false and throw out

ZurdoDev 7-Sep-16 10:05am

I already explained that. You do not have any rows.

faisal23 7-Sep-16 10:06am

6 records in table.
if no reccords then it false in first condition means
if (ds.Tables.Count > 0)
here it return 0 but it rtrn 1

ZurdoDev 7-Sep-16 10:09am

ds.Table.Count counts how many tables are in the dataset. So, if it returns 1 then you have 1 table.

To get to that one table you use ds.Tables[0]. 0 index being the first table.

So, ds.Tables[0]Rows = 0 means your table does not have any rows. So, like I said the very first time I replied, check your sql because your DataTable in C# does not have any rows/records.

faisal23 7-Sep-16 10:10am

now i understand thanx

1 solution

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)

ZurdoDev · Accepted Answer · 2016-09-07T04:12:00

As discussed in comments, your sql table may have records in it but they are not getting in C# so make sure you are calling your sql properly and passing in all the correct parameters. You can use Sql Profiler to trace and see what exactly is being sent to SQl.

Also, when binding your gridview, you likely do not want to check for rows. Just bind it to the DataTable and be done. If there are no rows, your grid will be empty. If there are, there will be rows. Don't worry about checking row count to determine how to databind.