Mavzu: xml va Ma’lumotlar bazasi Reja: xml tili xaqida tushuncha

Xususiyatlari

• 
  Connection - SqlDataReader bilan bog'langan SqlConnection-ni oladi.
  
• 
  HasRows - SqlDataReader da so`rov natijasida bir yoki bir nechta qator mavjudligini ko'rsatadigan qiymatni oladi.
  

Usullari. 

• 
  Close () - SqlDataReader ob'ektini yopadi.
  
• 
  Read ()- SqlDataReader-ni keyingi yozuvga o'tkazadi.
  
• 
  GetValues (Object []) - Belgilangan ustun qiymatini asl formatida oladi.
  

3. “Microsoft SQL Server 2014 Management Studio” da sql buyruqlari bilan ishlash.
DDL (Data Definition Language)
Create operatori yordamida jadval yaratish
DML (Data Manipulation Language)
Update operatori
Insert operatori
Delete operatori
DQL (Data Query Language)
Select operatori
4. Visual C# dasturda SQLDataReader bilan ishlash.
Satr ulanishlar
1. SQL Server Authentication uchun
string connectionString = @"Data Source =.\SQLEXPRESS; Initial Catalog = baza_nomi; User Id = sa; Password = parol";
2. Windows Authentication uchun
string connectionString = @"Data Source=.\SQLEXPRESS; Initial Catalog=baza_nomi; Integrated Security=True";
Jadvalga qiymat qo`shish SQLCommand orqali.
string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog
=usersdb;Integrated Security=True";
using (SqlConnection connection = new SqlConnection(connectionString))
{
string sqlExpression = "INSERT INTO talaba (t_r, familiya, ism, tug_yili) "+
" values (12,'O`rinova','Mahfuza', '07/13/1999');";
try {
connection.Open();
Console.WriteLine("Bazaga ulandi");
SqlCommand command = new SqlCommand(sqlExpression, connection);