public void Repeater_bind(Repeater rp, ref DataSet ds, string sqlstr, string connstr) { //对连接字符串connstr所指的数据库,执行查询语句sqlstr,并用其返回的关系,绑定Repeater控件rp.函数返回数据集,供进一步操作 MyData md = new MyData(connstr); ds = md.FillDataset(sqlstr); rp.DataSource = ds.Tables[0].DefaultView; rp.DataBind(); }
public void fill_dropdownlist(DropDownList[] ddl, string connstr, string sql, string textfield, string valuefield) { //对连接字符串connstr所指的数据库,执行查询语句sql,并用其返回的关系的textfield字段和valuefield字段分别绑定给ddl数组中各控件的DataTextField属性和DataValueField属性 MyData md = new MyData(connstr); DataSet ds1 = md.FillDataset(sql); for (int i = 0; i < ddl.Length; i++) { ddl[i].DataSource = ds1.Tables[0].DefaultView; ddl[i].DataTextField = textfield; ddl[i].DataValueField = valuefield; ddl[i].DataBind(); } }
public void DG_bind(DataGrid dg, string sqlstr, string SearchCondition, string SortExpression, string connstr) { // 对连接字符串connstr所指的数据库,执行查询语句sqlstr,并用其返回的关系,绑定DataGrid控件dg,SearchCondition为检索时的检索条件,SortExpression为当前数据表格的排序模式 MyData md = new MyData(connstr); DataSet ds1 = md.FillDataset(sqlstr); if (SearchCondition != "") { ds1.Tables[0].DefaultView.RowFilter = SearchCondition; } ds1.Tables[0].DefaultView.Sort = SortExpression; dg.DataSource = ds1.Tables[0].DefaultView; try { dg.DataBind(); } catch { dg.CurrentPageIndex -= 1; dg.DataBind(); } }