Sql parameter problem

[Lasse Edsvik]

Hello

I have this:

public SqlParameter GetParameter(st ring sqlparam)

{
SqlParameter param = cmd.Parameters. Add(sqlparam);

param.Direction = ParameterDirect ion.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to 'System.Data.Sq lClient.SqlPara meter'

problem is that I dont "want" to be needed to specify datatype of the
parameter, if I check "6 of 6" in that yellow hint-box, as I get it, I'm
able to just pass the parameter-name.

or what's needed to do?

TIA
/Lasse

[Lasse Edsvik]

Richard,

I cant pass the value since that's what im trying to retrieve.

/Lasse
"Richard Blewett [DevelopMentor]" <ri******@devel op.com> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. .

The problem is you are calling the following overload of Add

int Add( object o );

and you are trying to assign it to a SqlParameter reference - hence the error message.
if you can supply the value as well you can call this overload

SqlParameter Add(string name, object value);

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft. com/microsoft.publi c.dotnet.langua ges.csharp/<uq************ **@TK2MSFTNGP14 .phx.gbl>
Hello

I have this:

public SqlParameter GetParameter(st ring sqlparam)

{
SqlParameter param = cmd.Parameters. Add(sqlparam);

param.Direction = ParameterDirect ion.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to 'System.Data.Sq lClient.SqlPara meter'
problem is that I dont "want" to be needed to specify datatype of the
parameter, if I check "6 of 6" in that yellow hint-box, as I get it, I'm
able to just pass the parameter-name.

or what's needed to do?

TIA
/Lasse


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.768 / Virus Database: 515 - Release Date: 22/09/2004

[microsoft.publi c.dotnet.langua ges.csharp]

[Sijin Joseph]

public SqlParameter GetParameter(st ring sqlparam)
{
SqlParameter param = new SqlParameter();
param.Parameter Name = sqlParam;
param.Direction = ParameterDirect ion.Output;
cmd.Parameters. Add(param);
return param;
}

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph
Lasse Edsvik wrote:

Hello

I have this:

public SqlParameter GetParameter(st ring sqlparam)

{
SqlParameter param = cmd.Parameters. Add(sqlparam);

param.Direction = ParameterDirect ion.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to 'System.Data.Sq lClient.SqlPara meter'

problem is that I dont "want" to be needed to specify datatype of the
parameter, if I check "6 of 6" in that yellow hint-box, as I get it, I'm
able to just pass the parameter-name.

or what's needed to do?

TIA
/Lasse

[Richard Blewett [DevelopMentor]]

OK in that case you'll need to change your code as follows:

SqlParameter GetParameter(Sq lCommand cmd, string pname)
{
SqlParameter p = new SqlParameter();
p.ParameterName = pname;
p.Direction = ParameterDirect ion.Output;
cmd.Parameters. Add(p);
return p;
}

btw: when are you doing to set the param type for the out param?

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft. com/microsoft.publi c.dotnet.langua ges.csharp/<eq************ **@TK2MSFTNGP09 .phx.gbl>

Richard,

I cant pass the value since that's what im trying to retrieve.

/Lasse
"Richard Blewett [DevelopMentor]" <ri******@devel op.com> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. .

The problem is you are calling the following overload of Add

int Add( object o );

and you are trying to assign it to a SqlParameter reference - hence the error message.
if you can supply the value as well you can call this overload

SqlParameter Add(string name, object value);

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft. com/microsoft.publi c.dotnet.langua ges.csharp/<uq************ **@TK2MSFTNGP14 .phx.gbl>
Hello

I have this:

public SqlParameter GetParameter(st ring sqlparam)

{
SqlParameter param = cmd.Parameters. Add(sqlparam);

param.Direction = ParameterDirect ion.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to 'System.Data.Sq lClient.SqlPara meter'
problem is that I dont "want" to be needed to specify datatype of the
parameter, if I check "6 of 6" in that yellow hint-box, as I get it, I'm
able to just pass the parameter-name.

or what's needed to do?

TIA
/Lasse


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.768 / Virus Database: 515 - Release Date: 22/09/2004

[microsoft.publi c.dotnet.langua ges.csharp]

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.769 / Virus Database: 516 - Release Date: 24/09/2004

[microsoft.publi c.dotnet.langua ges.csharp]

[Lasse Edsvik]

Richard,

hmm, not sure, what happens if i dont?

btw, do i "need" to pass the "SqlCommand cmd"?

thx
/Lasse
"Richard Blewett [DevelopMentor]" <ri******@devel op.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

OK in that case you'll need to change your code as follows:

SqlParameter GetParameter(Sq lCommand cmd, string pname)
{
SqlParameter p = new SqlParameter();
p.ParameterName = pname;
p.Direction = ParameterDirect ion.Output;
cmd.Parameters. Add(p);
return p;
}

btw: when are you doing to set the param type for the out param?

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft. com/microsoft.publi c.dotnet.langua ges.csharp/<eq************ **@TK2MSFTNGP09 .phx.gbl>
Richard,

I cant pass the value since that's what im trying to retrieve.

/Lasse
"Richard Blewett [DevelopMentor]" <ri******@devel op.com> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. .

> The problem is you are calling the following overload of Add
>
> int Add( object o );
>
> and you are trying to assign it to a SqlParameter reference - hence the

error message.

>
> if you can supply the value as well you can call this overload
>
> SqlParameter Add(string name, object value);
>
> Regards
>
> Richard Blewett - DevelopMentor
> http://staff.develop.com/richardb/weblog
>
>

nntp://news.microsoft. com/microsoft.publi c.dotnet.langua ges.csharp/<uq************ **@TK2MSFTNGP14 .phx.gbl>

>
> Hello
>
> I have this:
>
> public SqlParameter GetParameter(st ring sqlparam)
>
> {
>
>
> SqlParameter param = cmd.Parameters. Add(sqlparam);
>
> param.Direction = ParameterDirect ion.Output;
>
> return param;
>
> }
>
>
>
> and I get:
>
> Cannot implicitly convert type 'int' to

'System.Data.Sq lClient.SqlPara meter'

>
>
>
> problem is that I dont "want" to be needed to specify datatype of the
> parameter, if I check "6 of 6" in that yellow hint-box, as I get it, I'm > able to just pass the parameter-name.
>
> or what's needed to do?
>
> TIA
> /Lasse
>
>
>
>
>
>
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.768 / Virus Database: 515 - Release Date: 22/09/2004
>
>
>
> [microsoft.publi c.dotnet.langua ges.csharp]

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.769 / Virus Database: 516 - Release Date: 24/09/2004

[microsoft.publi c.dotnet.langua ges.csharp]

[Richard Blewett [DevelopMentor]]

SqlParameter defaults its SqlDbType to NVarChar. So unless you are only going to return NVarChar types and you preset the size, this isn't going to work.

Also, if you don't pass the SqlCommand in how are you going to call cmd.Parameters. Add, do you have it as a member variable?

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft. com/microsoft.publi c.dotnet.langua ges.csharp/<#Y************ **@TK2MSFTNGP10 .phx.gbl>

Richard,

hmm, not sure, what happens if i dont?

btw, do i "need" to pass the "SqlCommand cmd"?

thx
/Lasse
"Richard Blewett [DevelopMentor]" <ri******@devel op.com> wrote in message
news:%2******** **********@TK2M SFTNGP10.phx.gb l...

OK in that case you'll need to change your code as follows:

SqlParameter GetParameter(Sq lCommand cmd, string pname)
{
SqlParameter p = new SqlParameter();
p.ParameterName = pname;
p.Direction = ParameterDirect ion.Output;
cmd.Parameters. Add(p);
return p;
}

btw: when are you doing to set the param type for the out param?

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft. com/microsoft.publi c.dotnet.langua ges.csharp/<eq************ **@TK2MSFTNGP09 .phx.gbl>
Richard,

I cant pass the value since that's what im trying to retrieve.

/Lasse
"Richard Blewett [DevelopMentor]" <ri******@devel op.com> wrote in message
news:%2******** *******@tk2msft ngp13.phx.gbl.. .

The problem is you are calling the following overload of Add

int Add( object o );

and you are trying to assign it to a SqlParameter reference - hence the

error message.

if you can supply the value as well you can call this overload

SqlParameter Add(string name, object value);

Regards

Richard Blewett - DevelopMentor
http://staff.develop.com/richardb/weblog

nntp://news.microsoft. com/microsoft.publi c.dotnet.langua ges.csharp/<uq************ **@TK2MSFTNGP14 .phx.gbl>

Hello

I have this:

public SqlParameter GetParameter(st ring sqlparam)

{
SqlParameter param = cmd.Parameters. Add(sqlparam);

param.Direction = ParameterDirect ion.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to

'System.Data.Sq lClient.SqlPara meter'

problem is that I dont "want" to be needed to specify datatype of the
parameter, if I check "6 of 6" in that yellow hint-box, as I get it, I'm able to just pass the parameter-name.

or what's needed to do?

TIA
/Lasse


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.768 / Virus Database: 515 - Release Date: 22/09/2004

[microsoft.publi c.dotnet.langua ges.csharp]

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.769 / Virus Database: 516 - Release Date: 24/09/2004

[microsoft.publi c.dotnet.langua ges.csharp]

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.769 / Virus Database: 516 - Release Date: 24/09/2004

[microsoft.publi c.dotnet.langua ges.csharp]