Start Datagridview validating edit

Datagridview validating edit

Hi Rahim, First of all thanks for such a code,because i researched the entire google but found no single code for this ins,upd & del.

I have a Data Grid View with a Date (Date Time) Column. When a user edit the cell and change the date I woulk like to allow him to write "081501" and programmatically transform the entered date to "2008/15/01"( using a custom method *called Transform Date(string ARaw Date)) But I can't find any Data Grid View event to call the Transform Date method and replace the user input by the computed value. Does anybody if this kind of transformation *is possible in a Data Grid View and Where is the best place to put the call to the transformation method ? In the following example, the data is stored as 75000 but the user wants the data displayed as "75k" instead.

I have a Data Grid View with a Date (Date Time) Column. Check out the Format and Parse events on the cells.

private void add Upadate Button_Click(object sender, Event Args e) Now, whatever you do with the datagridview like insert or update on the form this will update or insert in to database accordingly. App Settings[“connection String”]; sql Connection = new Sql Connection(connection String); select Query String = “SELECT * FROM Users”; sql Connection.