Date get remove when i click row on gridview for editing

Akhter HUssain

8y1.6k.NET

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?

8 Replies

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

Jignesh Kumar8y ago
Accepted 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');
}
}
0
Akhter HUssain8y ago
that issue resolve but when updating again this issue is coming String was not recognized as a valid DateTime. after using pre render
0
Akhter HUssain8y ago
Jignesh Kumar

Thanks Alot ,You are genious ,very thanks
0
Jignesh Kumar8y ago
Hi Akhter,
Please change bleow line it will work for you.

"txtDate" runat="server" Text='<%# Bind("EntryDate") %>' 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);
}
0
Akhter HUssain8y ago
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
0
Suraj Kumar8y ago
If you will change TextMode="Date" then it will work as shown below
"txtEntryDate" runat="server" Text='<%# Bind("EntryDate", "{0:yyyy-MM-dd}") %>' 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.
0
Akhter HUssain8y ago
HERE IS Html Code

<%-- <%# Convert.ToDateTime(Eval("BirthDate")).ToString("dd/MM/yyyy") %>--%>

<%----%>

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

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