//获取信息数据
public void bind()
{
String name = Text1.Value.Trim();
String address=DropDownList1.SelectedValue.Trim();
if (address == "全部地区")
{
address ="%";
} /*String sqlstr = "select drugID,name AS 药品名称,address AS 来源地区,"
+"company AS 公司名称,price AS 价格,num AS 数量 "
+"from drugInfo where name like '%@name%' and address like '%@address%' order by name";
cf.sqlconn.Open();
sqlcomm = cf.sqlconn.CreateCommand();
sqlcomm.CommandText = sqlstr;
SqlParameter para;
para = new SqlParameter("@name",name);
sqlcomm.Parameters.Add(para);
para = new SqlParameter("@address",address);
sqlcomm.Parameters.Add(para); SqlDataAdapter myda = new SqlDataAdapter(sqlcomm);
DataSet myds = new DataSet();
myda.Fill(myds,"drugInfo"); GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "drugID" };
GridView1.DataBind();
cf.sqlconn.Close();*/ String sqlstr = "select drugID,name AS 药品名称,address AS 来源地区,"
+ "company AS 公司名称,price AS 价格,num AS 数量 "
+ "from drugInfo where name like '%"+name+"%' and address like '%"+address+"%' order by name";
cf.sqlconn.Open();
sqlcomm = new SqlCommand(sqlstr,cf.sqlconn); SqlDataAdapter myda = new SqlDataAdapter(sqlcomm);
DataSet myds = new DataSet();
myda.Fill(myds,"drugInfo"); GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "drugID" };
GridView1.DataBind();
cf.sqlconn.Close();
}把sql查询语句替换为注释里面的内容 页面就没有数据了新手求助ASPdatasetGridView
public void bind()
{
String name = Text1.Value.Trim();
String address=DropDownList1.SelectedValue.Trim();
if (address == "全部地区")
{
address ="%";
} /*String sqlstr = "select drugID,name AS 药品名称,address AS 来源地区,"
+"company AS 公司名称,price AS 价格,num AS 数量 "
+"from drugInfo where name like '%@name%' and address like '%@address%' order by name";
cf.sqlconn.Open();
sqlcomm = cf.sqlconn.CreateCommand();
sqlcomm.CommandText = sqlstr;
SqlParameter para;
para = new SqlParameter("@name",name);
sqlcomm.Parameters.Add(para);
para = new SqlParameter("@address",address);
sqlcomm.Parameters.Add(para); SqlDataAdapter myda = new SqlDataAdapter(sqlcomm);
DataSet myds = new DataSet();
myda.Fill(myds,"drugInfo"); GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "drugID" };
GridView1.DataBind();
cf.sqlconn.Close();*/ String sqlstr = "select drugID,name AS 药品名称,address AS 来源地区,"
+ "company AS 公司名称,price AS 价格,num AS 数量 "
+ "from drugInfo where name like '%"+name+"%' and address like '%"+address+"%' order by name";
cf.sqlconn.Open();
sqlcomm = new SqlCommand(sqlstr,cf.sqlconn); SqlDataAdapter myda = new SqlDataAdapter(sqlcomm);
DataSet myds = new DataSet();
myda.Fill(myds,"drugInfo"); GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "drugID" };
GridView1.DataBind();
cf.sqlconn.Close();
}把sql查询语句替换为注释里面的内容 页面就没有数据了新手求助ASPdatasetGridView
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@name", name);
sqlcomm.Parameters.Add(para);
para[1] = new SqlParameter("@address", address);
sqlcomm.Parameters.Add(para);
SqlParameterCollection 只接受非空的 SqlParameter 类型对象,不接受 SqlParameter[] 对象。