data Adapter

  • Thread starter Thread starter simon
  • Start date Start date
S

simon

I use my functions to create adapter and fill dataSet:

funkcije.createAdapter("c_CPOSkupaj", False, myParams).Fill(ds,
"brezReklam")

If I use this function another time to fill dataSet with other table, I get
an error message, like that the parameter already exists.
The SqlParameter with ParameterName '@datumZ' is already contained by
another SqlParameterCollection

So, I would like to clear parameters:

adapter.SelectCommand.Parameters.Clear()

How can I do that?

I don't have reference to data adapter, because it's created by function.

Does exists something like:

currentActiveAdapter.SelectCommand.Parameters.Clear ?

Thank you,
Simon
 
Hi,

I know that I can use da.InsertCommand.Parameters.Clear.

But I use function for insert table into data set because I don't want to reference and create each time data adapter.

Instead of this:

Dim da As SqlDataAdapter
da = createAdapter(sqlStr, False, myParams)
da.Fill(myDataSet, tableName)
da.SelectCommand.Parameters.Clear()
da.Dispose()
da = Nothing

I do everything in one line:

funkcije.createAdapter(sqlStr, False, myParams).Fill(ds,"tableName")

Function createAdapter returns adapter, but after creating adapter and use fill method I can't clear the parameters because I don't have reference to it.

I need something like: currentActiveAdapter.SelectCommand.Parameters.Clear()

I hope you know what I mean.

Thank you,
Simon
 
Back
Top