I am trying to update a query.....But there is a problem at ExecuteNon Query
stmt
I have used a Access Database using OLEDB .
can anyone suggest me the syntax of update query.
My code is......
Dim dbcom, dbcon, dbread
dbcon = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" &
Server.MapPath("emp.mdb"))
Dim strSql As String
strSql = "Update Employ set Ename='" & name & "' , Edes='" & des & "' , Esal='"
& sal & "' where Eno=" & no
//name,no,name,sal,des are all text flieds.
dbcom = New OleDbCommand(strSql, dbcon)
dbcon.Open()
dbcom.ExecuteNonQuery()
dbcon.Close()
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
