Ejemplos de G8_DataAccess DataAccess en C# (CSharp)

Ejemplo n.º 1

Archivo: frm_selectspaceship.cs Proyecto: sdcz-2442/G8M-PACS

        private void btn_selectspaceship_Click(object sender, EventArgs e)
        {
            G8_DataAccess.DataAccess dataAccess = new G8_DataAccess.DataAccess();
            DataSet dts;

            dataAccess.connectToDDBB(projectName);

            spaceshipCode = tbx_spaceshipname.Text;

            dts = dataAccess.getByQuery("SELECT * FROM SpaceShips WHERE CodeSpaceShip = '" + spaceshipCode + "'", "Spaceships", projectName);

            spaceshipIdSelected = dts.Tables[0].Rows[0]["idSpaceShip"].ToString();
            spaceshipIP         = dts.Tables[0].Rows[0]["IPSpaceShip"].ToString();
            spaceshipPort1      = dts.Tables[0].Rows[0]["PortSpaceShip"].ToString();
            spaceshipPort2      = dts.Tables[0].Rows[0]["PortSpaceship1"].ToString();


            this.Hide();
            new frm_spaceship().Show();
        }