Can someone please show me a code syntax on how to update an SQL database programmatically ( execute on click of button).
I want to get all records from the "Student" database table where StudentStatus = 'New'' .Find a particular RegDate (2001/02/02) , StudNo ( 200144176) and update it's StudentStatus to "Öld", by clicking a command button ( UpdateDatabase). I'm using SQL2000( Windows Authentication).
and please show me how to connect or retreive that information from the database .
Hope I make sense.