protected void Pro_TextChanged(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(GetConnectionString()); //Parametros de conexion string sql = "select * from Servicio where idUnidad=" + Pro.SelectedValue; //Query //Se sacan los datos y se meten en los select SqlDataAdapter sda = new SqlDataAdapter(sql, conn); conn.Open(); DataTable dt = new DataTable(); sda.Fill(dt); Serv.DataSource = dt; Serv.DataTextField = "nombre"; Serv.DataValueField = "idServicio"; Serv.DataBind(); conn.Close(); }