Ad:

C# Discussion Thread
Unsolved
Views: 2469

You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page

Apr 19th, 2009

Re: saving listview data in text form

Click to Expand / Collapse Quote originally posted by JerryShaw ...

SubString didn't work because you are using a 0 when you should be using a 1.
Looking further while to correct that.... back in a bit.
// Jerry

Using 1 at Substring does not work too. I show you example of my result. Example like I have 2 items in the ListView.

C# Syntax (Toggle Plain Text)
ID     Name
23,    45
56,    78
ID     Name
23,    45
56,    78

But the result is not what i want above, the result is below there.

C# Syntax (Toggle Plain Text)
ID	 Name	
,23,45
 
,56,78
ID	 Name	
,23,45

,56,78

You can see the empty line between that and that when i use substring(0). When i used Substring(1), here is result:

C# Syntax (Toggle Plain Text)
 ID	 Name	,232,4545
,232,45754
 ID	 Name	,232,4545
,232,45754

No empty string but the first item is in the line of the header.

NguyenThai

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

15 posts
since Sep 2006

Permalink

Apr 19th, 2009

Re: saving listview data in text form

Untested modified version

C# Syntax (Toggle Plain Text)
 private void saveButton_Click(object sender, EventArgs e)
        {
            string st1= string.Empty;
            FileStream file = new FileStream(@"C:\sample.playist", FileMode.Create, FileAccess.Write);
            StreamWriter sw = new StreamWriter(file);
            for (int col = 0; col < listView1.Columns.Count; col++)
            {
                st1 += (" " + listView1.Columns[col].Text.ToString() + "\t");             
            }
            sw.WriteLine(st1);
            st1 = string.Empty;
 
            for (int row = 0; row < listView1.Items.Count; row++)
            {
                //st1 = "\r\n"; the writeline will take care of this
                for (int col = 0; col < listView1.Columns.Count; col++)
                {
                    // used concat operator, and string format to get things positioned right
                    // Note that each value starts with a comma.
                    st1 += string.Format("{0},\t", listView1.Items[row].SubItems[col].Text.ToString());
                }
                st1 = st1.Substring(0, st1.Length - 2); // remove the last comma and tab chars
                sw.WriteLine(st1);
            }
            sw.Flush();
            sw.Close();
        }
 private void saveButton_Click(object sender, EventArgs e)
        {
            string st1= string.Empty;
            FileStream file = new FileStream(@"C:\sample.playist", FileMode.Create, FileAccess.Write);
            StreamWriter sw = new StreamWriter(file);
            for (int col = 0; col < listView1.Columns.Count; col++)
            {
                st1 += (" " + listView1.Columns[col].Text.ToString() + "\t");             
            }
            sw.WriteLine(st1);
            st1 = string.Empty;

            for (int row = 0; row < listView1.Items.Count; row++)
            {
                //st1 = "\r\n"; the writeline will take care of this
                for (int col = 0; col < listView1.Columns.Count; col++)
                {
                    // used concat operator, and string format to get things positioned right
                    // Note that each value starts with a comma.
                    st1 += string.Format("{0},\t", listView1.Items[row].SubItems[col].Text.ToString());
                }
                st1 = st1.Substring(0, st1.Length - 2); // remove the last comma and tab chars
                sw.WriteLine(st1);
            }
            sw.Flush();
            sw.Close();
        }

// Jerry

Last edited by JerryShaw; Apr 19th, 2009 at 1:52 am.

JerryShaw

Reputation Points: 69

Solved Threads: 75

Posting Pro in Training

Offline

465 posts
since Nov 2006

Permalink

Apr 19th, 2009

Re: saving listview data in text form

It works with the tab and first comma, also with an empty line, but there still error, 2 duplicate first item.

Quote ...

ID Name
565, 87
565, 8754745, 78078

The input is

C# Syntax (Toggle Plain Text)
 ID   Name	
565, 87
54745, 8078
 ID   Name	
565, 87
54745, 8078

NguyenThai

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

15 posts
since Sep 2006

Permalink

Apr 19th, 2009

Re: saving listview data in text form

Here is the Tested, and working version

