What's new

C# Help mga master sa C# if null item

Status
Not open for further replies.

tamadsijuan

Eternal Poster
Joined
Feb 17, 2016
Posts
849
Reaction
327
Points
268
3 folders with CSV files
lahat ng folder papasukin and imerge yung mga csv files into 1 file(Merged.csv)

Question is nag eeror sya pag walang laman yung isang folder
new lang po kasi sa c# or programming
ang idea ko is gagamit ako ng if statment kaso hindi ko sure kung saan ko ilalagay at panung code(statement)yung ilalagay ko

error ko is : {"Sequence contains no elements"} sa may csvheader

salamat po sa mga makakatulong


Code:
namespace Merge
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Path paths = new Path();
            /*paths.path1 = textBox1.Text + @"\";
            paths.path2 = textBox2.Text + @"\";
            paths.path3 = textBox3.Text + @"\";*/


            var Allpaths = new List<string>() { paths.path1, paths.path2, paths.path3 };


            foreach (string lcPaths in Allpaths)
            {
                string newPath = lcPaths + "merged.csv";

                var all = Directory.GetFiles(lcPaths, "*.csv", SearchOption.TopDirectoryOnly);

                string[] csvheader = { File.ReadAllLines(all.First()).First(l => !string.IsNullOrWhiteSpace(l)) };
                var mergedata = all.SelectMany(csv => File.ReadAllLines(csv).SkipWhile(l => string.IsNullOrWhiteSpace(l)).Skip(0));


                File.WriteAllLines(newPath, mergedata);
                
            }

        }
    }
}
 
Hindi ko sure kung saan nagerror, baka puwede mo lagyan ng Try Catch itong statements na ito:

C#:
string[] csvheader = { File.ReadAllLines(all.First()).First(l => !string.IsNullOrWhiteSpace(l)) };
var mergedata = all.SelectMany(csv => File.ReadAllLines(csv).SkipWhile(l => string.IsNullOrWhiteSpace(l)).Skip(0));

File.WriteAllLines(newPath, mergedata);
 
Hindi ko sure kung saan nagerror, baka puwede mo lagyan ng Try Catch itong statements na ito:

C#:
string[] csvheader = { File.ReadAllLines(all.First()).First(l => !string.IsNullOrWhiteSpace(l)) };
var mergedata = all.SelectMany(csv => File.ReadAllLines(csv).SkipWhile(l => string.IsNullOrWhiteSpace(l)).Skip(0));

File.WriteAllLines(newPath, mergedata);
thanks sir na solve ko na din po ito hahaha
iclose thread ko nalang
bali nag condition pa ako before ng code na ito
 
Status
Not open for further replies.
Back
Top