Fan nomi: Dasturlash 2 Mavzu

Prosedura nomlari va parametrlari:



Loyihaning Visual C++ yordamida vizuallashtirilgan ko’rinishi:


O’zgartirish bo’limi oynasi


Qidirish bo’limi oynasi


Yangilash bo’limi oynasi

MB bilan bog’lanish va ma’lumotlaridan foydalanish uchun class yaratish

Class da global funksiya yaratish (MS ACCESS uchun)

Class da global funksiya yaratish (SQL Server uchun)


Dasturda class dan foydalanish




Bazaga bog’lanish va undan ma’lumotlar qidirish funksiyasi

SQL so’rovlari amalga oshirish





Ma’lumotlarni komponentalarga chiqarish


Ma’lumotlarni yangilash

Bazaga yangi ma’lumotlar kiritish

Bazada yangi jadval yaratish

Ma’lumotlar bazasi (TTJ.rar) faylida;

Dasturiy vosita (TTJ_dastur.rar) faylida taqdim etildi.
Login: Oybek;
Password: 564;
Dasturiy vositaning listing kodi:
TTJ_sinf.h
#pragma once
using namespace System;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Data::OleDb;

ref class TTJ_sinf

{
public:
TTJ_sinf(void){};
void ShowRecord(DataGridView^ DBGrid, String^ komanda);
};

TTJ_sinf.cpp
#include "stdafx.h"
#include "TTJ_sinf.h"

void TTJ_sinf::ShowRecord(DataGridView^ DBGrid, String^ komanda){ //"Select * From Talabalar"

System::Data::OleDb::OleDbConnection^ DBConnection = gcnew System::Data::OleDb::OleDbConnection(

"Data Source=\"TTJ.mdb\";User " + "ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";");
DBConnection->Open();

System::Data::DataSet^ SetData = gcnew System::Data::DataSet();

//"Select * From Talabalar", DBConnection
OleDb::OleDbDataAdapter^ DBQuyery = gcnew System::Data::OleDb::OleDbDataAdapter(komanda, DBConnection);
DBQuyery->Fill(SetData);

DBGrid->DataSource = SetData->Tables[0]->DefaultView;

DBConnection->Close();

delete DBConnection, DBQuyery, SetData;

}