예제 #1
0
        public FormThemKQ(string id) : this()
        {
            Models.Connection data = new Models.Connection();
            id_gv = id;
            string    query = "EXEC dbo. getHocvien '" + id + "'";
            DataTable info  = data.getDataSet(query).Tables[0];

            lbmahv.Text = info.Rows[0]["MaHV"].ToString().Trim();
        }
예제 #2
0
        public FormRLcualop(string id)
        {
            InitializeComponent();
            Models.Connection data = new Models.Connection();
            id_gv = id;
            string query = "EXEC dbo. spgetTableHVLop '" + id + "'";

            dgvHv.DataSource = data.getDataSet(query).Tables[0];
        }
예제 #3
0
        public FormNhapSuacualop(string id) : this()
        {
            Models.Connection data = new Models.Connection();
            id_gv = id;
            string    query = "EXEC dbo. getHocvien '" + id + "'";
            DataTable info  = data.getDataSet(query).Tables[0];

            lbmahv.Text = info.Rows[0]["MaHV"].ToString().Trim();
            dgvchinhsuarl.DataSource = Models.HVRL.gettablehvplrl(info.Rows[0]["MaHV"].ToString().Trim());
        }
예제 #4
0
        public FormLop(string id) : this()
        {
            Models.Connection data = new Models.Connection();
            id_gv = id;
            string query = "EXEC dbo. spgetTableHVLop '" + id + "'";

            dgvlop.DataSource = data.getDataSet(query).Tables[0];
            DataTable info = data.getDataSet(query).Tables[0];

            lbLop.Text = info.Rows[0]["Tenlop"].ToString().Trim();
        }