Edit Date within a Datagrid

israfel_e

I'm trying to edit records through a dynamically populated datagrid. The problem arises when i try to update a Date value in one of the cells. Does anyone know any good links, or is willing to explain how to deal with DateTime within a datagrid. For my Id field this works fine TableCell cell1 = (TableCell)e.Item.Controls[0]; string id = ((TextBox)cell1.Controls[0]).Text; My dateTime cells are on Controls[1], but every variation on the theme of the above ive tried to read the value ive changed, just deosnt work. Has anyone come up against this problem before and know how to get around it. I've tried variations along the lines of TableCell cell2 = (TableCell)e.Item.Controls[1]; DateTime myDate = ((TextBox)cell2.Controls[1]).Text.toString(); I just keep on hitting a wall. I can't update the records in the database unless i can do this. ANy help or advice appreciated.

7 Replies

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

israfel_e21y ago
Yasser, Thanks for your help. I got totally sick of one line of code holding me up, so i changed it from a datagrid to a separate interface that you choose your edit date through a drop down list and change it to a value from a calendar. Not quite as neat but it works at least. Perhaps when i get better i'll figure out where the hell i went wrong. I used editable datagrids elsewhere though and it just seemed to be the datetime it disliked. Cheers anyhow
yasser_822721y ago
Hi, If I would be at your place, I would have retrieved values this way: // ID string id = ((TextBox)e.Item.Controls[0]).Text; Label1.Text = "Id = " + id; // Date DateTime myDate = DateTime.Parse(((TextBox)e.Item.Controls[1]).Text); Now in this case, it should surely return me the Date value at index 1, if it is present. Even if you are getting an error: "String is not recognized as valid date time value", then I'll recommend check the value returned by index 1, there may be some thing wrong with the value. However to convert a string value to a valid DateTime value, you use either DateTime.Parse(string s) or Convert.ToDateTime(string s). For more info check this out: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatetimeclassparsetopic.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemconvertclasstodatetimetopic.asp Cheers, Yasser
israfel_e21y ago
It gave me "String was not recognized as a valid DateTime.". I thought control[0] would be the id field and controls[1] would then be the datetime field however the argument when i change the exact same code to control[1] as opposed to your suggestion gives me "Specified argument was out of the range of valid values. Parameter name: index". Extremely frustrating, cheers for replying though
yasser_822721y ago
Change your index from 1 to 0 i.e.: DateTime myDate = DateTime.Parse(((TextBox)cell2.Controls[0]).Text);
israfel_e21y ago
Hi guys, Thanks for the replys, Damn thing still won't work for me. I'm sure I'm doing something very wrong. Would you mind taking a peak at the code i have under Update Datagrid and see if you can spot it please. It's compiling fine but I'm getting "Specified argument was out of the range of valid values. Parameter name: index" On the DateTime parse line. Cheers private void Update_DataGrid(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { // ID TableCell cell1 = (TableCell)e.Item.Controls[0]; string id = ((TextBox)cell1.Controls[0]).Text; Label1.Text = "Id = " + id; // Date TableCell cell2 = (TableCell)e.Item.Controls[1]; DateTime myDate = DateTime.Parse(((TextBox)cell2.Controls[1]).Text); //DateTime myDate = Convert.ToDateTime(((TextBox)cell2.Controls[1]).Text); //DateTime cDate = ((TextBox)cell2.Controls[1]).ToString(); //TextBox cDate = (TextBox) e.Item.Cells[2].Controls[1]; String strCmd = "update openday set dt = " + myDate + " where Id = " + id; SqlCommand myCommand = new SqlCommand(strCmd ,sqlConnection1); sqlConnection1.Open(); myCommand.ExecuteNonQuery(); sqlConnection1.Close(); DG_Openday.EditItemIndex = -1; BindData(); } This is the Datagrid html. Thought i'd add it just in case.
pavithran21y ago
Hi i think even u can use Convert.ToDateTime(string). DateTime myDate = Convert.ToDateTime(((TextBox)cell2.Controls[1]).Text); pavithran
yasser_822721y ago
You'll need to parse string value to DateTime. Here's how: DateTime myDate = DateTime.Parse(((TextBox)cell2.Controls[1]).Text);