Entity Framework

abhinav

SOLVED CLOSED ACTIVE ANSWERED
User: abhinav
Posted: on Jun 27, 2012 03:46 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 8242

Suppose i want all values of keyword and resulthead which year = 2005.

then what should i do?

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

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

abhinav

0 6

Reply
User: abhinav
Replied: on Jun 27, 2012 05:44 AM
Report

I wrote this function but it is not working

 public void SelectValue()
        {
            using (MyConnection ctx = new MyConnection())
            {
                var parameter = new SqlParameter
                {
                    DbType = DbType.Int32,
                    ParameterName = "Year",
                    Value = 2005
                };

                var result = ctx.SeoAnalysis.SqlQuery("select_value @Year", parameter).ToList();
                Response.Write(result);
               // Assert.AreEqual(1, result.Id);
            }
        }

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

Entity Framework

Company

Explore

Follow us

Contact Us