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
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 YourtableLimno
<Columns> <asp:TemplateField HeaderText="yourHeader" SortExpression="yourDataField"> ...
How to add oracle's CLOB column to PB10's datawindowHi,
I try to show all record from product table in DataWindow. The backend
database is Oracle 9i. When I try to drop a CLOB column into datawindow, it
don't allow me to do so.
Please advise.
Danny
...
Computed field's background color diff from regular column'sI just migrated an app from v6.5 to v10 build 5502 and I'm having a
problem with computed fields. Their background color is showing
differently from a regular column's. The DW has a background color of
Silver, the columns and computed fields are set to transparent. In the
IDE the background colors are the same, but when I run the app the
background color for the computed fields shows as I believe a light
gray.
If I set the computed field to Silver, then when I run the app the
computed field's background color shows as silver except for whe the
selected row is ...
Using 6.5 DW's in 7's HTML and ActiveX DataWindowsPB 7 has the new HTML DataWindow and the ActiveX DataWindow. Both just read
PBD's to extract a specific datawindow to process.
Question: Can these new facilites read PB 6.5 datawindows? This would be
nice to ease transition. We can still develop DW's in 6.5 until we thing 7.0
is stable and we can distribute to our developers.
Don Weimann
1. No, it won't read PB7 datawindows. HTMLDW is implemented by adding
properties to the datawindow object.
2. PB7 is, AFAIK, rather stable. I've invested a great deal of time to
ensure that it, and in particular, the HTM...
DataWindow editor 6.5 column's properties "expressions" tabHi,
I'm on PB 6.0.1 (beta 2) and I'am waiting for PB 6.5.1 to upgrade.
To those of you who are on PB 6.5, I'd like to know if in the DataWindow editor,
in the column's properties "expressions" tab, you can set an expression for
"Background.Mode". In PB 6.0.1 (beta 2), I can set an expression for
"Background.Color", but not for "Background.Mode".
If not, I will submit an enhancement request to Sybase for that property to be
�expressionnable� in the DataWindow editor.
In fact, if I Export a dataWindow, I can manually add an...
Setting column's property in a datawindow from composite datawindowHi
I know this is easy but I cant get it to work.
I have two datawindows controls (dw_1, dw_2) in a composite datawindow
(dw_report).
I want to change Text of a header column of dw_2, so I try it using:
1. GetChild and Modify
------
datawindowchild ldw_child
Int li_Rtn
String ls_Error
dw_Report.SetTransObject ( SQLCA )
li_Rtn = dw_Report.GetChild ( "dw_2", ldw_Child )
/* This returns 1, no problem */
If li_Rtn = 1 Then
ls_Error = ldw_Child.Modify ( "item_number_t.Text = ~'New Text~' ")
/* ls_Error is empty string, no problem, but report do...
Gridview
Gridview - how to find a column by it's column name rather than it's Cell index
Hello Friendshow to find a column by it's column name rather than it's Cell indexi.e i want to do something likestrFirstName = Grid1.Rows[2].Cells["FirstName"]In the project i am working on gets customized to different customers....so the position of the columns keep changing depending on the customers requirement.hardcoding..like below is a pain to maintainif i use Grid1.Rows[2].Cells["1"]Can some body help..regardsSara
Hi,
columns do not get associated names exactly like that. Nearest equivalent w...
5.5.4 client with 5.5.5 xla'sIs it possible to run the 5.5.4 client with xla's from 5.5.5?
We are running Win and Office XP and cannot use the 5.5.5 client due
to
issues with workflow. Can the 5.5.5 xla's be used and will they
integrate
better with Excel than the 5.5.4 ones?
I don't think the XLA actually changed.
--
Michael J. Bell
Novell Support Connection Volunteer Sysop
PLEASE: Do not e-mail me privately unless specifically asked.
I'm a volunteer, not a Novell employee!
All opinions and advice provided are MINE alone and NOT Novell's
unless
specifically identified ...
5.5.5 nlm's on 5.5.4 mta and poaDear All,
I am thinking of upgrading my 5.5.4 nlm's to 5.5.5 nlm's. Basically I
don't want to go thru a whole process of a normal upgrade. I know this
will work as I have tested it. we are using a mixture of Netware 6
and 5
with NT/98 desktop/laptops.
Does anyone know of any draw backs or problems I will have ?
Many Thanks for any help.
Varuni
Please explain. You haven't really said anything.
--
Michael J. Bell
Novell Support Connection Volunteer Sysop
Author of Guinevere (http://www.openhandhome.com)
PLEASE: Do not e-mail me priv...
General ?'s about DBD's and platforms------=_NextPart_000_0006_01C0C1B3.2FD29310
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
PSCI_1I am relatively new to Perl, primary experience through Windows NT
with limited knowledge of UNIX. I have been instructed to identify a
corporate standard version of Perl and upgrade our desktops and servers. For
servers we have NT, HP/UX and SunSolaris. We run Oracle 7 & 8, and DB2 UDB.
Is it naive of me to think that I can have one standard build of perl for
the corporation? I was thinking of having one, with DBD's for all our
data...
Let's see what's up here #5Name: KarleneT
Email: karlenevcdatgmaildotcom
Product: eBay Companion
Summary: Let's See What's Up Here
Comments:
Hey<a href=http://www.fha-203k-approved.com>,</a> what's up here? I tried to post something before<a href=http://www.fha-203k-approved.com>,</a> my post never showed up.
Is anyone here looking to network?<a href=http://www.sba-approved.com>,</a> If so PM me.
Looking to meet new people to exchange info with<a href=http://www.adinida.com>,</a> so let's do this.
Later<a href=https://incentivebux.com...
MS SQL server 6.5 table's columns cannot be seen through pb 5.xThis is a multi-part message in MIME format.
------=_NextPart_000_007F_01BECF9F.B8FDC0E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I have both PB 5.x and PB 6.5 installed in the same machine. When I =
connect to the MS SQL server database through PB 6.5 it is connecting & =
working fine both through native driver & ODBC driver. But when I try to =
connect to the same database in PB 5.x through native driver, it =
connects fine. But when I try to open a table, I am getting error saying =
that the col...
How do i upgrade PowerBuilder 5.0's native driver for MS SQL Server 6.5?
If you have the 5.0.04 patches, you have the latest stuff that I know of.
Tech Support might have something as a private EBF, but you would have to
contact them directly to determine that. Are you having a particular
problem with the drivers you have now?
On Tue, 9 Feb 1999 11:38:18 +0800,
in powersoft.public.powerbuilder.database
A-B-C <a-b-c@163.net> wrote:
>
---
Bruce Armstrong [TeamPS] | Romac/Source International
mailto:Bruce.Armstrong@eudoramail.com | mailto:jobs@sourcela.com
| http://www.romac-sou...
superreview requested: [Bug 408749] "ASSERTION: A block's child' s next in flow's parent must be a block" with -moz-column, table stuff : [ Attachment 293607] fix assertRobert O'Callahan (:roc) <roc@ocallahan.org> has asked Boris Zbarsky (reviews
very slow until spring) <bzbarsky@mit.edu> for superreview:
Bug 408749: "ASSERTION: A block's child's next in flow's parent must be a
block" with -moz-column, table stuff
https://bugzilla.mozilla.org/show_bug.cgi?id=408749
Attachment 293607: fix assert
https://bugzilla.mozilla.org/attachment.cgi?id=293607&action=edit
------- Additional Comments from Robert O'Callahan (:roc) <roc@ocallahan.org>
This patch creates nsBlockFrame* nsLayoutUtils::GetAsBlock wh...