Home > DeveloperSection > Forums > automatic time display in grid view column
suresh g
suresh g

Total Post:3

Points:21
Posted on    December-28-2011 6:27 AM

 C# C# 
Ratings:


 3 Reply(s)
 1618  View(s)
Rate this:
in grid view one column name is date/time. when we will insert the record through grid view the date/time record will automatically store in the database.


John Smith

Total Post:101

Points:711
Posted on    December-28-2011 12:43 PM

I am unable to understand you question properly...please try to explain your question..
If you talking about  ( the date time should be inserted automatically in the database then for that you can use trigger in database)

http://mindstick.com/Articles/d9d0f625-6146-415b-b286-3319e3ec336f/?Trigger%20in%20SQL%20server

http://www.mindstick.com/Articles/f7074849-0e9e-463b-a12d-f3d7a35b2785/?Trigger%20in%20SQL%20Server

http://mindstick.com/Articles/8a50890e-16b5-4fc6-8970-54ae61a898f9/?Triggers%20in%20SQL%20Server

suresh g
suresh g

Total Post:3

Points:21
Posted on    December-28-2011 11:56 PM

Hi.... John Smith

I am working with windows grid view with in that i have five columns are there those names are(Select(check box), Slno, ID, Name, Date) with in that i have six buttons are there those are(ADD,DELETE,UPDATE,TODAY,MONTH, SHOW ALL)
when i will going to insert the record ID, Name fields are able to enter  Date, Slno are automatically enter with press tab key.
if i click on ADD records are inserted into data base(one are more records depends up on inserting). 
if i click on DELETE  only checked records will be deleted.
if i click on TODAY  button depending on date column only today records will be show in the grid view.
if i click on MONTH button ask one message enter month, then the month records will be display.
these are my requirement please help me. if possible give me your mail id i will send the sample grid view. my id: suri1319@gmail.com

Modified On Dec-29-2011 12:07:02 AM

Jenry Hock
Jenry Hock

Total Post:18

Points:126
Posted on    December-29-2011 12:47 AM

Hey Suresh,
You can use cell_endedit event of datagridview to add automatically value in datagridview. You can take a look of following code snippet to perform this task.

/// <summary>

/// You can use cell end edit event to perform automatic insertion of value.

/// </summary>

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)

{

    //Suppose that column index is 3 where you want to insert datetime

    //value automatically.

    if (e.RowIndex > -1 && e.ColumnIndex == 3)

    {//This condition will insure correct cell is clicked.

 

                //dataGridView1[3, e.RowIndex] will represent modified cell.

                dataGridView1[3, e.RowIndex].Value = DateTime.Now;

    }

}

Thanks.

Modified On Dec-29-2011 12:48:23 AM

Don't want to miss updates? Please click the below button!

Follow MindStick