Export to Excel in zip format - .NET (Core and Framework) Discussion Boards

Re: how to display the student who is in due - there are 4 rows, in 4th row he paid balance amt so i should not select that student and the who paid less than total i need to select that student

sr1595-Aug-10 23:37

sr159

5-Aug-10 23:37

thank you for replying. Now it is working.

Re: how to display the student who is in due - there are 4 rows, in 4th row he paid balance amt so i should not select that student and the who paid less than total i need to select that student

Luc Pattyn29-Jul-10 23:45

Luc Pattyn

29-Jul-10 23:45

Hi,

your data is redundant so there must be several solutions; try one of these(untested):

SELECT stud_id WHERE sum(paid)<total GROUP BY stud_id ORDER BY stud_id

SELECT DISTINCT stud_id WHERE stud_id NOT IN (SELECT stud_id WHERE bal=0)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: how to display the student who is in due - there are 4 rows, in 4th row he paid balance amt so i should not select that student and the who paid less than total i need to select that student

PIEBALDconsult1-Aug-10 8:36

PIEBALDconsult

1-Aug-10 8:36

sr159 wrote:
i have column called receipt_no, student_id, paid_amt, Bal_amt

First go back and correct your schema.

About Poweshell

NetQuestions29-Jul-10 20:22

NetQuestions

29-Jul-10 20:22

Hi,

Is it necessary to have .Net Framewrok installed to you power shell?

regards,
NetQuestions

Re: About Poweshell

Richard MacCutchan29-Jul-10 22:19

Richard MacCutchan

29-Jul-10 22:19

Yes, for further information see this page[^].

It's time for a new signature.

About WMI

NetQuestions29-Jul-10 4:03

NetQuestions

29-Jul-10 4:03

hi,

I thought in the namespace System.Management, I would find classes / methods or rather some interface
that I can use to get some management information, say about IIS.

But System.Management only has attributes like 'ManagementConfigurationAttribute' which states that
the property is read-only.

So how do I get the interface to access information about IIS in a console application.

Regards,
NetQuestions

Re: About WMI

dan!sh 29-Jul-10 23:11

dan!sh

29-Jul-10 23:11

What kind of information are you speaking about? You can use WMI for information about IIS. See if this[^] helps.

Export to Excel in zip format

Member 322226428-Jul-10 23:01

Member 3222264

28-Jul-10 23:01

Hi,
I have gridview.
I need to export the data to excel and zip it

I had used dot net zip free dll

The zip file is not having the excel.

Need help how to include the excel file in zip

the below code creates zip file

using Ionic.Zip;
using System.Text;
using System.IO;
using Ionic.Zlib;

protected void btn_Export_Click(object sender, EventArgs e)
{
HtmlForm form = new HtmlForm();
string attachment = "attachment; filename=Employee.xls";
Response.ClearContent();

Response.ContentType = "application/ms-excel";
System.IO.StringWriter stw = new System.IO.StringWriter();
HtmlTextWriter htextw = new HtmlTextWriter(stw);
form.Controls.Add(grd);
this.Controls.Add(form);
form.RenderControl(htextw);

var filesToInclude = new System.Collections.Generic.List<String>();

if (filesToInclude.Count == 0)
{
Response.Clear();
Response.BufferOutput = false;

System.Web.HttpContext c = System.Web.HttpContext.Current;
//string archiveName = String.Format("Employee.zip", DateTime.Now.ToString("yyyy-MMM-dd-HHmmss"));
string archiveName = String.Format("archive-{0}.zip", DateTime.Now.ToString("yyyy-MMM-dd-HHmmss"));
Response.ContentType = "application/zip";
Response.AddHeader("content-disposition", "filename=" + archiveName);
// ZipFile zip = new ZipFile();
using (ZipFile zip = new ZipFile())
{

//zip.AddFile("export.xls", "content");

zip.Encryption = EncryptionAlgorithm.WinZipAes256;

// filesToInclude is a string[] or List<String>
zip.AddFiles(filesToInclude, "files");

zip.Save(Response.OutputStream);
// zip.Save(archiveName);

}
Response.Close();

}

}

Thanks
S.Guhananth

Re: Export to Excel in zip format

Eddy Vluggen28-Jul-10 23:11

Eddy Vluggen

28-Jul-10 23:11

Member 3222264 wrote:
//zip.AddFile("export.xls", "content");

..why is that line commented out? Smile | :)

I are Troll Suspicious | :suss:

Re: Export to Excel in zip format

Member 322226429-Jul-10 0:59

Member 3222264

29-Jul-10 0:59

tried

zip.Addfile("export.xls","content");

getting this error

C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\Employee.xls
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\Employee.xls

Re: Export to Excel in zip format

Eddy Vluggen29-Jul-10 1:04

Eddy Vluggen

29-Jul-10 1:04

Member 3222264 wrote:
tried

That was the part that seemed to be used to add files to the zip-archive. An empty list of files will result in an empty archive.

Member 3222264 wrote:
getting this error

Check if the file below exists;

txt

C:\Program Files\Common Files\Microsoft Shared\DevServer\10.0\Employee.xls

If the file doesn't exist, then it won't be added to the archive. Make sure you call the code that creates the Excell-file before adding it to the list.

I are Troll Suspicious | :suss:

Re: Export to Excel in zip format

Member 322226429-Jul-10 1:13

Member 3222264

29-Jul-10 1:13

while exporting to excel how the file will be in this path

the below works fine to export it as excel

HtmlForm form = new HtmlForm();

string attachment = "attachment; filename=Employee.xls";

Response.ClearContent();

Response.AddHeader("content-disposition", attachment);

