Pass Date from Gridview to textbox

I'm not sure what exactly you want to achieve, however, if you are trying to display the result in GridView based on date ranges then you can do something like this:

private string GetConnectionString(){
//call the Connection string that was set up from the web.config file
return System.Configuration.ConfigurationManager.ConnectionStrings["YourConnectionStringName"].ConnectionString;
}
private void BindGrid(string startDate, string endDate){
DateTime dStartDate;
DateTime dEndDate;
DataTable dt = new DataTable();
//Check if the string has the valid date format
if (datetime.TryParse(startDate, out dStartDate) && datetime.TryParse(endDate, out dEndDate))
{
SqlConnection connection = new SqlConnection(GetConnectionString());
try
{
connection.Open();
string sqlStatement = "SELECT FROM WHERE DateColumnName > @DateFrom AND DateColumnName < @DateTo";
SqlCommand sqlCmd = new SqlCommand(sqlStatement, connection);
sqlCmd.Parameters.AddWithValue("@DateFrom", dStartDate);
sqlCmd.Parameters.AddWithValue("@DateTo", dEndDate);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
//Show no Records found
}
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Fetch Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
connection.Close();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
BindGrid(TextDateFrom.Text, TextDateTo.Text);
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akhter HUssain7y ago
i do not want this,my issue is that i have two web pages ,on one web page i have gridview and on gridview i have given selection on each row for passing data on another web page form ,so i have date format data in gridview which is not passing on Web page form
as you can see below image in which INTIME and OUTTime date are not coming from gridview.which i highlted by red color,other data are coming.
Vincent Maverick Durano7y ago
I'm not sure what exactly you want to achieve, however, if you are trying to display the result in GridView based on date ranges then you can do something like this:
private string GetConnectionString(){
        //call the Connection string that was set up from the web.config file
        return System.Configuration.ConfigurationManager.ConnectionStrings["YourConnectionStringName"].ConnectionString;
}

private void BindGrid(string startDate, string endDate){

        DateTime dStartDate;
        DateTime dEndDate;
        DataTable dt = new DataTable();

        //Check if the string has the valid date format
        if (datetime.TryParse(startDate, out dStartDate) && datetime.TryParse(endDate, out dEndDate))
        {
            SqlConnection connection = new SqlConnection(GetConnectionString());
            try
            {
                connection.Open();
                string sqlStatement = "SELECT  FROM  WHERE DateColumnName > @DateFrom AND DateColumnName < @DateTo";
                SqlCommand sqlCmd = new SqlCommand(sqlStatement, connection);
                sqlCmd.Parameters.AddWithValue("@DateFrom", dStartDate);
                sqlCmd.Parameters.AddWithValue("@DateTo", dEndDate);
                SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
                sqlDa.Fill(dt);

                if (dt.Rows.Count > 0)
                {
                    GridView1.DataSource = dt;
                    GridView1.DataBind();
                }
                else
                {
                    //Show no Records found
                }
            }
            catch (System.Data.SqlClient.SqlException ex)
            {
                string msg = "Fetch Error:";
                msg += ex.Message;
                throw new Exception(msg);
            }
            finally
            {
                connection.Close();
            }
        }
}

protected void Button1_Click(object sender, EventArgs e)
{
    BindGrid(TextDateFrom.Text, TextDateTo.Text);
}