.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Replacing Null Only if

Posted By:      Posted Date: October 17, 2010    Points: 0   Category :Sql Server

Hi Guys,

In my derived column, I need an expression to replace NULL value with "VOID" but only if Lineflag column value is "IC".

Current Output

transno   LineFlag  State

1               IC

2               IC      VOID


I need expression to replace NULL value in state column with "VOID" but only if Lineflag column value is "IC". Both the columns are sting Data Typs.


Required Output

transno   LineFlag  State

1               IC      VOID

2               IC      VOID

Any help much appreciated.







View Complete Post

More Related Resource Links

replacing ok and cancel button of an alert message with YES an NO button in asp.net web application.


i want to replace ok and cancel button of an alert message with YES an NO button in asp.net web application.When a user will click yes the data will be saved in the database and if user clicks that will act as a reset button and do not save the data in database and the control will move with as usual to the redirect page.Any pointers will be highly appreciated.I am usin g C# language.

How to check for null/empty strings on dynamic objects?


What is the proper way to check for null or empty strings on dynamic objects? This is the only solution I've found so far:

if (admin.PasswordHash.GetType() == typeof(DBNull) || admin.PasswordHash == string.Empty)

If the field is null, the object returned is DBNull.Value, but if the field is empty string, it's return as a System.String object. This makes it impossible to do regular "admin.PasswordHash == DBNull.Value" check, as that will fail whenever the field has been set to empty string. Is my example the right (and only) way to go?

Users getting logged out because HttpContext.Current is null


We've  been trying to fix this one for a couple years, and I'm just out of ideas, so any help is really appreciated!

We've got a fairly large, complex web application that uses Forms Authentication to authenticate users.  Throughout the application we store and retrieve information about users in the Session object, and in some cases in cookies.  In a couple places we check for the existence of the context, and if it's null we send the user back to the login page to re-establish the session. 

Just a quick run-down of this web app: C#, .NET 3.5, IIS 6, ASP.NET State Service to manage session

As for the session timer, we use our own home-grown timer, which is basically a client-side timer, which is backed up by a check to the SQL database to see when their last activity was.  This seems to work well for us.  It's not perfect, but it allows us to notify the user before the session times out, and allows us to be certain we're not logging a user out before their 60 minutes of inactivity is up.

What's happening is that certain users are being logged out after just a few minutes.  We've eliminated the timer as a cause and believe what's happening is the HttpContext.Current is null, so the user is logged out.  We do not know why the HttpContext.Current is null, and I underst

'element.className' is null or not an object



I just downloaded the project, compiled it and ran it right out of the box and when I put the mouse pointer over or remove the mouse pointer from either MenuItem in the menu demo, I generate this error:

'element.className' is null or not an object

It points to this javascript method:

