Cant Write Large Text File - C# Discussion Boards

#realJSOP11-Jan-10 3:31

11-Jan-10 3:31

Is there a reason you're not using linq-to-xml? It's much simpler (types from memory, so you may need to tweak it a bit)...

XDocument doc = XDocument.Load("myfile.xml");
XElement root = doc.Element["Rooms"];
foreach (XElement element in root.Elements)
{
    int roomID    = Convert.ToInt32(element.Element["RoomRQID"].Value);
    int quantity  = Convert.ToInt32(element.Element["Quantity"].Value);
    int numAdults = Convert.ToInt32(element.Element["NumAdults"].Value);
}

No messing around with InnerText and that kind of crap.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

How do I get the location and size of the upper leftmost cell in a DataGridView?

arnold_w10-Jan-10 22:25

arnold_w

10-Jan-10 22:25

I have a regular DataGridView and RowHeadersVisible is set to true. How do I get the location and size of the cell in the upper leftmost corner (the one to the left of the headings)?

Re: How do I get the location and size of the upper leftmost cell in a DataGridView?

sanforjackass10-Jan-10 23:55

sanforjackass

10-Jan-10 23:55

DataGridView[0,0].value!!!!

Re: How do I get the location and size of the upper leftmost cell in a DataGridView?

arnold_w11-Jan-10 0:02

arnold_w

11-Jan-10 0:02

Thanks, but I figured it out finally:

DataGridView.GetCellDisplayRectangle(-1, -1, true)

appending text

Member 59031010-Jan-10 22:23

Member 590310

10-Jan-10 22:23

hw can i append text to end of a file?

Re: appending text

Nicholas Butler10-Jan-10 22:27

Nicholas Butler

10-Jan-10 22:27

System.IO.File.AppendAllText( string path, string contents )

Nick

----------------------------------
Be excellent to each other Smile | :)

Re: appending text

Abhinav S10-Jan-10 22:59

Abhinav S

10-Jan-10 22:59

MSDN link Here[^].

There are only 10 types of people in this world — those who understand binary, and those who don't.

Cant Write Large Text File

salamonty8610-Jan-10 21:49

salamonty86

10-Jan-10 21:49

Dear all,

I want to create a large .txt file but when i run my code i got a strange thing,
A messagebox say's: "No Symbols are loaded for any call stack frame. The source code cannot be displayed."

and a warning say's "The CLR has been unable to transition from COM context 0x1c2000 to COM context 0x1c2170 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations."

My code is:

string prev="";<br />
<br />
            string connectionString = "Provider=Microsoft.JET.OLEDB.4.0;data source=E:\\ICA_Newspapers.mdb";<br />
<br />
            OleDbConnection conn = new OleDbConnection(connectionString);<br />
<br />
            string sql = "SELECT * FROM All_Analyzed_Corpus";<br />
<br />
            OleDbCommand cmd = new OleDbCommand(sql, conn);<br />
<br />
            conn.Open();<br />
<br />
            OleDbDataReader reader;<br />
            reader = cmd.ExecuteReader();<br />
<br />
            StreamWriter tw = new StreamWriter(Application.StartupPath + "\\TaggedCorpus.txt");<br />
