public DataTable Grid(string Email) { PlaGaDBfunk dbClass = new PlaGaDBfunk(); using (var conn = dbClass.Rang()) { conn.Parameters.AddWithValue("@Email", Email); DataTableFunk dataTablesFunktions = new DataTableFunk(); SqlDataReader reader; reader = conn.ExecuteReader(); DataTable dt = dataTablesFunktions.Grids(); dt.Load(reader); return(dt); //cboAbsence.Items.Add("Keine Asenze"); } }
public string Multipli(string Email, string Genre) { PlaGaDBfunk dbClass = new PlaGaDBfunk(); using (var conn = dbClass.Multiplo()) { conn.Parameters.AddWithValue("@Email", Email); conn.Parameters.AddWithValue("@Genre", Genre); DataTableFunk dataTablesFunktions = new DataTableFunk(); SqlDataReader reader; reader = conn.ExecuteReader(); //string mul = conn.ToString(); DataTable dt3 = dataTablesFunktions.dt3(); // conn while (reader.Read()) { mul = reader[0].ToString(); } // dt3.Load(reader); return(mul); } }