Hi,
I know so many people have same question, Answer is depend upon which architecture you are using. Ex: if you are using 3-Tier architecture then your data flow would be differ then a single layer architecture.
For that reason i have written one article on CRUD operations.
Please have a look into :
Insert, Update, Search and Delete (CRUD operation) using ASP.Net and MySQL[
^] .In this article i have explain about N-Tier architecture. you will also learn some other related things along with only CRUD operations.
In above article we have used MySQL as database but the process will be same for any database. just you need to change SP and Connection related information.
Best of luck
Thanks
-Amit Gajjar