ASP.NET中利用存儲過程實現(xiàn)模糊查詢

    ASP.NET中利用存儲過程實現(xiàn)模糊查詢
    建表腳本
    USE [TestDB]
    GO
    /****** Object: Table [dbo].[tblCustomer] Script Date: 01/18/2014 22:01:53 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[tblCustomer](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [name] [nvarchar](100) NULL,
    [dat] [date] NULL
    ) ON [PRIMARY]
    GO
    SearchCustomer.sql
    CREATE PROCEDURE SearchCustomer
    -- Add the parameters for the stored procedure here
    @name nvarchar(100)
    AS
    SELECT * FROM dbo.tblCustomer WHERE name LIKE '%'+@name+'%'
    GO
    模糊搜索代碼
    代碼如下:
    using (SqlConnection cn = new SqlConnection("Server=localhost;Database=TestDB;Trusted_Connection=True;"))
    {
    cn.Open();
    string str = "關(guān)鍵字";
    //str = null;
    SqlCommand cmd = new SqlCommand("SearchCustomer", cn);
    cmd.CommandType = CommandType.StoredProcedure;
    DataTable dt = new DataTable();
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    da.SelectCommand.Parameters.Add("@name", SqlDbType.NVarChar).Value = str;
    da.Fill(dt);
    Debug.Assert(dt.Rows.Count > 0);
    GridView1.DataSource=dt;
    GridView1.Bind();
    cn.Close();
    }