同一个页面,多个gridview控件显示数据问题
我在一个页面中用了2个gridview控件,这2个控件的Visible都为true,都绑定了数据源,为啥显示的时候,只有第一个显示数据,第二个控件不见了?编辑的时候没有提示有错误。也能正常运行,但是就是显示数据的时候,有一个控件消失了,请问这可能是什么情况? --------------------编程问答-------------------- 这2个gridview控件只是数据绑定函数不同,数据绑定函数如下:第一个gridview控件的绑定函数:
public void gvbind()
{
string start_station = Request.QueryString["a"].ToString();
string end_station = Request.QueryString["b"].ToString();
SqlConnection con = new SqlConnection("Initial Catalog=db_bus;Integrated Security=True");
con.Open();
string str1 = "select num,style,station,rtime,station2,rtime2,all_time,all_distance,all_price from (select num,style,station,rtime from busline where station='"
+ start_station +"') a inner join (select busline.num AS num1,sum(ptime) AS all_time,sum(pprice) AS all_price,sum(pdistance) AS all_distance from busline,(select num,snumber from busline where station='"
+ start_station +"') b where busline.num = b.num and busline.snumber >= b.snumber group by busline.num) c on a.num = c.num1 inner join (select * from (select busline.num AS num2,busline.station AS station2,busline.rtime AS rtime2 from busline,(select num,snumber from busline where station='"
+ start_station +"') s1 where busline.num = s1.num and busline.snumber >= s1.snumber) s2 inner join (select busline.num AS num3,busline.station AS station3,busline.rtime AS rtime3 from busline,(select num,snumber from busline where station='"
+ end_station +"') s3 where busline.num = s3.num and busline.snumber <= s3.snumber) s4 on s2.station2 = s4.station3) f on a.num = f.num2";
SqlDataAdapter da1 = new SqlDataAdapter(str1,con);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
GridView1.DataSource = ds1;
GridView1.DataBind();
con.Close();
}
第二个gridview控件的绑定函数与上面的这个类似,只是查询语句不同,为啥第二个就显示不了?
这2个函数我都在pageload函数中调用过了
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
gvbind1();
gvbind2();
}
} --------------------编程问答-------------------- 确保第二个gridview绑定的数据源里面有记录,如果没有记录,也看不到 --------------------编程问答-------------------- 首先断点调试下看看有没有数据吧 --------------------编程问答-------------------- 楼主,怎么没有 gvbind1();
gvbind2();这两个事件的代码
补充:.NET技术 , ASP.NET