Response.ContentType = "application/ms-excel";

System.IO.StringWriter stw = new System.IO.StringWriter();

HtmlTextWriter htextw = new HtmlTextWriter(stw);

form.Controls.Add(grd);

this.Controls.Add(form);

form.RenderControl(htextw);

Response.Write(stw.ToString());

Response.End();

but i do not know why the Employee.xls is not attached to excel

Do u have sample code to zip the file and export?

Re: Export to Excel in zip format

Eddy Vluggen29-Jul-10 1:25

Eddy Vluggen

29-Jul-10 1:25

Member 3222264 wrote:
but i do not know why the Employee.xls is not attached to excel

Well, the above code doesn't generate a file on disk. And that's what the code that's doing the zipping is expecting.

Member 3222264 wrote:
while exporting to excel how the file will be in this path

What data is in that streamwriter? ..and what happens if you write that data to a file?

I are Troll Suspicious | :suss:

Re: Export to Excel in zip format

Not Active29-Jul-10 2:28

Not Active

29-Jul-10 2:28

Please read the forum guidelines and use pre tags when posting code.

I know the language. I've read a book. - _Madmatt

data not binding

sr15928-Jul-10 0:51

sr159

28-Jul-10 0:51

in crystal report whatever i am sending through dataset, all the columns of the database it is displaying in crystal report but only date column field is not binding. It is not getting value. but in dataset the date column has a value. Reply . Thanks in advance.

Problem in Crystal report

sr15928-Jul-10 0:48

sr159

28-Jul-10 0:48

using mysql select query, i am sending dataset to crystal report and i am getting the result. But i want get only one row for particular ID. We are making 3 or more times transaction. So 3 rows is coming. For taking only one row, how to write formula in total field in crystal report so that it will add all those amount for that particular id and display only one row with the sum of that amount. thanks in advance.

Handlers removed automatically?

divyesh143228-Jul-10 0:00

divyesh1432

28-Jul-10 0:00

Hi,

In winforms or wpf application, lets say there is one container control which adds controllers dynamically and it also adds event handlers of that child controls.

Now if I call a clear method of the parent container control, will the event handlers added be removed automatically?

If not and I dont remove them (event handlers), will it create any other issue?

Please suggest!

Thanks,
Divyesh

Re: Handlers removed automatically?

Luc Pattyn28-Jul-10 1:13

Luc Pattyn

28-Jul-10 1:13

when you clear a container control, it disposes of all the contained controls; each control will be available for garbage collection, and the event members they contain will have no influence, just like any other data members. There is no need to remove handlers at all.

BTW: The same applies to a modeless form that gets closed.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Setup project help

TSWatson26-Jul-10 3:59

TSWatson

26-Jul-10 3:59

Hi
Is there a way of installing other software such as MySQL in a setup project. If so is it also possible to execute a script to create a database?

Thanks

Re: Setup project help

Peace ON27-Jul-10 2:27

Peace ON

27-Jul-10 2:27

Yes, definitely it is possible.
You can specify pre-requisite that need to be
installed before your project files installed.

Find following links for how to specify pre-requisite
for your setup project.

How to add prerequisites in visual studio .net 2005 setup[^]

http://msdn.microsoft.com/en-us/library/7eh4aaa5%28v=VS.80%29.aspx[^]

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Codedom Question

Gavin_L25-Jul-10 18:57

Gavin_L

25-Jul-10 18:57

In C#2.0,the Codedom library how to generate the method of foreach? Confused | :confused:

Re: Codedom Question

Pete O'Hanlon26-Jul-10 10:05

Pete O'Hanlon

26-Jul-10 10:05

A foreach is actually a convenience wrapper around a loop with an enumerator. That's what you need to enumerate over. Try to create a CodeDOM for this instead:

IEnumerator e = item.GetEnumerator();
while(e.MoveNext())
{
  myList.Add(ConvertToObject(item));
}

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Install SQL Server 2008 R2 Express with my installation

bonzaiholding24-Jul-10 22:28

bonzaiholding

24-Jul-10 22:28

Hi,
I have an application in C# that use SQL Server 2008 R2 Express.
When i install the package i need to choose option and to install:
1. Microsoft .Net Framework 3.5 SP1.
2. Windows Installer 4.5.
3. Windows PowerShell 1.0

I have an SQL Script that will build my DB at SQL 2008 R2 Express and will add the user configuration that i want.
I want to make install package that will include the SQL 2008 R2 Express (including "Microsoft .Net Framework 3.5 SP1.",
,"Windows Installer 4.5" and "Windows PowerShell 1.0 ").
Will run the script and install my application.
I don't want to let the user to choose configuration for the DB in the installation process.
How can i do that?

Thanks,
Shai.

cross-post

Luc Pattyn25-Jul-10 2:19

Luc Pattyn

25-Jul-10 2:19

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

How to convert a EMF file to Bitmap

hawkgao012924-Jul-10 22:06

hawkgao0129

24-Jul-10 22:06

Guys;

I used system.drawing.Image to get a MetaFile, the type is an EMF file:

Image img= new Metafile(new System.IO.MemoryStream(), HDC,rc, MetafileFrameUnit.Pixel, EmfType.EmfOnly);

After an EMF file is created. I need to convert it to Bitmap, using: img.Save(sTempfilename, ImageFormat.bmp); Its background becomes black. I think i can not save directly since the format is different.

Would you give some suggestions on how to convert the EMF image to a Bitmap? Thanks very much.

Last Visit: 31-Dec-99 18:00 Last Update: 1-Oct-24 18:25

Refresh

ᐊ Prev 1...309 310 311 312313314 315 316 317 318 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.