public static DataTable buscaDatosPlural2() { DataTable tabla = new dataCredito.datosSing2DataTable(); using (SQLiteConnection con = new SQLiteConnection(Datos.conexion)) { using (SQLiteCommand comando = new SQLiteCommand()) { comando.CommandText = "select * from datosPlural2"; comando.Connection = con; con.Open(); SQLiteDataReader lector = comando.ExecuteReader(); while (lector.Read()) { DataRow fila = tabla.NewRow(); fila["nombre"] = lector.GetString(0); fila["direccion"] = lector.GetString(1); fila["direccion2"] = lector.GetString(2); fila["ciudad"] = lector.GetString(3); fila["id"] = lector.GetString(4); fila["idCliente"] = lector.GetInt32(5); fila["anio"] = lector.GetInt32(6); fila["asesor"] = lector.GetString(7); fila["cantidad"] = lector.GetString(8); fila["cantidadL"] = lector.GetString(9); fila["fecha"] = lector.GetDateTime(10); fila["meses"] = lector.GetString(11); fila["pie"] = lector.GetString(12); tabla.Rows.Add(fila); } } con.Close(); } return (tabla); }
public static DataTable consulta(string nombre) { DataTable tabla = new dataCredito.datosSing2DataTable(); using (SQLiteConnection con = new SQLiteConnection(Datos.conexion)) { using (SQLiteCommand comando = new SQLiteCommand()) { comando.CommandText = string.Format("select * from datosSing4 where nombre like '%{0}%' ", nombre); comando.Connection = con; con.Open(); SQLiteDataReader lector = comando.ExecuteReader(); while (lector.Read()) { DataRow fila = tabla.NewRow(); fila["nombre"] = lector.GetString(0); fila["direccion"] = lector.GetString(1); fila["direccion2"] = lector.GetString(2); fila["ciudad"] = lector.GetString(3); fila["id"] = lector.GetString(4); fila["idCliente"] = lector.GetInt32(5); fila["asesor"] = lector.GetString(6); fila["encabezado"] = lector.GetString(7); fila["fecha"] = lector.GetDateTime(8); fila["pie"] = lector.GetString(9); fila["saludo"] = lector.GetString(10); tabla.Rows.Add(fila); } } con.Close(); } return (tabla); }
public static DataTable consulta2(string nombre) { DataTable tabla = new dataCredito.datosSing2DataTable(); using (SQLiteConnection con = new SQLiteConnection(Datos.conexion)) { using (SQLiteCommand comando = new SQLiteCommand()) { comando.CommandText = string.Format("select * from datosSing44 where nombre like '%{0}%' ", nombre); comando.Connection = con; con.Open(); SQLiteDataReader lector = comando.ExecuteReader(); while (lector.Read()) { DataRow fila = tabla.NewRow(); fila["nombre"] = lector.GetString(0); fila["direccion"] = lector.GetString(1); fila["direccion2"] = lector.GetString(2); fila["ciudad"] = lector.GetString(3); tabla.Rows.Add(fila); } } con.Close(); } return (tabla); }