Help with C# generated Excel documents - C# Discussion Boards

Sonia Gupta wrote:
session.abandon removes the key and the value. right?

No, it doesn't.

It marks the Session object for removal. When the request finishes, the entire Session object is removed. The items are never removed from the Session object.

---
single minded; short sighted; long gone;

Sonia Gupta wrote:
i am using the following code
Session["Sonia"] = "11";
Session["Sonia1"] = "12";
Session.Clear();

it renders the Session["Sonia"] and session["Sonia1"] to null.

Actually, it removed the items. If it would just set the items to null, the Session.Count property would still return 2, but clearing the session items makes it return 0.

Sonia Gupta wrote:
Session["Sonia"] = "11";
Session["Sonia1"] = "12";
Session.Abandon();
leaves the session["Sonia"] AND Session["Sonia"] AS IT IS.

Yes. The current session can't be removed until the current request is completed. That would be sawing off the branch you are sitting on.

---
single minded; short sighted; long gone;

Guffa wrote:
can't be removed until the current request is completed

What's the meaning of this line.
if u provide an example.

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

public void generateTabularStructure(DataSet dsItems, HtmlTable tblTemp)
{
DataView dvItems = dsItems.Tables[0].DefaultView;
HtmlTableRow trTemp;
HtmlTableCell tdtemp;
for (int i = 0; i < dvItems.Count; i++)
{
HtmlTable objTable = null;
objTable = getArticleTable(dvItems[i]);
if (i % 2 == 0)
{
trTemp = new HtmlTableRow();
tblTemp.Rows.Add(trTemp);
}
tdtemp = new HtmlTableCell();
trTemp.Cells.Add(tdtemp);
tdtemp.Controls.Add(objTable);

tdtemp = new HtmlTableCell();
trTemp.Cells.Add(tdtemp);
tdtemp.InnerHtml = " ";
}
}

The above code when compiled gives error message
Use of unassigned local variable 'trTemp'
at the line which is bold

but for value i = 0 'trTemp' would be initialized in the if syntax before it is used so the error should not appear

any justification for this compilation error

This is a compilation error. You have described a condition where the value is set at runtime, which the compiler can't know about.

To get round this, change your code to include the following:

HtmlTableRow trTemp = null;
HtmlTableCell tdtemp = null;

Deja View - the feeling that you've seen this post before.

thanks

You're welcome. Big Grin | :-D

Deja View - the feeling that you've seen this post before.

I have 2 Excel files...

1. the original Excel file that was given to me to be converted to a dataset and so I could fill up the SQL Database.
2. the other is the one I retrieved from the database and then generated into an Excel document. used a similar procedure
to that of the tutorial here... a low-tech version of generating Excel files... using the XML spreadsheet style in one of the tutorials...

I open both Excel files (the original and generated excel file) and they look identical and they even contain the exact same data in each cells...

now here's the problem...I need to make a method that checks whether or not they're equivalent or not to see if any data is lost since checking each
cell of a large excel file would take a lot of time...

so I use OleDB that comes with C# Express since we're not suppose to use any 3rd party dlls...
for a temporary method to test whether they're equal is, I try to convert the 2 excel documents to 2 datasets and then compare the two generated datasets
whether or not they are equivalent to each other...

public static DataSet Method()
{
    string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FILE_PATH;Extended Properties=""Excel 8.0;HDR=YES;""";

    OleDbConnection conn = new OleDbConnection(connectionString);
    OleDbCommand cmd = new OleDbCommand("Select * from [Project List$]", conn);
    cmd.CommandType = CommandType.Text;
    OleDbDataAdapter myAdapter = new OleDbDataAdapter(cmd);
    DataSet ds = new DataSet();

    try
    {
        myAdapter.Fill(ds);
        return ds;
    }
    catch(OleDbException ex)
    {
        throw ex;
    }
}

the original converts to a dataset with no problem but when I try to convert the one generated from the database is catches an OleDbException...

OleDBException was caught:
External table is not in the expected format.

how come? and is there any word around to this problem without using any 3rd party dlls? or downloading any additional dlls from Microsoft?

so we tried another method... used XmlDocument to get the dataset... and then compared it to one another and yet they were not equal? any suggestions?

You are getting the exception because the excel file is in xml format. It should be in native xls file format for OleDb to work. You can use Excel object model to convert the xml file to excel format. I have described it here: Excel[^]

#region signature
my articles
#endregion

I get the following error message when trying to run my tests (ctrl-shift-X) :
"column 'TestType' does not belong to table test".
Has anyone found a workaround for this ?

-- modified at 4:07 Monday 10th September, 2007

Johan Lombaard

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein

This seems to be an issue with TFS (and possibly the testrun.config file0. To work round it, create a new test project and run with that.

Deja View - the feeling that you've seen this post before.

Thanks Pete. I tried that, but I still get the stupid message Frown | :(

Johan Lombaard

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein

Are you running the tests on Vista? There seems to be some issues with this.

I got the answer to my problem on this[^] thread.

Deja View - the feeling that you've seen this post before.

I'm running it on XP.
I tried : Create new C# test project, reload, no joy.
Then : Create VB test project, reload original C# project, joy.
Wierd

Johan Lombaard

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein

The problem is when I close the port my program hangs. When I close the serial port, or the form, my program throws an exception, after hanging for a while.

Basically it hangs whenever I call SerialPort.Close();

Help would be greatly appreciated Smile | :)

can you post some code? do you have any program loops reading input from the port? what is the error exception.message?

If it' stuck, DO NOT pull harder!

Hi all,

Any one help me in .NET deployment. I am deploying an project which was created using c# 2005. In this i want to ask the user to enter for an serial key. I tried using the Custom information serail key option, but i feel that it's not good and more secured. I want to keep my own key as serial key and want to validate it. How to do this. plz giude me....

Thanks in advance

Know is Drop, Unknown is Ocean

Need some clarity here, are you trying to come up with your own way of creating serial keys for your project?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Hi All

I need a DLL for convert PDF to Image
It is very urgent

Sakthi

Hi,

I would like to know what language should i use to create a program that includes a search engine searching pdf files (or .rgo files(repligo)).

for example,

pdf file has 9 pages. pages are numbered 1 to 9, i enter 1 into search engine and the program displays pdf file's page 1.

Thanks for your help

Regards

I am getting some serial inputs and storing them into a buffer when I want to place the contents onto the textbox from the buffer...a cross thread violation error comes up...I am running the textbox from the interrupt function of the serial comm. any advise?

Thanks

samuel

This should fix your problem...

<br />
		public Form1()<br />
		{<br />
			<br />
			InitializeComponent();<br />
			<br />
			CheckForIllegalCrossThreadCalls = false;<br />
		}<br />

Look at what I got for the same answer:

http://www.codeproject.com/script/comments/forums.asp?msg=2170602&forumid=1649&Page=2&userid=3539989&mode=all#xx2170602xx[^]

Wow that helps me alot... I have been having trouble with my GUI hanging...

Thanx!!!

Maybe you could edit your original reply where you suggest to disable the check? People who read it might not follow the link to the previous discussions and actually think they have found a solution. And as it often appears to work after a quick test they would be in the dark why their GUI hangs.