Insert a value into a field in my database onclick of a button

[undeclared]

I have a table tblEmployee with a boolean "Active" field. I'd like to insert a value of 0 into this field when i click my btnTerminateEmployee.
How do i make this happen?

 

[ca8msm]

You'll have to write an Inert query in your database (ideally put it in a Stored Procedure) and then execute the Stored Procedure using the relevant SQL provider (i.e. if it's SQL Server, use the System.Data.SQLClient.SqlCommand class).


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244 on how to get better results.