xslt template for creating excel file with multiple worksheets - ASP.NET Discussion Boards

Re: Generate PDF documents from a HTML page using ASP.NET

Bernhard Hiller31-Jul-13 22:35

31-Jul-13 22:35

In which of the lines do you get that error?
And is that img src="../Images/image1.png" ever shown correctly on your page?

Re: Generate PDF documents from a HTML page using ASP.NET

GopalakrishnanPS1-Aug-13 2:15

GopalakrishnanPS

1-Aug-13 2:15

image is showing correctly in the page. but the error comes when i crteating pdf.

Error comes when i parse the html elements. it takes wrong url path for images.

C#

<pre lang="c#">
htmlparser.Parse(sr);

Re: Generate PDF documents from a HTML page using ASP.NET

Bernhard Hiller1-Aug-13 3:50

Bernhard Hiller

1-Aug-13 3:50

And what about using a full URL, i.e. img src="http://www.yourserver.com/images/myimage.jpg"?

Re: Generate PDF documents from a HTML page using ASP.NET

GopalakrishnanPS1-Aug-13 5:06

GopalakrishnanPS

1-Aug-13 5:06

nouw im developing in Localhost

Manually handling ASP.NET sessions

Desmond Lim31-Jul-13 15:32

Desmond Lim

31-Jul-13 15:32

I have a webserver that will be running an ASP.NET application and a WCF service.

The ASP.NET application would require the user to log in before he/she can use the WCF service. I want to handle the sessions so that the user will be logged out automatically after a period of time.

This is where I'm stuck, for the WCF application, I can check that the user is still using the system (i.e. the session gets updated every time the WCF application is called) but for the ASP.NET side, I'm just wondering how can I go about joining these 2 together. Because currently, the ASP.NET application would log the user off since what is happening after login doesn't touch the ASP.NET application which means that the user cannot access the WCF service.

I want to know if I can manually handle the ASP.NET sessions so that I can use the same session table (as the WCF service) in the database.

Thanks.

3-layer application

larsp77731-Jul-13 9:28

larsp777

31-Jul-13 9:28

Even though I now a bit about Web Forms I really know more about programing Window-applications.

I want to make a site using MVC but only the pattern, not the technology.

I read something about object data sources but must you use that?

Can someone please give me an example.

Re: 3-layer application

Richard MacCutchan31-Jul-13 21:05

Richard MacCutchan

31-Jul-13 21:05

Google will find lots of samples and general articles that explain the MVC pattern.

Use the best guess

xslt template for creating excel file with multiple worksheets

kanniga31-Jul-13 2:01

kanniga

31-Jul-13 2:01

I have used the follwing code:
The first sheet has the dataset value.But the second shhet doesnt have any value.I dont knw where the second data will be added to the XML writer cod part.

protected void btnExport_Click(object sender, EventArgs e)
{

string procInfo = "type='text/xsl' href='" + "\\transform.xslt" + "'";//Processing info for XSLT
string curdate = DateTime.Now.ToString().Replace(":", "").Replace("/", "").Replace(" ", "");
//string FileName = curdate + "_" + "Details_test.xls";
string TempPath = Server.MapPath("../Uploads");
string XMLPath=TempPath+ "\\Details.xml"; //temp path to store the XML file
string XLSPath = TempPath + "\\Details.xls";//temp path to store the XLS file

//Write the dataset as XML file with some XSLT processing information
using (XmlTextWriter tw = new XmlTextWriter(XMLPath ,
null))
{
tw.Formatting = Formatting.Indented;
tw.Indentation = 10;
tw.WriteStartDocument();
DataSet ds = GetDetails1();
ds.Tables[0].TableName = "Detail1";
DataSet ds1 = GetDetails2();
ds1.Tables[0].TableName = "Detail2";
tw.WriteProcessingInstruction("xml-stylesheet", procInfo);
ds.WriteXml(tw);
//ds1.WriteXml(tw);
}

XmlDataDocument xmldoc = new XmlDataDocument();
xmldoc.Load(XMLPath);
XslCompiledTransform xsl = new XslCompiledTransform();
xsl.Load(Server.MapPath(".")+"\\transform.xslt");

using (XmlTextWriter tw = new XmlTextWriter(XLSPath, System.Text.Encoding.UTF8))
{
tw.Formatting = Formatting.Indented;
tw.Indentation = 3;
tw.WriteStartDocument();
xsl.Transform(xmldoc, null, tw);//Performa XSLT transformation.
}

//Streams the generated XLS file to the user
byte[] Buffer = null;
using (FileStream MyFileStream = new FileStream(XLSPath, FileMode.Open))
{
// Total bytes to read:
long size;
size = MyFileStream.Length;
Buffer = new byte[size];
MyFileStream.Read(Buffer, 0, int.Parse(MyFileStream.Length.ToString()));
}
Response.ContentType = "application/xls";
string header = "attachment; filename=" +"Details.xls";
Response.AddHeader("content-disposition", header);
Response.BinaryWrite(Buffer);
Response.Flush();
Response.End();

}

Re: xslt template for creating excel file with multiple worksheets

kanniga1-Aug-13 0:45

kanniga

1-Aug-13 0:45

I have used the below code.and the corresponding workbooks are added with the data values.

DataSet ds = new DataSet();

Datatable dt1;
dt1 = Details1();
Datatable dt2;
dt1 = Details2();
Datatable dt3;
dt1 = Details3();
ds.Tables.Add(dt1.Copy());
ds.Tables.Add(dt2.Copy());
ds.Tables.Add(dt3.Copy());

