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

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

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" />

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、选择日期：

2、查询结果：

转载于:https://www.cnblogs.com/bbyang/archive/2013/06/03/3115697.html