Empty String to NULL

[MarcusO]

Hello,

I am using SQL Server 2000 as database. When a user updates a record, let's say phone no, and just erases the value already stored, then VB.Net tries to store it as a zero-string. This doesn't work that well and SQL Server throws an error. Do I really have to check every value with if/then/else first to see if it is zero-string and if so convert it it NULL before running the update query?

Thanks,
Marcus

 

[bboffin]

In a word, yes. How else is ADO.NET to know what you mean?

You can also do it in the stored procedure if you're using one.

If you're using a strongly typed dataset there is a method of the dataset that will set the the column to null that can be called if the string is zero length.



Bob Boffin

 

[ThatRickGuy]

Or you can write one...

Public Shared Function CheckEmpty (value as string) as object
  if value = string.empty
    return dbnull.value
  else
    return value
  end if
end function

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[earthandfire]

Welcome back Rick.

 

[MarcusO]

Thanks for that.

 

[ThatRickGuy]

Just in for a visit, had to bug ca8msm. One of my co-workers got the boot and my posting time has been massively cut back

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.