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
|
static DataTable MyTable;
public static DataTable CreateDataTable()
{
DataTable myDataTable = new DataTable();
DataColumn myDataColumn;
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.Int32");
myDataColumn.ColumnName = "CodiceOperatore";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "Prodotto";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "IdProdotto";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.Int32");
myDataColumn.ColumnName = "Qte";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.Char");
myDataColumn.ColumnName = "Tipo";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.Decimal");
myDataColumn.ColumnName = "Totale";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.DateTime");
myDataColumn.ColumnName = "Data";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.Int32");
myDataColumn.ColumnName = "Id";
myDataTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "Stato";
myDataTable.Columns.Add(myDataColumn);
return myDataTable;
}
public static void AddDataToTable(int idoperatore, string prodotto, string idprodotto, int qte, char tipo, decimal totale, DateTime data, int id, string stato, DataTable myTable)
{
DataRow row;
row = myTable.NewRow();
row["CodiceOperatore"] = idoperatore;
row["Prodotto"] = prodotto;
row["IdProdotto"] = idprodotto;
row["Qte"] = qte;
row["Tipo"] = tipo;
row["Totale"] = totale;
row["Data"] = data;
row["Id"] = id;
row["Stato"] = stato;
myTable.Rows.Add(row);
} |
Partager