Thursday, October 16, 2008

Update the datas in Oledb Provider

Trying to update an Access DB using Oledbconnection.

Getting a syntax error (missing operator) in the SQL statement below, cannot see what it is can anyone help?

DBCommand = New OleDbCommand("SELECT * FROM Customer Where CustID = " &_ LBL_CustID.Text & " UPDATE Customer SET CustName = " & TXT_CustName.Text & " ", ManufacturingConn)

Is there a better way to do it?

1 comment:

Magesh Kumar.M said...

hi this information is very.. i got some idea about the connections.. thk u