How to retrieve data in gridview according to date selected by user

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Knight 1
    New Member
    • Oct 2011
    • 3

    How to retrieve data in gridview according to date selected by user

    Code:
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <div>
    <asp:TextBox ID="TextBox1" runat="server" AutoPostBack="True"></asp:TextBox>
    
    <asp:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="TextBox1">
    </asp:CalendarExtender>
    
    </div>
    Code:
    using System;
    using System.Collections.Generic;
    using System.Configuration;
    using System.Data;
    using System.Data.OleDb;
    using System.Data.SqlClient;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Globalization;
    public partial class View : System.Web.UI.Page
    {
    string strcon = ConfigurationManager.ConnectionStrings["con"].ToString();
    
    protected void Page_Load(object sender, EventArgs e)
    {
    string str = TextBox1.Text;
    
    CultureInfo[] cultures = { CultureInfo.CreateSpecificCulture("en-US") };
    foreach (CultureInfo culture in cultures)
    {
    DateTime date;
    date = DateTime.Parse(str, culture);
    }
    //string str = TextBox1.Text;
    // DateTime date = DateTime.ParseExact(str, "yyyy/MM/DD", null);
    //System.DateTime str_date = DateTime.Parse(TextBox1.Text, System.Globalization.CultureInfo.CreateSpecificCulture("en-AU").DateTimeFormat);
    //var userdateformat = DateTime.ParseExact(" ' " + TextBox1.Text.ToString() + " ' ", "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
    
    Load_GridData();
    
    }
    void Load_GridData()
    {
    SqlConnection conn = new SqlConnection(strcon);
    conn.Open(); // open the connection 
    SqlDataAdapter Sqa = new SqlDataAdapter("select Image, ImageName from Img where ([Date] = @date) ", conn);
    DataSet ds = new DataSet();
    Sqa.Fill(ds); // fill the dataset 
    GridView1.DataSource = ds; // give data to GridView
    GridView1.DataBind();
    conn.Close();
    }
    }
    ERROR:- STRING IS NOT RECOGNIZED AS VALID DATETIME..


    date is saved in yyyy-mm-dd formate in database. Please help.
Working...