How to deactivate the old record using update query

See more:

C#5.0

Fromdate calendar1

choosefile Import(Button)

When i click the import button for selected date all the record will be displayed in the gridview.

In Gridview record as follows

Schdate      course     staff    session
11 Aug 14     BSC         VK       1
11 Aug 14     BE          VK       2
12 Aug 14     BTech       CMK      1
12 Aug 14     BSC(NS)     CMK      2
13 Aug 14     MFA          MJ      1
14 Aug 14     EFA          RJ      3
15 Aug 14     PST          VJ      2
16 Aug 14     EFA          MJ      4

In database records as follows (Table name Tb_sch_time_table)

Schdate      course     staff    session     Active
11 Aug 14     BSC         VK       1           A
11 Aug 14     BE          VK       2           A
12 Aug 14     BTech       CMK      1           A
12 Aug 14     BSC(NS)     CMK      2           A
13 Aug 14     MFA          MJ      1           A
14 Aug 14     EFA          RJ      3           A
15 Aug 14     PST          VJ      2           A
16 Aug 14     EFA          MJ      4           A

When user click the From date and click the import button, i want to check for selectd date record is there in the database.

if suppose for selected date record is there i want to show popup message "For selected date record is there do you want to import the new record in gridview"

if user gives yes means i want to change the Active 'D' from Active 'A' in table Tb_sch_time_table in the database for all the 11aug 14 to 16 aug 14 date.

And after that insert the new import excel data inserted to database.

for that how can i do in asp.net using c#.

Regards,
Narasiman P.