Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error message for using a View in a Databinding with Oracle Client

Status
Not open for further replies.

atruhoo

Programmer
Jan 8, 2003
131
US
An unhandled exception of type 'System.ArgumentException' occurred in system.windows.forms.dll

Additional information: Cannot create a child list for field V_AGENT_ISSUER.

I am using this statement to databind a text box.

txtIssuerNameFnd.DataBindings.Add(New Binding("Text", AGORDataSet, "V_AGENT_ISSUER.VAI_ISSR_NM"))

The error looks like its thinking the V_AGENT_ISSUER is a field when it is a View in the Oracle DB. Any suggestions on how to do the data binding?
 
It appears that it did not like the underscores. When tried it using an alias it worked fine.

AGORAdapter.SelectCommand = New OracleCommand("SELECT VAI_FULL_NM FullName, VAI_FILE_NUM, " & _
"VAI_SSN_NM, VAI_BGN_DT, VAI_END_DT,VAI_RGSTR_STAT_CDE,VAI_ENRP_CDE,VAI_ISSR_NM IssuerName " & _
"FROM V_AGENT_ISSUER AGOR", OraConn)

Dim AGORDataSet As DataSet = New DataSet("AGORDataSet")

AGORAdapter.Fill(AGORDataSet, "AGOR")

dgAgentsFound.SetDataBinding(AGORDataSet, "AGOR")
txtIssuerNameFnd.DataBindings.Add(New Binding("Text", AGORDataSet, "AGOR.IssuerName"))
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top