Pass Date from Gridview to textbox

Question

I want to pass date from gridview to textbox by selection row from gridview. Intime and Out Time are not coming other field data is coming from gridview

Vincent Maverick Durano · Answer

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 ; 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); }

Akhter HUssain · Answer

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.

Pass Date from Gridview to textbox

Answers (2)