Started ...with database

[alnahash]

I am learning vb.net alon.. and the only source I have is the internet .. I made an excersise and its very easy for experts like you,, but its very important for me because I will learn alot from it.. Simply,, the exercise is saving the first and last name of students and an automatic ID ..

I created the DB and form design .. its as follow:

Database name "customers.mdf" Table name "customersTable"
Fields data types:
customer ID int PK identity Specification = yes
firstname nvarchar 50
last name nvarchar 50

Dataset name: costomer dataset.xsd

text boxes: firstnametxt, lastnametxt, customeridtxt, savebtn ,deletebtn, updatebtn, savebtn and form1

I want to let the software contact with databse so it can read from it ,, also I want to delete ,add, update and save records...

I dont want to use the binding navigator because i want to learn how to do it... please help me

 

[Arg81]

I want to let the software contact with databse so it can read from it ,, also I want to delete ,add, update and save records...

Use the wizard in VS to create a new DataSource. Connect this to your DB and select the tables you want to put into the DataSet.

I dont want to use the binding navigator because i want to learn how to do it... please help me

A binding navigator is just a navigation tool to browse through your records. The built in one adds buttons to be able to add, save, delete to the "toolbar" - but you can see the code for these anyway.
With a BN, you just set the dataSource to a BindingSource (which in turn is configured to a dataTable).

Using the wizards and the GUI will make you learn more than trying to code everything yourself. Microsoft didn't invest millions of dollars into this kind of development if it was deemed to be useless...


EDIT: by the way, is this actually an ASP.net question??

 

[JohnH]

I am learning vb.net alon.. and the only source I have is the internet ..

While internet is great on learning resources don't underestimate the value of a book to teach you the basics of programming and VB.Net in a well structured fashion. Much difficulties may be avoided later and going into intermediate topics will take a lot less time with the proper foundation. There exist many alternatives to get hold of a beginner book, including an ebook version from the internet if you're lucky.

 

[alnahash]

Thank you Arg81 and JohnH ,

But everybody has his own way of learning, and really I like to learn this way ,, doing everything by my own hands,,, this will let me understand vb.net more and more...

still waiting your help...