select data from db and insert them into gridview

Question

0.00/5 (No votes)

See more:

C#

i want to show 2 query result in 1 grid view how can i do this

Posted 3-Dec-12 22:42pm

f.sarikhani

Add a Solution

Comments

__TR__ 4-Dec-12 4:51am

If both the queries have same column names you can use Union or Union all[^] to combine the results of both the queries.

3 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)

Krunal Rohit · Answer 1 · 2012-12-03T22:46:00

Solution 1

Get the results from both queries and join them in memory just before you bind them to the GridView instead of joining them in a single query.

Similar solved thread : show data of both queries at runtime in a grid view[^]

Posted 3-Dec-12 22:46pm

Krunal Rohit

Updated 3-Dec-12 22:51pm

v2

Comments

f.sarikhani 4-Dec-12 4:48am

how can i do this?
i have data in gridview and whith click on button i want to execute another query and then its result add to gridview and this action can happen multi time

[no name] 4-Dec-12 4:52am

I've updated solution.. explore link :)

azizulhoque.bd · Answer 2 · 2012-12-03T22:51:00

Solution 2

Hi dear,

Get the result when the both query are joining [Inner Join, Outer Join etc ] Or Union Or Union All.

Posted 3-Dec-12 22:51pm

azizulhoque.bd

Comments

f.sarikhani 4-Dec-12 5:01am

the query is varable and in run time with input value is dimonestrate
also the number of clicking on button is varable then the number of query is varable how can do this?????

Sandesh M Patil · Answer 3 · 2012-12-04T00:27:00

Solution 3

Create a view by joining both tables and then bind this view to the gridview control.

Posted 4-Dec-12 0:27am

Sandesh M Patil