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();
}
