protected void DdlPN_TextChanged(object sender, EventArgs e) { Cnx.SelecBD(); using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex())) { string VbTxtSql = "EXEC SP_PANTALLA_ADVICE 16, @P,'','','SN',0,0,0,@ICC,'01-1-2009','01-01-1900','01-01-1900'"; sqlConB.Open(); using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB)) { SC.Parameters.AddWithValue("@P", DdlPN.Text); SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]); using (SqlDataAdapter SDA = new SqlDataAdapter()) { using (DataSet DSTDdl = new DataSet()) { SDA.SelectCommand = SC; SDA.Fill(DSTDdl); DdlSN.DataSource = DSTDdl.Tables[0]; DdlSN.DataTextField = "SN"; DdlSN.DataValueField = "Codigo"; DdlSN.DataBind(); DdlModel.DataSource = DSTDdl.Tables[1]; DdlModel.DataTextField = "Descripcion"; DdlModel.DataValueField = "CodModelo"; DdlModel.DataBind(); } } } } }
protected void BindModelDdl(string make, string model, string other) { List <ModelLookup> models = ModelLookup.GetAllModelsLookup(make); DdlModel.DataSource = models; DdlModel.DataBind(); if (model != "") { if (models.Select(m => m.Model).ToString() == model) { DdlModel.SelectedValue = model; } if (model == "Other") { RfvModelOther.Enabled = true; RfvModelOther.Visible = true; TxtModelOther.Enabled = true; TxtModelOther.Visible = true; TxtModelOther.Text = other; } } }