Posted on: 4/14/2014 1:07:11 PM | Views : 373

May i know how to access GETDATE() value using insert query in C# (db connection), For Singe Cell in a row..
Every time i login into the page..Instead update, i use insert query to display time in gridview column .. If i use update query i cant get list of search values filtered using date
I have four columns(one primary too) in that i want to change only fourth cell Getdate(). value using insert query its challenging i tried more cant get result
primarycol. col1 col2 col3 Date(col4) 12345 aaa 4000.00 a121 2014-04-14 17:08:16.437 67890 bbb 3500.00 @121 2014-04-14 17:08:22.873 112233 ccc 2000.00 12345 2014-04-14 17:07:23.700 445566 ddd 6000.00 6789 2014-04-14 15:25:29.857 SqlCommand cmd = new SqlCommand(("Insert into tablename (Date) values('" + DateTime.N ...

Go to the complete details ...