Sub DropDownList1_SelectedIndexChanged(sender As Object, E As System.EventArgs)
textvalue = sender.selecteditem.value
texttext = sender.selecteditem.Text
End Sub
SqlConnection cnn = new SqlConnection("server=(local);database=pubs; uid=sa; pwd=;");
SqlDataAdapter da = new SqlDataAdapter("select * from authors",cnn);