file : ---Web.config ---

<connectionstrings> <add name="conn" connectionstring="server=192.168.1.237;database=star;uid=dba;password=sql" providername="iAnywhere.Data.SQLAnywhere.v3.5"/>

</connectionStrings>

---test.asmx.cs---

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; using System.Data.Odbc; using System.Data; using System.Data.SqlClient; using iAnywhere.Data.SQLAnywhere; using System.Web.Extensions; using System.Web.Script.Serialization; using System.Text.RegularExpressions; using System.Text; namespace WebService1 { /// <summary> /// Service1
/// </summary> [WebService(Namespace = "http://WebService/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] [System.Web.Script.Services.ScriptService] public class Service1 : System.Web.Services.WebService { [WebMethod] public List<string> result(String tb_name,String command) { return test(tb_name, command, return_str(tb_name)); //return test("part", "part_id='0011'", return_str("part")); } private List<string> test(String str_tb_name,String command,List<string> tb_name) {

        List<String> list = new List<String>();
        List<String> list_result = new List<String>();
        string strOdbcConn = "Driver={SQL Anywhere 12};SERVER=mm;DBN=star;UID=dba;PWD=MyPassword";

        OdbcConnection oLogConn;
        OdbcCommand oLogCmd;
        String strSql = "";
        if (command != "")
        {
            strSql = "SELECT * FROM " + str_tb_name + " WHERE " + command;
        }
        else { 
            strSql = "SELECT * FROM " + str_tb_name;
        }


        try
        {
            oLogConn = new OdbcConnection(strOdbcConn);
            oLogCmd = new OdbcCommand(strSql, oLogConn);
            oLogConn.Open();
            OdbcDataReader MyLogDataReader = oLogCmd.ExecuteReader(CommandBehavior.CloseConnection);
            while (MyLogDataReader.Read())
            {
                int count = 0;
                while (count < MyLogDataReader.FieldCount - 1)
                {

list.Add(MyLogDataReader[count].ToString());

                    count++;
                }
                for (int i=0; i < list.Count - 1; i++) {      //to
                    list_result.Add(tb_name[i] + ":" + list[i]);
                }
                list.Clear();

            }
            return list_result;
        }
        catch (Exception ex)
        {
            Console.Write(ex);
            list.Add(ex.ToString());
            return list;
        }
    }

private List<string> return_str(String str_tb_name) { List<string> lists = new List<string>(); String strOdbcConn = "ODBC;Driver=Sybase SQL Anywhere 5.0;DefaultDir=C:\DatabasePath\;Dbf=C:\SqlAnyWhere50\MyDatabase.db;Uid=dba;Pwd=MyPassword;Dsn=\"\";"; OdbcConnection oLogConn; OdbcCommand oLogCmd; String strSql = "SELECT * FROM pbcatcol where pbc_tnam='" + str_tb_name + "'"; //name try { oLogConn = new OdbcConnection(strOdbcConn); oLogCmd = new OdbcCommand(strSql, oLogConn); oLogConn.Open(); OdbcDataReader MyLogDataReader = oLogCmd.ExecuteReader(CommandBehavior.CloseConnection); while (MyLogDataReader.Read()) { lists.Add(MyLogDataReader[3].ToString()); //clomn } return lists; } catch (Exception ex) { lists.Add("ERROR2"); return lists; } finally {

        }
    }
}

}