How to Check DataReader column also assign default value as Null if it’s Not Exist in DataReader using C# in ASP.net

rhino000

  string Item = Convert.ToString(drr["Item_Code"]);

This Row is not present in the Datatable.So its throw an error.Instead of thrown an erroe i want the (Item ) value is NULL..

Is this Possible without using If Conditon

AnandM

0 1

rhino000 says:

string Item = Convert.ToString(drr["Item_Code"]);

replace above code with below

string Item = drr["Item_Code"] == null ? "NULL" : Convert.ToString(drr["Item_Code"]);

rhino000

0 2

Same error occur

 Column 'Item_Code' does not belong to table Table1.

AnandM

0 3

rhino000 says:
Same error occur

Column 'Item_Code' does not belong to table Table1.

that means you dont have the column with name Item_Code in your database table.so it will throw error everytime you are trying to access.

rhino000

0 4

Yes..how to assign the NULL value to this Witrhout using If condtion

rhino000

0 5

I have the column in database table .But in c# we did not assign value for that column in this case we can assign the NULL value to that Column in c#

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html