//绑定搜索到的助教数据 protected void DataListBind() { DalOperationUsers dos = new DalOperationUsers(); DataView dv = dos.SearchUserByTypeAndKeywod(2, txtKeyword.Text.Trim()).DefaultView; this.AspNetPager2.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功 pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = pageIndex - 1; pds.PageSize = CommonUtility.pageSize; ; this.dlSearchAssistant.DataSource = pds; this.dlSearchAssistant.DataBind(); if (pds.Count > 0) { this.dlSearchAssistant.ShowFooter = false; } }
private string SearchTeacherIds(string keyWord) { DalOperationUsers dos = new DalOperationUsers(); DataView dv = dos.SearchUserByTypeAndKeywod(1, keyWord).DefaultView; DataRowCollection drCollection = dv.Table.Rows; List<string> tidList = new List<string>(); for (var i = 0; i < drCollection.Count; i++) { string s = drCollection[i]["teacherNo"].ToString(); tidList.Add("'" + s + "'"); } string tids = string.Join(",", tidList.ToArray()); return tids; }