|
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.
|
|
|
|
|
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.
|
|
|
|
|
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"))
|
|
|
|
|
Hi
I was wondering how i can upload pictures with the fck editor?
best regards
Örvar
|
|
|
|
|
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[^] 
led mike
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
I believe it's different fonts.
|
|
|
|
|
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
|
|
|
|
|
will it store in each single node ?
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
dhandapani_pp wrote: please give me the solution for this with code.
Gimme your pay check 
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]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Send me code for that one
|
|
|
|
|
One thing you can do
Take a hiddenvariable.set it 0 .Increment it by one every check.When it excedds from 3 show a error message.
Cheers!!
Brij
|
|
|
|
|
Can u send me code for this
|
|
|
|
|
I have some data passed to a function as a string like:
"<?xml version=\"1.0\" encoding=\"utf-16\"?><Patient xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><FirstName>Joe</FirstName><LastName>Klink</LastName></Patient>"
I load this data into an XmlDocument object as follows:
mXmlDocument.LoadXml(var) - var has the xml string above
how can I validate this XmlDocument object against an existing schema.
Background: I can easily validate an xml file against a schema if am reading it from a physical file using XmlReader. My challenge is when am dealing with a loaded XmlDocument.
Thanks
|
|
|
|
|
XMLDocument.LoadXML supports loading from a XMLReader instance. XMLReader can be loaded from a stream. You can make a stream from the XML string you have. So if you know how to validate on a XMLReader, I think it can be applied here.
|
|
|
|
|
Thanks man.
I had a feeling this is the work around I would need to use. The thing I have to focus on now is how to 'make a stream from the XML string'. I am googling my way to it but if you have some quick pointers I will be glad to hear. Thanks once again.
|
|
|
|
|
Use the other overload which takes a TextReader instance. Your code would be
StringReader stringReader = new StringReader(YourXMLString);
XMLReader reader = XMLReader.Create(stringReader,settings);
XMLDocument document = new XMLDocument();
document.LoadXML(reader); StringReader is a subclass of TextReader.
|
|
|
|
|
Your proposal is very correct. Though with my mXmlDocument, all I did was:
XmlReader mXmlReader = XmlReader.Create(new StringReader(mXmlDocument.OuterXml), mReaderSettings)
|
|
|
|
|
For validating a XMLDocument object you have to follow the below steps:
first create the XmlReaderSettings object
XmlReaderSettings settings = new XmlReaderSettings();
settings.Schemas.Add("urn:xmlns:25hoursaday-com:my-bookshelf", xsd);
settings.ValidationEventHandler += new ValidationEventHandler(ValidationCallback);
settings.ValidationType = ValidationType.Schema;
Then create the validating XmlReader object and the XmlDocument object.
XmlDocument mXmlDocument = new XmlDocument();
mXmlDocument.Load(XmlReader.Create(document, settings));
Now validate the XMLdocument
mXmlDocument.Validate(new ValidationEventHandler(ValidationCallback), element.ParentNode);
Cheers!!
Brij
|
|
|
|
|
how i can refresh datagrid of contentplaceholder1 when contentplaceholder2 panel input data in database using ajax. i am not want to refresh? 
I will do my best?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
