Importing Excel Sheet Which Have Dynamic Column Name And Dynamic Number Of Columns - ASP.NET Discussion Boards

Re: Problem with linq to sql

Manas Bhardwaj9-Jun-09 2:29

Manas Bhardwaj

9-Jun-09 2:29

There is a seperate forum on LINQ[^]

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

Write HTML in PDF with iTextSharp

vnsraj9-Jun-09 2:13

vnsraj

9-Jun-09 2:13

Hi All,

I need to create pdf file using iTextSharp. I can write simple text in my pdf file. But How can I add html content in pdf file.

I used string variable to hold html content. But when I use that variable my pdf file content not showing html format.

my Code given below :
private void createPDF()
{

//string newFile = @"N:\.NET\New Document.pdf";
string strContent = "";
StringWriter sw = new StringWriter();
string newFile = Server.MapPath("1.pdf");
Document doc = new Document();
PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(newFile, FileMode.Create));
// Metadata
doc.AddCreator("PDF Printer by Joachim Tesznar");
doc.AddTitle("New PDF Document");

// Add content
doc.Open();
sw.Write(GetMailBodyOrderDetails().ToString());

doc.Add(new Paragraph(sw.ToString()));
doc.Close();
}

#region string GetMailBodyOrderDetails()
public string GetMailBodyOrderDetails()
{
StreamReader StmRdr1 = null;
FileInfo fi1 = null;
string strFileName1 = Request.PhysicalApplicationPath + "Registration.html";
fi1 = new FileInfo(strFileName1);
if (fi1.Exists)
{
StmRdr1 = File.OpenText(strFileName1);
StreamReaderStrLine1 = StmRdr1.ReadToEnd();
// StreamReaderStrLine1 = StreamReaderStrLine1.Replace("<TITLE>", ListingName).Replace("<PRICE>", Price.ToString()).Replace("<DESCRIPTION>", ListingDetail).Replace("<EMAIL>", Email).Replace("<COUNTRY>", Country).Replace("<STATE>", State).Replace("<SUBURB>", City).Replace("<TOPADS>", "No");
StreamReaderStrLine1 = StreamReaderStrLine1.Replace("\r\n", "");
StreamReaderStrLine1 = StreamReaderStrLine1.Replace("", "}").Replace("\t", "");
}
return StreamReaderStrLine1;
}
#endregion

please reply
Thanks
Raj

How to read UNREAD mails from mail server through .netcode???

nkmkrishna9-Jun-09 2:02

nkmkrishna

9-Jun-09 2:02

Hi to all,
How to read UNREAD mails from mail server through .netcode???

Re: How to read UNREAD mails from mail server through .netcode???

saanj9-Jun-09 2:08

saanj

9-Jun-09 2:08

Is your application going to read emails from Exchange Server?

Regards
Saanj

Either you love IT or leave IT...

Re: How to read UNREAD mails from mail server through .netcode???

nkmkrishna9-Jun-09 2:24

nkmkrishna

9-Jun-09 2:24

s I reading mails from exchange server.

Re: How to read UNREAD mails from mail server through .netcode???

saanj9-Jun-09 2:29

saanj

9-Jun-09 2:29

Try out the following CP Article:

Accessing Remote Exchange Server To read/delete mails using WEBDAV[^]

Regards
Saanj

Either you love IT or leave IT...

Re: How to read UNREAD mails from mail server through .netcode???

Abhijit Jana9-Jun-09 3:32

Abhijit Jana

9-Jun-09 3:32

nkmkrishna wrote:
s I reading mails from exchange server.

Which Exchange Server are you using ? If you are using Exchange Server 2007, Microsoft provided a web Services for that (Exchange Web Services [ EWS ] ), using that you can read mail from Exchange server.
Here is some excellent article in Code project by Brij,
Check the Exchange Server Section

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Importing Excel Sheet Which Have Dynamic Column Name And Dynamic Number Of Columns

praveenkumar_mca9-Jun-09 1:24

praveenkumar_mca

9-Jun-09 1:24

I have a quick question regarding my project. I have looked for the information on the web, but was not able to find relevant information.

We are getting Source data from two of our client in the form of Excel Sheet. These Excel sheets
Are generated using reporting services. On examining the excel sheet, I found out that the name Of the columns contain data itself, so the names are not static such as Jan 2007 Sales, Feb 2007 Sales etc etc.
And even the number of columns are not static. It depends upon the range of date selected by the user.

I wanted to know, if there is a way to import Excel sheet using Integration Services by defining the position Of column, instead of column name and I am not sure if there is a way for me to import excel with dynamic Number of columns.

Your help in this respect is highly appreciated!

Thanks,

Praveen Kumar.R

autorefresh

naveen attri9-Jun-09 0:50

naveen attri

9-Jun-09 0:50

i want to refresh my page automatically after 5 sec.
im using java script
its working fine

but i want that this autorefreshing stops after some given time
how to do that ?
is it possible?
help me.
its urgent.

