Sql parameter problem

[Lasse Edsvik]

Hello

I have this:

public SqlParameter GetParameter(string sqlparam)

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

param.Direction = ParameterDirection.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to 'System.Data.SqlClient.SqlParameter'

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******@develop.com> wrote in message
news:%2***************@tk2msftngp13.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.public.dotnet.languages.csharp/<uq**************@TK2MSFTNGP14.phx.gbl>
Hello

I have this:

public SqlParameter GetParameter(string sqlparam)

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

param.Direction = ParameterDirection.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to 'System.Data.SqlClient.SqlParameter'
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.public.dotnet.languages.csharp]

[Sijin Joseph]

public SqlParameter GetParameter(string sqlparam)
{
SqlParameter param = new SqlParameter();
param.ParameterName = sqlParam;
param.Direction = ParameterDirection.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(string sqlparam)

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

param.Direction = ParameterDirection.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to 'System.Data.SqlClient.SqlParameter'

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(SqlCommand cmd, string pname)
{
SqlParameter p = new SqlParameter();
p.ParameterName = pname;
p.Direction = ParameterDirection.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.public.dotnet.languages.csharp/<eq**************@TK2MSFTNGP09.phx.gbl>

Richard,

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

/Lasse
"Richard Blewett [DevelopMentor]" <ri******@develop.com> wrote in message
news:%2***************@tk2msftngp13.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.public.dotnet.languages.csharp/<uq**************@TK2MSFTNGP14.phx.gbl>
Hello

I have this:

public SqlParameter GetParameter(string sqlparam)

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

param.Direction = ParameterDirection.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to 'System.Data.SqlClient.SqlParameter'
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.public.dotnet.languages.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.public.dotnet.languages.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******@develop.com> wrote in message
news:%2******************@TK2MSFTNGP10.phx.gbl...

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

SqlParameter GetParameter(SqlCommand cmd, string pname)
{
SqlParameter p = new SqlParameter();
p.ParameterName = pname;
p.Direction = ParameterDirection.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.public.dotnet.languages.csharp/<eq**************@TK2MSFTNGP09.phx.gbl>
Richard,

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

/Lasse
"Richard Blewett [DevelopMentor]" <ri******@develop.com> wrote in message
news:%2***************@tk2msftngp13.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.public.dotnet.languages.csharp/<uq**************@TK2MSFTNGP14.phx.gbl>

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

'System.Data.SqlClient.SqlParameter'

>
>
>
> 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.public.dotnet.languages.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.public.dotnet.languages.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.public.dotnet.languages.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******@develop.com> wrote in message
news:%2******************@TK2MSFTNGP10.phx.gbl...

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

SqlParameter GetParameter(SqlCommand cmd, string pname)
{
SqlParameter p = new SqlParameter();
p.ParameterName = pname;
p.Direction = ParameterDirection.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.public.dotnet.languages.csharp/<eq**************@TK2MSFTNGP09.phx.gbl>
Richard,

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

/Lasse
"Richard Blewett [DevelopMentor]" <ri******@develop.com> wrote in message
news:%2***************@tk2msftngp13.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.public.dotnet.languages.csharp/<uq**************@TK2MSFTNGP14.phx.gbl>

Hello

I have this:

public SqlParameter GetParameter(string sqlparam)

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

param.Direction = ParameterDirection.Output;

return param;

}

and I get:

Cannot implicitly convert type 'int' to

'System.Data.SqlClient.SqlParameter'

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.public.dotnet.languages.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.public.dotnet.languages.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.public.dotnet.languages.csharp]