PLEASE HELP!!! VB Database Connection

Question

Hi I am Visual Basic beginner needing help desperately. I am using Microsoft Visual Studio.Net 2003. I have a basic Form with 3 Labels and 1 Button. I also have a Database with 3 Fields. I want the Text from Label1 Label2 and Label 3 to be stored in the database when Button 1 is clicked. Please can someone help me to do this with sample code including the database connection. Thanks ensuvari

Erhan Suvari · Answer

Thanks for your help. I have solved this problem.

Uday Parekh · Answer

hello are you using sql server? Or oracle ? Plz specify. Thanks

Erhan Suvari · Answer

Thanks a lot I'm using MS Access 2000 should that make a difference? Also I forgot to mention that as well as the 3 fields I also have an AutoNumber Primary Key Field. Should this populate automatically or will I need to include coding for it?

Dumisani July · Answer

Lets say u r using a SQL 2000 database righ ++++++++++ Dim cmdAdd As New SqlClient.SqlCommand Dim drAdd As SqlClient.SqlDataReader Dim strUsers as String Dim Con As New SQLConection +++++++++++ Con = New SqlConnection(workstation id=YOUR WORK STATION ID;packet size=4096;integrated security=SSPI;data source=YOUR WORK STATION ID;persist security info=False;initial catalog=Security) +++++++++++++++ Con.Close() Con.Open() cmdAdd.Connection = con cmdAdd.CommandText = Insert into YOUR TABLE NAME values( & Field Name 1 =  & Label 1 &  Field Name 2 =  & Label 2 &  Field Name 3 =  & Label 3 &  ) ++++++++++++++++ drAdd = cmdAdd.ExecuteReader Con.Close() +++++++++++++++++++ This should work like a breeze if u have any problems with this code let me know cheerz 4 now Dancin Fingerz PS>>>>>> Where I have the ++++++++ skip a line ....!