SELECT CASE WHEN Col1=99 THEN 'N/A'
ELSE Convert(VARCHAR(5),Col1) End AS [TEXT],
Col1 AS [Value]
FROM TABLE1
after that ,bind [Text] and Vlaue fields to dropdwonList.
Drp.DataValueField = "Value";
Drp.DataTextField = "Text";
Drp.DataSource = // Fetch data using above query
Drp.DataBind();
On Tue, Mar 8, 2011 at 6:12 AM, Gourav <[email protected]> wrote:
> HI All...
>
> I have only one Column in my Database and its Data Type is Integer and
> we can't modified this table ,And i am binding its value into My web
> page in a DropDown...
> My problem is that
> in Database my Table Data is...
> ---------------------------------
> | Special CODE |
> |-------------------------------
> | 1 |
> | 2 |
> | 3 |
> | 99 ||
> --------------------------------
>
> I want that when Its Bind in DropDown this 99 show NA.SO please guide
> me how to do this......
> I binding a datatable and then bind Dropdown through this
> datatable..SO how can i show this 99 to 'NA'......and i can't modified
> and add some other column in table...
>
> --
> You received this message because you are subscribed to the Google
> Groups "DotNetDevelopment, VB.NET <http://vb.net/>, C# .NET,
> ADO.NET<http://ado.net/>,
> ASP.NET <http://asp.net/>, XML, XML
> Web Services,.NET Remoting" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
> or visit the group website at http://megasolutions.net
>
--
"People who never make mistakes, never do anything."
dEv
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
