|
Universiteti katta hajmli ma'lumotlar
|
| bet | 2/4 | | Sana | 15.12.2023 | | Hajmi | 48,5 Kb. | | #119411 |
Bog'liq Katta hajmli malumotlar{
static void Main()
{
// SQL Server ma'lumotlar bazasiga ulanish o'rnatilishi
string connectionString = "Data Source=your_server;Initial Catalog=your_database;Integrated Security=True";
// SQL so'rov
string query = "SELECT Students.StudentID, Students.StudentName, Courses.CourseName " +
"FROM Students " +
"INNER JOIN Enrollments ON Students.StudentID = Enrollments.StudentID " +
"INNER JOIN Courses ON Enrollments.CourseID = Courses.CourseID";
// SqlConnection obyekti yaratish
using (SqlConnection connection = new SqlConnection(connectionString))
{
// SqlCommand obyekti yaratish
using (SqlCommand command = new SqlCommand(query, connection))
{
// Ma'lumotlar bazasini ochish
connection.Open();
// SqlDataReader obyekti yaratish
using (SqlDataReader reader = command.ExecuteReader())
{
// Natijalarni ekranga chiqarish
while (reader.Read())
{
Console.WriteLine($"StudentID: {reader["StudentID"]}, StudentName: {reader["StudentName"]}, CourseName: {reader["CourseName"]}");
}
}
}
}
}
}
Ushbu misolda, "Students", "Enrollments" va "Courses" jadvallari orasidagi bog'lanishni INNER JOIN bilan bajaramiz. Natijada, har bir talaba (Students jadvali) va uning o'qiygan kurslari (Courses jadvali) ma'lumotlarini ko'rsatamiz.
Inner Join misoli:
using System;
using System.Collections.Generic;
using System.Linq;
class Program
{
static void Main()
{
// Students va Courses nomli ikkita ro'yxat
List students = new List
|
| |
