以下sql语句关联到两个表的查询结果,如何将结果直接显示到页面
select bh,mc,sum(sl)sl from (select bh,mc,sl from a1 union all select bh,mc,sl from a2)t group by bh,mc
select bh,mc,sum(sl)sl from (select bh,mc,sl from a1 union all select bh,mc,sl from a2)t group by bh,mc
string sertstr = "select bh,mc,sum(sl)sl from (select bh,mc,sl from a1 union all select bh,mc,sl from a2)t group by bh,mc";
SqlDataAdapter myCommand = new SqlDataAdapter(sertstr, MyConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds);
请问如何返回ds的视图
...........
.................
DataSet ds = new DataSet();
myCommand.Fill(ds);
//接着写:如果是GridView的话
GridView1.DataSource = ds;
GridView1.DataBind();就可以了!!这样结果直接显示到页面
string sertstr = "select bh,mc,sum(sl)sl from (select bh,mc,sl from a1 union all select bh,mc,sl from a2)t group by bh,mc";
SqlDataAdapter myCommand = new SqlDataAdapter(sertstr, MyConnection);
Dataset ds = new Dataset();
myCommand.Fill(ds);
GridView1.DataSource = ds .Tables[0].DefaultView;
GridView1.DataBind();
//可以在Gridview上显示
SqlDataAdapter da = new SqlDataAdapter("select bh,mc,sum(sl)sl from (select bh,mc,sl from a1 union all select bh,mc,sl from a2)t group by bh,mc", con);
DataTable table = new DataTable();
da.Fill(table);
this.GridView1.DataSource = table.DefaultView;
this.GridView1.DataBind();protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.BindDate();
}
}
试试看,SQL语句数据可以运行?