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

Something like this ? .. ?

da.InsertCommand.Parameters.Clear

Terry Burns

http://TrainingOn.net





"simon" <(E-Mail Removed)> wrote in message
news:e$(E-Mail Removed)...
>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




"OHM ( Terry Burns )" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
> Something like this ? .. ?
>
> da.InsertCommand.Parameters.Clear
>
> Terry Burns
>
> http://TrainingOn.net
>
>
>
>
>
> "simon" <(E-Mail Removed)> wrote in message
> news:e$(E-Mail Removed)...
>>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
>>
>
>