Replace 1's and 0's in a gridview column with Yes's and No's

Is it possible to change the display of a column in a gridview to show a Yes for all 1's and a No for 0's that display in a particular column of a gridview bound to a database?  If so, can someone share the way with me?  I am using ASP.NET 2.0 with VB Code Behind.

 Thanks

0
defyant_2004
1/17/2007 7:47:29 PM
asp.net.presentation-controls 72751 articles. 2 followers. Follow

3 Replies
1098 Views

Similar Articles

[PageSpeed] 49

One way you can do is thrrough  CASE in your select statement: 

Select

YesNoColumn= CASE yourColumn

WHEN 1 THEN 'Yes'

WHEN

0 THEN 'No'

ELSE

'' END

FROM Yourtable


Limno

0
limno
1/17/2007 8:25:33 PM

<Columns>
     <asp:TemplateField HeaderText="yourHeader" SortExpression="yourDataField">
            <ItemTemplate>
               <asp:Label ID="Label1" Text='<%# changeText(Eval("yourDataField"),30) %>' runat=server ></asp:Label>
            </ItemTemplate>
         </asp:TemplateField> 
</Columns>

CodeBehind

protected string changeText(object fromDatabase)
{
   string dbValue = fromDatabase.ToString().Trim();
   return(        dbValue == "1" ? "Yes" : "No");

0
g2000
1/17/2007 8:30:33 PM

i hav also used it n i make my app wrokd as i needed...

0
jayesh
10/17/2007 3:06:16 PM
Reply:

Similar Artilces:

It's Linux !? No, it's BSD ! No, no, it's...
kFreeBSD http://wiki.debian.org/Debian_GNU/kFreeBSD a Debian distro using the FreeBSD kernel ! ObiWan wrote: > kFreeBSD > > http://wiki.debian.org/Debian_GNU/kFreeBSD > > a Debian distro using the FreeBSD kernel ! Why use a BSD kernel? I hope the reason is more than, just because they can. http://wiki.debian.org/Debian_GNU/kFreeBSD_why It's easy to understand why the would want to use Debian packages. :) -- Jimmy Johnson Registered Linux User #380263 >> kFreeBSD >> >> http://wiki.debian.org/Debian_GNU/kFreeBSD >> ...

Help! I cannot access the DataGrid's ItemTemplate's LinkButton's Text Atrribute 's Value!!!!!!!!!!!
I write a datagrid's ItemDataBound method as follows:   private void dgTable_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)  {   if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)   {    if(!isRole("Manager"))    {     LinkButton tmp = (LinkButton)e.Item.FindControl("lbPassed");     if(tmp.Text == "Passed")     {      ((LinkBu...

Hyperlink's, ImageURL's, and OnError's
I created an ASP:Hyperlink and set the ImageURL attribute so the link will be the image.If the image is missing, I would like it to display a 'missing image' pic that I have.  I know you can use the OnError attribute of the <img> tag to run some javascript to change it.Unfortunately I can't find a way to access the Hyperlink's Image that is inside it, so I can add an Attribute so the resulting <img> tag will have an OnError attribute inside of it.Any help?If my Hyperlink is called 'foo'....would I do...  ((Image) foo.Controls[0]).Attributes.Add(&...

DataSet's DataTable's and TableAdapter's Oh My!
Here is my situation.  I am using VB as my programming language.I am creating a part of a website that will be the admin section.  I want the admin to be able to add/edit data in a set of tables that normal users can't.  There are 20 lookup tables that I use in the website that I want the admin to be able to manage (i.e. add, edit, delete, insert).  I don't want to create 20 separate web pages (one for each table).  I have one page that has links to all the tables.  Each link has a "table" querystring variable associated with it.  When the...

Guru's..?? Any do's and/or dont's for Zfd4 and Citrix..?
We've got a nw6/sp5 network with GW 6.5, bm3.7 and zfd 4.01 up'n'running.. Now we're adding a citrix server ( win2003) to the mix, will supply a couple off app's to users over the internal VPN in another city. Probably we'll skip the AD phase since we can not see any app and/or user with the need for AD. So,, any special considorations..? tip's'tricks..? known issues...? t.i.a... On Mon, 16 Aug 2004 15:57:10 GMT, Emerson wrote: > So,, any special considorations..? tip's'tricks..? known issues...? biggest one... zfd4.x d...

Who's show is SN? Steve's or Leo's?
I don't want to start anything (honestly)! Just want to ask a simple question. Does the Security Now podcast belong to Steve Gibson or Leo Laporte? Maybe I'm in a world all to myself, but when I listen to the excellent SN podcasts, I want to hear STEVE, not Leo. But especially in the past few shows, it seems Leo will repeatedly interrupt Steve in the middle of a sentence that I want to hear the rest of. I consider this very rude of Leo. Steve is making a point that I (we) want to hear, then looses his train of thought after Leo barges in and asks something. It...

how to control a RadioButtonList's Listitem's text show according database's field
Hi my page has a repeater control,in repeater has a RadioButtonList control now i want to let the RadioButtonList has four Listitem,every Listitem's text is a database's field so the listitem can show dynamic according every record how can i work out my problem thanks a lot  hello dearbound your RadioButtonList to database if i m not clear fell free 4 replySatyabrat SinghB.E.(C.Sc.)Web developer Livetek Solution Dont forget to click "Mark as Answer" on the post that helped you. yes.i bound the radiobuttonlist to a dataset but how to display the ...

411 it's pconsole, 51 it's NWPMW32, 65 it's ???
I like to give some of my users controll over their print jobs. In Netware 3.x to 4.x it was pconsole. In Netware 5.x it was NWPMW32. I don't seem to be able to find the same type of utility for Netware 6.5? We don't like to give user access to nwadmin and the NWPMW32 I copied from my 51 server (TID 10075273) to the 65 server won't display the jobs. Mmccabe, It appears that in the past few days you have not received a response to your posting. That concerns us, and has triggered this automated reply. Has your problem been resolved? If not, you might try o...

Repost: FF won't show gif's nor jpg's Red X's
XP sp2 FF 2.0.0.4 extentions: Adblock Plus Copy plain text Fasterfox Firebug FireFTP McAfee SiteAdvisor NoScript Talkback Video Downloader Pic's show red x's. These pics show just fine in Internet Explorer and Netscape. Anyone have any ideas????? Fasterfox, I guess. See what happens if you disable it (or just disable its pipelining feature). -- �Q� =============== Thank you Q. I disabled all of them, one at a time (restarting each time) and the problem still exists :-( digimomma On 7/12/2007 5:26 PM digimom inquired: > Thank y...

The value's length for key 'data source' exceeds it's limit of '128'.
Hii, When I tried to bind dropdownlist to database by declaring connection string in the code behind file I am getting this error: The value's length for key 'data source' exceeds it's limit of '128'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentException: The value's length for key 'data source' exceeds it's limit of '128'.Source Error: An...

It's not about 1st amendment, it's about condoning Mozilla's despicable behavior.
Today I got a nice email from someone inside Mozilla, in response to my ang= ry post elsewhere, explaining Mozilla's actions. He ended his email with: "Open dialogue is an important part of Mozilla's commitment to open, honest= and community-driven communication, and we remain committed to a free, ope= n web." In the spirit of open dialogue, let me share here my response to him. Ze'ev --------- Dear ..., I appreciate your position yet I remain convinced that Mozilla's behavior w= as despicable. Mozilla caved in to public pressure about one of i...

Trojans, PUP's and virus's in GRC NG's Hmmm
Hmm, Just connected a new client that caused a refresh of the group. Multiple postings were intercepted as containing trojans and other such. Even one in grc.news, which only Steve can port to (as far as I know) Is this expected.. IE you guys are discussing the mechanics of trojans etc, with code examples? Dave 09/11/2008 19:41:38 Deleted HOSTNAME\USERNAME C:\Program Files\Windows Live\Mail\wlmail.exe C:\Sandbox\USERNAME\LiveMailnOE\user\current\Local Settings\Application Data\Microsoft\Windows Live Mail\news.grc.com\grc.news\11AB78DB-00000117.nws Exploit-CodeBase.g...

GRIDVIEW's column's right-click
Hi, I would like to make right-click on gridview's Hyperlink Field  where i will able to do actions and redirect to other Reports in short some kind of WINDOWS functionality on WEB, i am also using AJAX, if any body has any idea please let me know. Thanks ~Parth  ThanksParthvisit for some interesting articals at www.parthrawal.blogspot.comMark as Answer if it helps you hi i am done with it please follow the link  http://aspalliance.com/946ThanksParthvisit for some interesting articals at www.parthrawal.blogspot.comMark as Answer if it helps you...

Sybase Ver wise SysTab's, Proc's and add-on info's !!!
Hi DBA Team, Any one is having table formatted information or an excel sheet which will have a clear picture about Sybase Version wide details on System Tables, Procedures and add-on=92s features right from Sybase 4.x to up to date. This will be serving more clarification on Sybase DBA=92s World to know about Sybase version wide comparative changes, features and upcoming details. Experienced DBA=92s are already known this information on their minds. Kindly spare your time to share the same across the WORLD. Thanks In Advance Regards, Viswanathan.V Sybase DBA Practice ...

Web resources about - Replace 1's and 0's in a gridview column with Yes's and No's - asp.net.presentation-controls

Resources last updated: 11/21/2015 4:28:36 PM