Visual Studio dasturining Visual C++ dasturlash tilida kichik loyihalar yaratish Loyiha bu

Prosedura nomlari va parametrlari:




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;

}