“Dasturlash texnologiyalari” fanidan

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.

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);

Console.WriteLine("{0} \t{1} \t{2}\t{3}", tartib, familiya, ism, tug_yili);

}

}

reader.Close();

}

Console.Read();

Jadval qiymatlarini so`rov orqali o`qish. SQLDataReader orqali.

Jadval qiymatlarini so`rov orqali o`qish. SQLDataReader orqali.

using (SqlConnection connection = new SqlConnection(connectionString)) {

Console.WriteLine("Ismi:"); string ismi = Console.ReadLine();