Exemplos de WindowsFormsApplication1 connection.select em C# (CSharp)

Exemplo n.º 1

Arquivo: AddPos.cs Projeto: Arkven/C-Sharp

 public AddPos(int ID, int ID_s)
 {
     InitializeComponent();
     this.ID = ID;
     this.ID_s = ID_s;
     btn.Text = "Изменить";
     connection connection = new connection();
     SqlDataReader myReader = connection.select("*", "[Посещаемость]", "[Код Посещаемость]=" + ID);
     while (myReader.Read())
     {
         tbDate.Text = Convert.ToString(myReader[2]);
         cbPos.Checked =(bool) myReader[3];
     }
     myReader.Close();
     connection.Close();
 }

Exemplo n.º 2

Arquivo: AddSchool.cs Projeto: Arkven/C-Sharp

        public AddSchool(int ID)
        {
            InitializeComponent();
            this.ID = ID;
            btn.Text = "Изменить";
            connection connection = new connection();
            SqlDataReader myReader = connection.select("*", "Школа", "[Код школа]=" + ID);
            while (myReader.Read())
            {
                tbName.Text = Convert.ToString(myReader[1]);
                tbAdress.Text = Convert.ToString(myReader[2]);
                tbFIO.Text = Convert.ToString(myReader[3]);

            }
            myReader.Close();
            connection.Close();
        }

Exemplo n.º 3

Arquivo: AddDis.cs Projeto: Arkven/C-Sharp

        public AddDis(int ID)
        {
            InitializeComponent();
            this.ID = ID;
            btn.Text = "Изменить";
            connection connection = new connection();
            SqlDataReader myReader = connection.select("*", "Предмет", "[Код предмет]=" + ID);
            while (myReader.Read())
            {
                tbName.Text = Convert.ToString(myReader[1]);
                tbAveScore.Text = Convert.ToString(myReader[2]);
                tbIDTeacher.Text = Convert.ToString(myReader[3]);
                tbFIOTeacher.Text = Convert.ToString(myReader[4]);

            }
            myReader.Close();
            connection.Close();
        }

Exemplo n.º 4

Arquivo: AddClass.cs Projeto: Arkven/C-Sharp

        public AddClass(int ID)
        {
            InitializeComponent();
            this.ID = ID;
            btn.Text = "Изменить";
            connection connection = new connection();
            SqlDataReader myReader = connection.select("*", "Класс", "[Код класс]=" + ID);
            while (myReader.Read())
            {
                tbIDShool.Text = Convert.ToString(myReader[1]);
                tbNum.Text = Convert.ToString(myReader[2]);
                tbFIOElder.Text = Convert.ToString(myReader[3]);
                tbFIOClassRook.Text = Convert.ToString(myReader[4]);

            }
            myReader.Close();
            connection.Close();
        }

Exemplo n.º 5

Arquivo: AddStudent.cs Projeto: Arkven/C-Sharp

        public AddStudent(int ID)
        {
            InitializeComponent();
            this.ID = ID;
            btn.Text = "Изменить";
            connection connection = new connection();
            SqlDataReader myReader = connection.select("*", "Ученик", "[Код ученик]=" + ID);
            while (myReader.Read())
            {

                tbIDClass.Text = Convert.ToString(myReader[1]);
                tbFIO.Text = Convert.ToString(myReader[2]);
                tbAdress.Text = Convert.ToString(myReader[3]);
                tbNum.Text = Convert.ToString(myReader[4]);
                tbFIOParents.Text = Convert.ToString(myReader[5]);
            }
            myReader.Close();
            connection.Close();
        }

Exemplo n.º 6

Arquivo: AddTeacher.cs Projeto: Arkven/C-Sharp

        public AddTeacher(int ID)
        {
            InitializeComponent();
            this.ID = ID;
            btn.Text = "Изменить";
            connection connection = new connection();
            SqlDataReader myReader = connection.select("*", "Преподаватель", "[Код преподаватель]=" + ID);
            while (myReader.Read())
            {

                tbFIO.Text = Convert.ToString(myReader[1]);
                tbIDSchool.Text = Convert.ToString(myReader[2]);
                tbIDDis.Text = Convert.ToString(myReader[3]);
                tbAge.Text = Convert.ToString(myReader[4]);
                tbQual.Text = Convert.ToString(myReader[5]);
                tbClass.Text = Convert.ToString(myReader[6]);
            }
            myReader.Close();
            connection.Close();
        }