C# (CSharp) Exec_Class.GetData Examples

Example #1

File: VM_ThongKe_HocKy.cs Project: hoangduong1501/-Thuc-Tap-Chuyen-Mon-Nguyen_Hoang_Duong-Le_Nhat_Hoang

        private DataTable LayDS_Query(string query)
        {
            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.CommandText = query;

            return(Exec_Class.GetData(sqlCommand));
        }

Example #2

        private DataTable LayDS_Query(string query)
        {
            //string query = @"EXEC dbo.LayDS_MonHoc";
            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.CommandText = query;

            return(Exec_Class.GetData(sqlCommand));
        }

Example #3

File: VM_DanToc_TonGiao.cs Project: hoangduong1501/-Thuc-Tap-Chuyen-Mon-Nguyen_Hoang_Duong-Le_Nhat_Hoang

        private DataTable LayDS_TonGiao()
        {
            string     query      = @"EXEC dbo.LayDS_TonGiao";
            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.CommandText = query;

            return(Exec_Class.GetData(sqlCommand));
        }

Example #4

        private DataTable LayDS_LoaiNguoiDung()
        {
            string     query      = @"EXEC dbo.LayDS_LoaiNguoiDung";
            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.CommandText = query;

            return(Exec_Class.GetData(sqlCommand));
        }

Example #5

File: VM_QuyDinh.cs Project: hoangduong1501/-Thuc-Tap-Chuyen-Mon-Nguyen_Hoang_Duong-Le_Nhat_Hoang

        public DataTable Backup()
        {
            string     query      = @"Backup database QLHocSinhTHPT to disk ='f:\BackUp.bak'";
            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.CommandText = query;

            return(Exec_Class.GetData(sqlCommand));
        }

Example #6

        private DataTable LayDS_TimGiaoVien(string value)
        {
            string     query      = @"EXEC dbo.Tim_GiaoVien @value";
            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.Parameters.AddWithValue("@value", value);
            sqlCommand.CommandText = query;

            return(Exec_Class.GetData(sqlCommand));
        }