1. There are many articles on CP
http://www.codeproject.com/KB/database/#ADO.NET[
^], for example
Using ADO.NET for beginners[
^]
2.
Select * from StudentTable where ID = [insert the id you want to search here]
3. Update what? are you asking SQL question or data access? for sql
<br />
UPDATE StudnetTable<br />
set First_name = 'Joe'<br />
where ID = [insert the id you want to search here]<br />
If your question is about data access, you will find your answer in the tutorial.