写错了,不知道你写的sha!Creat PROCEDURE [dbo].[aaa] @buyername varchar(50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; sELECT * from dbo.基础信息购买商名称 where [购买商] like '%' + @buyername + '%' END还有一段存储过程
给你给完整的: -----------------------底层的查询DAL--------------------- /// <summary> /// 根据sql语句查询 /// </summary> /// <param name="cmdText">sql语句</param> /// <returns></returns> public DataTable QueryTableData(String cmdText) { DataSet dst = new DataSet(); SqlCommand comm = CreateCommend(); comm.Connection = Conn; comm.CommandText = cmdText; //BindCommendParameters(comm, parameters); SqlDataAdapter dad = new SqlDataAdapter(comm); dad.Fill(dst, "sourceTalbe"); if (dst.Tables.Count >= 0) { return dst.Tables[0]; } else { return null; } } -----------------------页面web--------------------- string sql="select * from table"; DataTable dt=new DAL的类名(). QueryTableData(sql); this.GridView控件ID.DataSource=dt; this.DataBind();基本的数据库链接你就自己写了,很简单的东东为什么要用存储过程?sql语句就可以搞定
写错了,不知道你写的sha!
写错了,不知道你写的sha!Creat PROCEDURE [dbo].[aaa]
@buyername varchar(50)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON; sELECT * from dbo.基础信息购买商名称 where [购买商] like '%' + @buyername + '%'
END还有一段存储过程
-----------------------底层的查询DAL--------------------- /// <summary>
/// 根据sql语句查询
/// </summary>
/// <param name="cmdText">sql语句</param>
/// <returns></returns>
public DataTable QueryTableData(String cmdText)
{ DataSet dst = new DataSet();
SqlCommand comm = CreateCommend();
comm.Connection = Conn;
comm.CommandText = cmdText; //BindCommendParameters(comm, parameters);
SqlDataAdapter dad = new SqlDataAdapter(comm);
dad.Fill(dst, "sourceTalbe");
if (dst.Tables.Count >= 0)
{
return dst.Tables[0];
}
else
{
return null;
}
}
-----------------------页面web---------------------
string sql="select * from table";
DataTable dt=new DAL的类名(). QueryTableData(sql);
this.GridView控件ID.DataSource=dt;
this.DataBind();基本的数据库链接你就自己写了,很简单的东东为什么要用存储过程?sql语句就可以搞定
因为后面的存储过程可能会越来越复杂。这只是为了先了解一下原理。如果在不建参数的话,sqldatasource直接与Gridview在asp.net里绑定的话显示数据就没有问题。
一定要引入adapter和dataset啊?