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模糊查询

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 = "关键字";     //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(); }