Change text received from sql query in asp.net

Question

I am using a listview in asp.net and inside this listview I have a listbox that gets filled with data using my query. Some of the values that are in the listbox are empty. Is there a way to get the data that is empty and change it to "(Blank)"?

ASP.NET

<asp:ListBox ID="ListBox1" runat="server" DataSourceID="FormTitleDataSource" 
    DataTextField="FormTitle" DataValueField="FormID" 
    SelectedValue='<%# Bind("FormID") %>' AppendDataBoundItems="true">

<asp:SqlDataSource ID="FormTitleDataSource" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ORHP_Dev03182014ConnectionString %>" 
    SelectCommand="SELECT DISTINCT FormTitle, FormID FROM Core.Form_Lkup ORDER BY FormTitle">
</asp:SqlDataSource>

Or does anyone know a way to use the select statement to change the empty strings without changing the value in the table.(using it for an application) — user3339242
– user3339242, Commented Aug 27, 2014 at 18:27
In Oracle, you could do select NVL(FormTitle, '(Blank)'). Not sure if there's an equivalent syntax for SQL Server (NVL stands for No Value, it's a function that replaces null with a specified value.) — mason
– mason, Commented Aug 27, 2014 at 18:35

JimmyV · Accepted Answer · 2014-08-27 18:42:35Z

1

Have you tried writing it into your SQL statement?

SELECT DISTINCT case when FormTitle = '' then '(Blank)' else FormTitle end as FormTitle, FormID FROM Core.Form_Lkup ORDER BY FormTitle

edited Aug 27, 2014 at 18:42

answered Aug 27, 2014 at 18:37

JimmyV

5306 silver badges16 bronze badges

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

1 Comment

JimmyV Over a year ago

I forgot to end my case statement...fixed

Moshtaf · Accepted Answer · 2014-08-27 18:44:00Z

1

Add OnDataBound="ListBox1_DataBound" to your ListBox control:

<asp:ListBox ID="ListBox1" runat="server" OnDataBound="ListBox1_DataBound" DataSourceID="FormTitleDataSource" 
    DataTextField="FormTitle" DataValueField="FormID" 
    SelectedValue='<%# Bind("FormID") %>' AppendDataBoundItems="true">

Then add this method in codebehind:

protected void ListBox1_DataBound(object sender, EventArgs e)
{
    foreach (ListItem i in ListBox1.Items)
    {
        if (i.Value == "")
            i.Text = "Blank";
    }
}

answered Aug 27, 2014 at 18:44

Moshtaf

4,9132 gold badges27 silver badges34 bronze badges

Collectives™ on Stack Overflow

Change text received from sql query in asp.net

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related