C# (CSharp) Exec_Class.GetData Exemples

Exemple #1

Fichier : VM_ThongKe_HocKy.cs Projet : 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));
        }

Exemple #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));
        }

Exemple #3

Fichier : VM_DanToc_TonGiao.cs Projet : 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));
        }

Exemple #4

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

            sqlCommand.CommandText = query;

            return(Exec_Class.GetData(sqlCommand));
        }

Exemple #5

Fichier : VM_QuyDinh.cs Projet : 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));
        }

Exemple #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));
        }