获取使用csv helper时可用的字段长度 [英] get the length of fields available when using csv helper

问题描述

Hii，



我正在使用csv帮助程序从csv文件中检索我的数据，



但在此之前我想添加到数据库中，我只是想检查一下我是否正确地将所有列都放入该csv文件中，所以我想查看库存数量的数量



我该怎么做

Hii ,

I am using csv helper to retrive my data from csv file ,

but before that i want to add into database , i just want to check wether i have all columns properly or not into that csv file , so i want to check number of coulmns count

how can i do that

 using (System.IO.StreamReader file = new System.IO.StreamReader(Server.MapPath(filepath)))
                        {
                            //Csv reader reads the stream
                            CsvReader csvread = new CsvReader(file);
                            var recs = csvread.GetRecords<dynamic>().ToArray();
                            int length = recs.Length;
                            while (csvread.Read())
                            {   
                                var intField = csvread.GetField<string>("HeaderName");
                                var stringField = csvread.GetField<string>(1);
                            }
}

推荐答案

using (System.IO.StreamReader file = new System.IO.StreamReader(Server.MapPath(filepath)))
                        {
                            //Csv reader reads the stream
                            CsvReader csvread = new CsvReader(file);
                            while (csvread.Read())
                            {
                                int count = csvread.FieldHeaders.Count();
                                if (count == 55)
                                {
                                    DataRow dr = myExcelTable.NewRow();
                                    if (csvread.GetField<string>("FirstName") != null)
                                    {
                                        dr["FirstName"] = csvread.GetField<string>("FirstName"); ;
                                    }
                                    else
                                    {
                                        dr["FirstName"] = "";
                                    }

                                    if (csvread.GetField<string>("LastName") != null)
                                    {
                                        dr["LastName"] = csvread.GetField<string>("LastName"); ;
                                    }
                                    else
                                    {
                                        dr["LastName"] = "";
                                    }
                                }
                                else
                                {
                                    lblMessage.Visible = true;
                                    lblMessage.Text = "Columns are not in specified format.";
                                    lblMessage.ForeColor = System.Drawing.Color.Red;
                                    return;
                                }
                            }
                            }

这篇关于获取使用csv helper时可用的字段长度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！