|
Hi, how can i export an excel file from a datagrid.
When I am exporting a set of numbers like this 54564564588956 .. the excel file is showing me as this: 5422F12
Why is this?? Can someone help me on this problem!! Its killing me 
Adrian De Battista - Web Designer, Web Programmer, Software Programmer From Malta. My Website .. www.MaltaTrade.org
|
|
|
|
|
Hello,
if your DataGrid name is dgGrid then try the following code
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw =
new System.Web.UI.HtmlTextWriter(tw);
DataGrid dgGrid = new DataGrid();
dgGrid.DataSource = dsExport;
// Get the HTML for the control.
dgGrid.HeaderStyle.Font.Bold = true;
dgGrid.DataBind();
dgGrid.RenderControl(hw);
// Write the HTML back to the browser.
Response.ContentType = "application/vnd.ms-excel";
this.EnableViewState = false;
Response.Write(tw.ToString());
Response.End();
Mehedi Hasan
|
|
|
|
|
Hi,
The problem remains the same but .. when I am exporting a large set of numbers the excel is showing them as this 4433F12 and I am exporting the number like this 4433131123342342
How can i solve this problem pls
Adrian De Battista - Web Designer, Web Programmer, Software Programmer From Malta. My Website .. www.MaltaTrade.org
|
|
|
|
|
I want to send the mails by using the particular IP. bu default it take local ip but i want it to be changed.
Mohinder Singh
|
|
|
|
|
vengaqua wrote: I want to send the mails by using the particular IP.
Do you mean changing your SMTP server ?
|
|
|
|
|
yes i want to change my smtp server
Mohinder Singh
|
|
|
|
|
Hi Mohinder
you can do it by
SmtpClient clnt = new SmtpClient("your IP");
clnt.Port = your port;(default 25)
hope it Helps
|
|
|
|
|
Hi,
I am facing problem of counting words for .doc or .txt files.
I am using following methods ,
1.
aDoc = wordApp.Documents.Open(ref fileName, ref missing, ref readOnly, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref isVisible, ref missing, ref missing, ref missing, ref missing);
aDoc.Activate();
aDoc.Select();
int WCnt = aDoc.Content.Words.Count;
2.
aDoc = wordApp.Documents.Open(ref fileName, ref missing, ref readOnly, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref isVisible, ref missing, ref missing, ref missing, ref missing);
aDoc.Activate();
aDoc.Select();
string ToCount = aDoc.Content.Text;
int RCount = ToCount.Split('\r').Length;
int WCnt = ToCount.Split(' ').Length + RCount;
Still it is not counting words properly.
Please tell me proper method to count the words in .doc or .txt file correctly.
#Abhi#
|
|
|
|
|
hi guys currently my asp project have no font style watsoever in it
and it looks ugly i would like to change the font style of the pages
anyone know how to chagne the default one?
|
|
|
|
|
Respected Gurus
I have a CrystalReport
i cannot set the displaygrouptree property of my crystalreportviewer.
when i set
crystalreportviewer1.displaygrouptree=true
it does not have any effect.
it always show me the first records report.
for all other records i want to use displaygrouptree.
wht to do.
Initially displaygrouptree property of my crystalreportviewer is true
any help
Ajay
|
|
|
|
|
hi i want to make http Request to a webpage that will take a values of sent query string values and insert them into a SQL DB, ok i did it but i want to know the way of just displaying a response to a client to and display ok on the replied web page, i dont want to add a label and then display OK txt inside its text.
i want to make the user see just only OK work when he right click on the response page and selct view source, just ok word and no any thing else,
Thanks alot
Hamody
|
|
|
|
|
Mohammad Daba`an wrote: want to make the user see just only OK work when he right click on the response page and selct view source
You can create a empty page with the text OK and when your process completes redirect the page to this empty page.
|
|
|
|
|
thanks a lot for ur idea
but have u an idea on working with hhtpresponse and httprequest, have u an example on this
Thanks alot
Hamody
|
|
|
|
|
hi,
pls help me to find a solution
I have implemented ajax timer in my project,but when we run the app,if we try to access the internet options from tools menu ,the timer event stops from triggering ,then gets back to the same time.So it fails to maintain the time.
so wht could be a better solution,disabling the tool bars or anything else?
pls help
regards
-- modified at 5:30 Monday 16th April, 2007
|
|
|
|
|
Hi all,
I have this problem with my website, when I insert data I get an error Specified cast is not valid.
And this is the source error:
<asp:Image id=imggm runat="server" Width="40px" Height="32px" ImageUrl='<%#((string)DataBinder.Eval(Container.DataItem, "MoodToday")=="Good Mood"?"laughing":"sad")+".gif"%>' ImageAlign="Baseline">
What could be the problem?
Thanks
|
|
|
|
|
It may be showing you the error becuase you are converting image type to string. which might be the problem that you are facing.
KHATRI
|
|
|
|
|
The problem was actually in the code behind. But now I have solved it I was adding: InsertEmpty(); yet I was not supposed But now I'm facing another error after deploying it on server it works properly but when on the client side the user tries to insert data an error occurs:
Exception Details: System.Runtime.InteropServices.COMException: The network path was not found
Why would this happened.
Thanks
|
|
|
|
|
I have two webpages. In one Page I dispaly List of Products using dataGrid.
When I clicked Product id, I displayed another Page for Edit the product details. After edit when, I clcked the Update botton, I want close this Popup window and Refresh the DataGrid values of Previous Page.
Mohan Balal
|
|
|
|
|
Mkanchha wrote: I want close this Popup window and Refresh the DataGrid values of Previous Page.
Use javascript parent window properties to refresh the parent page and use window.close to close the page.
|
|
|
|
|
Thanks for your reply.
When I click update botton in Popup window at a time It should be close the popup and Refresh the Previous Page.
Mohan Balal
|
|
|
|
|
How ArrayList Sort? Numeric or Alphabetical. If you have some good example Please send Me.
Mohan Balal
|
|
|
|
|
If you're not using .NET 2.0, then you're stuck with ArrayList. ArrayLists can be sorted, you just need to provide a function that is used to specify sort order. You can sort them any way you like. MSDN has examples.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Have u tried Sort method of ArrayList?
Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.
|
|
|
|
|
No, I am not tried. In one Interview they asked to Me
Mohan Balal
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
