[bry090911]

whats the meaning of this?
i get this from PsychoCoder

This is the link topic

sample:

cmdDelete.Parameters.Clear()

??

This post has been edited by AdamSpeight2008: 01 March 2012 - 11:26 AM
Reason for edit:: Stop the shouty man

[nK0de]

.clear() method removes all the parameter objects from the collection.

[bry090911]

nK0de, on 01 March 2012 - 04:06 AM, said:

.clear() method removes all the parameter objects from the collection.

can you explain further?

[lordofduct]

http://msdn.microsof...parameters.aspx

SqlCommand.Paremeters is a collectoin of parameters, more specifically it's an IList. An IList is like an array, just with a more abstract interface. It describes a list of items... lists can be emptied. When you want to empty a list you call the 'Clear' function of the collection:

http://msdn.microsof...list.clear.aspx

So it sounds to me that they want to clear out all the parameters stored in the parameters collection of that sql command. Maybe to ensure that the parameters from any previous calls to the database aren't accidentally sent again.

[Psyguy]

If you don't remove them from the collection and you try to use them again, it will tell you that they already belong to a collection and you can't use the parameter again (for instance, if you want to add it to another command and use it again.

[bry090911]

hmmm so it's better to use this

.Parameters.Clear() ?

[Psyguy]

It's situational. If you need to reuse the parameters, then yes, otherwise, there is no need to clear them.

[shadachi]

If you use it in a loop and you want to reuse your parameters by assigning them with new values . It is best to Clear them first before assigning the new values in .

If not like Psyguy mentioned , you do not need to clear them , but just remember to dipose your SqlCommand when you are done with it . =)

[bry090911]

i am using add,edit,delete,update so what do you recommend?


hmmmmm... can you explain 1 by 1 this?

parameters - ???

and

clear - ???


own explanation please?

[bry090911]

anybody please.. answer my question.

[shadachi]

bry090911, on 02 March 2012 - 09:01 AM, said:

i am using add,edit,delete,update so what do you recommend?


hmmmmm... can you explain 1 by 1 this?

parameters - ???

and

clear - ???


own explanation please?

Hey bry090911 , sorry for the late reply.. erm.. what do you mean by using add , edit , delete and update?

All of the above can use SQL parameters .

Delete From table where colname = @varName ; 

well for clear() method , as already mentioned above , it only clears all the values assigned to the parameters and not the parameter it self .

[CharlieMay]

Quote

well for clear() method , as already mentioned above , it only clears all the values assigned to the parameters and not the parameter it self .

I don't think so... Parameters is a collection of parameter objects. Parameter objects are added to the collection. Parameters.Clear removes all parameter objects (the collection is emptied).

Just like a listbox holds a collection of Items (objects). If you then clear the listbox with Listbox.Items.Clear you empty the listbox not just the value being displayed in each item.

Quote

FROM MSDN - Removes all OleDbParameter objects from the OleDbParameterCollection.

[shadachi]

I see.. I might have been mistaken .

Yes it seems that it clears all the objects within the collection . So it seems.. thanks for the insight Charlie . =D