MVC 调用SQL存储过程

 

 

1、首先在Web.Config文件中配置一个与数据库的连接connectionStrings
  <connectionStrings    >
    <add name ="Conn" connectionString ="server=(local);uid=sa;pwd=123456;database=ShoesShop;" providerName ="System.Data.SqlClient"/>
  </connectionStrings>
参数就不必说是什么意思了吧

2、采用存储过程mvc3的访问数据库的通用类
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

namespace ShoesShop.DBUility
{
    public class MsSql
    {
        //通过根据存储过程提取所有的函数
        public DataSet getAllRecord(string storename, string Conn)
        {
            D