469,592 Members | 1,741 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,592 developers. It's quick & easy.

Export Datagrid

Hi and TIA! I have a datagrid inside a panel control. I have a procedure
that exports the panel control and thus the datagrid to excel. The datagrid
has the following sample fields/data.

Nomen NIIN Qty
Key 000234567 2
Ring 002818181 3

The problem is that I loose the leading zero's. How can I update the
dataset to concatenate an apostrophe to the beginning of each NIIN value,
rebind the datagrid then export the panel as normal. Basically how do I
update the dataset? I don't want to concat the value in SQL view because I
have many views that use this export and I want the displayed value not to
show the apostrophe . Thanks for your help.

--

Reggie

Oct 17 '08 #1
1 1050
Never mind got it figured out. One thing though. I was thinking(hoping)
that the apostrophe wouldn't show in the excel sheet. It disappears when you
type it directly into a cell in excel. Any thoughts?

--

Reggie
"Reggie" <No*****************@yahoo.comwrote in message
news:OP**************@TK2MSFTNGP03.phx.gbl...
Hi and TIA! I have a datagrid inside a panel control. I have a procedure
that exports the panel control and thus the datagrid to excel. The
datagrid has the following sample fields/data.

Nomen NIIN Qty
Key 000234567 2
Ring 002818181 3

The problem is that I loose the leading zero's. How can I update the
dataset to concatenate an apostrophe to the beginning of each NIIN value,
rebind the datagrid then export the panel as normal. Basically how do I
update the dataset? I don't want to concat the value in SQL view because
I have many views that use this export and I want the displayed value not
to show the apostrophe . Thanks for your help.

--

Reggie
Oct 17 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Bidarkota | last post: by
3 posts views Thread by Bidarkota | last post: by
2 posts views Thread by footballhead | last post: by
6 posts views Thread by Sridhar | last post: by
1 post views Thread by Kondapanaidu | last post: by
1 post views Thread by Arch Stanton | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.