How to fetch Parent DataBound event Value to Child DataBound Event

Question

0.00/5 (No votes)

See more:

(Parent Grid) Doc_No                            (ChildGrid) Material  Quantity
              112233                                        Pipes       8
                                                            cubes       10
                                                            Piping      20

              123125                                        Pipes       5
                                                            Rcc         2

Doc_No is taken from DB, Material,Quantity is from temparory DataTable(material,Quantity).
Now,my question is to inser Parent Grid Doc_No into my temparory DataTable

like this.

Temprory DataTable

Doc_No     Material        Quantity
112233     Pipes           8
112233     cubes           10
......

How to do this can anyone help me to solve this issue....

Thanks in advance....

Posted 28-Sep-12 23:08pm

pranathis012

Updated 30-Sep-12 18:55pm

v2

Add a Solution

Comments

Sandeep Mewara 29-Sep-12 9:35am

Is the column Doc_no defined in temp table?

[no name] 1-Oct-12 0:02am

yes, Doc_No is also defined in Child Grid also and make it visible false.

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)

Maciej Los · Answer 1 · 2012-09-29T03:25:00

Solution 1

Probably you don't need to use temporary table, you can use simple SELECT query. If the data are stored in two different tables, like Document and Document_Details and they are related by Doc_No, you can use something like this:

SQL

SELECT D.Doc_No, DD.Material, DD.Quantity
FROM Document AS D
    LEFT JOIN Document_Details AS DD ON D.Doc_No = DD.Doc_No

But if you need it:

SQL

CREATE TABLE #tt (Doc_No INT, Material NVARCHAR(300), Quantity INT)

INSERT INTO #tt (Doc_No, Material, Quantity)
SELECT D.Doc_No, DD.Material, DD.Quantity
FROM Document AS D
    LEFT JOIN Document_Details AS DD ON D.Doc_No = DD.Doc_No

SELECT *
FROM #tt

DROP TABLE #tt

Posted 29-Sep-12 3:25am

Maciej Los

Updated 29-Sep-12 4:08am

v2

Comments

Sandeep Mewara 29-Sep-12 9:54am

Will this do what OP asks?
"Now,my question is to inser Parent Grid Doc_No into my temparory DataTable"

I guess, your query simply selects and is not inserting anything in temptable.

Maciej Los 29-Sep-12 10:05am

You are right, my query is a simply select instruction, because i'm not sure that OP realy need temporary table. ;)
Do you suggest me to correct my answer (rhetorical question, because i've change it now)?
Thanks Sandeep ;)

Sandeep Mewara 29-Sep-12 10:47am

It's ok. I see you already updated it.

My 5 for the answer.

Maciej Los 29-Sep-12 10:49am

Thank you, Sandeep ;)