Data to temporary XLS with Multiple Worksheets and then emailed. - ASP.NET Discussion Boards

aref8720-Aug-08 9:53

20-Aug-08 9:53

Hello

I use from a compress C# code in HttpCompression.cs and i use from two methods in sercice.cs
one for before compress
other for after compress

DO I do it true?

also i added HttpCompression.dll to web.config
<httpmodules>
<add name="HttpCompression">
type="Behrouz.Compression.HttpCompression, HttpCompression"/>

C# code for compress:
its file is HttpCompression.cs

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.Services.Protocols;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.VisualBasic;
using System.IO;
using System.IO.Compression;
using Microsoft.CSharp;

/// <summary>
/// Summary description for HttpCompression
/// </summary>
namespace Behrouz.Compression
{
public class HttpCompression : IHttpModule
{
//public HttpCompression()
// {
//
// TODO: Add constructor logic here
//
// }

void IHttpModule.Dispose()
{

}

void IHttpModule.Init(System.Web.HttpApplication context)
{
context.BeginRequest += this.onZip;
}

public void onZip(object sender, EventArgs e)
{
HttpApplication app = (HttpApplication)sender;
string encodings = app.Request.Headers.Get("Accept-Encoding");
if (encodings == null)
return;
Stream baseStream = app.Response.Filter;
encodings = encodings.ToLower();
if ((encodings.Contains("gzip")))
{
app.Response.Filter = new GZipStream(baseStream, CompressionMode.Compress);

app.Response.AddHeader("Content-Encoding", "gzip");
}
else if (encodings.Contains("deflate"))
{
app.Response.Filter = new DeflateStream(baseStream, CompressionMode.Compress);
app.Response.AddHeader("Content-Encoding", "deflate");
}

}
}
}

C# code in server side:
its file is service.cs

