I am very new to .Net I want to the detail code for inserting a record using data adapter in asp.net using vb as a language. and the table will simple as DeptNo, DeptName and Location . When I click the add button the records will saved in database.


Well when u create the table adapter, it should automatically setup your insert query, so you should be able to just call the query and pass it what you need inserted, like:

MyTableAdapter.Insert(myDeptNo, MyDeptName, MyDeptLoc)