コード例 #1
0
        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");
            }
        }
コード例 #2
0
        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);
            }
        }