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

int qiymat = command.ExecuteNonQuery();
Console.WriteLine("{0}: yozuv qo`shildi ", qiymat);
}
catch {
connection.Close();
Console.WriteLine("Bazaga ulanishda xatolik mavjud!!!");
} Natija
connection.Close();
Console.Read();
}
Jadvalga konsol oyna orqali kiritish.
using (SqlConnection connection = new SqlConnection(connectionString)) {
string ism, familiya, tug_yili;
int tr;
Console.WriteLine("Tartib raqami:"); tr= int.Parse(Console.ReadLine());
Console.WriteLine("Familiya:"); familiya = Console.ReadLine();
Console.WriteLine("Ism:"); ism = Console.ReadLine();
Console.WriteLine("Tug`ilgan yili('oy/kun/yil'):"); tug_yili = Console.ReadLine();
try { connection.Open();
Console.WriteLine("Bazaga ulandi");
string sqlExpression = String.Format("INSERT INTO talaba (t_r, familiya, ism, tug_yili) VALUES({0},'{1}','{2}','{3}')", tr.ToString(), familiya, ism, tug_yili);
SqlCommand command = new SqlCommand(sqlExpression, connection);
command.CommandText = sqlExpression;
int qiymat = command.ExecuteNonQuery();
Console.WriteLine("{0}: yozuv qo`shildi ", qiymat);
}
catch { connection.Close();
Console.WriteLine("Bazaga ulanishda xatolik mavjud!!!"); }
connection.Close();
Console.Read(); }
Jadvaldan qiymat o`qish SQLDataReader orqali.
using (SqlConnection connection = new SqlConnection(connectionString)) {
connection.Open();
string sqlExpression = "select t_r,familiya,ism,tug_yili from talaba";
SqlCommand command = new SqlCommand(sqlExpression, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows) {
Console.WriteLine("{0}\t{1}\t{2}\t{3}", reader.GetName(0), reader.GetName(1), reader.GetName(2), reader.GetName(3));
while ( reader.Read() ) {
object tartib = reader.GetValue(0);
object familiya = reader.GetValue(1);
object ism = reader.GetValue(2);
object tug_yili = reader.GetValue(3);