Transportda axborot tizimlari va texnologiyalari» kafedrasi «Dasturlash tili va texnologiyalari(C#, Python)»

Поля – maydon turlari, xossalarini o‘zgartirish, jadval formatlarini
tahrirlash, matematik funksiyalardan foydalanish mumkin.
Таблица – makroslar yaratish, jadvllarni o‘zaro bog‘lash, xossa-larini
o‘rnatish mumkin. 

MS Access 2010 ning asosiy elementlari quyidagilar:
 Таблицы – ma’lumotlarni saqlash uchun xizmat qiladi;
 Запросы – ma’lumotlarni tanlash shartlarini berishni ularga
o‘zgartirishlar kiritish uchun xizmat qiladi;
 Формы – ma’lumotlarni ko‘rish va tahrirlash uchun xizmat qiladi;
 Страницы – HTML (gipermatn) formatidagi fayllar, ular MS
Access 2010 da ma’lumotlarini Internet Explorer brouzeri yordamida
ko‘rish uchun ishlatiladi;
 Отчеты – ma’lumotlarni umumlashtirish va chop qilish imkonini
beradi;
 Макрос – bir yoki bir qancha amallarni avtomatik ravishda bajaradi.
MS Access 2010 da maydonlar ma’lumotlarni mantiqiy tashkil
etishning elementar birligi hisoblanadi. 

II. BOB Asosiy qism
Dorixona


Form1



1-rasm.Kirish oynasi

using System;

using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;

using System.Windows.Forms;

namespace Ali_Kurs_ishi
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
Form2 forma = new Form2();
forma.Show();
this.Hide();
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void label2_Click(object sender, EventArgs e)
{
}
private void label1_Click(object sender, EventArgs e)
{
}
private void button16_Click(object sender, EventArgs e)
{
Application.Exit();
}
}
}
Form2



2-rasm.Dorixona bolimi.

3-rasm.Tovar bolimi.

4-rasm.Yetkazib beruvchi bolimi.

using System;

using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Threading.Tasks;

namespace Ali_Kurs_ishi

{
public partial class Form2 : Form
{
//WindowState = FormWindowState.Maximized;
OleDbConnection Con = new OleDbConnection();
public Form2()
{
InitializeComponent();
Con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Dorixona.accdb";
}
void korsatish(string zapros, DataGridView datagrid)
{
try
{
Con.Open();
OleDbDataAdapter da = new OleDbDataAdapter(zapros, Con);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds);
datagrid.DataSource = ds.Tables[0];
Con.Close();
}
catch
{
}
finally { Con.Close(); }
}
void filter(string zapros, DataGridView datagrid)
{
try
{
Con.Open();
OleDbDataAdapter da = new OleDbDataAdapter(zapros, Con);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds);
datagrid.DataSource = ds.Tables[0];
Con.Close();
}
catch
{
}
finally { Con.Close(); }
}
void qoshish(string insert)
{
try
{
Con.Open();
OleDbCommand com = new OleDbCommand(insert, Con);
com.ExecuteNonQuery();
Con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally { Con.Close(); }
}
void tozalash()
{
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox5.Clear();
textBox6.Clear();
textBox7.Clear();
textBox8.Clear();
textBox9.Clear();
textBox10.Clear();
textBox11.Clear();
textBox4.Clear();
}
private void Form2_Load(object sender, EventArgs e)
{
korsatish("Select *from Dorixona",dataGridView1);
korsatish("Select *from Tovar", dataGridView2);
korsatish("Select *from Yetkazib_beruvchi", dataGridView3);
}
private void button1_Click(object sender, EventArgs e)
{
string insert = "Insert into Dorixona(Nomi,Joriy_sana,Yetkazib_beruvchi,Tovar) values ('" + textBox1.Text + "','" + textBox2.Text + "','" + (textBox3.Text) + "','" + (textBox4.Text) + "')";
qoshish(insert);
MessageBox.Show("Ma\'lumot qo\'shildi");
korsatish("Select *from Dorixona", dataGridView1);
}
private void button2_Click(object sender, EventArgs e)
{
string insert = "Update Dorixona set Nomi='" + textBox1.Text + "', Joriy_sana='" + textBox2.Text + "',Yetkazib_beruvchi='" + (textBox3.Text) + "', Tovar='" + (textBox4.Text) + "'where Id=" + label13.Text + "";
qoshish(insert);
MessageBox.Show("Ma\'lumot o\'zgartirildi");
korsatish("Select *from Dorixona", dataGridView1);
}
private void button3_Click(object sender, EventArgs e)
{
string insert = "Delete from Dorixona where Id=" + label13.Text + "";
qoshish(insert);
MessageBox.Show("Ma\'lumot o\'chirildi");
korsatish("Select *from Dorixona", dataGridView1);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
label13.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
textBox2.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
textBox3.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
textBox4.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
}
private void button5_Click(object sender, EventArgs e)
{
string insert = "Insert into Tovar(Nomi,Narxi,Yetkazib_beruvchi,Soni,Yaroqlik_muddati) values ('" + textBox5.Text + "','" + textBox6.Text + "','" + (textBox7.Text) + "','" + (textBox8.Text) + "','" + (textBox9.Text) + "')";
qoshish(insert);
MessageBox.Show("Ma\'lumot qo\'shildi");
korsatish("Select *from Tovar", dataGridView2);
}
private void button6_Click(object sender, EventArgs e)
{
string insert = "Update Tovar set Nomi='" + textBox5.Text + "', Narxi='" + textBox6.Text + "',Yetkazib_beruvchi='" + (textBox7.Text) + "', Soni='" + (textBox8.Text) + "',Yaroqlik_muddati='" + (textBox9.Text) + "'where Id=" + label14.Text + "";
qoshish(insert);
MessageBox.Show("Ma\'lumot o\'zgartirildi");
korsatish("Select *from Tovar", dataGridView2);
}
private void button7_Click(object sender, EventArgs e)
{
string insert = "Delete from Tovar where Id=" + label14.Text + "";
qoshish(insert);
MessageBox.Show("Ma\'lumot o\'chirildi");
korsatish("Select *from Tovar", dataGridView2);
}
private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
label14.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
textBox5.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
textBox6.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
textBox7.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
textBox8.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
textBox9.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
}
private void button9_Click(object sender, EventArgs e)
{
string insert = "Insert into Yetkazib_beruvchi(Nomi,Tovar) values ('" + textBox10.Text + "','" + textBox11.Text + "')";
qoshish(insert);
MessageBox.Show("Ma\'lumot qo\'shildi");

korsatish("Select *from Yetkazib_beruvchi", dataGridView3);

}
private void button10_Click(object sender, EventArgs e)
{
string insert = "Update Yetkazib_beruvchi set Nomi='" + textBox10.Text + "', Tovar='" + textBox11.Text + "'where Id=" + label15.Text + "";
qoshish(insert);
MessageBox.Show("Ma\'lumot o\'zgartirildi");
korsatish("Select *from Yetkazib_beruvchi", dataGridView3);
}
private void button12_Click(object sender, EventArgs e)
{
string insert = "Delete from Yetkazib_beruvchi where Id=" + label15.Text + "";
qoshish(insert);
MessageBox.Show("Ma\'lumot o\'chirildi");
korsatish("Select *from Yetkazib_beruvchi", dataGridView3);
}
private void dataGridView3_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
label15.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
textBox10.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
textBox6.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
}
private void button11_Click(object sender, EventArgs e)
{
tozalash();
}
private void button8_Click(object sender, EventArgs e)
{
tozalash();
}
private void button4_Click(object sender, EventArgs e)
{
tozalash();
}
private void button13_Click(object sender, EventArgs e)
{
Form1 n = new Form1();
n.Show();
this.Hide();
}
private void button15_Click(object sender, EventArgs e)
{
Form1 n = new Form1();
n.Show();
this.Hide();
}
private void button14_Click(object sender, EventArgs e)
{
Form1 n = new Form1();
n.Show();
this.Hide();
}
private void button16_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
filter("Select *from Dorixona WHERE Nomi Like '%" + textBox1.Text + "%'", dataGridView1);
}
private void textBox5_TextChanged(object sender, EventArgs e)
{
filter("Select *from Tovar WHERE Nomi Like '%" + textBox5.Text + "%'", dataGridView2);
}
private void textBox10_TextChanged(object sender, EventArgs e)
{
filter("Select *from Yetkazib_beruvchi WHERE Nomi Like '%" + textBox10.Text + "%'", dataGridView3);
}
}
}

