how to merge 4 datatables into one in c#?

Question

1.00/5 (1 vote)

See more:

Hi All,

I have one datagridview with four datagridcomboboxcolumns.
I want to bind four different lists to four datagridComboboxcolumns.

So i am approaching this with the logic:
1.Adding each list to each datatable.
2.Merging all four datatables to one datatable.
3.Binding final datatable with the datagridview.

But i am having problem in merging all datatable
to one datatable.? If i add second table to first one. Then secondtable column
starts from the next row of the last value of first table. It is not adding from the
first index of the datatable.

So Can anyone give me codelogic for above problem?
Or any better idea of binding that 4 lists
to my datagridview???

Whichever can anyone guide me with dis??

Regars,
Mohana

Posted 12-Jun-12 1:27am

Mohanapriya Ranganathan

Add a Solution

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)

AmitKumar89 · Answer 1 · 2012-06-12T01:47:00

Solution 1

Hi,
If the schema of your table is same for all datatables then you can use a dataset and call the merge function of the dataset with respective datatable.

All the best.
--AK

Posted 12-Jun-12 1:47am

AmitKumar89

Michael_Jacsi · Answer 2 · 2012-06-12T02:42:00

Solution 2

My Advise Try to Write A Store Procedure Work out that place make single Temp Table then fetch it that as datatable or dataset to assign gridview datasource thats best way and simple one

Note:
1.Finally make query return like have 4 Dropdownlist Text and value field as colum

2.In Bind time dropdown datasource for all 4 same but each dropdown different text and value field for that same Datasource table column

Posted 12-Jun-12 2:42am

Michael_Jacsi

Updated 12-Jun-12 2:49am

v2

Comments

Mohanapriya Ranganathan 12-Jun-12 10:34am

But my 2 lists are static lists and 2 lists are created during run time.
so i thought of processing it in the UI itself.

Michael_Jacsi 13-Jun-12 4:17am

Can you Post some Source Code now what you tried in your Page.. its may better helps to understand and solve the problem