Thanks Crazy....... Its useful for me....Thanks a Lot....
On Tue, Mar 8, 2011 at 11:13 AM, crazy <[email protected]> wrote: > > > > 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 > -- Warm Regards :- Gourav Vishnoi +91-9871157845 ( M ) -- 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
