how to get multiple queries data using entity framework stored procedure.

See more:

C#

ASP.NET

SQL

Hi,

This is my code:
This is my Procedure

ALTER proc [dbo].[GetTotalDataByIp]
@cntid int,
@checkid int
as
begin
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT ON;
If(@checkid = 1)
begin

SELECT top(24) LocationName,
COUNT(LocationName) AS TotalCount
FROM
Job WITH (NOLOCK) where CountryId = @cntid and LocationName !=' ' and LocationName !='???'
GROUP BY LocationName ORDER BY TotalCount DESC

end
else if(@checkid = 2)
begin
SELECT top(16) CompanyName,
COUNT(CompanyName) AS TotalCount
FROM
Job WITH (NOLOCK) where CountryId = @cntid and CompanyName != ' ' and isactive=1
GROUP BY CompanyName ORDER BY TotalCount DESC
end
end

I have to import as complex type but only first if condition fields shows only like Locationname and Totalcout.

In my page load I have bind like this...

int getcountry=108;
var getlocationbyip = dc.GetTotalDataByIp(getcountry, 1);
            if (getlocationbyip != null)
            {
                rptgetlocations.DataSource = getlocationbyip;
                rptgetlocations.DataBind();
            }

            //var getcompaniesbyip = dc.getcompaniesbyip(getcountry);
            var getcompaniesbyip = dc.GetTotalDataByIp(getcountry, 2);

            if (getcompaniesbyip != null)
            {
                rptcompanies.DataSource = getcompaniesbyip;
                rptcompanies.DataBind();
            }

I got error when second repeater binding.
Please help me..
Thank you...