Problme using nullable parameters from vb.net

[John]

Hi

vb2005/sqlserver2005. I have a stored procedure that accepts three optional
parameters. If I run the following it returns the data fine;

DECLARE @return_value int
EXEC @return_value = [dbo].[NewSelectCommand]
@CompanyType = NULL,
@Status = NULL,
@BusinessDivision = NULL

If however I use the following in my vb.net app, I get nothing.

Me.CompaniesTableAdapter.Fill(Me.EMSDataSet.Compan ies,
DBNull.Value.ToString, DBNull.Value.ToString, DBNull.Value.ToString)

What is the problem and how can I fix it?

Thanks

Regards

[DanJurden]

Try using System.Data.SqlTypes.SqlString.Null for your parameter values. If
your parameters are not strings there are additional types in the SqlTypes
namespace for the different SQL data types.

--
Thanks
Dan Jurden
"John" wrote:

Hi

vb2005/sqlserver2005. I have a stored procedure that accepts three optional
parameters. If I run the following it returns the data fine;

DECLARE @return_value int
EXEC @return_value = [dbo].[NewSelectCommand]
@CompanyType = NULL,
@Status = NULL,
@BusinessDivision = NULL

If however I use the following in my vb.net app, I get nothing.

Me.CompaniesTableAdapter.Fill(Me.EMSDataSet.Compan ies,
DBNull.Value.ToString, DBNull.Value.ToString, DBNull.Value.ToString)

What is the problem and how can I fix it?

Thanks

Regards

[John Bell]

Hi

You have posted to a large number of groups which may not be appreciated if
they are not relivant. SQL 2005 questions should be posted to the SQL 2005
newsgroup see http://communities.microsoft.com/new...s/default.asp?

You may want to also check out:
http://support.microsoft.com/default...b;en-us;267588
http://support.microsoft.com/default...b;en-us;269541
http://support.microsoft.com/default...b;en-us;811889

John

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

Hi

vb2005/sqlserver2005. I have a stored procedure that accepts three
optional parameters. If I run the following it returns the data fine;

DECLARE @return_value int
EXEC @return_value = [dbo].[NewSelectCommand]
@CompanyType = NULL,
@Status = NULL,
@BusinessDivision = NULL

If however I use the following in my vb.net app, I get nothing.

Me.CompaniesTableAdapter.Fill(Me.EMSDataSet.Compan ies,
DBNull.Value.ToString, DBNull.Value.ToString, DBNull.Value.ToString)

What is the problem and how can I fix it?

Thanks

Regards

[Cor Ligthert [MVP]]

John,

I cannot find the method you are using so if you have documentation about
that please show us. In VB2003 is this in my opinion the most simple method
to use with parameters.

http://www.windowsformsdatagridhelp....6-7139b8970071

I hope this helps,

Cor

[Erland Sommarskog]

John (Jo**@nospam.infovis.co.uk) writes:

vb2005/sqlserver2005. I have a stored procedure that accepts three
optional parameters. If I run the following it returns the data fine;

DECLARE @return_value int
EXEC @return_value = [dbo].[NewSelectCommand]
@CompanyType = NULL,
@Status = NULL,
@BusinessDivision = NULL

If however I use the following in my vb.net app, I get nothing.

Me.CompaniesTableAdapter.Fill(Me.EMSDataSet.Compan ies,
DBNull.Value.ToString, DBNull.Value.ToString, DBNull.Value.ToString)

What is the problem and how can I fix it?

I don't really know what DBNull.Value.ToString() returns, but it is
not likely to be a NULL value. My guess goes for the string "NULL" which
is something completely different.

In any case, you desperately need to be more discriminate in your selection
of newsgroups, or else people will grew tired of you quickly.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp