protected void lstAvtori_SelectedIndexChanged(object sender, EventArgs e)
        {
            SelektirajAvtor(lstAvtori.SelectedValue);
        }
        protected void SelektirajAvtor(string id)
        {
            SqlConnection connection = new SqlConnection();
            connection.ConnectionString = con;
            SqlCommand command = new SqlCommand();
            string sqlCommand = "select * from authors where au_id='" + id + "'";
            command.Connection = connection;
            command.CommandText = sqlCommand;
            try
            {
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                while(reader.Read())
                {
                    tbID.Text = reader[0].ToString(); //reader["au_id"].ToString();
                    tbIme.Text = reader[1].ToString();//reader["au_fname"].ToString();
                    tbPrezime.Text = reader[2].ToString(); //reader["au_lname"].ToString();
                    tbTelefon.Text = reader[3].ToString(); //reader["phone"].ToString();
                    tbAdresa.Text = reader[4].ToString();//reader["address"].ToString();
                    tbGrad.Text = reader[5].ToString();//reader["city"].ToString();
                    tbDrzava.Text = reader[6].ToString();//reader["state"].ToString();

                }
                reader.Close();

            }
            catch (Exception ex)
            {
                lblPoraka.Text = ex.Message;
            }
            finally
            {
                connection.Close();
            }
        }