Xulosa

Xech kimga sir emaski, bugungi kunda dasturlarga ehtiyoj juda oshib bormoqda. Bu dasturlarni tuzish uchun esa albatta malum bir dasturlash muhiti kerak. Bu dasturlash muhitlarining bittasi sifatida biz C# dasturlash muhitini misol qilishimiz mumkin. C# dasturlash muhitini boshqa tillarga qaragan imkoniyatlari ancha keng. C# dasturlash tilida turli hil ishlanmalar jumladan bugungi kunda bizning ehtiyojlarimizdan eng keragi bо‘lgan Web ishlanmalar va undan tashqari inson uchun zarur bо‘lgan barcha dasturlarni tuzishimiz mumkin.

Visual Studio.NET muhiti Windows platformasida ishlaydi, hamda Windows va Web – ilovalar yaratishga mо‘ljallangan, lekin ishlab chiquvchilar konsol ilovalar yaratishni ham nazarda tutishgan. Konsol ilovani ishga tushirganda operatsion tizim konsol oynani yaratadi, uning yordamida hamma kiritish-chiqarish olib boriladi. Tashqaridan qaraganda u operatsion tizimning komanda satri rejimi ishini esga soladi, qachonki kiritish-chiqarish simvollar oqimini namoyish etadi. Konsol ilovalar tilni о‘rganishga eng yaxshi uslub, chunki unda grafik interfeysni hosil qilish uchun kо‘plab standart obyektlar ishlatilmaydi.
Men bu dasturni yaratish davomida C# dasturlash tilida formada ishlash, Ma’lumotlar bazasi bilan ishlash, klasslar... haqidagi nazariy bilimlarni mustahkamlab oldim.

Foydalanilgan adabiyotlar

1). Биллиг В. А . Аснови программирования на C# Издво <<Интенет – университет информационних технологий ИНТУИТ.ру>>,2006.-488 с.

2). Павловская Т. А. С/С++. Программ уровня: Учебник для вузов.- СПБ: Петер,2001.- 464 с.
3). Робисон У. C# без лишних слов. М.: ДМК Пресс, 2002.- 352 с.
4). Гуннерсон Э. Введение в С#. Библотека программиста – СПБ.Ж . Питер, 2001.- 304 с.
5). Секунов Н. Самоучител С#. Серия Самоучител. Петербург, 2001. -576 с.
6). Фролов А. В. Фролов Г.В. Язик С# Самоучител. – М. Диалог- МИФИ,2003.- 560 с.