Re: autorefresh

saanj9-Jun-09 0:58

saanj

9-Jun-09 0:58

Use javascript setTimeout not setInterval. setTimeout will cause the page to be refreshed only once.

Regards
Saanj

Either you love IT or leave IT...

Re: autorefresh

Viral Upadhyay9-Jun-09 1:00

Viral Upadhyay

9-Jun-09 1:00

use cleartimeout() function.

Viral
My Site
Tips & Tracks

Re: autorefresh

naveen attri12-Jun-09 2:22

naveen attri

12-Jun-09 2:22

hi thanks for reply
can u please tell me how can i do postback after i use the cleartimeout()

Re: autorefresh

Viral Upadhyay12-Jun-09 9:40

Viral Upadhyay

12-Jun-09 9:40

I don't understand your question.
cleartimeout() is javascript function which will clear your refreshing function if you want to set timer again use settimeout().

If you just want to postback your page with javascript then use, __doPostBack() function.

Viral
My Site
Tips & Tracks

Re: autorefresh

Christian Graus9-Jun-09 1:14

Christian Graus

9-Jun-09 1:14

naveen attri wrote:
how to do that ?
is it possible?
help me.
its urgent.

Ah, the calling card of the moron. Help me, it's urgent. Google broken where you live ?

The answer is pretty common sense. You remove the script that does the auto refresh after a given number of times.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Re: autorefresh

Baran M9-Jun-09 3:08

Baran M

9-Jun-09 3:08

did you try this ?

<meta http-equiv="refresh" content="300">

show alert message when browser tab is closed

ashok@techxygen9-Jun-09 0:24

ashok@techxygen

9-Jun-09 0:24

hi all,

how to show confirm alert message when the user closes the browser tab in asp.net using javascript...

Ashok

Re: show alert message when browser tab is closed

saanj9-Jun-09 0:32

saanj

9-Jun-09 0:32

There is no straight forward way to achieve this. However, you can check the folowing link:

http://aspadvice.com/blogs/getwhatyouwant/archive/2006/09/20/bypass-_2200_The-Web-page-you-are-viewing-is-trying-to-close-the-window_2200_-_2D00_-_2800_simple_2900_.aspx[^]

Regards
Saanj

Either you love IT or leave IT...

Re: show alert message when browser tab is closed

satigar1238-Jul-09 9:22

satigar123

8-Jul-09 9:22

var displayPrompt=true;
if (displayPrompt){
event.returnValue = "are you sure to close?";
}

show alert message when browser is closed

ashok@techxygen9-Jun-09 0:24

ashok@techxygen

9-Jun-09 0:24

hi all,

how to show confirm alert message when the user closes the browser tab in asp.net using javascript...

Ashok

Re: show alert message when browser is closed

Christian Graus9-Jun-09 0:43

Christian Graus

9-Jun-09 0:43

ASP.NET has nothing to do with it. There is a closing event on a form you can hook into in js, as someone else said ( so, why did you ask twice ? )

Moving ListBox Items From One To Another In ASP.NET!!

Sr...Frank8-Jun-09 23:58

Sr...Frank

8-Jun-09 23:58

Hi Guys,

Anybody knows of a good implementation in ASP.NET using C# where you have 2 list boxes and you want to move items between them.

Records will be coming to first list box from database.

Like…
[Available Items] << < > [Select Items]

If not going to use AJAX.

Thanks

Re: Moving ListBox Items From One To Another In ASP.NET!!

Christian Graus9-Jun-09 0:04

Christian Graus

9-Jun-09 0:04

There's tons of examples for this on the web. IT's not an ASP.NET problem, unless you want to do a postback every time. Otherwise, it's a javascript problem.

Re: Moving ListBox Items From One To Another In ASP.NET!!

saanj9-Jun-09 0:07

saanj

9-Jun-09 0:07

Have you tried it by yourself or have you googled for this? I think you might have got lot of answers regarding this if you have tried. By the way, you can try like the following:

ListBox2.Items.Add(ListBox1.SelectedItem);

Regards
Saanj

Either you love IT or leave IT...

Re: Moving ListBox Items From One To Another In ASP.NET!!

Abhijit Jana9-Jun-09 2:30

Abhijit Jana

9-Jun-09 2:30

saanj wrote:
ListBox2.Items.Add(ListBox1.SelectedItem);

I will suggest him do using javascript rather than server side code. Because it will causes unnecessary postback Smile | :)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: Moving ListBox Items From One To Another In ASP.NET!!

saanj9-Jun-09 2:36

saanj

9-Jun-09 2:36

Oh Yeah Abhijeet, you are absolutely right. Smile | :)

But consider a case when the javascript may be disabled on the browser. I know that the proability will be very less. But it would be better if he can write the code in two places. One should be in javascript and the other one should be in code-behind. If the js one fails then the server side code will be executed. I would like to know your point of view regarding this. Smile | :)

Regards
Saanj

Either you love IT or leave IT...

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