sing System;
using System.Web;
using System.Web.Services;
using System.Data;
using System.IO.Compression;
using System.Data.SqlClient;
using System.Web.Services.Protocols;
using Behrouz.Compression;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Diagnostics.DebuggerStepThroughAttribute(), System.ComponentModel.DesignerCategoryAttribute("code"), System.Web.Services.WebServiceBindingAttribute(Name = "Service1Soap", Namespace = "http://tempuri.org/")]
public class Service : System.Web.Services.WebService
{
public Service () {

//Uncomment the following line if using designed components
//InitializeComponent();
}

[WebMethod]
[System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://tempuri.org/getproducts", RequestNamespace = "http://tempuri.org/", ResponseNamespace = "http://tempuri.org/", Use = System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle = System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]

public string HelloWorldAfterCompress() {
return "Hello World";
}
[WebMethod]
public string HelloWorldbeforeCompress()
{
return "Hello World";

}

}

Re: compress

Christian Graus20-Aug-08 15:10

Christian Graus

20-Aug-08 15:10

aref87 wrote:
DO I do it true?

I don't know, does it seem to work ?

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

Re: compress

aref8720-Aug-08 15:26

aref87

20-Aug-08 15:26

hello
i do not underestant your question
what is your SCOPE?

Re: compress

Christian Graus20-Aug-08 15:50

Christian Graus

20-Aug-08 15:50

Gosh - are you serious ? You posted a bunch of code and said 'is this right'. No-one is going to trawl through your code with such a vague question. Why do you ask ? Is it working as expected ? What is your specific concern ?

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

Re: compress

aref8720-Aug-08 19:48

aref87

20-Aug-08 19:48

Hello

I want to use compressing of message for my weservice.

I want a dataset that it is full of orders table of Northwind,then i want send it to client compressin.

I tried with 2 ways

the first way is in this address:[it is vb.net and i converted to C#]
http://www.dotnetjunkies.com/PrintContent.aspx?type=tutorial&id=46630AE2-1C79-4D5F-827E-6C2857FF1D23

the second way is in this address:
http://www.barnamenevis.org/forum/showthread.php?t=55129&page=1

that the second address is codes that you saw in my post in codeproject.

i tried very much for getting a true answer about compressing,but non of the above could guid
me to a true result.

it seems that i have lost true way for getting a good result , and i want anyone help me.

Re: compress

aref8721-Aug-08 22:01

aref87

21-Aug-08 22:01

Hello
Is there one who help me?
with thanks

Re: compress

aref8722-Aug-08 3:12

aref87

22-Aug-08 3:12

Hello

when i use from using ICSharpCode.SharpZipLib or
using ICSharpCode.SharpZipLib.zip

and then when i want to produce dll file ,i go to following path:

D:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

and i produce dll file from this code:
csc /t:library /r:System.dll,System.Web.dll D:\inetpub\wwwroot\myApp\App_Code\HttpCompression.cs

but i get this error:
there is not ICSharpCode.SharpZipLib.zip

But i add ICSharpCode.SharpZipLib.dll to my project and put it to bin folder.

Data to temporary XLS with Multiple Worksheets and then emailed.

gamerdrew20-Aug-08 9:16

gamerdrew

20-Aug-08 9:16

Hi,
This is a rather obscure question but:

I was wondering if there was a way that when a user clicks a button to take data(either in a single or multiple datagrids, or arraylist etc,doesnt matter) and store it in a xls with multiple worksheets and then email it as an attachement? All automatically without using Response.ContentType = "application/ms-excel" or Response.ContentType = "application/vnd.ms-excel" or any other technique that will open up excel on the clients machine? Currently I use my sqlserver 2000 database(xp_smtp_sendmail stored procedure) to send the email.

So far my only idea is to use the server side technique of having excel installed on my web server. Create a template of the file I want on the server and having it fill in the relevant data each time it needs to be sent. Then send the absolute path as a parameter to my database that will then email it as an attachment.

My only other idea would be to use the client to create the xls file and then instead of having it open on the client, have it be sent to the server and then emailed?

Sorry if this is confusing, I will be happy to elaborate,
thanks,
Drew.

Re: Data to temporary XLS with Multiple Worksheets and then emailed.

gamerdrew20-Aug-08 10:44

gamerdrew

20-Aug-08 10:44

NM, I think i got this working using a 3rd party dll to save locally to xls and then used SmtpMail.Send.
Thanks for reading,
Drew.

Re: Data to temporary XLS with Multiple Worksheets and then emailed.

Jörgen Andersson20-Aug-08 11:02

Jörgen Andersson

20-Aug-08 11:02

gamerdrew wrote:
Sorry if this is confusing

A bit, what I don't understand is why you want to send a mail with the file.
If you don't want it opened on the client you can use Response.AppendHeader

Response.ContentType = "application/ms-excel"
Response.AppendHeader("Content-Disposition","attachment; filename=testfile.xls")
Response.TransmitFile( Server.MapPath("~/temp/testfile.xls"))

FCK editor

shadow1720-Aug-08 6:19

shadow17

20-Aug-08 6:19

Hi
I was wondering how i can upload pictures with the fck editor?

best regards

Örvar

Re: FCK editor

led mike20-Aug-08 9:40

led mike

20-Aug-08 9:40

shadow17 wrote:
I was wondering how i can upload pictures with the fck editor?

You have fallen victim to a navigation error, the FCKeditor forums are over here[^] Roll eyes | :rolleyes:

led mike

Japanese currency symbol is displaying a single strikethrough on “Y” (i.e. “¥”) instead of double strikethrough (i.e. “¥”).

mdpavel20-Aug-08 4:29

mdpavel

20-Aug-08 4:29

Hi,
Can anyone tell me why "Japanese currency symbol is displaying a single strikethrough on “Y” (i.e. “¥”) instead of double strikethrough (i.e. “¥”)." I am useing Asp.net and C#.

Thanks in advance

Re: Japanese currency symbol is displaying a single strikethrough on “Y” (i.e. “¥”) instead of double strikethrough (i.e. “¥”).

Manas Bhardwaj20-Aug-08 5:19

Manas Bhardwaj

20-Aug-08 5:19

mdpavel wrote:
single strikethrough on “Y” (i.e. “¥”) instead of double strikethrough (i.e. “¥”).

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Japanese currency symbol is displaying a single strikethrough on “Y” (i.e. “¥”) instead of double strikethrough (i.e. “¥”).

Jörgen Andersson20-Aug-08 5:55

Jörgen Andersson

20-Aug-08 5:55

I believe it's different fonts.

Convert XML file to an ASPX page

Krishnaraj Barvathaya B20-Aug-08 3:08

Krishnaraj Barvathaya B

20-Aug-08 3:08

Hi
I have an xml file stored in database. This XML files defines asp/html controls, its size, layout etc. Sample XML file is given below:

<Label Field="Label1" Top="22" Left="24" Height="31" Width="485" Align="Left" Caption="Title Text"><br />
  <Font Name="Garamond" Size="27" Color="FFFFFF"/><br />
</Label><br />
<Image Field="Image1" Top="0" Left="0" Height="80" Width="735" File="Image1.jpg"/><br />
<Label Field="Label2" Top="25" Left="18" Height="29" Width="493" Align="Left" Caption="Sub Title"><br />
  <Font Name="Garamond" Size="24" Color="FFFFFF"/><br />
</Label><br />

Is there any way without XSLT I can tranform this XML file into an ASPX/html page during run time.

Thank you,

Krishnaraj Barvathaya B

Re: Convert XML file to an ASPX page

Abhijit Jana20-Aug-08 4:14

Abhijit Jana

20-Aug-08 4:14

will it store in each single node ?

cheers,
Abhijit
Check My Latest Article

Re: Convert XML file to an ASPX page

Manas Bhardwaj20-Aug-08 4:27

Manas Bhardwaj

20-Aug-08 4:27

Krishnaraj Barvathaya B wrote:
Is there any way without XSLT I can tranform this XML file into an ASPX/html page during run time.

Not a nice idea though, but you can parse this xml and create control at runtime.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Convert XML file to an ASPX page

Krishnaraj Barvathaya B20-Aug-08 4:49

Krishnaraj Barvathaya B

20-Aug-08 4:49

Thank you for your comments. Now I think it won’t be possible to convert to html from xml without defining a XSLT. Can anybody tell me the best way to write an xslt for the above code segment? All the controls have been defined in the xml in the same order it must appear in the web page.

Krishnaraj Barvathaya B

Re: Convert XML file to an ASPX page

Christian Graus20-Aug-08 15:11

Christian Graus

20-Aug-08 15:11

Converting to HTML is a canonical example, any XSLT book or website will show examples.
\

Christian Graus

No longer a Microsoft MVP, but still happy to answer your questions.

Listbox-Multiple selection

dhandapani8420-Aug-08 2:46

dhandapani84

20-Aug-08 2:46

How to validate listbox control. in listbox control has many items. The selection mode for this is multiple.The condition is that user can select only 3 items.if it exceeds error msg to display. please give me the solution for this with code.

Re: Listbox-Multiple selection

Manas Bhardwaj20-Aug-08 2:48

Manas Bhardwaj

20-Aug-08 2:48

dhandapani_pp wrote:
please give me the solution for this with code.

Gimme your pay check Smile | :)

Anyway, the idea would be to check the number on selected items on every SelectedIndexChanged Event. If it is greater than 3, show the error message. Rose | [Rose]