예제 #1
0
        private void button5_Click(object sender, EventArgs e)
        {
            DGVClo h = new DGVClo();

            this.Hide();
            h.Show();
        }
예제 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "")
            {
                {
                    if (button1.Text == "Add Clo's")
                    {
                        SqlConnection conn = new SqlConnection("Data Source=DESKTOP-OQV6IBM;Initial Catalog=ProjectB;Integrated Security=True");
                        conn.Open();
                        string     Query = "insert into Clo(Name,DateCreated,DateUpdated) values('" + this.textBox1.Text + "','" + DateTime.Now + "','" + DateTime.Now + "')";
                        SqlCommand cmd   = new SqlCommand(Query, conn);
                        cmd.ExecuteNonQuery();
                        MessageBox.Show("Data Successfully Added");
                    }
                    else
                    {
                        SqlConnection conn = new SqlConnection("Data Source=DESKTOP-OQV6IBM;Initial Catalog=ProjectB;Integrated Security=True");
                        conn.Open();

                        string     Query = "update Clo set Name='" + this.textBox1.Text + "',DateUpdated='" + DateTime.Now + "'  where Id = '" + StdId + "'";
                        SqlCommand cmd   = new SqlCommand(Query, conn);
                        cmd.ExecuteNonQuery();
                        MessageBox.Show("Data Updated Successfully");
                    }
                    DGVClo f = new DGVClo();
                    this.Hide();
                    f.Show();
                }
            }
            else
            {
                MessageBox.Show("Please fill the required fields");
            }
        }