Good I would like you to help me I'm doing is to consume a webservice that I return a list and those values add it in a combobox
This is my Webservice
public List<Combos> D_LlenarCombo(Int32 Opt, Int32 Id_Tipo)
{
SqlDataReader reader;
SqlConnection cn = new SqlConnection(ObtenerCadenaConexion());
cn.Open();
SqlCommand cmd = new SqlCommand("llenarcombos", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@opt", SqlDbType.Int).Value = Opt;
cmd.Parameters.Add("@Id_Tipo", SqlDbType.Int).Value = Id_Tipo;
reader= cmd.ExecuteReader();
List<Combos> Combo = new List<Combos>();
try
{
while (reader.Read())
{
Combo.Add(new Combos { Id = reader.GetInt32(0), Nombre = reader.GetString(1) });
}
reader.Close();
cmd.Dispose();
cn.Close();
return Combo;
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
This is the Combo class.
public class Combos
{
public Int32 Id { get; set; }
public String Nombre { get; set; }
}
This is the web page that will consume the webservice.
void LLenarCombo()
{
//Cargar al combobox ViaIncidencia
var varViaIncidencia = Obj.Ws_LlenarCombo(4, 0).ToList();
CboViaIncidencia.DataSource = varViaIncidencia;
CboViaIncidencia.DataTextField = "ViaIncidencia";
CboViaIncidencia.DataValueField = "Id_ViaIncidencia";
CboViaIncidencia.DataBind();
CboViaIncidencia.SelectedIndex = -1;
}
If you could help me please