	AllExperts > Experts
	Search

About Syed Rizwan Muhammad Rizvi
Expertise
I can answers questions regarding web based and desktop based programming in VB.Net. Which can include SOAP, XML, Custom Controls, COM Interoperability etc.

Experience
Have been working in this specific area for last 2 years previously I was a VB 6 Developer with experties in other languages as well. Total 10 years of programming experience.

You are here: Experts > Computing/Technology > Basic > VB.NET > connecting to an oracle DB(SQL)

Topic: VB.NET

Expert: Syed Rizwan Muhammad Rizvi
Date: 1/27/2008
Subject: connecting to an oracle DB(SQL)

Question
I am building a program that connects to an oracle DB and I am havimg trouble with EXACT and PERSICE SYNTAX ERRORS...
Is this the corect sytax for an UPDATE, SEARCH, DELETE Buttons?

Dim UPDATE As String

UPDATE = "UPDATE Employee SET ID=" & _

"'" & txtID.Text & "' , " & _

"EmpName = '" & txtName.Text & "' , " & _

"EmpDepName = '" & txtDep.Text & "' , " & _

"EmpTitle = '" & txtTitle.Text & "' , " & _

"EmpManager = '" & txtManager.Text & "' , " & _

"EmpTel = '" & txtTel.Text & "' , " & _

"EmpMobile = '" & txtMob.Text & "' , " & _

"EmpEmail='" & txtEmail.Text & "' , " & _

"EmpPOBox='" & txtPOBox.Text & "'"

************************************************************************************************************

Dim Delete As String

Delete = " Delete from Employee Where empID = 'txtID'"

************************************************************************************************************

Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click

Dim myDA = New OleDb.OleDbDataAdapter()

Dim myConnection As OleDbConnection

Dim myCommand As OleDbCommand

myConnection = New OleDbConnection("Provider=MSDAORA.1;User_ ID=ayesha;password=ayesha;database=test.world")

myConnection.Open()

myCommand = New OleDbCommand("SELECT (*) FROM Employees Where txtID = '""' ", myConnection)

Answer
Dear Reema/Ayesha (just a guess on this one),

you need to paste exact errors that you are getting.

I certainly do see your delete code as wrong also the select code doesnt need you to put * in ().

Also you need to tell me what exactly you are trying to achieve on the search button.

Regards,
Riz

Add to this Answer Ask a Question

About Us | Advertise on This Site | User Agreement | Privacy Policy | Help
Copyright © 2008 About, Inc. About and About.com are registered trademarks of About, Inc. The About logo is a trademark of About, Inc. All rights reserved.