就是这样:
using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using DBlib; public partial class ribao : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string currentDate = Convert.ToString(System.DateTime.Now.Year * 10000 + System.DateTime.Now.Month * 100 + System.DateTime.Now.Day); TextBox1.Text = currentDate; } string ymd = TextBox1.Text; this.bindData(ymd); } protected void bindData(string ymd) { DBlib.DB db = new DB(); DataSet ds = null; try { ds = db.ExecuteDataSet(" SELECT CL.CAR.CAR_TYPE,CL.CAR.CAR_NO,CL.LDCB.DJH,CL.CAR.TONNAGE,MIS.DEPT.DEPT_ALIAS,CL.CAR.CZDW,CL.YCDJ.RWSM,CL.LDCB.GL,MIS.CODING.ITEM_DESC,CL.LDCB.WEIGHT,CL.LDCB.TB,CL.LDCB.SNYTB,CL.LDCB.JF,CL.LDCB.DFFK FROM CL.CAR,CL.LDCB,CL.YCDJ,MIS.DEPT,MIS.CODING WHERE ( cl.ldcb.djh = cl.ycdj.djh (+)) and ( CL.CAR.CAR_SHORT = CL.LDCB.CH ) and ( CL.CAR.SSDW = MIS.DEPT.DEPT_CODE ) and ( CL.LDCB.ZD = MIS.CODING.ITEM_CODE ) and ( ( to_char(CL.LDCB.SI,'yyyymmdd') = :P0 ) AND ( CL.YCDJ.ZXZK >= '3' ) OR ( CL.LDCB.DFFK = 'Y' ) ) AND ( MIS.CODING.CODE_ID = 'CL16' ) ", ymd); GridView1.DataSource = ds.Tables[0].DefaultView; GridView1.DataBind(); } catch (Exception ex) { ex.ToString(); } } protected void GridView1_PageIndexChanged(object sender, EventArgs e) { // } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { // GridView1.PageIndex = e.NewPageIndex; string ymd = TextBox1.Text; this.bindData(ymd); } protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { } protected void Button1_Click1(object sender, EventArgs e) { } protected void Button2_Click(object sender, EventArgs e) { Response.Write(""); } }
怎么回事啊?
using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using DBlib; public partial class ribao : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string currentDate = Convert.ToString(System.DateTime.Now.Year * 10000 + System.DateTime.Now.Month * 100 + System.DateTime.Now.Day); TextBox1.Text = currentDate; } string ymd = TextBox1.Text; this.bindData(ymd); } protected void bindData(string ymd) { DBlib.DB db = new DB(); DataSet ds = null; try { ds = db.ExecuteDataSet(" SELECT CL.CAR.CAR_TYPE,CL.CAR.CAR_NO,CL.LDCB.DJH,CL.CAR.TONNAGE,MIS.DEPT.DEPT_ALIAS,CL.CAR.CZDW,CL.YCDJ.RWSM,CL.LDCB.GL,MIS.CODING.ITEM_DESC,CL.LDCB.WEIGHT,CL.LDCB.TB,CL.LDCB.SNYTB,CL.LDCB.JF,CL.LDCB.DFFK FROM CL.CAR,CL.LDCB,CL.YCDJ,MIS.DEPT,MIS.CODING WHERE ( cl.ldcb.djh = cl.ycdj.djh (+)) and ( CL.CAR.CAR_SHORT = CL.LDCB.CH ) and ( CL.CAR.SSDW = MIS.DEPT.DEPT_CODE ) and ( CL.LDCB.ZD = MIS.CODING.ITEM_CODE ) and ( ( to_char(CL.LDCB.SI,'yyyymmdd') = :P0 ) AND ( CL.YCDJ.ZXZK >= '3' ) OR ( CL.LDCB.DFFK = 'Y' ) ) AND ( MIS.CODING.CODE_ID = 'CL16' ) ", ymd); GridView1.DataSource = ds.Tables[0].DefaultView; GridView1.DataBind(); } catch (Exception ex) { ex.ToString(); } } protected void GridView1_PageIndexChanged(object sender, EventArgs e) { // } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { // GridView1.PageIndex = e.NewPageIndex; string ymd = TextBox1.Text; this.bindData(ymd); } protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { } protected void Button1_Click1(object sender, EventArgs e) { } protected void Button2_Click(object sender, EventArgs e) { Response.Write(""); } }
怎么回事啊?
解决方案 »
- 用C#修改淘宝网的宝贝价格.超级支付alipay
- 客户端软件调用几个门户网站的资源,顶者有分
- 写了一个播放器程序,而我的电脑已经安装了千千静听,如何编程设置注册表,让我能双击mp3文件就用自己的播放器打开它?
- 问个新手问题dataset添加保存问题,谢谢
- 求助程序题
- 一个页面有2个ascx,怎么在一个ascx中修改另一个ascx控件的值?
- 就Applied Microsoft.NET Framework Programming一书中的装箱与拆箱提问。(欢迎参加讨论)
- 在C#中将SQL SERVER 2000数据导入到Excel中
- C#怎样执行DOS批处理文件?
- VC#真的不能在WIN98下用用吗?
- 跪求:vs2008 datagridview 如何添加下拉模板列
- Form show方法的问题
iis里面没配置后缀?
iis里面没配置后缀?配置什么后缀?