使用My97DatePicker实现日期选择并连接数据库

1、My97DatePicker组件在http://www.my97.net 下载，然后将My97DatePicker文件夹复制到网站根目录下。

clip_image002

2、分别创建一个TextBox、 Button、 GridView控件

   1: <asp:TextBox runat="server" ID="txtDate" 
   2:     onfocus="WdatePicker({startDate:'&y-%m-01',
   3:         dateFmt:'yyyy-MM-dd',alwaysUseStartDate:true})" />
   4: <asp:Button runat="server" ID="btnSearch" Text="查询" onclick="btnSearch_Click" />

clip_image002[4]

3、编写按钮事件：

   1: protected void btnSearch_Click(object sender, EventArgs e)
   2:     {
   3:         string connectiongString = WebConfigurationManager.ConnectionStrings["Database"].ConnectionString;
   4:         SqlConnection con = new SqlConnection(connectiongString);
   5:         con.Open();
   6:         SqlCommand cmd = con.CreateCommand();
   7:         cmd.CommandText = string.Format("select * from DateDemo where 日期='{0}'", this.txtDate.Text);
   8:  
   9:         SqlDataAdapter adpt = new SqlDataAdapter();
  10:         adpt.SelectCommand = cmd;
  11:         DataSet ds = new DataSet();
  12:         adpt.Fill(ds);
  13:         con.Close();
  14:         this.GridView1.DataSource = ds;
  15:         this.GridView1.DataBind();
  16: }

 

结果图：

1、选择日期：

clip_image002[6]

2、查询结果：

clip_image002[8]

posted @ 2013-06-03 16:37  加油ing  阅读(520)  评论(0)  编辑  收藏  举报