protected void Tipo_Rale_SelectedIndexChanged(object sender, EventArgs e) { Titu.Visible = false; Literal5.Text = ""; GridView1.Visible = false; Rale1.Items.Clear(); Rale1.Items.Add(new ListItem("-- Selecciona Rale --", "")); TIPO.Items.Clear(); TIPO.Items.Add(new ListItem("-- Selecione la Subdelegación --", "")); TIPO.Enabled = false; incidencia.Items.Clear(); incidencia.Items.Add(new ListItem("-- Seleccione Incidencia --", "")); incidencia.Enabled = false; Dias.Text = ""; Dias.Enabled = false; tipo_doc.Items.Clear(); tipo_doc.Items.Add(new ListItem("-- Seleccione Tipo de Documento --", "-1")); tipo_doc.Enabled = false; tipo_mov.Items.Clear(); tipo_mov.Items.Add(new ListItem("-- Seleccione Tipo de Movimiento --", "-1")); tipo_mov.Enabled = false; Rale1.AppendDataBoundItems = true; String strQuery = "SELECT CONVERT(NVARCHAR, fecha_rale, 105) AS MOSTRAR, CONVERT (NVARCHAR, fecha_rale, 105) AS VALUE, CONVERT (NVARCHAR, fecha_rale, 102) AS VALUE1 FROM Rales_Combo WHERE (tipo_rale = @COP_RCV ) ORDER BY VALUE1 ASC"; SqlConnection con = new SqlConnection(strConnString); SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("@COP_RCV", Tipo_Rale.SelectedItem.Value); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); Rale1.DataSource = cmd.ExecuteReader(); Rale1.DataTextField = "MOSTRAR"; Rale1.DataValueField = "VALUE"; Rale1.DataBind(); if (Rale1.Items.Count > 1) { Rale1.Enabled = true; } else { Rale1.Enabled = false; } } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } }
protected void Tipo_Rale_SelectedIndexChanged(object sender, EventArgs e) { LabelMensaje.Visible = false; Rale1.Items.Clear(); Rale1.Items.Add(new ListItem("-- Selecciona Rale Base --", "")); Rale2.Items.Clear(); Rale2.Items.Add(new ListItem("-- Selecciona Rale a Comparar --", "")); Rale2.Enabled = false; RadioButtonList1.ClearSelection(); RadioButtonList1.Enabled = false; RadioButtonList2.ClearSelection(); RadioButtonList2.Enabled = false; fecha1.Items.Clear(); fecha1.Items.Add(new ListItem("-- Seleccione el Periodo Inicial --", "")); fecha1.Enabled = false; fecha2.Items.Clear(); fecha2.Items.Add(new ListItem("-- Seleccione el Periodo Final --", "")); fecha2.Enabled = false; Rale1.AppendDataBoundItems = true; String strConnString = ConfigurationManager.ConnectionStrings["SupervisionConnectionString"].ConnectionString; String strQuery = "SELECT CONVERT(NVARCHAR, fecha_rale, 105) AS MOSTRAR, CONVERT (NVARCHAR, fecha_rale, 112) AS VALUE FROM Rales_Combo WHERE (tipo_rale = @COP_RCV ) ORDER BY VALUE ASC"; SqlConnection con = new SqlConnection(strConnString); SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("@COP_RCV", Tipo_Rale.SelectedItem.Value); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); Rale1.DataSource = cmd.ExecuteReader(); Rale1.DataTextField = "MOSTRAR"; Rale1.DataValueField = "VALUE"; Rale1.DataBind(); if (Rale1.Items.Count > 1) { Rale1.Enabled = true; } else { Rale1.Enabled = false; Rale2.Enabled = false; } } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } }
protected void Tipo_Rale_SelectedIndexChanged(object sender, EventArgs e) { Rale1.Items.Clear(); Rale1.Items.Add(new ListItem("-- Selecciona Rale --", "")); Rale1.AppendDataBoundItems = true; String strQuery = "SELECT CONVERT(NVARCHAR, fecha_rale, 105) AS MOSTRAR, CONVERT (NVARCHAR, fecha_rale, 105) AS VALUE,CONVERT (NVARCHAR, fecha_rale, 112) AS VALUE1 FROM Rales_Combo WHERE (tipo_rale = @COP_RCV ) ORDER BY VALUE1 ASC"; SqlConnection con = new SqlConnection(strConnString); SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("@COP_RCV", Tipo_Rale.SelectedItem.Value); cmd.CommandType = CommandType.Text; cmd.CommandText = strQuery; cmd.Connection = con; try { con.Open(); Rale1.DataSource = cmd.ExecuteReader(); Rale1.DataTextField = "MOSTRAR"; Rale1.DataValueField = "VALUE"; Rale1.DataBind(); if (Rale1.Items.Count > 1) { Rale1.Enabled = true; } else { Rale1.Enabled = false; } } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); } }