Listar
------------------------------------

        protected void BtnListBox_Click(object sender, EventArgs e)
        {
            try
            {
                Conexion();
                Con.Open();
                CargarTabla();
                DataTable tabla;
                tabla = Dset.Tables["Datos_Video"];
                foreach (DataRow FFila in tabla.Rows)
                {
                    ListBox1.Items.Add(FFila[0].ToString().PadLeft(12, ' ') +
                                       FFila[1].ToString().PadLeft(10, ' ') +
                                       FFila[2].ToString().PadLeft(10, ' ') +
                                       FFila[3].ToString().PadLeft(10, ' ') +
                                       FFila[4].ToString().PadLeft(10, ' ') +
                                       FFila[5].ToString().PadLeft(10, ' ') +
                                       FFila[6].ToString().PadLeft(10, ' ') +
                                       FFila[7].ToString().PadLeft(10, ' '));
                }
            }
            catch (Exception AA)
            {
                Response.Write("Error" + AA);
            }
        }
        
Buscar por RUT
___________________________-
protected void busrut(object sender, EventArgs e)
        {
            conectar();
            DataTable tabla = new DataTable();
            Tabb = new SqlCommand("select * from cliente where rut_cli='" + txtbusrut.Text.Trim() + "'", Conn);
            Dadap.SelectCommand = Tabb;
            Dadap.SelectCommand.ExecuteNonQuery();

            Dadap.Fill(Dset2);
            tabla = Dset2.Tables[0];



            ListBox1.Items.Clear();
            foreach (DataRow Fila in tabla.Rows)
            {
                this.ListBox1.Items.Add(Fila[0].ToString() + "\t" +
                                        Fila[1].ToString() + "\t" +
                                        Fila[2].ToString() + "\t" +
                                        Fila[3].ToString() + "\t" +
                                        Fila[4].ToString() + "\t" +
                                        Fila[5].ToString() + "\t" +
                                        Fila[6].ToString() + "\t" +
                                        Fila[7].ToString() + "\t");


            }

            desconectar();
        }


Buscar por Nombre
___________________________-
protected void busnom_Click(object sender, EventArgs e)
        {
            String nombre = "";
            nombre = txtbusnom.Text.Trim();
            conectar();
            DataTable tabla = new DataTable();
            Tabb = new SqlCommand("select * from cliente where nom_cli like '" + nombre + "%'", Conn);
            Dadap.SelectCommand = Tabb;
            Dadap.SelectCommand.ExecuteNonQuery();

            Dadap.Fill(Dset2);
            tabla = Dset2.Tables[0];



            ListBox1.Items.Clear();
            foreach (DataRow Fila in tabla.Rows)
            {
                this.ListBox1.Items.Add(Fila[0].ToString() + "\t" +
                                        Fila[1].ToString() + "\t" +
                                        Fila[2].ToString() + "\t" +
                                        Fila[3].ToString() + "\t" +
                                        Fila[4].ToString() + "\t" +
                                        Fila[5].ToString() + "\t" +
                                        Fila[6].ToString() + "\t" +
                                        Fila[7].ToString() + "\t");


            }

            desconectar();
        }