<br />
            StringBuilder text = new StringBuilder();<br />
            <br />
            <br />
            while (reader.Read())<br />
            {<br />
                //if new line<br />
                if (reader.GetValue(1).ToString() == "/D")<br />
                {<br />
                    //if end of line<br />
                    text.Append("</s>");<br />
                    //text.Capacity = text.Length;<br />
                    // write a line of text to the file<br />
                    <br />
                    tw.WriteLine(text);<br />
                    tw.Flush();<br />
                    text = text.Remove(0, text.Length);<br />
<br />
                    text.Append("<s> ");<br />
                    prev = "/D";<br />
                }<br />
                else if (reader.GetValue(1).ToString() == "/T" && prev != "/D")<br />
                {<br />
                    //if end of line<br />
                    text.Append("</s>");<br />
                    //text.Capacity = text.Length;<br />
                    // write a line of text to the file<br />
                    tw.WriteLine(text);<br />
                    tw.Flush();<br />
                    <br />
                    text = text.Remove(0, text.Length);<br />
<br />
                    text.Append("<s> ");<br />
                    prev = "/T";<br />
                }<br />
                else if (reader.GetValue(1).ToString() == "/P" && prev != "/T")<br />
                {<br />
                    //if end of line<br />
                    text.Append("</s>");<br />
                    //text.Capacity = text.Length;<br />
                    // write a line of text to the file<br />
                    tw.WriteLine(text);<br />
                    tw.Flush();<br />
<br />
                    text = text.Remove(0, text.Length);<br />
<br />
                    text.Append("<s> ");<br />
                    prev = "/P";<br />
                }<br />
<br />
                <br />
<br />
                if(reader.GetValue(5).ToString().Contains("/"))<br />
                {<br />
                    pr1 = reader.GetValue(5).ToString().Split(char.Parse("/"))[1];<br />
                }<br />
                else<br />
                {<br />
                    pr1 = reader.GetValue(5).ToString();<br />
                }<br />
<br />
                if (reader.GetValue(6).ToString().Contains("/"))<br />
                {<br />
                    pr2 = reader.GetValue(6).ToString().Split(char.Parse("/"))[1];<br />
                }<br />
                else<br />
                {<br />
                    pr2 = reader.GetValue(6).ToString();<br />
                }<br />
<br />
                if (reader.GetValue(7).ToString().Contains("/"))<br />
                {<br />
                    pr3 = reader.GetValue(7).ToString().Split(char.Parse("/"))[1];<br />
                }<br />
                else<br />
                {<br />
                    pr3 = reader.GetValue(7).ToString();<br />
                }<br />
                if (reader.GetValue(8).ToString().Contains("/"))<br />
                {<br />
                    stm = reader.GetValue(8).ToString().Split(char.Parse("/"))[1];<br />
                }<br />
                else<br />
                {<br />
                    stm = reader.GetValue(8).ToString();<br />
                }<br />
<br />
                if (reader.GetValue(9).ToString().Contains("/"))<br />
                {<br />
                    suf1 = reader.GetValue(9).ToString().Split(char.Parse("/"))[1];<br />
                }<br />
                else<br />
                {<br />
                    suf1 = reader.GetValue(9).ToString();<br />
                }<br />
<br />
                if (reader.GetValue(10).ToString().Contains("/"))<br />
                {<br />
                    suf2 = reader.GetValue(10).ToString().Split(char.Parse("/"))[1];<br />
                }<br />
                else<br />
                {<br />
                    suf2 = reader.GetValue(10).ToString();<br />
                }<br />
<br />
                if (reader.GetValue(14).ToString().Contains("/"))<br />
                {<br />
                    cas = reader.GetValue(14).ToString().Split(char.Parse("/"))[1];<br />
                }<br />
                else<br />
                {<br />
                    cas = reader.GetValue(14).ToString();<br />
                }<br />
<br />
<br />
                text.Append(pr1 + "+" + pr2 + "+"<br />
                    + pr3 + "+" + stm + "+" + suf1<br />
                    + "+" + suf2 + "+" + cas + " ");<br />
<br />
<br />
                text = text.Replace(" +", " #+");<br />
                text = text.Replace("+++", "+#+#+");<br />
                text = text.Replace("++", "+#+");<br />
                text = text.Replace("+ ", "+# ");<br />
<br />
                //Thread.Sleep(2000);<br />
                //tw.Close();<br />
                <br />
            }<br />
<br />
            // close the stream<br />
            tw.Close();<br />
            <br />
            reader.Close();<br />
            conn.Close();<br />
<br />

Thanks in advance...

Re: Cant Write Large Text File

Covean10-Jan-10 22:13

Covean

10-Jan-10 22:13

It seems that a COM object needs to respond within 60 seconds, but you create someting in this time.
Is this an operation you run in your main tread (or the thread which created a window)?

I would try to execute Application.DoEvents(); every loop iteration.

Greetings
Covean

Re: Cant Write Large Text File

salamonty8611-Jan-10 0:27

salamonty86

11-Jan-10 0:27

When I did Application.DoEvents(); no message appears but the file size stopped at 7805 kb and the program stopped and thats cant be because the file must end with the last record in my database table.

Re: Cant Write Large Text File

Covean11-Jan-10 1:19

Covean

11-Jan-10 1:19

Are there no exceptions?

I looked over your code and couldn't find any problem, so I tried if there is maybe a problem with the filesize (I haven't really awaited that there is an error and there is no error. I was able to create an 9GB large text file without problems).

