-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: ravipillala
Message 1 in Discussion
Dear Group Members, I'm using a Sql with joining to fill the Dataset
like.............. Dim csConnectionString As String = "Data Source=viraj;User
ID=scott;Password=tiger"
Dim loConn As New OracleConnection(csConnectionString)
loConn.Open()
Dim lsSql As String = "SELECT a.empno,a.ename,b.dname FROM emp a,dept b WHERE
empno=7934 AND a.DEPTNO=b.DEPTNO"
Dim loDataAdapter As OracleDataAdapter = New OracleDataAdapter(lsSql, loConn)
loDataAdapter.Fill(loDataSet, "EMPDEPT") ---------------------
i'm assigning that dataset to the grid and after changing the grid values ,
sending the same dataset to the server to update the changed records by using
DataAdapter. here the server side code function code ......... Dim loConn As New
OracleConnection(csConnectionString)
loConn.Open()
Dim loCB As OracleCommandBuilder
Dim lsSql as String="SELECT a.empno,a.ename,b.dname FROM emp a,dept b WHERE empno=7934
AND a.DEPTNO=b.DEPTNO"
Dim loDataAdapter As OracleDataAdapter = New OracleDataAdapter(lsSql, loConn)
loCB = New OracleCommandBuilder(loDataAdapter)
Try
loDataAdapter.Update(loDataSet, "EMPDEPT")
Catch ex As Exception
Debug.Write(ex.Message)
MsgBox(ex.Message)
End Try
i am getting the bellow error , "Dynamic SQL generation is not supported against
multiple base tables". please help me how to update tables when i use the joining.
Thanks in advance
Ravi Shankar P
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