C# Syntax (Toggle Plain Text)
private void saveButton_Click(object sender, EventArgs e)
        {
            string st1 = string.Empty;
            FileStream file = new FileStream(@"C:\Titan\sample.playist", FileMode.Create, FileAccess.Write);
            StreamWriter sw = new StreamWriter(file);
            for (int col = 0; col < listView1.Columns.Count; col++)
            {
                st1 += (" " + listView1.Columns[col].Text.ToString() + "\t"); // added \r\n
            }
            sw.WriteLine(st1);
            st1 = string.Empty;
            for (int row = 0; row < listView1.Items.Count; row++)
            {
                st1 = string.Empty;
                for (int col = 0; col < listView1.Columns.Count; col++)
                {
                    st1 += string.Format("{0},\t", listView1.Items[row].SubItems[col].Text.ToString());
                }
                st1 = st1.Substring(0, st1.Length - 2);
                sw.WriteLine(st1);
            }
            sw.Flush();
            sw.Close();
        }
private void saveButton_Click(object sender, EventArgs e)
        {
            string st1 = string.Empty;
            FileStream file = new FileStream(@"C:\Titan\sample.playist", FileMode.Create, FileAccess.Write);
            StreamWriter sw = new StreamWriter(file);
            for (int col = 0; col < listView1.Columns.Count; col++)
            {
                st1 += (" " + listView1.Columns[col].Text.ToString() + "\t"); // added \r\n
            }
            sw.WriteLine(st1);
            st1 = string.Empty;
            for (int row = 0; row < listView1.Items.Count; row++)
            {
                st1 = string.Empty;
                for (int col = 0; col < listView1.Columns.Count; col++)
                {
                    st1 += string.Format("{0},\t", listView1.Items[row].SubItems[col].Text.ToString());
                }
                st1 = st1.Substring(0, st1.Length - 2);
                sw.WriteLine(st1);
            }
            sw.Flush();
            sw.Close();
        }

// Jerry
Mark as solved if this works for you.

JerryShaw

Reputation Points: 69

Solved Threads: 75

Posting Pro in Training

Offline

465 posts
since Nov 2006

Permalink

Apr 19th, 2009

Re: saving listview data in text form

Thank for help. It works. Yeah. Can I ask you 1 question. So how we can populate the ListView with this file? My thought was we have to use delighted method of the reader for the comma, and then remove the header, and then populate each of them.

NguyenThai

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

15 posts
since Sep 2006

Permalink

Apr 19th, 2009

Re: saving listview data in text form

To read the file you created, yes, discard the first line read (the header), then for each new line read, split the values based on the comma, and don't forget to replace the Tab character:

C# Syntax (Toggle Plain Text)
private void button2_Click(object sender, EventArgs e)
        {
            char[] delim = new char[2]{',','\t'};
            listView1.Items.Clear();
            TextReader file = new StreamReader(@"C:\sample.playist");
            file.ReadLine();
 
            string line = file.ReadLine();
            string[] values;
            while (!string.IsNullOrEmpty(line)) 
            {
                values = line.Split(delim,StringSplitOptions.RemoveEmptyEntries);
                ListViewItem item = new ListViewItem(values[0]);
                for (int i = 1; i < values.Length; i++)
                    item.SubItems.Add(values[i]);
                listView1.Items.Add(item);
                line = file.ReadLine();
            }
            file.Close();
        }
private void button2_Click(object sender, EventArgs e)
        {
            char[] delim = new char[2]{',','\t'};
            listView1.Items.Clear();
            TextReader file = new StreamReader(@"C:\sample.playist");
            file.ReadLine();

            string line = file.ReadLine();
            string[] values;
            while (!string.IsNullOrEmpty(line)) 
            {
                values = line.Split(delim,StringSplitOptions.RemoveEmptyEntries);
                ListViewItem item = new ListViewItem(values[0]);
                for (int i = 1; i < values.Length; i++)
                    item.SubItems.Add(values[i]);
                listView1.Items.Add(item);
                line = file.ReadLine();
            }
            file.Close();
        }

JerryShaw

Reputation Points: 69

Solved Threads: 75

Posting Pro in Training

Offline

465 posts
since Nov 2006

Permalink

Apr 19th, 2009

Re: saving listview data in text form

Thank you very much.

NguyenThai

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

15 posts
since Sep 2006

Previous
1
Page 2

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: Automatically detect CD/DVD

Next Thread in C# Forum Timeline: how to make chats in C#

DaniWeb Message

Cancel Changes

User Name
Password