阅读“.CSV”的听力在SqlCe表中导入CSV文件时的文件 [英] Reading Hearder of ".CSV" file while Importing CSV file in SqlCe Table

问题描述

我想将CSV文件导入到SQLCE数据库表中，它也正在读取Header Row所以请spme一个帮我编码........



这是我的.CSV文件格式，用于导入

i want to import CSV file in to SQLCE database table, it is reading the Header Row also so please spme one help me to code........

This is my ".CSV" file format for Import

"Sr.No","Sales Order No","Shipment No.","Cust. Name","Item","Bundle No.","Roll No.","Qty","Trans Id","Validated By","Record Id"
1,"S0000093","GNL-000099","Aarpee Hygiene Pvt Ltd","H0010AW0101-01P-0600-06050","G1150505045","G1150504070406",14,"GNL-005111","",35637153767
2,"S0000093","GNL-000099","Aarpee Hygiene Pvt Ltd","H0010AW0101-01P-0600-06050","G1150505002","G1150504050301",46,"GNL-005111","",35637153768

这是从SQLCE出口后的文件

This is the file After Exporting from SQLCE

Sr.No,Sales Order No,Shipment No.,Cust. Name,Item,Bundle No.,Roll No.,Qty,Trans Id,Validated By,Record Id
"Sr.No","Sales Order No","Shipment No.","Cust. Name","Item","Bundle No.","Roll No.","Qty","Trans Id","Validated By","Record Id"
1,"S0000093","GNL-000099","Aarpee Hygiene Pvt Ltd","H0010AW0101-01P-0600-06050","G1150505045","G1150504070406",14,"GNL-005111","",35637153767
2,"S0000093","GNL-000099","Aarpee Hygiene Pvt Ltd","H0010AW0101-01P-0600-06050","G1150505002","G1150504050301",46,"GNL-005111","",35637153768

这是我的导入代码.CSV文件

this is my code for importing .CSV File

private void SycItems()
        {
            string Path = null;
            string Line = null;
            string FileName = null;
            StreamReader Reader = default(StreamReader);
            Path = "\\My Documents";
            try
            {
                ConStr = "Data Source =" + System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\freedom.sdf";
                con.ConnectionString = ConStr;
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }
                Cmd.Connection = con;

                try
                {
                    if (File.Exists(Path + "\\Items.csv"))
                    {
                        FileName = "Items.txt";
                        Cmd.CommandText = "Delete from Items";
                        Cmd.ExecuteNonQuery();
                        FileInfo ItemsFile = new FileInfo(Path + "\\Items.csv");
                        Reader = ItemsFile.OpenText();
                        do
                        {

                            Line = Reader.ReadLine();
                            if (!(string.IsNullOrEmpty(Line)))
                            {
                                
                                string[] values = Line.Split(',');
                                //Edit column name
                                Cmd.CommandText = "Insert Into Items (No,Salesorder,Shipmentno,Custname,Itemno,Bundleno,Rollno,Qty,Transid,Validatedby,RecordID)values('" + values[0] + "','" + values[1] + "','" + values[2] + "','" + values[3] + "','" + values[4] + "','" + values[5] + "','" + values[6] + "','" + values[7] + "','" + values[8] + "','" + values[9] + "','" + values[10].Replace('\'', ' ') + "')";
                                //Cmd.CommandText = "Insert Into Items (No,Salesorder,Shipmentno,Custname,Itemno,Bundleno,Rollno,Qty,Transid,Validatedby,RecordID)values('" + values[0] + "','" + values[1] + "','" + values[2] + "','" + values[3] + "','" + values[4] + "','" + values[5] + "','" + values[6] + "','" + values[7] + "','" + values[8] + "','" + values[9] + "','" + values[10].Replace('\'',' ' ) + "')";
                                Cmd.ExecuteNonQuery();
                            }
                        } while (!(Line == null));
                        Reader.Close();

                        if (File.Exists(Path + "\\Items.csv"))
                        {
                            File.Delete(Path + "\\Items.csv");
                        }
                        MessageBox.Show("CSV Imported Successfuly", "Import CSV");
                    }
                    else
                    {
                        MessageBox.Show("Items File is not found", "Import CSV");
                        Application.Exit();
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("Error in Items File", "Import CSV");
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Error", "Import CSV");
            }
}

推荐答案

好的，所以请阅读文件的第一行，不要做任何事情用它。



StreamReader.ReadLine（） [ ^ ]

OK, so read the first line of the file and don't do anything with it.

StreamReader.ReadLine()[^]

这篇关于阅读“.CSV”的听力在SqlCe表中导入CSV文件时的文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！