예제 #1
0
        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Hide();

            control frm = new control();

            frm.ShowDialog();
        }
예제 #2
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            SqlConnection  cn = new SqlConnection(@"Server=study-pc\KEROLES; Initial catalog=VECS3; Integrated Security=false;  User ID=sa; password=123");
            SqlCommand     cm;
            SqlDataAdapter sda = new SqlDataAdapter("select count(*)from admin1 where username ='******' and password='******'", cn);
            DataTable      dt  = new DataTable();

            sda.Fill(dt);
            if (dt.Rows[0][0].ToString() == "1")
            {
                //     MessageBox.Show("Login Success");

                this.Hide();

                control frm = new control();
                frm.ShowDialog();
            }
            else
            {
                MessageBox.Show("Please Ckeck Your User Name and Password");
            }
        }
예제 #3
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                cmd = new SqlCommand("Insert into devices (type,ip,status,location,name,admin_id,device_num) values ('" + txttype.Text + "','" + txtip.Text + "','" + txtStatus.Text + "','" + txtlocation.Text + "','" + txtname.Text + "','" + txtadmin_id.Text + "','" + txtDevice_num.Text + "')", cn);
                cn.Open();
                cmd.ExecuteNonQuery();
                MessageBox.Show("Add Successfuly ", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
                cn.Close();

                this.Hide();

                control frm = new control();
                frm.ShowDialog();
            }
            catch (SqlException ex)
            {
                MessageBox.Show("some Errors was occured " + ex.Message);
            }
            finally
            {
                cn.Close();
            }
        }