473,321 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

Bit Conversion

ben
Hi All,
I have a table in the database with one column of bit datatype...how
can i retrieve its value as yes/no or true/false in my datagrid
column, i realize i need to convert it in the query n pass the
modified datasource to the datagrid, but unsure on how to
proceed...any help will be greatly appreciated.
thanks in advance
Ben
Nov 18 '05 #1
4 1310
I cant remember the exact name of it offhand, but there is an event
that gets fired on each row of a datagrid during binding. Use this to
check the value of the source, and change it to "Y" or "N" or whatever
you want.
On 27 Feb 2004 05:36:11 -0800, sk****@yahoo.com (ben) wrote:
Hi All,
I have a table in the database with one column of bit datatype...how
can i retrieve its value as yes/no or true/false in my datagrid
column, i realize i need to convert it in the query n pass the
modified datasource to the datagrid, but unsure on how to
proceed...any help will be greatly appreciated.
thanks in advance
Ben


Nov 18 '05 #2
ben
Thanks Dan...but did anybody have any sample code i cud follow, unable
to find the event so far
thanks in advance
benDan Brussee <db******@nc.rr.com> wrote in message news:<qg********************************@4ax.com>. ..
I cant remember the exact name of it offhand, but there is an event
that gets fired on each row of a datagrid during binding. Use this to
check the value of the source, and change it to "Y" or "N" or whatever
you want.
On 27 Feb 2004 05:36:11 -0800, sk****@yahoo.com (ben) wrote:
Hi All,
I have a table in the database with one column of bit datatype...how
can i retrieve its value as yes/no or true/false in my datagrid
column, i realize i need to convert it in the query n pass the
modified datasource to the datagrid, but unsure on how to
proceed...any help will be greatly appreciated.
thanks in advance
Ben

Nov 18 '05 #3
<asp:datagrid .... onitemcreated="methodtocall" ... >

In server code...
public void OfferedItemCreated(object Sender, dataGridItemEventArgs e)

take a look at e.item. It should be a collection of table cells that
have just been added to the datagrid.

On 1 Mar 2004 06:32:21 -0800, sk****@yahoo.com (ben) wrote:
Thanks Dan...but did anybody have any sample code i cud follow, unable
to find the event so far
thanks in advance
benDan Brussee <db******@nc.rr.com> wrote in message news:<qg********************************@4ax.com>. ..
I cant remember the exact name of it offhand, but there is an event
that gets fired on each row of a datagrid during binding. Use this to
check the value of the source, and change it to "Y" or "N" or whatever
you want.
On 27 Feb 2004 05:36:11 -0800, sk****@yahoo.com (ben) wrote:
>Hi All,
>I have a table in the database with one column of bit datatype...how
>can i retrieve its value as yes/no or true/false in my datagrid
>column, i realize i need to convert it in the query n pass the
>modified datasource to the datagrid, but unsure on how to
>proceed...any help will be greatly appreciated.
>thanks in advance
>Ben


Nov 18 '05 #4
ben
Hi,
I found this article very useful and helped me to easily accomplish
the task...thanks datagrid girl !(and to dan brussee for responding to
my post)

http://datagridgirl.com/faq.aspx

Ben

Dan Brussee <db******@nc.rr.com> wrote in message news:<kh********************************@4ax.com>. ..
<asp:datagrid .... onitemcreated="methodtocall" ... >

In server code...
public void OfferedItemCreated(object Sender, dataGridItemEventArgs e)

take a look at e.item. It should be a collection of table cells that
have just been added to the datagrid.

On 1 Mar 2004 06:32:21 -0800, sk****@yahoo.com (ben) wrote:
Thanks Dan...but did anybody have any sample code i cud follow, unable
to find the event so far
thanks in advance
benDan Brussee <db******@nc.rr.com> wrote in message news:<qg********************************@4ax.com>. ..
I cant remember the exact name of it offhand, but there is an event
that gets fired on each row of a datagrid during binding. Use this to
check the value of the source, and change it to "Y" or "N" or whatever
you want.
On 27 Feb 2004 05:36:11 -0800, sk****@yahoo.com (ben) wrote:

>Hi All,
>I have a table in the database with one column of bit datatype...how
>can i retrieve its value as yes/no or true/false in my datagrid
>column, i realize i need to convert it in the query n pass the
>modified datasource to the datagrid, but unsure on how to
>proceed...any help will be greatly appreciated.
>thanks in advance
>Ben

Nov 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Stub | last post by:
Docs says that "The compiler does not use an explicit constructor to implement an implied conversion of types. It's purpose is reserved explicitly for construction." I put up code of three cases...
7
by: Michael Lehn | last post by:
Hi, I have a question regarding the conversion of objects. When is the conversion done by the constructor and when by the operator. My feeling tells me that the constructor is preferred. But...
16
by: TTroy | last post by:
Hello, I'm relatively new to C and have gone through more than 4 books on it. None mentioned anything about integral promotion, arithmetic conversion, value preserving and unsigned preserving. ...
31
by: Bjørn Augestad | last post by:
Below is a program which converts a double to an integer in two different ways, giving me two different values for the int. The basic expression is 1.0 / (1.0 * 365.0) which should be 365, but one...
11
by: Steve Gough | last post by:
Could anyone please help me to understand what is happening here? The commented line produces an error, which is what I expected given that there is no conversion defined from type double to type...
2
by: Alex Sedow | last post by:
Why explicit conversion from SomeType* to IntPtr is not ambiguous (according to standart)? Example: // System.IntPtr class IntPtr { public static explicit System.IntPtr (int); public...
3
by: Steve Richter | last post by:
here is a warning I am getting in a C++ .NET compile: c:\SrNet\jury\JuryTest.cpp(55) : warning C4927: illegal conversion; more than one user-defined conversion has been implicitly applied while...
0
by: Lou Evart | last post by:
DOCUMENT CONVERSION SERVICES Softline International (SII) operates one of the industry's largest document and data conversion service bureaus. In the past year, SII converted over a million...
0
by: dataentryoffshore | last post by:
Get a Discount up to 60% on data entry, data capture, dataentry services, large volume data processing and data conversion services through offshore facilities in India. Offshore data entry also...
21
by: REH | last post by:
It it permissible to use the constructor style cast with primitives such as "unsigned long"? One of my compilers accepts this syntax, the other does not. The failing one chokes on the fact that the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.