I have a requirement to check if datatable is null then copy the row to datatable otherwise need to append the row to the datatable.

Question

0.00/5 (No votes)

See more:

i have a requirement to check if DataTable is null then copy the row to DataTable otherwise need to append the row to the DataTable.

What I have tried:

if (dtTable == null)
    {
        dtTable = (from DataRow dr in dtDetails.Rows
                   where dr["ID"].ToString() == Id
                   select dr).CopyToDataTable();
    }
    else
    {
       // Here Need to Add a new row in DataTable and append the output of 
         query into DataTable ie dtTable.

       DataRow row = selectedTable.NewRow();

        dtTable  = (from DataRow dr in dtDetails.Rows
        where dr["ID"].ToString() == Id
        select dr)
        // Need help here

    }

Posted 19-Dec-18 0:25am

dipak prodhan

Updated 19-Dec-18 0:35am

Add a Solution

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)

OriginalGriff · Accepted Answer · 2018-12-19T00:35:00

If a DataTable is null then you can't copy anything to it: there isn't anything to copy into!

It's a bit like a pocket: you have a pocket in your shirt, which you use to hold a pen. If you reach into the pocket and find there isn't a pen there, you can't sign your name on a piece of paper - and you will get very funny looks if you try!
But what you are trying to do is reach into a pocket while you aren't even wearing a shirt! You can't check the pocket for a pen, because the pocket isn't there at all.

If you want to copy data to a DataTable and the variable is null, you have to create an instance of a table to add it to.

In this case, all you need to do is use the Add method:

C#

else
    {
        dtTable.Rows.Add (from DataRow dr in dtDetails.Rows
        where dr["ID"].ToString() == Id
        select dr)