1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
|
public DataSet GetTable1()
{
DataSet ds = new DataSet();
DataTable dt1 = ds.Tables.Add("ListeBug");
dt1.Columns.Add("projet");
dt1.Columns.Add("NumeroBug");
dt1.Columns.Add("Priorite");
dt1.Columns.Add("Severite");
dt1.Columns.Add("DateSoumission");
dt1.Columns.Add("Resume");
dt1.Columns.Add("Rapporteur");
// read and insert a new line
System.IO.StreamReader csv_file1 = File.OpenText(@"D:\Users\pmagnin\Desktop\Statistiques\Statistiques\statistiquesWinfORM\statistiquesWinfORM\bin\Debug\ListeBug.csv");
while (csv_file1.Peek() >= 0)
{
// read and add a line
string line = csv_file1.ReadLine();
string[] vals = line.Split(';');
DataRow dr = dt1.NewRow();
dr["Projet"] = vals[0];
dr["NumeroBug"] = vals[1];
dr["Priorite"] = vals[2];
dr["Severite"] = vals[3];
dr["DateSoumission"] = vals[4];
dr["Resume"] = vals[5];
dr["Rapporteur"] = vals[6];
dt1.Rows.Add(dr);
}
csv_file1.Close();
DataTable dt2 = ds.Tables.Add("AffectationBug");
dt2.Columns.Add("NumeroBug");
dt2.Columns.Add("dateModification");
dt2.Columns.Add("ModifiePar");
dt2.Columns.Add("De");
dt2.Columns.Add("Vers");
System.IO.StreamReader csv_file2 = File.OpenText(@"D:\Users\pmagnin\Desktop\Statistiques\Statistiques\statistiquesWinfORM\statistiquesWinfORM\bin\Debug\AffectationBug.csv");
while (csv_file2.Peek() >= 0)
{
// read and add a line
string line = csv_file2.ReadLine();
string[] vals = line.Split(';');
DataRow dr = dt2.NewRow();
dr["NumeroBug"] = vals[0];
dr["dateModification"] = vals[1];
dr["ModifiePar"] = vals[2];
dr["De"] = vals[3];
dr["Vers"] = vals[4];
dt2.Rows.Add(dr);
}
csv_file2.Close();
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);
return ds;
} |
Partager