Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SqlConnection conn = new SqlConnection();
- conn.ConnectionString = @"Data Source=10.81.73.2,49166; Initial Catalog=dj_gligorijevicE34; User ID=dj_gligorijevicE34;
- Password=dj_gligorijevicE34";
- conn.Open();
- SqlCommand command = new SqlCommand();
- command.Connection = conn;
- if (DropDownList1.SelectedIndex == 0)
- {
- string recSrpski = TextBox1.Text;
- command.CommandText = "SELECT engleski, opis FROM Recnik WHERE srpski='" + recSrpski + "'";
- SqlDataReader dr = command.ExecuteReader();
- while (dr.Read())
- {
- TextBox2.Text = dr[0].ToString() + "\r";
- TextBox2.Text += dr[1].ToString();
- }
- }
- if (DropDownList1.SelectedIndex == 1)
- {
- string recEngleski = TextBox1.Text;
- command.CommandText = "SELECT srpski, opis FROM Recnik WHERE engleski='" + recEngleski + "'";
- SqlDataReader dr = command.ExecuteReader();
- while (dr.Read())
- {
- TextBox2.Text = dr[0].ToString() + "\r";
- TextBox2.Text += dr[1].ToString();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement