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);
}
