Muhamad al-xorazmiy nomidgi toshkentaxborot texnalogiyalari universiteti nurafshon filiali

^ Stefens, Rayan (2011). Sams 24 soat ichida o'zingizga SQL-ni o'rgatadi. Indianapolis, Ind: Sams. ISBN 9780672335419.

^ "Ma'lumotlar bazasi xavfsizligi bo'yicha eng yaxshi amaliyotlar". technet.microsoft.com. Arxivlandi asl nusxasi 2016-09-15. Olingan 2016-09-02.

^ Seema Kedar (2009 yil 1-yanvar). Ma'lumotlar bazasini boshqarish tizimlari. Texnik nashrlar. p. 15. ISBN 978-81-8431-584-4.


2-topshiriqAmaliyot ishida tanlangan variyant asosida, tayyor tizim loyihasini ishlab chiqish va loyihani yakunlash.


Firmada har oyda sotib olingan mahsulotlar miqdorlarini va sof daromatni oylik diagrammasini yaratuvchi dastur tuzish
Dasturning umumiy ko‘rinishi quyidagicha bo‘ladi.

1. 
   rasm. Dasturning umumiy ko‘rinishi oynasi.
   

1-qadam. Formaga chart komponentasi joylashtiriladi. Uning Series xossasiga kirib 2- Series qo‘shiladi. Series1 tanlanadi va uning LegendText xossasiga “Maxsulot xajmi” matni yoziladi. Series2 tanlanadi va uning LegendText xossasiga “Soft daromat” matni yoziladi. Ushbu Series qo‘shish oynasi 7.2- rasmda keltirilgan.

2. 
   rasm. Series qo‘shish oynasi.
   

2-qadam. Formaga dataGridView, listBox va button komponentalari joylashtiriladi. Ularning xech qanday xosasi o‘zgartirilmaydi.
3-qadam. Formaning load xodissasi kodlari quyidagicha:
DataTable ^ Tablitsa;
private: System::Void Form1_Load(System::Object^ sender, System::EventArgs^ e) {chart1->Titles>Add("Oylar bo'yicha sotib olingan maxsulotlar soni va sof daromat"); listBox1->Items->Add("Pie"); listBox1->Items->Add("Line"); this->Text = "Grafik ma'lumotlar";
Tablitsa = gcnew DataTable();
//Ushbu jadvalda 2 ta ustun "Oy"va "Sotib olingan
//max.soni":
Tablitsa->Columns->Add("Oy", String::typeid);
// V C#: Tablitsa.Columns.Add("Mesyas",
//typeof(String));
//2-ustun bo'yicha ma'lumotlar long tipida bo'lasi:
Tablitsa->Columns->Add("Sotib olingan max.soni",
Int64::typeid); Tablitsa->Columns->Add("Xarajatlar",
Int64::typeid);
Tablitsa->Columns->Add("Daromat", Int64::typeid);
Tablitsa->Columns->Add("Sof daromat", Int64::typeid); // V C#: Tablitsa.Columns.Add("Ob’em prodaj", typeof(long));
//Jadvalning 1- qatorini to'ldiramiz:
DataRow ^ Ryad = Tablitsa->NewRow();
Ryad["Oy"] = "May"; Ryad["Sotib olingan max.soni"]
=10; Ryad["Xarajatlar"] =3; Ryad["Daromat"] =15;
Ryad["Sof daromat"]
=Convert::ToInt64(Ryad["Daromat"])-
Convert::ToInt64(Ryad["Xarajatlar"]);
//Convert::ToInt64( dataGridView1->Rows[0]->Cells[0]-
>Value);
Tablitsa->Rows->Add(Ryad);
//Jadvalning 2- qatorini to'ldiramiz:
Ryad = Tablitsa->NewRow();
Ryad["Oy"] = "Iyun"; Ryad["Sotib olingan max.soni"] =
20; Ryad["Xarajatlar"] =5; Ryad["Daromat"] =25; Ryad["Sof daromat"]
=Convert::ToInt64(Ryad["Daromat"])-
Convert::ToInt64(Ryad["Xarajatlar"]); Tablitsa->Rows->Add(Ryad);
//3- qatorni qo'shamiz:
Ryad = Tablitsa->NewRow();
Ryad["Oy"] = "Iyul"; Ryad["Sotib olingan max.soni"] =
30; Ryad["Xarajatlar"] =10; Ryad["Daromat"] =35;
Ryad["Sof daromat"]
=Convert::ToInt64(Ryad["Daromat"])-
Convert::ToInt64(Ryad["Xarajatlar"]); Tablitsa->Rows->Add(Ryad);
//4- qatorni qo'shamiz:
Ryad = Tablitsa->NewRow();
Ryad["Oy"] = "Avgust"; Ryad["Sotib olingan max.soni"]
= 40; Ryad["Xarajatlar"] =15; Ryad["Daromat"] =45;
Ryad["Sof daromat"]
=Convert::ToInt64(Ryad["Daromat"])-
Convert::ToInt64(Ryad["Xarajatlar"]); Tablitsa->Rows->Add(Ryad);
//5- qatorni qo'shamiz:
Ryad = Tablitsa->NewRow();
Ryad["Oy"] = "Sentyabr"; Ryad["Sotib olingan max.soni"] = 50; Ryad["Xarajatlar"] =20;
Ryad["Daromat"] =55;
Ryad["Sof daromat"]
=Convert::ToInt64(Ryad["Daromat"])-
Convert::ToInt64(Ryad["Xarajatlar"]); Tablitsa->Rows->Add(Ryad); dataGridView1->DataSource = Tablitsa;
chart1->DataSource = Tablitsa; chart1->Series["Series1"]->XValueMember = "Oy"; chart1->Series["Series2"]->XValueMember = "Oy"; chart1->Series["Series1"]->YValueMembers = "Sotib olingan max.soni";
chart1->Series["Series2"]->YValueMembers = "Sof daromat";
chart1->Series["Series1"]->ChartType =
System::Windows::Forms::DataVisualization::Charting:: SeriesChartType::Column;
chart1->Series["Series2"]->ChartType =
System::Windows::Forms::DataVisualization::Charting::
SeriesChartType::Column;
// Diogrammaning turi quyidagicha bo'lishi ham
//mumkin. masalan: Pie, Line va bohqa. chart1->Series["Series1"]->Color = Color::Aqua;
chart1->Series["Series2"]->Color = Color::Yellow; chart1->DataBind();} }