using (XmlTextWriter tw = new XmlTextWriter(XMLPath ,
null))
{
tw.Formatting = Formatting.Indented;
tw.Indentation = 10;
tw.WriteStartDocument();
tw.WriteProcessingInstruction("xml-stylesheet", procInfo);
ds.WriteXml(tw);

}

Print to serial port printer from the browser (asp.net web app:)

sk_ko30-Jul-13 15:26

sk_ko

30-Jul-13 15:26

Hi, friends,
please answer to me.

I want to print to serial printer from asp.net web application,
is it possible?
the printer is using serial port, and small one for printing queue ticket, or billing receipts.
is it possible to print on such kind of printer from the browser?
please suggest me on this.

best regards

Re: Print to serial port printer from the browser (asp.net web app:)

Ron Beyer30-Jul-13 15:47

Ron Beyer

30-Jul-13 15:47

I think instead of printing from the web app that you insert the data into a database then use a desktop app to watch for new records and print them out. That way you can disconnect the web app from the desktop side.

ASP.NET CMS recommendation for a small website

devenv.exe30-Jul-13 4:16

devenv.exe

30-Jul-13 4:16

If i want to develop a 'small' website based on ASP.NET but using a free content management system, what would you strongly recommend.

What is your take on kentico[^] or http://umbraco.com/[^]

"Coming soon"

Re: ASP.NET CMS recommendation for a small website

Rahul Rajat Singh31-Jul-13 0:25

Rahul Rajat Singh

31-Jul-13 0:25

Definitely Umbraco.

Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.

Re: ASP.NET CMS recommendation for a small website

Jahanzaib Rahman1-Aug-13 21:05

Jahanzaib Rahman

1-Aug-13 21:05

Yes go with Umbraco. It's a good one

Re: ASP.NET CMS recommendation for a small website

Dusara Maulik12-Aug-13 9:40

Dusara Maulik

12-Aug-13 9:40

You can also go with mojoPortal[^]

Message Removed

30-Jul-13 3:55

devenv.exe

30-Jul-13 3:55

Message Removed

Automate OAuth2

y_chen30-Jul-13 3:12

y_chen

30-Jul-13 3:12

Good morning,

I'm working on a project where I've to connet to a provider server. This server uses OAuth2 techmology for authentication. You can find the sandbox example here http://sandbox.ihealthlabs.com/contentfiles/files/SandboxAPISample.zip and you can use the credentials sandboxuser@ihealthlabs.com with password 111111 .

OK, this example allows you to access and view the informations with an user but I want to make a log-like page where I will make access and extract the datas of many users and update an our database.

But I don't know where to start.
I found some libraries and examples but always for Facebook, Twitter etc...

The only documentatios that I have is the pdf inside this zip file http://developer.ihealthlabs.com/contentfiles/files/Open%20API%20Protocol.zip

Please, can you help me?

Thank you

treeview in asp.net

RajivRanjan Yadav30-Jul-13 2:24

RajivRanjan Yadav

30-Jul-13 2:24

hello sir,
how to bind local Computer drivers in treeview as well Directories using asp.net c#?.

please sir give me source code on Email:- rrajiv91@gmail.com

thanks sir.

Re: treeview in asp.net

Vani Kulkarni30-Jul-13 20:08

Vani Kulkarni

30-Jul-13 20:08

Hello,
Check the answer in this link.
Treeview in ASP.Net[^]

Thanks & Regards,
Vani Kulkarni

asp.net

Sumathi Sivaraj30-Jul-13 2:05

Sumathi Sivaraj

30-Jul-13 2:05

i need the solution for configuring IIS for securing web application. Please help me Sir/Madam...

yours truly
S. Sumathi

Re: asp.net

Vani Kulkarni30-Jul-13 20:11

Vani Kulkarni

30-Jul-13 20:11

Take a look at following links, see if that is what you are looking for:

secure-an-iis-web-server-with-these-10-steps/[^]
IIS Tutorial[^]

Thanks & Regards,
Vani Kulkarni

Rating list Binding

VishwaKL30-Jul-13 0:21

VishwaKL

30-Jul-13 0:21

Hi guys,

i have a data base table which has comments, users, and rating, i have to bind that rating information in the form stars according to individual user, like 1st user rated 1 so 1 star, 2nd user rated 3 so 3 star, what is the best way to achieve this.

Re: Rating list Binding

Dholakiya Ankit10-Sep-13 1:54

Dholakiya Ankit

10-Sep-13 1:54

just googling i found

http://stackoverflow.com/questions/15707759/how-to-create-a-list-of-top-rated-articles-for-a-period-of-time-asp-net-c-shar[^]

http://www.dotnetcurry.com/ShowArticle.aspx?ID=440[^]

AJAX ASP.NET Rating Control[^]

Smile | :)

Re: Rating list Binding

VishwaKL10-Sep-13 16:53

VishwaKL

10-Sep-13 16:53

I was asked for average rating like 3 people rated the item average may come like 1.2, 3.5 that rating i have to bind from code/jquery or any technology.

I also googled and got the links which you have given anyhow thanks for the reply.

If you come to know the average binding of rating control please reply back

Thanks
Vishwa

Re: Rating list Binding

Dholakiya Ankit10-Sep-13 17:06

Dholakiya Ankit

10-Sep-13 17:06

its very simple bro
enter this rating in to datbase

people have enter 2,3,4
then find average of that one select avg((2+3+4)/3)

Smile | :)

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