set & get methods for Collections

[Sadun Sevingen]

i have SqlParameterCollection and i want to reach it by SET and GET
methods...

public SqlParameterCollection Parameter this[string Parameter]
{
get
{
return Command.Parameters[Parameter];
}
set
{
Command.Parameters[Parameter] = value;
}
}

which is not right... but i want to do ???

[Sridhar]

Hi,

You have to write like this:

public SqlParameterCollection this[string Parameter]
{
get
{
return Command.Parameters[Parameter];
}
set
{
Command.Parameters[Parameter] = value;
}
}

Sridhar!!

"Sadun Sevingen" wrote:

i have SqlParameterCollection and i want to reach it by SET and GET
methods...

public SqlParameterCollection Parameter this[string Parameter]
{
get
{
return Command.Parameters[Parameter];
}
set
{
Command.Parameters[Parameter] = value;
}
}

which is not right... but i want to do ???

[Sadun Sevingen]

but this give collection property to object... i want to access into an
collection in the object...

lets say... i have object A and it has C attribute as collection... i want
to declare get property G to access C

when i wrote

A.G[key]

also i could get A.C[key]

[Ken Kolda]

What type of object does the Command.Parameters[Parameter] call return -- a
SqlParameter, right? So, the indexer would look like:

public SqlParameter this[string Parameter]
{
get
{
return Command.Parameters[Parameter];
}
set
{
Command.Parameters[Parameter] = value;
}
}

Ken
"Sadun Sevingen" <b-saduns@ms> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

i have SqlParameterCollection and i want to reach it by SET and GET
methods...

public SqlParameterCollection Parameter this[string Parameter]
{
get
{
return Command.Parameters[Parameter];
}
set
{
Command.Parameters[Parameter] = value;
}
}

which is not right... but i want to do ???

[SP]

"Sadun Sevingen" <b-saduns@ms> wrote in message
news:O%****************@tk2msftngp13.phx.gbl...

but this give collection property to object... i want to access into an
collection in the object...

lets say... i have object A and it has C attribute as collection... i want
to declare get property G to access C

when i wrote

A.G[key]

also i could get A.C[key]

In your A class you need a property to get to your collection first.

public SqlParameterCollection Parameters
{
get
{
return this.pararmeters
}
set
{
this.parameters = value;
}
}

Then the collection class has the indexer

class Parameters
{
// indexer
public SqlParameter Parameter this[string Parameter]
{
get
{
return Command.Parameters[Parameter];
}
set
{
Command.Parameters[Parameter] = value;
}
}
}

SP