Sqldatareader field null

The nice thing about this is that it also allows you to include a default value rather than setting it as null. I had other issue regarding of null-able value object, and this saved me hours of trying to figure out what's going on. WPF doesn't explain the issue when compiling runtime. Can you please tell us exactly which line is throwing the error while debugging. It would be easier. Note: I am not sure where you are assigning startingDate to the value read from the database, because it is not shown in the posted code.

That is why I assigned it directly in my example, but you may need to adjust the placement of the example logic. How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 6 months ago.

Active 3 years, 4 months ago. Viewed 31k times. Jay Jay 2 2 gold badges 5 5 silver badges 17 17 bronze badges. DateTime is not nullable, DateTime? I understand what you are saying now I just left the question mark out — Jay.

Add a comment. Active Oldest Votes. GetOrdinal name ; return reader. IsDBNull col? Open ; cmd. StoredProcedure; cmd. GetInt32 reader. IsDBNull 1? Show 1 more comment. If someone changes the Age column from being an int to an SQL bigint c long , your code will fail silently by returning 0. I wonder if you can override the default int to be -1 instead of 0 — Chris.

Chris - You should be able to just replace default int with Stevo You are correct! I tried that and it worked as you said right after I posted, but I forgot to come back to this page : — Chris. Be aware that using "as" here can hide index errors. If you accidentally use sqlreader[indexAge] as string?? Consider whether you really want int? Stevo default int is 0, not Chris: Make sure you're using the one you really want.

Show 2 more comments. GetValueOrDefault ; or the null-coalescing operator?? Jim G. Gone Coding Gone Coding Value return default T ; return INullable t. Value return null; return INullable t. I'm finding that the explicit operators on the System. SqlTypes types are throwing errors everywhere trying to use this code See stackoverflow. IsDbNull ColumnIndex works as many answers says. PJ3 PJ3 2, 1 1 gold badge 23 23 silver badges 31 31 bronze badges.

This also works on old versions of System. Data and. I would use the following and wouldn't worry too much: employee. ToString ;. Ralph Willgoss One way to do it is to check for db nulls: employee. GetString indexFirstName ;. Michael Todd Michael Todd Geoff 8, 1 1 gold badge 38 38 silver badges 49 49 bronze badges. Summer-Time Summer-Time 1, 14 14 silver badges 19 19 bronze badges.

Copying and customizing this code directly into an extensions class right now. Vijai Vijai 1, 3 3 gold badges 20 20 silver badges 26 26 bronze badges. I think this is the best common method to handle any kind of null.

I don't know why this answer is not popular. Your code won't throw in error in that case. If possible, use this avoid nulls.

Otherwise, I like Sonny Boy's answer of helper methods. Why a static, separate helper method? Doesn't an extension method on the SqlDataReader seem more compelling and more intuitive?? The answer should tell about the C way of handling it , not using SQL. In my case, I don't have control over SQL query. Check sqlreader. CesarGon CesarGon GetOrdinal nameOfColumn ; return reader. Project Mayhem Project Mayhem 5 5 silver badges 12 12 bronze badges.

I don't know who you are, but bless you. This function saved over three hours of work. IsDBNull col? I would not call this method "SafeGet" because if T is a struct it will convert nulls to the non-null default for T - not really safe. Perhaps "GetValueOrDefault". RhysJones Why would you have T as a struct in this case? Even if you do I would argue that the non-null default in the struct is the expected behavior.

Usman Ali Usman Ali 7 7 silver badges 19 19 bronze badges. IsDBNull index? Kaido Kaido 3, 22 22 silver badges 32 32 bronze badges. I think you would want to use: SqlReader. The static method s would contain code to check for nulls see other answers on this page. And I want to mention if you working with column names, just comparing types may be more comfortable. Call this when reading Datareader. We use a series of static methods to pull all of the values out of our data readers.

I am using the code listed below to handle null cells in an Excel sheet that is read in to a datatable. March 4, c Leave a comment. If there is a new record, I then want the script to store the entries from two sp What I am trying to achieve is when clicking on the button it should open a URL in a n Add menu.

You need to check for IsDBNull : if! IsDBNull colIndex return reader. GetString colIndex ; return string. For a string you can simply cast the object version accessed using the array operator and wind up with a null string for nulls: employee. GetValueOrDefault ; or the null-coalescing operator??