Beginner in Database programming

[nile1483]

Friends

i am BEAGNER IN vb.net i have a good skill in designing in window form, plz tell me simple solution for databse

i careate 3 databes filed in sql and vb.net forum designer
sr. no.
name
and
city

i create a table and connect sql server to databse and i also successfully entered data through vb in sql but i want to learn how we do data access by move firs, move last, move next and move previous and also i want to give auto increament field to Sr.no.

 

[Arg81]

i want to give auto increament field to Sr.no.

Set the "identity" of the column (Sr. no) to "Yes - Not for replication"

You will then see;
Identity Seed
Identity Increment

Seed = the value your FIRST record will take. Leave it at 1 and your first row will have Sr. No of 1. Set it to 10 and your first row will have Sr. No of 10...
Increment = the next row value. Leave at 1 and each row will increment by 1, e.g. row 1 = 1, row 2 = 2, row 3 = 3 etc.
Set it to 10 for example, and row 1 = 1, row 2 = 11, row 3 = 21....

Use the DataSet Wizard in VS2005 to create your dataTables, tableAdapters and DataSet(s). By dragging a table from your "data sources" pane to your form, it will automatically create the code you need for navigation through the results.