public static void LoadDB(DataTable dt) { string text1 = Environment.CurrentDirectory + @"\Data\" + dt.TableName + ".csv"; dt.BeginLoadData(); try { dt.Rows.Clear(); if (dt.TableName == "Folder") { object[] objArray1 = new object[5]; objArray1[1] = 0; objArray1[2] = "All"; objArray1[3] = DateTime.Now; objArray1[4] = 1; dt.Rows.Add(objArray1); object[] objArray2 = new object[5]; objArray2[1] = 0; objArray2[2] = "Scan"; objArray2[3] = DateTime.Now; objArray2[4] = 1; dt.Rows.Add(objArray2); object[] objArray3 = new object[5]; objArray3[1] = 0; objArray3[2] = "Exchange"; objArray3[3] = DateTime.Now; objArray3[4] = 1; dt.Rows.Add(objArray3); object[] objArray4 = new object[5]; objArray4[1] = 0; objArray4[2] = "Favorite"; objArray4[3] = DateTime.Now; objArray4[4] = 1; dt.Rows.Add(objArray4); object[] objArray5 = new object[5]; objArray5[1] = 0; objArray5[2] = "Industry"; objArray5[3] = DateTime.Now; objArray5[4] = 1; dt.Rows.Add(objArray5); object[] objArray6 = new object[5]; objArray6[1] = 0; objArray6[2] = "Reserved"; objArray6[3] = DateTime.Now; objArray6[4] = 0; dt.Rows.Add(objArray6); object[] objArray7 = new object[5]; objArray7[1] = 0; objArray7[2] = "Reserved"; objArray7[3] = DateTime.Now; objArray7[4] = 0; dt.Rows.Add(objArray7); object[] objArray8 = new object[5]; objArray8[1] = 0; objArray8[2] = "Reserved"; objArray8[3] = DateTime.Now; objArray8[4] = 0; dt.Rows.Add(objArray8); object[] objArray9 = new object[5]; objArray9[1] = 0; objArray9[2] = "Reserved"; objArray9[3] = DateTime.Now; objArray9[4] = 0; dt.Rows.Add(objArray9); object[] objArray10 = new object[5]; objArray10[1] = 0; objArray10[2] = "Reserved"; objArray10[3] = DateTime.Now; objArray10[4] = 0; dt.Rows.Add(objArray10); } if (!File.Exists(text1)) { return; } StreamReader reader1 = File.OpenText(text1); try { string text2 = reader1.ReadLine(); char[] chArray1 = new char[1] { ',' }; string[] textArray1 = text2.Trim().Split(chArray1); int num1 = dt.Rows.Count; text2 = null; if (num1 > 0) { while (num1-- > 0) { if ((text2 = reader1.ReadLine()) == null) { break; } } } while ((text2 = reader1.ReadLine()) != null) { string[] textArray2 = StockDB.DecodeCSV(text2); DataRow row1 = dt.NewRow(); for (int num2 = 0; (num2 < textArray1.Length) && (num2 < textArray2.Length); num2++) { if (textArray2[num2] != "") { try { row1[textArray1[num2]] = textArray2[num2]; } catch { } } } if (!row1.IsNull(dt.PrimaryKey[0])) { dt.Rows.Add(row1); } } } finally { reader1.Close(); } } finally { dt.EndLoadData(); } }