sqlserver 存储过程 C#调用 实现从数据库Get数据

-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>//下面要添加名字
-- =============================================
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>      
    -- Add the parameters for the stored procedure here//添加参数
    <@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>, 
    <@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here//添加sql语句
    SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END
GO

USE [xxx]
GO
/****** Object:  StoredProcedure [dbo].[GetPluralProject]    Script Date: 1/5/2018 1:39:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[GetPluralProject]--这边是名字
    -- Add the parameters for the stored procedure here//参数
        @Language nvarchar(20)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here//sql语句
    SELECT distinct trans.[ProjectName] as ProjectName
  FROM [xxx].[dbo].[xxx] trans
  Where trans.string like '%plural,%'
END

exec GetPluralProject ''

 /// <summary>
        /// Executes the stored procedure, and return DataTable
        /// </summary>
        /// <param name="paraValues"></param>
        /// <returns></returns>
        /// 
        public DataTable ExecuteDataTable(string ProName, params object[] paraValues)//存储过程名字，参数
        {
            SqlCommand cmd = CreateSqlCommand(ProName);
            try
            {
                this.DeriveParameters(cmd);
                this.AssignParameterValues(cmd, paraValues);
                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                DataTable dataTable = new DataTable();
                adapter.Fill(dataTable);
                return dataTable;
            }
            catch
            {
                throw;
            }
        }

using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using xxxService.Models;

namespace xxxService.Controllers
{
    public class ProjectsController : ApiController
    {
        [CrossSite]
        public DataTable Get()
        {

            DbHelper DBH = new DbHelper();
            DataTable result = DBH.ExecuteDataTable("GetPluralProject", "");
            return result;

        }
    }
}

 object[] Params = new object[2];
            Params[0] = ProjectName;
            Params[1] = CultureName;

            DbHelper DBH = new DbHelper();
            DataTable result = DBH.ExecuteDataTable("xxx", Params);
            return result;