|
Hi All,
I have a grid view which is displaying data from a dataset. i have a button on the page where grid view is there and on click of the button, all gridview data should be dispplayed in excel file opened in new window. please tell me how to do this?
Akhilesh Singh
|
|
|
|
|
This code is collected from "http://forums.asp.net/t/956392.aspx"
Export to Excel in ASP.NET is a very common feature, which I'm sure everyone who has worked in ASP.NET would have had the chance to implement.
Whenever we choose the Export to Excel option from our Application, a dialog box pops us with the option to Open or to Save.
By chance if the user checks off the option "Always ask before opening this type of file" that is shown in the dialog box, from next time the user will not be able to see the dialog box. Instead, the excel file opens up in the same window.
To set back this option, the following steps can be followed:
1. Go to Windows Explorer.
2. On the Tools menu, click Folder Options, and then click on the File Types tab.
3. From the Registered file types list box, select the XLS extension, and then click Advanced.
4. In the Edit File Type dialog box, set the Confirm open after download to selected.
5. Make sure the Browse in same window option is not selected, and then click OK.
The above steps will make sure that we get the dialog box as shown above. However, since this is an option set at the client computer, these steps cannot be mandated to be followed in every computer that browses the application.
So, from the code level, we must make sure that the excel file is opened in a separate window. One possible option for this is to Save the file to the web server, and then open the file in a separate window.
The code for this is given below:
private void ExportToExcel(DataGrid dgExport)
{
try
{
string strFileName = String.Empty, strFilePath= String.Empty;
strFilePath = Server.MapPath(@"../Excel/") + "ExcelFileName" + ".xls";
if (File.Exists(strFilePath))
{
File.Delete(strFilePath);
}
System.IO.StringWriter oStringWriter =new StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
StreamWriter objStreamWriter;
string strStyle =@" .text { mso-number-format:\@; }
";
objStreamWriter = File.AppendText(strFilePath);
dgExport.RenderControl(oHtmlTextWriter);
objStreamWriter.WriteLine(strStyle);
objStreamWriter.WriteLine(oStringWriter.ToString());
objStreamWriter.Close();
string strScript = "window.open('../Excel/" + "ExcelFileName" +
".xls','dn','width=1,height=1,toolbar=no,top=300,left=400,right=1,
scrollbars=no,locaton=1,resizable=1');";
if(!Page.IsStartupScriptRegistered("clientScript"))
{
Page.RegisterStartupScript("clientScript", strScript);
}
}
catch(Exception)
{
//Handle Exception
}
}
In the above method, the file is saved to the Web Server inside the folder "Excel". Of course, this folder must have write permissions for the user. But it will definitely ensure that the excel file is opened in a new window in the client computer.
**** I think it helps U ****
|
|
|
|
|
Try This:
#Region "Export To Excel Button Click Event"
Protected Sub cmdExportToExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdExportToExcel.Click
Dim sw As StringWriter = New StringWriter()
Dim htw As HtmlTextWriter = New HtmlTextWriter(sw)
Try
Dim ml_strFileName As String = ml_strSaveFileName
Dim attachment As String = "attachment; filename=" & ml_strFileName & ".xls"
Response.ClearContent()
Response.AddHeader("content-disposition", attachment)
Response.ContentType = "application/ms-excel"
Gridview1.RenderControl(htw)
Response.Write(sw.ToString())
Response.End()
Catch ex As Exception
Finally
If Not sw Is Nothing Then
If Not htw Is Nothing Then
sw = Nothing
htw = Nothing
End If
End If
End Try
End Sub
#End Region
#Region "VerifyRenderingInServerForm"
Public Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)
End Sub
#End Region
Hope this helps u???
|
|
|
|
|
I'm looking for an easy way to synchronize application caches on different front-end servers of a web farm. Any way to do distributed application data caching in .NET?
thx!
|
|
|
|
|
Hi there,
Some third party products can do that. Check out a tool called StateMirror.
|
|
|
|
|
hi all
i have file pg_dump.exe Export file
When i run cmd to this folder contain this file. After that i give argument is
pg_dump -i -h 127.0.0.1 -p 5432 -U postgres -d vietnamairlines -v " + '"' + @"C:\abc.backup" + '"';
click Enter
it show one Line Password:
i give my password and click Enter it Export my file to me.
I want implement this command on ASP.net (C# 2.0).
i have command :
string strPathFile = Server.MapPath(@"../cmd/pg_dump.exe");
MyProc.StartInfo.FileName = strPathFile;
MyProc.StartInfo.UseShellExecute = false;
MyProc.StartInfo.RedirectStandardError = false;
MyProc.StartInfo.RedirectStandardInput = false;
MyProc.StartInfo.RedirectStandardOutput = false;
MyProc.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
MyProc.StartInfo.Arguments = @" -i -h 127.0.0.1 -p 5432 -U postgres -d vietnamairlines -v " + '"' + @"C:\abc.backup" + '"';
MyProc.StartInfo.CreateNoWindow = true;
MyProc.StartInfo.Verb = "save";
MyProc.Start();
MyProc.WaitForExit();
How can i give Password to this Process ????
Some people give me this Line code put behind MyProc.Start();
MyProc.StandardInput.WriteLine("my password");
But it still not Ok !
Some body tell me ?????? 
|
|
|
|
|
I am prettysure it would need to go before the waitforexit, but you might need to pause for a second before you write it. So maybe something this would work:
MyProc.Start();
Threading.Thread.Sleep(1000);
StreamWriter myStreamWriter = MyProc.StandardInput;
myStreamWriter.WriteLine("my password");
myStreamWriter.Close();
MyProc.WaitForExit();
Hope that helps.
Ben
|
|
|
|
|
Environment.SetEnvironmentVariable("PGPASSWORD", "You Password");
Hope I have helped.
|
|
|
|
|
Hi! i want to use AJAX in OPERA but OPERA doesn't support XMLHttpRequest as a native script object or ActiveX Object. then what is the method for AJAX programming in OPERA WEB BROWSER?
Thanks & Regards,
SAMir Nigam,
Software Engineer,
STPL, Lucknow, India.
|
|
|
|
|
Voodoo ? Black magic ? If there's no XMLHttpRequest object, there can't be any AJAX, now can there ?
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 )
|
|
|
|
|
Opera does support is natively, but only since version 9.
|
|
|
|
|
Hi,
I am geting the list attachments as comma seperated in a textarea or a multiline textbox. I want the attachments to be hyperlink so that i can click on any of the attachment in the textbox and open it. Jus like how it is shown in rediffmail or any other mailing system.
Can anybody help me out in this. If anyone has any code or link to any code then plz reply.
Thanks,
Riz
|
|
|
|
|
string[] str = TextArea.Text.Split(char.parse(","));
for(int i=0;i<=str.length - 1;i++){
}
|
|
|
|
|
Thanks for ur response
But how to make the comma seperated text as hyperlinks in a textbox?
If we have file1.txt, file2.txt, file3.txt in a textbox then i want all 3 files to be a hyperlink so that i can open them onclick.
Rajiya
|
|
|
|
|
Hi i have some textbox in my form,
In future,if i like to add some more textbox in that form,
How its possible to add like that textbox in my form?,
Example:
For one student marks i want to enter,
If he have 3 subjects, so i will give now 3 textbox,
In future it will become as a 5 subjects,
Then i want to include 2 more textbox in my form,
So how its possible?,
Magi
|
|
|
|
|
Hi
Do you want to add text boxes at runtime?
If yes
dim MyTxtBox as new TextBox
set watever properties you want using "MyTextBox."
Add MyTextBox to panel,placeholder or to ASP Tables or any other.
eg:
panel1.controls.add(MyTextBox)
To succeed, we must first believe that we can.
Sherin Iranimose
|
|
|
|
|
I'm having problem in setting up the time-interval for my splash screen for a web application. How can i set this, to ensure the splash screen shows up even if application is loaded up faster than expected?
Jazz Morgan
|
|
|
|
|
If you have a form you call a splash screen, how are you closing it ?
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 )
|
|
|
|
|
how to play the flash file in iframe? can it be done? i already can upload the file to a specific folder, but it is not show in the iframe which is let the user to select...can anybody help? thanks.
|
|
|
|
|
Hi,
It is possible to play flash file in iframe.
give
src="path of the flash file"
|
|
|
|
|
I am just learning asp.net and I am doing some work for my company who has several asp.net sites already built. The particular site I am having trouble with has some codebehind files it is using. My problem is that I cannot find the aspx.vb files it is referring to. I realize that dll files are created and the site is actually using those files, but I want to look at the code it is using. Where are these files usually kept?
Thanks for the help.
Jim
|
|
|
|
|
The files will be contained in the solution which created the DLL - if you don't have access to them - download REFLECTOR and open the DLL files with that - you can at least see what the code behind looks like even if you don't have access to the original files.
Mark.
|
|
|
|
|
They in the project that was used to create the website. Usually they are stored in some version control system, such Visual SouceSafe, or could possibly be on the developers machine (very bad practice). Ask the person(s) who created the site.
only two letters away from being an asset
|
|
|
|
|
Hi all!
Heres my problem - i have a gridview bound (via sqldatasource) to a simple table... The table consists of 2 columns, an ID column (auto increment primary key) and a NText column...
On the webpage im displaying the gridview and a simple button. When the user clicks the button a new row is created and inserted... For testing purposes, the NText field just contains a random GUID. The gridview is then rebound and it appears in the list, great, that works fine..... however, when the user clicks the "add random" button i want the row they just created to be selected!!...
so far i've got the ID of the last inserted using the Insert Indentity methodology and returning the ID field. The problem is dont seem to be able to set the SelectedKey or SelectedValue on the datagrid, all i can change is the index!!
What am i missing here??
Cheers!
Will
|
|
|
|
|
Perhaps you should try using the selectedIndex property. Both of the SelectedDataKey and SelectedValue are readonly setting them will not affect which line is selected.
Hope that helps.
Ben
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
