Hello everyone,

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 .

...