private void btn_DongY_Click(object sender, EventArgs e)
        {
            int blresult;

            blresult = 0;
            blresult = Convert.ToInt16(MessageBox.Show("Bạn có muốn thêm bệnh nhân", "Thêm Bệnh Nhân", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation));
            //MessageBox.Show(blresult.ToString());
            if (blresult == 1)
            {
                DataProvider.connection = new SqlConnection(DataProvider.connection_String);
                DataProvider.connection.Open();
                try
                {
                    string     sql = "Update  tbl_ThamSo  set  TienKham = '" + txtGiaTriMoi.Text + "'";
                    SqlCommand cmd = DataProvider.connection.CreateCommand();
                    cmd.CommandText = sql;

                    int rowCount = cmd.ExecuteNonQuery();
                }
                catch
                {
                }
                finally
                {
                    DataProvider.connection.Close();
                    DataProvider.connection.Dispose();
                    DataProvider.connection = null;
                    FrmTienKham_GUI FrmThamSo = new FrmTienKham_GUI();
                    Close();
                    FrmThamSo.Show();
                }
            }
        }
        private void btnThayDoiTienKham_Click(object sender, EventArgs e)
        {
            FrmTienKham_GUI FrmTienKham = new FrmTienKham_GUI();

            FrmTienKham.Show();
        }