这其实很简单啊,首先是设置2个控件 然后分别绑定执行不同的sql就可以了。
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
SqlDataAdapter myCommand = new SqlDataAdapter("select * from TB_Net Where [Money]='非营利性' Order By CountN", connection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "FreeNet");
Repeater_Free.DataSource = ds.Tables["FreeNet"].DefaultView;
Repeater_Free.DataBind();
SqlDataAdapter myCommand2 = new SqlDataAdapter("select * from TB_Net Where [Money]='营利性' Order By CountN", connection);
myCommand2.Fill(ds, "MoneyNet");
Repeater_Money.DataSource = ds.Tables["MoneyNet"].DefaultView;
Repeater_Money.DataBind();
看我的 我用了2个Repeater控件
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
SqlDataAdapter myCommand = new SqlDataAdapter("select * from TB_Net Where [Money]='非营利性' Order By CountN", connection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "FreeNet");
Repeater_Free.DataSource = ds.Tables["FreeNet"].DefaultView;
Repeater_Free.DataBind();
SqlDataAdapter myCommand2 = new SqlDataAdapter("select * from TB_Net Where [Money]='营利性' Order By CountN", connection);
myCommand2.Fill(ds, "MoneyNet");
Repeater_Money.DataSource = ds.Tables["MoneyNet"].DefaultView;
Repeater_Money.DataBind();
看我的 我用了2个Repeater控件