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.Clea r()
I hope you know what I mean.
Thank you,
Simon
"OHM ( Terry Burns )" <me@mine.com> wrote in message news:%2****************@TK2MSFTNGP14.phx.gbl...
Something like this ? .. ?
da.InsertCommand.Parameters.Clear
Terry Burns
http://TrainingOn.net
"simon" <si*********@stud-moderna.si> wrote in message
news:e$*************@TK2MSFTNGP09.phx.gbl...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.Clea r ?
Thank you,
Simon