IfxConnection conn = new IfxConnection();
string cs = "Host=192.168.0.1;Service=9908;DataBase=mydb;Server=on_public;User ID=informix;Password=123456;Client_Locale=en_us.CP1252;DB_LOCALE=en_US.819";
conn.ConnectionString = cs;
conn.Open();

 1 IfxConnection connection = GetConnection();
 2 connection.Open();
 3 List<Hashtable> list = new List<Hashtable>();
 4 IfxCommand cmd = new IfxCommand(sql, connection);
 5 IfxDataReader reader = cmd.ExecuteReader();
 6 
 7 int count = reader.FieldCount;
 8 while (reader.Read())
 9 {
10     Hashtable row = new Hashtable();
11     for(int i = 0; i < count; i++)
12     {
13         string colname = reader.GetName(i);
14         object value;
15         if (reader.IsDBNull(i))
16         {
17             value = null;
18         }
19         else
20         {
21             value = reader.GetValue(i);
22             string type = value.GetType().Name.ToLower();
23             if (type.Contains("string"))
24             {
25                 //Encoding.Default.GetBytes(value.ToString());
26                 byte[] bytes = Encoding.GetEncoding("ISO-8859-1").GetBytes(value.ToString());
27                 value = Encoding.Default.GetString(bytes);
28             }
29         }
30 
31         row[colname] = value;
32     }
33     list.Add(row);
34 }
35 
36 connection.Close();