472,328 Members | 2,039 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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 1133
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Eric | last post by:
Dear All, I want to export datagrid content to a Excel file, the code just like below: Response.ContentType = "application/vnd.ms-excel"...
2
by: Bidarkota | last post by:
Hi, I have a DataGrid in which there are some images and Data are displayed and in the webform.asp page i am using some stylesheets. when i...
3
by: Bidarkota | last post by:
When i export DataGrid to Excel all the HTML contents are also exporting to excel. i am using stylesheets in the ASPX Page and i am getting an alert...
2
by: footballhead | last post by:
I have a page with a datagrid that I have configured with all the information I need to provide to froogle for listing my products on their site. I...
0
by: kieran | last post by:
Hi, I have an 'export to excel' button on my Datagrid. All works well except that on my Datagrid, I have sub total rows. The subtotal rows use...
6
by: Sridhar | last post by:
Hi, I have to export data inside the datagrid into an excel worksheet. I have to do this on button click event. I am trying to do like this. ...
0
by: madhavit | last post by:
hi, i am able to export datagrid data to excel sheet but the problem is i am not able to export datagrid within datagrid data to excel. can...
1
by: Kondapanaidu | last post by:
Hi, I am using .NET 1.1, How to Export the data from Datagrid to PDF file. Lets assume that EMP Table EmpNo Empname 1 AAA
1
by: johnlim20088 | last post by:
Hi All, I does have a question about export datagrid data to csv. Well, I know the common solution is 1) select the data again and put in the...
1
by: Arch Stanton | last post by:
I export the contents of my datagrid controls to Excel using the following Sub: Sub WriteToExcel(Sender as Object, E as EventArgs) ...
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
1
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

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.