Do you use any other COM-objects in your project?

At next I would try to do this database-"export" in an own thread.

Greetings
Covean

Making a maths solver

Matt Cavanagh10-Jan-10 21:37

Matt Cavanagh

10-Jan-10 21:37

Hi, in my database I have a bunch of sums which for example can be broken down to (100*25)/3 or whatever the case may be.
How would I work out programatically the sum in the string in my C# app?
Thanks.

Strive to be humble enough to take advice, and confident enough to do something about it.

Re: Making a maths solver

Rob Philpott10-Jan-10 22:13

Rob Philpott

10-Jan-10 22:13

Good question. I had thought .NET provided something for doing that sort of thing, but can't find it.

There are a number of projects on the net which provide functionality for doing that sort of thing. Here's one:

http://www.bestcode.com/html/bcparser_net.html

Regards,
Rob Philpott.

Re: Making a maths solver

Matt Cavanagh10-Jan-10 22:31

Matt Cavanagh

10-Jan-10 22:31

Nice find, thanks Smile | :)

.
Found a free one here: http://www.c-sharpcorner.com/UploadFile/patricklundin/MathExpParser12062005062213AM/MathExpParser.aspx[^] which also seems quite powerful.

Strive to be humble enough to take advice, and confident enough to do something about it.

Re: Making a maths solver

PIEBALDconsult11-Jan-10 3:53

PIEBALDconsult

11-Jan-10 3:53

Something like this[^]?

How to convert text file pdf?

Sunil G10-Jan-10 21:37

Sunil G

10-Jan-10 21:37

Hi,

I want to convert my text file to pdf file ?
is it possible in C#?

Thanking You
Sunil G.

modified on Monday, January 11, 2010 5:00 AM

Message Closed

10-Jan-10 22:13

stancrm

10-Jan-10 22:13

Message Closed

modified 23-Nov-14 7:13am.

Re: How to export data into excel or pdf?

Sunil G10-Jan-10 23:06

Sunil G

10-Jan-10 23:06

I think PDFSharp is third party component.
I dont want to use third party.

Re: How to export data into excel or pdf?

Dave Kreskowiak11-Jan-10 1:13

Dave Kreskowiak

11-Jan-10 1:13

You don't have a choice. There is nothing in the .NET Framework that reads/writes .PDF files natively.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: How to export data into excel or pdf?

Sunil G11-Jan-10 21:44

Sunil G

11-Jan-10 21:44

Id PDFsharp copyrighted or free source ?
Can i use PDFSharp in my C# application?
Can u give the component?

Re: How to export data into excel or pdf?

Dave Kreskowiak12-Jan-10 1:10

Dave Kreskowiak

12-Jan-10 1:10

Why don't you go find out for yourself: PDFSharp.com[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

buffer size in c#

anishkannan10-Jan-10 21:34

anishkannan

10-Jan-10 21:34

hi..

what is the maximum buffer size in c#.

while i use
byte [] byte = new byte [MAX];

how much will i set maximum value MAX variable.

have ant restriction to set maximum buffer size . can i use this long.MaxValue

Thanks.

Re: buffer size in c#

Nicholas Butler10-Jan-10 21:42

Nicholas Butler

10-Jan-10 21:42

The effective limit is how much RAM your users are going to have.

Int32.MaxValue is about 2GB, which is probably too much to assume is present on your users' machines

Int64.MaxValue is about 10¹⁹ which is a ridiculously large number.

Why do you need such a large buffer in the first place? You might want to re-think your algorithm.

Nick

----------------------------------
Be excellent to each other Smile | :)

Re: buffer size in c#

anishkannan10-Jan-10 23:28

anishkannan

10-Jan-10 23:28

i will consider ... thanks for your reply

Refresh form1 from form2

misCafe10-Jan-10 20:52

misCafe

10-Jan-10 20:52

Dear developers,

I am coding a very small project for my study. I want to refresh form1 after form2 is closed. For example, I open form1 and click one button to open form2 and in form2 I can insert data to the database (ex : tblItem). In addition, combobox in form1 retrieves data from the database (tblItem) too. So, after inserting data from form2 and when I close the form2, I want the comboxbox in form1 refresh to retrieve the last update of tblItem data.

Please advise, thanks.

Visoth

Chuon Visoth
Angkor Wat - Cambodia
asp.net - c sharp beginner

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