急！请教textbox查询多行数据显示的问题

Question

本帖最后由 citydemon1 于 2010-03-31 23:04:28 编辑

Answer 1

string[] content = this.txtBookBarCode.Text.Replace("\r", "").Split('\n');
         string strCond = "";
            foreach (string s in content)
            {
                
                if(s.Trim() == string.Empty) continue;
                strCond+= "'"+s.Trim()+"',";
                
            }  
            if(strCond.Length ==0)
            {
                 RegisterStartupScript("", "<script>alert('物品条形码不能为空')</script>");
                return;
            }            strCond = strCond.Substring(0,strCond.Length-1);            string sql = "select * from tb_bookInfo where bookBarCode IN("+strCond+")";
            
             DataSet ds = dataOperate.getDataset(sql);
                
                if (ds.Tables[0].Rows.Count > 0)
                {
                    gvBookBorrow.DataSource = ds;
                    gvBookBorrow.DataKeyNames = new string[] { "bookBarCode" }; 
                    gvBookBorrow.DataBind(); 
                }
                else
                    RegisterStartupScript("", "<script>alert('物品条形码错误！')</script>");

Answer 2

 gvBookBorrow.DataSource = ds;
                    gvBookBorrow.DataKeyNames = new string[] { "bookBarCode" }; 
                    gvBookBorrow.DataBind(); 你这段代码 在循环里面重复执行了！ 所以只显示最后数据了
楼上代码给出了