请教,想实现calendar中日期改变后,carousel中gridview控件,根据所选日期变化,(执行C1Calendar1_SelectedDatesChanged函数后),gridview控件改变。
目前情况是,日期变化后,gridview控件为空。
(1)有办法解决么
(2)是不是,用了carousel控件后,就不能从后台cs代码中,写sql语句绑定了
- protected void C1Calendar1_SelectedDatesChanged(object sender, EventArgs e)
- {
- string s_date = string.Format("{0:yyyyMMdd}", C1Calendar1.SelectedDate);
- Session["date"] = s_date;
- string date = Session["date"].ToString();
-
- DBClass db = new DBClass();
- string sql_nong_erfen = "SELECT [日期], [单位], [不良率时点], [不良率月增减], [不良率年增减], [不良金额时点], [不良金额月增减], [不良金额年增减] FROM [produce1].[dbo].[nong_erfen] where [日期]='" + date + "' ORDER BY [序号]";
- DataTable dt_nong_erfen = db.GetDataSet(sql_nong_erfen, "ok");
- this.SqlDataSource1.SelectParameters[0].DefaultValue = s_date;
- /*
- C1GridView1.DataSource = this.SqlDataSource1;
- C1GridView1.DataBind();*/
- }
复制代码 |