How to pass empty textbox data as parameter to stored procedure in oracle using .NET

Question

I am a developing an application with different text boxs that I am passing to oracle stored procedure using ASP.NET ( c# ). For each textbox there is a property in a class file. When I pass empty textbox it is throwing an error. This is because that a varchar2 field in oracle is not accepting "null".

      Private string _fristName;

      public string FirstName 
      {
           get { return _fristName; }
           set { _fristName= value; }
      }

Which is best practice for making _fristName as string.empty or "" ?

It's better to use string.Empty rather than "". After .Net 2.0, they are exactly the same. However, as far as readability is concerned, most programmers would agree that string.Empty is more pleasant to read. — Christopher Currens
– Christopher Currens, Commented Aug 8, 2011 at 19:04

David Hoerster · Accepted Answer · 2011-08-08 19:11:12Z

5

In your class' initialization, just set your private variable to a default value of String.Empty.

Private string _fristName = String.Empty;

Getting it will return an empty string, not null; setting it will change the value to whatever.

You could also do this:

  Private string _fristName;

  public string FirstName 
  {
       get { return _fristName ?? String.Empty; }
       set { _fristName= value; }
  }

Hope this helps!

EDIT: Took suggestion from @Marc in the comments. Changed the comparison to use the ?? operator. Thanks @Marc!

edited Aug 8, 2011 at 19:11

answered Aug 8, 2011 at 19:00

David Hoerster

28.8k9 gold badges71 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marc Over a year ago

Or more tersely get { return _firstName ?? ""; }

David Hoerster Over a year ago

Oooh, yeah -- I always forget about ??. Thanks!

Jon Raynor · Accepted Answer · 2011-08-08 19:12:33Z

0

Before setting the value of the parameter in the stored procedure, check for null. This could be put in a common function. Note this is for sql server, but a similiar function could be done for Oracle. Also, if the column can't take a null, then instead of DBNull.Value, maybe a default is used (String.Empty for strings, etc.).

IDbDataParameter parameter = new SqlParameter(ParameterName, DatabaseFieldType);

parameter.Value = (value== null ? DBNull.Value : value);

answered Aug 8, 2011 at 19:12

Jon Raynor

3,9126 gold badges33 silver badges45 bronze badges

Collectives™ on Stack Overflow

How to pass empty textbox data as parameter to stored procedure in oracle using .NET

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related