Question

MYMEMORY WARNING: YOU USED ALL AVAILABLE FREE TRANSLATIONS FOR TODAY. NEXT AVAILABLE IN 23 HOURS 57 MINUTES 13 SECONDS VISIT HTTPS://MYMEMORY.TRANSLATED.NET/DOC/USAGELIMITS.PHP TO TRANSLATE MORE

            public static void Read(string FilePath, DataTable dataTable)
            {
                dataTable.Rows.Clear();
                StreamReader streamReader = new StreamReader(FilePath);

                string[] Headers = streamReader.ReadLine().Split( , );
                while (!streamReader.EndOfStream)
                {
                    string[] filefields = Regex.Split(streamReader.ReadLine(), ",(?=(?:[^"]*"[^"]*")*[^"]*$)");
                    DataRow dataRow = dataTable.NewRow();
                    for (int i = 0; i < Headers.Length; i++)
                    {
                        switch (Type.GetTypeCode(dataTable.Columns[i].DataType))
                        {
                            case TypeCode.Boolean:
                                dataRow[i]  = Boolean.Parse(filefields[i]); break;
                            case TypeCode.Byte:
                                dataRow[i] = Byte.Parse(filefields[i]); break;
                            case TypeCode.Char:
                                dataRow[i] = Char.Parse(filefields[i]);break;
                            case TypeCode.DateTime:
                                dataRow[i] = DateTime.Parse(filefields[i]); break;
                            case TypeCode.Decimal:
                                dataRow[i] = Decimal.Parse(filefields[i]); break;
                            case TypeCode.Double:
                                dataRow[i] = Double.Parse(filefields[i]); break;
                            case TypeCode.Int16:
                                dataRow[i] = Int16.Parse(filefields[i]); break;
                            case TypeCode.Int32:
                                dataRow[i] = Int32.Parse(filefields[i]); break;
                            case TypeCode.Int64:
                                dataRow[i] = Int64.Parse(filefields[i]); break;
                            case TypeCode.Object:
                                dataRow[i] = (object)filefields[i]; break;
                            case TypeCode.SByte:
                                dataRow[i] = SByte.Parse(filefields[i]); break;
                            case TypeCode.Single:
                                dataRow[i] = Single.Parse(filefields[i]); break;
                            case TypeCode.String:
                                dataRow[i] = filefields[i].ToString(); break;
                            case TypeCode.UInt16:
                                dataRow[i] = UInt16.Parse(filefields[i]);break;
                            case TypeCode.UInt32:
                                dataRow[i] = UInt32.Parse(filefields[i]);break;
                            case TypeCode.UInt64:
                                dataRow[i] = UInt64.Parse(filefields[i]); break;
                            default: break;
                        }
                    }
                    dataTable.Rows.Add(dataRow);
                }
            }

MYMEMORY WARNING: YOU USED ALL AVAILABLE FREE TRANSLATIONS FOR TODAY. NEXT AVAILABLE IN 23 HOURS 57 MINUTES 12 SECONDS VISIT HTTPS://MYMEMORY.TRANSLATED.NET/DOC/USAGELIMITS.PHP TO TRANSLATE MORE

Answer 1

MYMEMORY WARNING: YOU USED ALL AVAILABLE FREE TRANSLATIONS FOR TODAY. NEXT AVAILABLE IN 23 HOURS 57 MINUTES 10 SECONDS VISIT HTTPS://MYMEMORY.TRANSLATED.NET/DOC/USAGELIMITS.PHP TO TRANSLATE MORE

public static void Read(string FilePath, DataTable dataTable)
            {
                dataTable.Rows.Clear();
                StreamReader streamReader = new StreamReader(FilePath);

                string[] Headers = streamReader.ReadLine().Split( , );
                while (!streamReader.EndOfStream)
                {
                    string[] filefields = Regex.Split(streamReader.ReadLine(), ",(?=(?:[^"]*"[^"]*")*[^"]*$)");
                    DataRow dataRow = dataTable.NewRow();
                    for (int i = 0; i < Headers.Length; i++)
                    {
                        DataColumn column = dataTable.Columns[i];
                        object parsedvalue = Convert.ChangeType(filefields[i], column.DataType);
                        dataRow[i] = parsedvalue;
                    }
                    dataTable.Rows.Add(dataRow);
                }
            }

友情链接