protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { string str = ALCSA.FWK.Web.Sitio.ExtraerValorQueryString(Request, "deudor"); this.txtnomDeudor.Text = Session["snomdeudor"].ToString(); if (Session["snoperacion"] == null) { txtNrooperacion.Text = ALCSA.FWK.Web.Sitio.ExtraerValorQueryString(Request, "estado"); } else { txtNrooperacion.Text = Session["snoperacion"].ToString(); } this.txtRutDeudor.Text = Session["srutdeudor"].ToString(); DataTable table = ConsultasEspecificas.ConMostrarDomicilios(str); Session["Excel_domi_cilios"] = table; Grilla.DataSource = table; Grilla.DataBind(); if (ALCSA.FWK.Web.Sitio.ExtraerValorQueryStringComoEntero(Request, "cerrar").Equals(1)) { btnCerrar.OnClientClick = "window.close();"; } } }
private void CargarAlumnos() { cAlumno alumno = new cAlumno(); DataTable trdo = alumno.GetAlumnos(); Grilla.DataSource = trdo; Grilla.DataBind(); }
protected void btnLimpiar_Click(object sender, EventArgs e) { txtId.Value = "0"; txtNombre.Text = ""; chkActivo.Checked = false; tu.limpiar(); txtNombre.Focus(); Grilla.DataSource = null; Grilla.DataBind(); }
protected void btnLimpiar_Click(object sender, EventArgs e) { txtId.Value = ""; txtNombre.Text = ""; txtRut.Text = ""; txtDigito.Text = ""; txtRazonSocial.Text = ""; txtTelefono1.Text = ""; txtTelefono2.Text = ""; txtEmail.Text = ""; chkActivo.Checked = false; proveedor.limpiar(); txtNombre.Focus(); Grilla.DataSource = null; Grilla.DataBind(); }
private void CargaGrilla(int indice) { DataTable table = ConsultasEspecificas.ConsultaDatosGrillaDomicilios( txtRut.Text, txtNroOperacion.Text, ddlCliente.SelectedValue ); if (table != null && table.Rows.Count > 0) { Session["snomdeudor"] = table.Rows[0]["nomdeudor"].ToString(); Session["srutdeudor"] = table.Rows[0]["rut_deudor"].ToString(); } Grilla.PageIndex = indice; Grilla.DataSource = table; Grilla.DataBind(); }
void muestra_productos() { String queryString = "Lista_Prod_Stock"; lbl_error.Text = ""; //lbl_status.Text = ""; using (MySqlConnection conn = new MySqlConnection(SMysql)) { try { conn.Open(); MySqlCommand command = new MySqlCommand(queryString, conn); command.CommandType = CommandType.StoredProcedure; if (txt_codigo.Text == "") { command.Parameters.AddWithValue("@v_codigo", DBNull.Value); } else { command.Parameters.AddWithValue("@v_codigo", txt_codigo.Text); } command.Parameters["@v_codigo"].Direction = ParameterDirection.Input; if (LstLineaVtas.SelectedItem.Value.ToString() == "0") { command.Parameters.AddWithValue("@v_id_linea_vta", DBNull.Value); } else { command.Parameters.AddWithValue("@v_id_linea_vta", LstLineaVtas.SelectedItem.Value.ToString()); } command.Parameters["@v_id_linea_vta"].Direction = ParameterDirection.Input; //var result = command.ExecuteNonQuery(); DataSet ds = new DataSet(); DataTable table = new DataTable(); MySqlDataAdapter mysqlDAdp = new MySqlDataAdapter(command); ///MySqlDataReader dr = command.ExecuteReader(); mysqlDAdp.Fill(table); if (table.Rows.Count == 0) { lbl_mensaje.Text = "Sin Resultados"; } else { Grilla.DataSource = table; Grilla.DataBind(); } lbl_mensaje.Text = "Cantidad de Registros: " + Grilla.Rows.Count.ToString(); conn.Close(); conn.Dispose(); } catch (Exception ex) { conn.Close(); conn.Dispose(); lbl_error.Text = ex.Message; } } }
protected void btnListar_Click(object sender, EventArgs e) { tu.Nombre = txtNombre.Text; Grilla.DataSource = tu.listar(); Grilla.DataBind(); }
void carga_clientes() { String queryString = ""; lbl_mensaje.Text = ""; queryString = "select cl.id_cliente, cl.rut + '-' + cl.Dv_Rut Rut, SUBSTRING(cl.razon_social,1,30) razon_social , pe.id_item ID_Item, pe.codigo, SUBSTRING(pe.descripcion,1,30) descripcion, mn.Sigla Moneda, pe.precio_lista , pe.precio, "; queryString = queryString + "IFNULL(pe.fecha_vigencia,IFNULL(pe.fecha_vigencia,DATE_SUB(NOW(),INTERVAL 24 HOUR))) fecha_vigencia, "; queryString = queryString + "IF(DATEDIFF(IFNULL(date(pe.fecha_vigencia),date(DATE_SUB(NOW(),INTERVAL 24 HOUR))),date(NOW())) > 0, 'S','N') Vigente "; queryString = queryString + "from tbl_clientes cl, tbl_precios_especiales pe, tbl_Monedas mn "; queryString = queryString + "where cl.ID_Cliente = pe.ID_Cliente "; queryString = queryString + "and pe.id_moneda = mn.ID_Moneda "; if (txt_idw.Text != "") { queryString = queryString + "and cl.id_cliente = " + txt_idw.Text; } if (txt_rutw.Text != "") { queryString = queryString + "and cl.rut = " + txt_rutw.Text; } if (txt_razonw.Text != "") { queryString = queryString + "and cl.Razon_Social like '%" + txt_razonw.Text + "%'"; } queryString = queryString + " order by cl.ID_Cliente "; using (MySqlConnection conn = new MySqlConnection(SMysql)) { try { conn.Open(); DataSet ds = new DataSet(); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = new MySqlCommand(queryString, conn); adapter.Fill(ds); if (ds.Tables[0].Rows.Count == 0) { lbl_mensaje.Text = "Sin Resultados"; } else { Grilla.DataSource = ds; Grilla.DataBind(); } //Productos.DataMember = "tbl_items"; conn.Close(); conn.Dispose(); } catch (Exception ex) { lbl_error.Text = ex.Message; conn.Close(); conn.Dispose(); } } }