首页 > 代码库 > 多个数据读取的两种简写方法
多个数据读取的两种简写方法
string[] gqds_key = new string[23];
string[] gqds_table = new string[23];
string[] gqds_where = new string[23];
string[] gqds_order = new string[23];
DataSet gqds = new DataSet();
gqds_key[0] = "top 9 oppid,title,opptype";
gqds_table[0] = "Opportunity";
gqds_where[0] = "opptype=3 and oppstate=1";
gqds_order[0] = "oppid desc";
gqds = DB.ReturnDataSet(gqds_key, gqds_table, gqds_where, gqds_order);
Bind(rptgy, gqds, 0);
protected void Bind(Repeater rpt, DataSet ds, int i)
{
rpt.DataSource = ds.Tables[i];
rpt.DataBind();
}
public static DataSet ReturnDataSet(string[] colums, string[] tabname, string[] where, string[] order);
string[] listsql2 = new string[7];
listsql2[0] = "";
listsql2[1] = "";
dataSet ds = DB.ReturnDataSet(listsql2 );
Bind(rptgy, ds , 0);
多个数据读取的两种简写方法