Date get remove when i click row on gridview for editing

Question

when i edit row in gridview then date in cell get remove from gridview , Need soultion for this i want to keep date as same when i do edit event click?

Jignesh Kumar · Answer

Hi Akhter, Please one mre gridview event GridView1_PreRender Source : "GridView1" runat= "server" AutoGenerateColumns= "false" OnRowEditing= "GridView1_RowEditing" OnRowUpdating= "GridView1_RowUpdating" OnPreRender= "GridView1_PreRender" > CodeBehind: protected void GridView1_PreRender( object sender, EventArgs e) { if ( this .GridView1.EditIndex != -1) { TextBox txtDate = this .GridView1.Rows[ this .GridView1.EditIndex].FindControl( "txtDate" ) as TextBox; DateTime val = DateTime.ParseExact(txtDate.Text, "M/d/yyyy h:mm:ss tt" , CultureInfo.InvariantCulture); txtDate.TextMode = TextBoxMode.DateTimeLocal; txtDate.Text = val.ToString( "yyyy-MM-dd HH:mm:ss" ).Replace( ' ' , 'T' ); } }

Akhter HUssain · Answer

that issue resolve but when updating again this issue is coming String was not recognized as a valid DateTime. after using pre render

Akhter HUssain · Answer

Jignesh Kumar Thanks Alot ,You are genious ,very thanks

Jignesh Kumar · Answer

Hi Akhter, Please change bleow line it will work for you. "txtDate" runat= "server" Text= ' ' htmlEncode= false DataFormatString= "{0:dd-MMM-yyyy}" > And Code behind file you need to change if (! string .IsNullOrEmpty(date2)) { EntryDate = DateTime.ParseExact(date2, "M/d/yyyy h:mm:ss tt" , CultureInfo.InvariantCulture); }

Akhter HUssain · Answer

but i am using converstion in c# DateTime EntryDate; if (!string.IsNullOrEmpty(date2)) { EntryDate = DateTime.ParseExact(date2, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture); } else { EntryDate = System.DateTime.Today; } then raising exception

Suraj Kumar · Answer

If you will change TextMode="Date" then it will work as shown below "txtEntryDate" runat= "server" Text= ' ' TextMode= "Date" > EDIT If you will run your application in IE then DateTimeLocal will also work as it is not supported by chrome. Hope this will help you.

Akhter HUssain · Answer

HERE IS Html Code '> ' Width="140"> '> ' Width="140"> '> --%> --%> ' TextMode="DateTimeLocal"> ItemStyle-Width="150" /> Here C# Code protected void GridView3_RowEditing(object sender, GridViewEditEventArgs e) { GridView3.EditIndex = e.NewEditIndex; this.BindGrid(); } protected void GridView3_RowUpdating(object sender, GridViewUpdateEventArgs e) { System.Globalization.CultureInfo enUS = new System.Globalization.CultureInfo("en-US"); GridViewRow row = GridView3.Rows[e.RowIndex]; int customerId = Convert.ToInt32(GridView3.DataKeys[e.RowIndex].Values[0]); string name = (row.FindControl("txtName") as TextBox).Text; string Country = (row.FindControl("txtCountry") as TextBox).Text; string date2 = (row.FindControl("txtEntryDate") as TextBox).Text; DateTime EntryDate; if (!string.IsNullOrEmpty(date2)) { EntryDate = DateTime.ParseExact(date2, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture); } else { EntryDate = System.DateTime.Today; } string query = "UPDATE Country SET Name=@Name, Country=@Country, EntryDate=@EntryDate WHERE CustomerId=@CustomerId"; con = new SqlConnection("Data Source=DESKTOP-5PJ76B9;Integrated Security=SSPI;Initial Catalog=Institute"); { using (SqlCommand cmd = new SqlCommand(query)) { cmd.Parameters.AddWithValue("@CustomerId", customerId); cmd.Parameters.AddWithValue("@Name", name); cmd.Parameters.AddWithValue("@Country", Country); cmd.Parameters.AddWithValue("@EntryDate", EntryDate); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } GridView3.EditIndex = -1; this.BindGrid(); }

Suraj Kumar · Answer

Request you to upload your sample code so it will be easy to help and track the issue and will get resolved soon.

Date get remove when i click row on gridview for editing

Answers (8)