連接字符串

  代碼如下:
 string conn = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
 

 confige文件
  代碼如下:
     <connectionStrings>
        <add name="NorthwindConnectionString" connectionString="Data Source=.;Initial Catalog=Northwind;Integrated Security=True" providerName="System.Data.SqlClient"/>
    </connectionStrings>
 
 1. 只返回單一記錄集的存儲過程
  代碼如下:
      SqlConnection sqlconn = new SqlConnection(conn);
        SqlCommand cmd = new SqlCommand();
        // 設(shè)置sql連接
        cmd.Connection = sqlconn;
        // 如果執(zhí)行語句
        cmd.CommandText = "Categoriestest1";
        // 指定執(zhí)行語句為存儲過程
        cmd.CommandType = CommandType.StoredProcedure;

        SqlDataAdapter dp = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        // 填充dataset
        dp.Fill(ds);
        // 以下是顯示效果
        GridView1.DataSource = ds;
        GridView1.DataBind();
 
 存儲過程Categoriestest1
  代碼如下:
 CREATE PROCEDURE Categoriestest1
AS
select *
from  Categories
GO
 

 2. 沒有輸入輸出的存儲過程
c#代碼部分
代碼如下:
       SqlConnection sqlconn = new SqlConnection(conn);
        SqlCommand cmd = new SqlCommand();

        cmd.Connection = sqlconn;
        cmd.CommandText = "Categoriestest2";
        cmd.CommandType = CommandType.StoredProcedure;
        sqlconn.Open();
        // 執(zhí)行并顯示影響行數(shù)
        Label1.Text = cmd.ExecuteNonQuery().ToString();
        sqlconn.Close();

存儲過程Categoriestest2
代碼如下:
CREATE PROCEDURE Categoriestest2  AS
insert into dbo.Categories
(CategoryName,[Description],[Picture])
values ('test1','test1',null)
GO

3. 有返回值的存儲過程
c#代碼部分
代碼如下:
SqlConnection sqlconn = new SqlConnection(conn);
        SqlCommand cmd = new SqlCommand();