Advertisement
Guest User

opet za lalu

a guest
Nov 15th, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.30 KB | None | 0 0
  1. SqlConnection conn = new SqlConnection();
  2.             conn.ConnectionString = @"Data Source=10.81.73.2,49166; Initial Catalog=dj_gligorijevicE34; User ID=dj_gligorijevicE34;
  3.                Password=dj_gligorijevicE34";
  4.             conn.Open();
  5.             SqlCommand command = new SqlCommand();
  6.             command.Connection = conn;
  7.             if (DropDownList1.SelectedIndex == 0)
  8.             {
  9.                 string recSrpski = TextBox1.Text;
  10.                 command.CommandText = "SELECT engleski, opis FROM Recnik WHERE srpski='" + recSrpski + "'";
  11.                 SqlDataReader dr = command.ExecuteReader();
  12.                 while (dr.Read())
  13.                 {
  14.                     TextBox2.Text = dr[0].ToString() + "\r";
  15.                     TextBox2.Text += dr[1].ToString();
  16.                 }
  17.             }
  18.  
  19.             if (DropDownList1.SelectedIndex == 1)
  20.             {
  21.                 string recEngleski = TextBox1.Text;
  22.                 command.CommandText = "SELECT srpski, opis FROM Recnik WHERE engleski='" + recEngleski + "'";
  23.                 SqlDataReader dr = command.ExecuteReader();
  24.                 while (dr.Read())
  25.                 {
  26.                     TextBox2.Text = dr[0].ToString() + "\r";
  27.                     TextBox2.Text += dr[1].ToString();
  28.                 }
  29.             }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement