Ma’lumotlar bazasiga ulanish usullari

Ma’lumotlar bazasiga ulanish usullari

using System;

using System.Data.SqlClient;
class Program
{
static void Main(string[] args)
{
string constr=@"Data Source=DESKTOP-QI7HNPK; Initial Catalog=UsersDb;
Integrated Security=True";
using (SqlConnection connec = new SqlConnection(constr))
{
connec.Open();
Console.WriteLine("Ulanish ochildi");
}
Console.WriteLine("Ulanish yopildi");
Console.ReadLine();
}
}


SqlCommand va sql buyruqlarni bajarish

using System;

using System.Data.SqlClient;
class Program
{
static void Main()
{
string ulaninsh_satri = @"Data Source=DESKTOP-QI7HNPK;
Initial Catalog=AvtoSalon;Integrated Security=True";
string sqltext = "SELECT * FROM MashinaDB";
using (SqlConnection connec = new SqlConnection(ulaninsh_satri))
{
connec.Open();
SqlCommand command = new SqlCommand(sqltext, connec);
}
Console.ReadLine();
}
}
SQL so’rov natijalarini o’qish



SqlDataReader obekti natijalarini turlarga ajratish. MBdan skalyar qiymatlarni olish.



So’rovlarni parametrlashtirish va tranzaktsiyalar

using System;

using System.Data.SqlClient;
namespace ConsoleApplication70
{
class Program
{
static void Main()
{
string ulanish = "Data Source=desktop-qi7hnpk; Initial Catalog=Talaba-S;
Integrated Security=True;";
using (SqlConnection con = new SqlConnection(ulanish))
{
con.Open();
string fnomi, fuqituvchi; int semestr;
Console.WriteLine("Yangi fan kiritish:");
Console.Write("Fan nomi: ");
fnomi = Console.ReadLine();
Console.Write("Fan o'qituvchisi: ");
fuqituvchi = Console.ReadLine();
Console.Write("Fan semestri: ");
semestr = Int32.Parse(Console.ReadLine());
string sql_ifoda = String.Format("INSERT INTO Fanlar (Fan_nomi,
Uqituvchi, Semestr) VALUES(@fnomi, @fuqituvchi,'{0}')", semestr);
SqlCommand command = new SqlCommand(sql_ifoda, con);
SqlParameter Param = new SqlParameter("@fnomi", fnomi);
command.Parameters.Add(Param);
Param = new SqlParameter("@fuqituvchi", fuqituvchi);
command.Parameters.Add(Param);
int n=command.ExecuteNonQuery();
if (n == 1) Console.WriteLine("Bazaga yozildi");
else Console.WriteLine("Bazaga yozilmadi");
}
Console.ReadLine();
}
}
}


MB bilan ishlashda SqlDataAdapter va DataSet imkoniyatlari