From my windows form, I configured a Data Adapter and generated a dataset to
load data from a SQL database table. Then I used a code to fill the dataset.
The code returns the error message: "An unhandled exception of type
'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error."

The code I used is the following. What am i doing wrong?

Dim IntakeBindingManager As BindingManagerBase
        SqlDataAdapter1.Fill(DS_SSCIntake1)
        IntakeBindingManager = Me.BindingContext(DS_SSCIntake1, "qmf_cint")

Thanks

TS

Can you try this,

dim IntakeBindingManager As CurrencyManager

IntakeBindingManager = DirectCast(BindingContext(DS_SSCIntake1, "qmf_cint"),
CurrencyManager)

You cannot use (normally) base classes directly.

I hope this helps,

Cor

Thanks for your reply. I'm still getting the same error message. I used the
syntax you sent me:
        Dim IntakeBindingManager As CurrencyManager
        SqlDataAdapter1.Fill(DS_SSCIntake1)
IntakeBindingManager = DirectCast(BindingContext(DS_SSCIntake1, "qmf_cint"),
CurrencyManager).

Please advise.


Show quoteHide quote

FindWindow API
VB to C#
the project location is not fully trusted by .net runtime
OT : Are you guys in the US on a Public Holiday today ?
Got to be an easier way...
using SB_GETTEXT
Pass an array to javascript
CurrencyManager Question
My Threading Timer Doesn't Fire
Unshare an Excel sheet with VB.Net