entity framework with stored procedure

abhinav

SOLVED CLOSED ACTIVE ANSWERED
User: abhinav
Posted: on Jun 26, 2012 04:13 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 2706

How can i make and call function using this stored procedure?

alter PROCEDURE [dbo].[select_value]
	-- Add the parameters for the stored procedure here
	@Keyword varchar(1000) output,
	@ResultHead varchar(1000) output,
	@Year int
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT @Keyword, @ResultHead from SeoAnalysis where YEAR= @Year
END
GO

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 5

Reply
ANSWER
User: Mudassar
Replied: on Jun 27, 2012 12:11 AM
Report

Your stored procedure is incorrect.

alter PROCEDURE [dbo].[select_value]
    -- Add the parameters for the stored procedure here
    @Keyword varchar(1000) output,
    @ResultHead varchar(1000) output,
    @Year int
     
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
 
    -- Insert statements for procedure here
    SELECT @Keyword=keyword, @ResultHead=resulthead from SeoAnalysis where YEAR= @Year

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

entity framework with stored procedure

Company

Explore

Follow us

Contact Us