//consult for ID
public static Array QueryID(int id)
{
string[] result = new string[] { };
MySqlCommand comando = new MySqlCommand(string.Format("select * from contact where id=" + id), Conexion.ObtenerConexion());
MySqlDataReader reader = comando.ExecuteReader();
if (reader.Read() == true)
{
contact c = new contact();
string i = c.Idd = reader.GetString(0);
string n = c.Name = reader.GetString(1);
string ln = c.LastName = reader.GetString(2);
string a = c.Address = reader.GetString(3);
string p = c.Phone = reader.GetString(4);
string e = c.Email = reader.GetString(5);
string cr = c.Created = reader.GetString(6);
result = new string[] { i, n, ln, a, p, e, cr };
}
Conexion.CerrarConexion();
return(result);
}
//consult all records
public static List <contact> Query()
{
List <contact> lista = new List <contact>();
MySqlCommand comando = new MySqlCommand(string.Format("select * from contact"), Conexion.ObtenerConexion());
MySqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
contact c = new contact();
c.Idd = reader.GetString(0);
c.Name = reader.GetString(1);
c.LastName = reader.GetString(2);
c.Address = reader.GetString(3);
c.Phone = reader.GetString(4);
c.Email = reader.GetString(5);
c.Created = reader.GetString(6);
lista.Add(c);
}
Conexion.CerrarConexion();
return(lista);
}