Stored Procedure return multiple results

Question

0.00/5 (No votes)

See more:

I have a stord procedure called EXEC [usp_GetDetail] will return multiple results.I need to display those Different datasets in a single webpage using Different DataGrids.

Posted 21-May-12 5:20am

myansweris

Updated 15-Jun-12 5:39am

v2

Add a Solution

Comments

Maciej Los 21-May-12 12:50pm

Where is a problem? What have you done so far? Have you read this?

John Orendt 23-May-12 0:14am

Does usp_GetOwnerDetail return a DataSet with multiple tables?

myansweris 23-May-12 9:42am

Yes it has multitables, but mu problem is to display those results in a collapsed panel like SQL server Dashboard

John Orendt 23-May-12 13:36pm

Sorry, I don't know what you mean by "a collapsed panel like SQL server Dashboard"?

myansweris 24-May-12 10:33am

Ok let me put it in this way ---- stored proc returns multiple values like 46 columns, and i want to display those values Horizontally , so that panel needs side by side diaplay.
Ex:-- sqlserver --> rightclick on databaseserver --->reports--->standardreports--->Server Dashboard
there u find this collapsed panels (CPU Usage)
I just want to desplay my panel exactly like that ... Any help ?

John Orendt 24-May-12 14:45pm

Cool, I never knew that report existed. In case where you want column names on side see http://www.codeproject.com/Articles/19313/Displaying-Vertical-Rows-in-DataGrid-View Are you building an aspx project or a windows app? How many tables does usp_GetOwnerDetail return? For each table how many columns and how many rows? You need all this info to design a nice layout. Do the number of tables, rows, columns vary? regarding the collapsed feature, those are just buttons. Buttons have a click event. In the ButtonClickHandler you would adjust the Visible property of the corresponding DataGridView and also change the text or image of the button.

myansweris 24-May-12 17:06pm

Thank you for u r reply, Am designing a ASP.net webportal,In that SQl stored proc returns 2 datasets, first one with 37 columns & second datasetreturns 9 columns.I just need to display those values in a gridview.But am sending a parameter to this gridview(button click).As i said i need to diaplay those values like a dashboard panel.

4 solutions

Solution 3

hi,

.aspx

C#

<form id="form1"  runat="server">
<div>
    <asp:panel id="PanelResult" runat="server">
    </asp:panel>
</div>
</form>

.aspx.cs

C#

DataSet dsResult = getDataSet("EXEC usp_GetOwnerDetail;");

for (int intTables = 0; intTables < dsResult.Tables.Count; intTables++)
{
    GridView gvTable = new GridView();
    gvTable.ID = "gv" + intTables;
    gvTable.DataSource = dsResult.Tables[intTables];
    gvTable.DataBind();

    PanelResult.Controls.Add(gvTable);
}

Posted 22-May-12 17:34pm

Una Yu

Updated 22-May-12 17:36pm

v2

Solution 4

if you have already added grid view control
then set datasource to all gridviews

C#

DataSet dsResult = getDataSet("EXEC usp_GetOwnerDetail;");
GridView1.DataSource=dsResult.Tables[0];
GridView2.DataSource=dsResult.Tables[1];
GridView2.DataSource=dsResult.Tables[2];
Page.DataBind();

if you have not added then

You can add GridView Direct on page

or create a asp:Panel on Page and Add All Grids to this Panel
like
Una Yu write

Posted 22-May-12 19:34pm

Technoses

Comments

myansweris 24-May-12 16:57pm

Thank you for u r reply , when i execute my stored Proc --i have 2 data sets one with primaryKey(ServerId) So i can retrieve ---> But iam unable to retrieve the second dataset because that doesn't have any Primary key to call in a Panel.so what is the best option to do?

Solution 1

Presumably you have added a way to differentiate between the datasets? Using that difference in a where clause would probably be the simplest way of doing this.

Posted 21-May-12 5:22am

R. Giskard Reventlov

Comments

myansweris 21-May-12 12:00pm

I don't want to Modify my StoredProc...Just need to diaplay Storedproc multiple set results in a single page using DataGrid

R. Giskard Reventlov 21-May-12 12:06pm

Did I say that you should? Apply the where clause to the logic that selects the data for each gridview.

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)

Wendelius · Accepted Answer · 2012-05-22T11:18:00

Solution 2

If you're going to receive multiple result set from the procedure you need to enable MARS[^]. Then when reading the data, if you use for example a SqlDataReader, use NextResult[^] to advance in the results.

Posted 22-May-12 11:18am

Wendelius

Comments

Espen Harlinn 22-May-12 18:08pm

Excellent :-D

Wendelius 23-May-12 1:27am

Thanks :)

Prasad_Kulkarni 23-May-12 0:24am

Great +5!

Wendelius 23-May-12 1:27am

Thank you :)

myansweris 24-May-12 10:30am

THanks

Wendelius 24-May-12 15:27pm

You'er welcome :)