Export Datagrid

  • Thread starter Thread starter Reggie
  • Start date Start date
R

Reggie

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.
 
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?
 
Back
Top