updateClassName: function(operation, element, name, value) {
        this[operation + 'String'](
                function() {
                    return element.className;
                function(newValue) {
                    element.className = newValue;

Page.FindControl Causing Null Reference Exception


Hi guys,

I developed a page in VWD 2008 and it works perfectly locally, but when I deployed it on the server every Page.FindControl() call is causing the NullReference Exception "Object reference not set to an instance of an object. " Can anyone help me out? Code is below


Mike Marshall

            For i As Integer = 1 To 10
                If (CType(Page.FindControl("last_" & i), TextBox).Text.Length > 0) Or (CType(Page.FindControl("first_" & i), TextBox).Text.Length > 0) Or (CType(Page.FindControl("dob_" & i), TextBox).Text.Length > 0) Then
                    Dim person_entry(7) As String
                    person_entry(0) = info_list.Count - 1
                    person_entry(1) = CType(Page.FindControl("last_" & i), TextBox).Text
                    person_entry(2) = CType(Page.FindControl("first_" & i), TextBox).Text
                    person_entry(3) = CType(Page.FindControl("dob_" & i), TextBox).Text
                    person_entry(4) = CType(Page.FindControl("appear_" & i), TextBox).Text
                    person_entry(5) = CType(Page.FindControl("mental_" & i), TextBox).Text
                    person_entry(6) = CType(Page.FindControl("behave_" & i), TextB

linq and max, if return null return error


hi there
i have this query :

var result2 = (from TH in DB.Threshold
                          where TH.ProductSKUID == int.Parse(HID_ProductSKUID.Value)
                          select TH.ThresholdID).Max();

the problem is that if this query does not find any items, return null, so thow exception
how can i do to return 0??

ObjectDataSource CancelSelectOnNullParameter="false" // Select all when select parameter is null or


Hi ! I am using an objectdatasource in my project and I want to select all rows when the selectparameter value is empty ! I did the following but I am failling;
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DataObjectTypeName="TugberkUgurluCom_TransferModule.TransferPriceDetailsAll" SelectMethod="GetAllDataFromPricesForControl" TypeName="TugberkUgurluCom_TransferModule.TransferPriceDBComponent" UpdateMethod="UpdateTransferPrices">
    <asp:ControlParameter ConvertEmptyStringToNull="true" ControlID="DropDownList1" Name="TpDestID" PropertyName="SelectedValue" Type="

How to deal with NULL values in a SQL table


 Hi all

In order to add/update/delete data from a table I build 2 classes: 1 class containing all the table fields and another class with methods to add/insert/update/delete records. I am learning how to avoid errors when your table must use SQL NULL values. One error is when I call my UPDATE method (see below):

  public void UpdateItem(OcItemConstraintDetails item)
  SqlConnection con = new SqlConnection(connectionString);
  SqlCommand cmd = new SqlCommand("ItemConstraints_Update", con);
  cmd.CommandType = CommandType.StoredProcedure;

  cmd.Parameters.Add(new SqlParameter("@itemConstraintId", SqlDbType.Int, 4));
  cmd.Parameters["@itemConstraintId"].Value = item.ItemConstraintId;

  cmd.Parameters.Add(new SqlParameter("@path", SqlDbType.NVarChar, 150));
  cmd.Parameters["@path"].Value = item.Path;

if you watch the SQL profiler trace you will see that I am passing a value of 'default' ;so that causes me problems.

exec ItemConstraints_Update @itemConstraintId=1,@path=default

With that said, what are the best practices when your SQL table accepts NULL values and when:
- you are passing an empty value to your stored procedure;

error in MicrosoftAjax.js: Cannot read property '_notified' of null


I am cross testing my project with multiple browsers: IE7, Firefox and Chrome.

One one page I have a dynamically built table with two DropDownLists and CascadingDropDown extenders. Maybe the only thing special about the drop down lists is, that I add a "onChange" for the second drop down list in each row which shows or hides the list depending on the value populated from the web services.

All of this works perfectly in IE7 and Firefox, but Chrome does not execute the JavaScript in the onChange attribute and the error console says:

Uncaught TypeError: Cannot read property '_notified' of null

Linq to SQL returns null for DateTime fields.


I have a linq to sql entity class in which I declared some DateTime fileds like this:

[Column(DbType = "smalldatetime")]
public DateTime? StartDate { get; set; }

And this is how I fetch data form repository:

return repository.Logs.OrderByDescending(l => l.LogID).FirstOrDefault();

All non DateTime fields are filled properly but all datetimes are null.

[Column(DbType = "smalldatetime")]

        public DateTime? StartDate { get; set; }

Question about Greater/Less Than if Value is Null


Currently on my site I am displaying wins and loses based on the score of an event. I got this to work except when both of the values are null. Until an event happens the values are null so when I am trying to show a greater than or less than statement that is grabbing a null value I get an error because it's not in the correct format. I also checked out this article here: http://www.codeproject.com/KB/cs/AgileWare_Convert_Int32.aspx

This code is within a DotNetNuke module right now and crashes because of this format. So basically I am looking to modify my statements below in some way where if the value is null it will still display on our site. Obviously if the values both show 0-0 it works but that isn't really an option for me to use prior to the event happening. Any help is appreciated. Thanks!

I've tried both Convert.ToInt32:

  if (objAwaySchool != null)
                    string strSchoolId

How to display a NULL value (of SQL DateType) as 'N/A' ?


hi all

My SQL field 'modified' is a DateTime type and if the value is NULL in SQL I want to display a 'n/a' string.
I am using FormView templates to display the value.

If I use this statement -> ISNULL(Items.modified,'') AS Modified; I get '1/1/1900 12:00:00 AM' in return.

If I use this statement -> ISNULL(Items.modified,'n/a') AS Modified; I get 'Conversion failed when converting datetime from character string.'

I could go ahead and change my class from "public DateTime Modified" to "public String Modified" but I want the field to represent its real value which is DateTime.

I am not inserting the date value back into the table since the sprocs all take care of that for me. I just want to display the 'n/a' string.

So, is there any way to display a SQL DateTime type as a string when its value is NULL inside the table?

ps: I would prefer not to change any code inside the FormView Templates if possible :)

Thank you!


BDC Editor NULL Structure




I am new to WSS and MOSS. I am attempting to use the BDC Editor to create a LOB system to use with Sharepoint. I have no trouble connecting to the webservice which is running on localhost and was generated using Codesmith and Nettiers. I can see all my entity methods and can add them to the definition editor. The issue is that when I attempt to execute a method instance, seemingly regardless of type, I am presented with either of the following 2 messages:


"NULL was returned to FindSpecific" (FindSpecific MethodInstance"

"Back-end returned a NULL structure which is incompatible with the associated metadata" (Finder Method Instance)


Any ideas what I might be doing wrong?





Microsoft JScript runtime error: 'Parent' is null or not an object


Hi friends,

        I got This Error : Microsoft JScript runtime error: 'Parent' is null or not an object

 In runtime,after  click on the check box, It Show "Microsoft JScript runtime error: 'Parent' is null or not an object"

<script language ="javascript" type ="text/javascript" >
        function SelectAllCheckboxesSpecific(spanChk)
           var IsChecked = spanChk.checked;
           var items=0;
           var Chk = spanChk;
              Parent = document.getElementById('gvUsers');          
              var items = Parent.getElementsByTagName('input');                         
              for(var i=0;i<items.length;i++)
                  if(items[i].id != Chk && items[i].type=="checkbox")
                      if(items[i].checked!= IsChecked)

please verify it. 

Sessions and null



 I have the following code

if (Session["vip_email"] != null || Session["vip_email"] != ""  )
                tb_email.Text = Session["vip_email"].ToString();

It breaks because it always thinks that the session is not null when it is (Object reference not set to an instance of an object.)

Am I using sessions correctly in asp.net

Can someone please assist?




ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend