hashtable to pass to proc

[CsharpGuy]

I took over an web app (C#) were the developer put everything in a has table
then called a method to execute a stored procedure, now I'm running into some
issues were if I do an update and a NULL is passed that the field in the db
is left empty and NULL is not entered in. So how can I pass a NULL value in a
hashtable, execute the stored procedure and have NULL entered in the table
instead of a blank field?

here is an example of the code:
the call to the stored procedure and passing parameters:

private voide UpdateCars(stri ng Make, string Model, string Notes)
{
string sql = "spUpdateCa rs";
System.Collecti ons.HashTable params = new System.Collecti ons.HashTables( );
params.add("@ma ke", Make);
params.add("@mo del", Model);
params.add("@no tes", Notes);

this.executeSto redProcedureNon Query(strSQL, params)

}

now the executeStoredPr ocedureNonQuery method:
protected int executeStoredPo rcedureNonQuery (string sqlCommand ,
System.Collecti ons.Hashtable parameters)
{
int result = 0 ;

SqlConnection conn = getConnection() ;
try
{
SqlCommand cmd = new SqlCommand(sqlC ommand, conn) ;
cmd.CommandType = CommandType.Sto redProcedure ;
foreach (DictionaryEntr y parameterEntry in parameters)
{
cmd.Parameters. Add((string)par ameterEntry.Key , parameterEntry. Value) ;

}

cmd.Connection. Open() ;
result = cmd.ExecuteNonQ uery() ;
cmd.Connection. Close() ;
}
catch(SqlExcept ion e)
{
Console.Write(e .StackTrace) ;
}
finally
{
if (conn != null)
conn.Close() ;
}

return result ;
}

so how can i get it to enter NULL in the field and not leave it blank?

[Peter Rilling]

Maybe you could set the HT value to DbNull, or just have a conditional
statement when you build the SqlCommand where if the value is null, then
insert DbNull. Either way you are using DbNull.

"CsharpGuy" <Cs*******@disc ussions.microso ft.com> wrote in message
news:F0******** *************** ***********@mic rosoft.com...

I took over an web app (C#) were the developer put everything in a has
table
then called a method to execute a stored procedure, now I'm running into
some
issues were if I do an update and a NULL is passed that the field in the
db
is left empty and NULL is not entered in. So how can I pass a NULL value
in a
hashtable, execute the stored procedure and have NULL entered in the table
instead of a blank field?

here is an example of the code:
the call to the stored procedure and passing parameters:

private voide UpdateCars(stri ng Make, string Model, string Notes)
{
string sql = "spUpdateCa rs";
System.Collecti ons.HashTable params = new
System.Collecti ons.HashTables( );
params.add("@ma ke", Make);
params.add("@mo del", Model);
params.add("@no tes", Notes);

this.executeSto redProcedureNon Query(strSQL, params)

}

now the executeStoredPr ocedureNonQuery method:
protected int executeStoredPo rcedureNonQuery (string sqlCommand ,
System.Collecti ons.Hashtable parameters)
{
int result = 0 ;

SqlConnection conn = getConnection() ;
try
{
SqlCommand cmd = new SqlCommand(sqlC ommand, conn) ;
cmd.CommandType = CommandType.Sto redProcedure ;
foreach (DictionaryEntr y parameterEntry in parameters)
{
cmd.Parameters. Add((string)par ameterEntry.Key , parameterEntry. Value) ;

}

cmd.Connection. Open() ;
result = cmd.ExecuteNonQ uery() ;
cmd.Connection. Close() ;
}
catch(SqlExcept ion e)
{
Console.Write(e .StackTrace) ;
}
finally
{
if (conn != null)
conn.Close() ;
}

return result ;
}

so how can i get it to enter NULL in the field and not leave it blank?

[CsharpGuy]

I've tried that and still passing in blank and not NULL to the table.
I did something like;
if(parameterEnt ry.value == "")
{
parameterEntry. value = System.DBNull.v alue;
}

and it would not pass NULL to the table, i even checked on the web form
itself,
if (make.text == "")
{
make.text = System.DBNull.v alue;
}

and still nothing,

"Peter Rilling" wrote:

Maybe you could set the HT value to DbNull, or just have a conditional
statement when you build the SqlCommand where if the value is null, then
insert DbNull. Either way you are using DbNull.

"CsharpGuy" <Cs*******@disc ussions.microso ft.com> wrote in message
news:F0******** *************** ***********@mic rosoft.com...

I took over an web app (C#) were the developer put everything in a has
table
then called a method to execute a stored procedure, now I'm running into
some
issues were if I do an update and a NULL is passed that the field in the
db
is left empty and NULL is not entered in. So how can I pass a NULL value
in a
hashtable, execute the stored procedure and have NULL entered in the table
instead of a blank field?

here is an example of the code:
the call to the stored procedure and passing parameters:

private voide UpdateCars(stri ng Make, string Model, string Notes)
{
string sql = "spUpdateCa rs";
System.Collecti ons.HashTable params = new
System.Collecti ons.HashTables( );
params.add("@ma ke", Make);
params.add("@mo del", Model);
params.add("@no tes", Notes);

this.executeSto redProcedureNon Query(strSQL, params)

}

now the executeStoredPr ocedureNonQuery method:
protected int executeStoredPo rcedureNonQuery (string sqlCommand ,
System.Collecti ons.Hashtable parameters)
{
int result = 0 ;

SqlConnection conn = getConnection() ;
try
{
SqlCommand cmd = new SqlCommand(sqlC ommand, conn) ;
cmd.CommandType = CommandType.Sto redProcedure ;
foreach (DictionaryEntr y parameterEntry in parameters)
{
cmd.Parameters. Add((string)par ameterEntry.Key , parameterEntry. Value) ;

}

cmd.Connection. Open() ;
result = cmd.ExecuteNonQ uery() ;
cmd.Connection. Close() ;
}
catch(SqlExcept ion e)
{
Console.Write(e .StackTrace) ;
}
finally
{
if (conn != null)
conn.Close() ;
}

return result ;
}

so how can i get it to enter NULL in the field and not leave it blank?

[Peter Rilling]

Have you checked to see if it is a problem with the stored procedure? Maybe
the SP has the code to convert nulls into empty strings. Maybe that field
cannot handle nulls.

"CsharpGuy" <Cs*******@disc ussions.microso ft.com> wrote in message
news:CB******** *************** ***********@mic rosoft.com...

I've tried that and still passing in blank and not NULL to the table.
I did something like;
if(parameterEnt ry.value == "")
{
parameterEntry. value = System.DBNull.v alue;
}

and it would not pass NULL to the table, i even checked on the web form
itself,
if (make.text == "")
{
make.text = System.DBNull.v alue;
}

and still nothing,

"Peter Rilling" wrote:

Maybe you could set the HT value to DbNull, or just have a conditional
statement when you build the SqlCommand where if the value is null, then
insert DbNull. Either way you are using DbNull.

"CsharpGuy" <Cs*******@disc ussions.microso ft.com> wrote in message
news:F0******** *************** ***********@mic rosoft.com...

>I took over an web app (C#) were the developer put everything in a has
>table
> then called a method to execute a stored procedure, now I'm running
> into
> some
> issues were if I do an update and a NULL is passed that the field in
> the
> db
> is left empty and NULL is not entered in. So how can I pass a NULL
> value
> in a
> hashtable, execute the stored procedure and have NULL entered in the
> table
> instead of a blank field?
>
> here is an example of the code:
> the call to the stored procedure and passing parameters:
>
> private voide UpdateCars(stri ng Make, string Model, string Notes)
> {
> string sql = "spUpdateCa rs";
> System.Collecti ons.HashTable params = new
> System.Collecti ons.HashTables( );
> params.add("@ma ke", Make);
> params.add("@mo del", Model);
> params.add("@no tes", Notes);
>
> this.executeSto redProcedureNon Query(strSQL, params)
>
> }
>
> now the executeStoredPr ocedureNonQuery method:
> protected int executeStoredPo rcedureNonQuery (string sqlCommand ,
> System.Collecti ons.Hashtable parameters)
> {
> int result = 0 ;
>
> SqlConnection conn = getConnection() ;
> try
> {
> SqlCommand cmd = new SqlCommand(sqlC ommand, conn) ;
> cmd.CommandType = CommandType.Sto redProcedure ;
> foreach (DictionaryEntr y parameterEntry in parameters)
> {
> cmd.Parameters. Add((string)par ameterEntry.Key , parameterEntry. Value) ;
>
> }
>
> cmd.Connection. Open() ;
> result = cmd.ExecuteNonQ uery() ;
> cmd.Connection. Close() ;
> }
> catch(SqlExcept ion e)
> {
> Console.Write(e .StackTrace) ;
> }
> finally
> {
> if (conn != null)
> conn.Close() ;
> }
>
> return result ;
> }
>
> so how can i get it to enter NULL in the field and not leave it blank?
>
>
>

[CsharpGuy]

The field in the table allows NULLS.

The procs looks like this
create procedure spUpdateCars
{
@salesID int,
@make char(25) = NULL,
@model char(20) = NULL,
@notes varchar(250) = NULL
},
update Cars
set
CarMake = @make,
CarModel = @model,
SaleNotes = @notes
where sales ID = @salesID
is this how it should look to allow NULLS and insert NULL in the table or no?

"Peter Rilling" wrote:

Have you checked to see if it is a problem with the stored procedure? Maybe
the SP has the code to convert nulls into empty strings. Maybe that field
cannot handle nulls.

"CsharpGuy" <Cs*******@disc ussions.microso ft.com> wrote in message
news:CB******** *************** ***********@mic rosoft.com...

I've tried that and still passing in blank and not NULL to the table.
I did something like;
if(parameterEnt ry.value == "")
{
parameterEntry. value = System.DBNull.v alue;
}

and it would not pass NULL to the table, i even checked on the web form
itself,
if (make.text == "")
{
make.text = System.DBNull.v alue;
}

and still nothing,

"Peter Rilling" wrote:

Maybe you could set the HT value to DbNull, or just have a conditional
statement when you build the SqlCommand where if the value is null, then
insert DbNull. Either way you are using DbNull.

"CsharpGuy" <Cs*******@disc ussions.microso ft.com> wrote in message
news:F0******** *************** ***********@mic rosoft.com...
>I took over an web app (C#) were the developer put everything in a has
>table
> then called a method to execute a stored procedure, now I'm running
> into
> some
> issues were if I do an update and a NULL is passed that the field in
> the
> db
> is left empty and NULL is not entered in. So how can I pass a NULL
> value
> in a
> hashtable, execute the stored procedure and have NULL entered in the
> table
> instead of a blank field?
>
> here is an example of the code:
> the call to the stored procedure and passing parameters:
>
> private voide UpdateCars(stri ng Make, string Model, string Notes)
> {
> string sql = "spUpdateCa rs";
> System.Collecti ons.HashTable params = new
> System.Collecti ons.HashTables( );
> params.add("@ma ke", Make);
> params.add("@mo del", Model);
> params.add("@no tes", Notes);
>
> this.executeSto redProcedureNon Query(strSQL, params)
>
> }
>
> now the executeStoredPr ocedureNonQuery method:
> protected int executeStoredPo rcedureNonQuery (string sqlCommand ,
> System.Collecti ons.Hashtable parameters)
> {
> int result = 0 ;
>
> SqlConnection conn = getConnection() ;
> try
> {
> SqlCommand cmd = new SqlCommand(sqlC ommand, conn) ;
> cmd.CommandType = CommandType.Sto redProcedure ;
> foreach (DictionaryEntr y parameterEntry in parameters)
> {
> cmd.Parameters. Add((string)par ameterEntry.Key , parameterEntry. Value) ;
>
> }
>
> cmd.Connection. Open() ;
> result = cmd.ExecuteNonQ uery() ;
> cmd.Connection. Close() ;
> }
> catch(SqlExcept ion e)
> {
> Console.Write(e .StackTrace) ;
> }
> finally
> {
> if (conn != null)
> conn.Close() ;
> }
>
> return result ;
> }
>
> so how can i get it to enter NULL in the field and not leave it blank?
>
>
>