DaniWeb Forum Index > Software Development > C#

saving listview data in text form

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2006

Posts: 15

Reputation: NguyenThai is an unknown quantity at this point

Solved Threads: 0

NguyenThai NguyenThai is offline

Offline

Newbie Poster

Re: saving listview data in text form

#11

Apr 19th, 2009

•

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.

 Help with Code Tags 
 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.

 Help with Code Tags 
 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:

 Help with Code Tags 
 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.

•

Join Date: Nov 2006

Posts: 436

Reputation: JerryShaw is on a distinguished road

Solved Threads: 72

JerryShaw

Offline

Posting Pro in Training

Re: saving listview data in text form

#12

Apr 19th, 2009

Untested modified version

 Help with Code Tags 
 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.

•

Join Date: Sep 2006

Posts: 15

Reputation: NguyenThai is an unknown quantity at this point

Solved Threads: 0

NguyenThai NguyenThai is offline

Offline

Newbie Poster

Re: saving listview data in text form

#13

Apr 19th, 2009

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

•

ID Name
565, 87
565, 8754745, 78078

The input is

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
 ID   Name	
565, 87
54745, 8078
 ID   Name	
565, 87
54745, 8078

•

Join Date: Nov 2006

Posts: 436

Reputation: JerryShaw is on a distinguished road

Solved Threads: 72

JerryShaw

Offline

Posting Pro in Training

Re: saving listview data in text form

#14

Apr 19th, 2009

Here is the Tested, and working version

 Help with Code Tags 
 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.

•

Join Date: Sep 2006

Posts: 15

Reputation: NguyenThai is an unknown quantity at this point

Solved Threads: 0

NguyenThai NguyenThai is offline

Offline

Newbie Poster

Re: saving listview data in text form

#15

Apr 19th, 2009

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.

•

Join Date: Nov 2006

Posts: 436

Reputation: JerryShaw is on a distinguished road

Solved Threads: 72

JerryShaw

Offline

Posting Pro in Training

Re: saving listview data in text form

#16

Apr 19th, 2009

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:

 Help with Code Tags 
 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();
        }