How To Change The Value Of A Column In Sql Server 2005 Database When A Button Is Clicked In Asp.net 2.0?

hi all,

I have created a table in sql server 2005 as follows:

table name --> sampletest

1.id -->int ,identity,primary key

2. student_name --> varchar(50),not null

2. active --> bit, default value=1

Using vb.net 2005 , i entered names into sampletest. And when i check the table in the sql server 2005 the names are inserted and the active value is 1.

In another page i added a drop down list which bind all the student_name from sampletest and a delete button.

Now when i select a name and click the delete button that respective item's active column should be changed to 0. if any one who knows how to do this please help me..

thanks

swapna.

When i enter names into the student_name it's active state is "true".I do this programmatically using vb.net 2005.