private void loadDataInGrid(String xFileName)
{
_CurrentTitle = xFileName;
lblWelcome.Text = xFileName;
this.canEdit = false;
this.changeEditButton();
// read datas and put them in datagridview1
string pathName = dir + "/datas/" + xFileName + ".csv";
System.IO.StreamReader sr = new System.IO.StreamReader(pathName, Encoding.Default, true);
//bdd access
DataSetISpaData dataISpa = new DataSetISpaData();
Console.WriteLine("file name" + xFileName);
switch (xFileName)
{
case "agenda":
DataSetISpaDataTableAdapters.VW_AGENDATableAdapter liste1 = new DataSetISpaDataTableAdapters.VW_AGENDATableAdapter();
liste1.Fill(dataISpa.VW_AGENDA);
_CurrentDataTable = dataISpa.VW_AGENDA;
this.dgv.DataSource = dataISpa.VW_AGENDA.DefaultView;
break;
case "clients":
DataSetISpaDataTableAdapters.VW_CLIENTTableAdapter liste2 = new DataSetISpaDataTableAdapters.VW_CLIENTTableAdapter();
liste2.Fill(dataISpa.VW_CLIENT);
_CurrentDataTable = dataISpa.VW_CLIENT;
this.dgv.DataSource = dataISpa.VW_CLIENT.DefaultView;
break;
case "products":
DataSetISpaDataTableAdapters.VW_PRODUITTableAdapter liste3 = new DataSetISpaDataTableAdapters.VW_PRODUITTableAdapter();
liste3.Fill(dataISpa.VW_PRODUIT);
_CurrentDataTable = dataISpa.VW_PRODUIT;
this.dgv.DataSource = dataISpa.VW_PRODUIT.DefaultView;
break;
case "factures":
DataSetISpaDataTableAdapters.VW_FACTURETableAdapter liste4 = new DataSetISpaDataTableAdapters.VW_FACTURETableAdapter();
liste4.Fill(dataISpa.VW_FACTURE);
_CurrentDataTable = dataISpa.VW_FACTURE;
this.dgv.DataSource = dataISpa.VW_FACTURE.DefaultView;
break;
case "users":
DataSetISpaDataTableAdapters.VW_USERTableAdapter liste5 = new DataSetISpaDataTableAdapters.VW_USERTableAdapter();
liste5.Fill(dataISpa.VW_USER);
_CurrentDataTable = dataISpa.VW_USER;
this.dgv.DataSource = dataISpa.VW_USER.DefaultView;
break;
default:
DataSetISpaDataTableAdapters.VW_AGENDATableAdapter liste6 = new DataSetISpaDataTableAdapters.VW_AGENDATableAdapter();
liste6.Fill(dataISpa.VW_AGENDA);
_CurrentDataTable = dataISpa.VW_AGENDA;
this.dgv.DataSource = dataISpa.VW_AGENDA.DefaultView;
Console.WriteLine("Default case");
break;
}
;
Console.WriteLine("START");
String[] arrHeader = new String[10];
int i = 0;
foreach (DataColumn col in _CurrentDataTable.Columns)
{
arrHeader[i] = col.ColumnName;
if (col.ColumnName == "XHEURE")
{
this.dgv.Columns[i].DefaultCellStyle.Format = "HH:mm";
}
if (col.ColumnName == "XDATE" || col.ColumnName == "XDOB")
{
this.dgv.Columns[i].DefaultCellStyle.Format = "dd.MM.yyyy";
}
i++;
}
Console.WriteLine("salut" + arrHeader[0] + arrHeader[1] + arrHeader[2] + arrHeader[3] + arrHeader[4] + arrHeader[5]);
_CurrentHeaders = arrHeader;
this.dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
this.dgv.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCells;
this.dgv.Sort(this.dgv.Columns[0], ListSortDirection.Ascending);
this.dgv.ReadOnly = true;
}
