public static bool OpenSql(DataTable table, String sql, String paramvalue, String pageinfo, String dsname) { try { InParams inparams = SDPClient.NewInParams(); OutParams outparams = SDPClient.NewOutParams(); inparams.SetRequestBody("ServiceName", "DataServices"); inparams.SetRequestBody("ServiceItem", "OpenSql"); inparams.SetRequestBody("SQL", sql); inparams.SetRequestBody("PageInfo", pageinfo); inparams.SetRequestBody("DataSource", dsname); if (TableUtil.IsAutoMetaData(table)) { inparams.SetRequestBody("AutoMetaData", "1"); } else { inparams.SetRequestBody("TableName", table.TableName); } inparams.SetRequestParams(paramvalue); SDPClient.CallService(inparams, outparams); DataTable resulttable = outparams.GetTableParam(0).GetDataTableValue(); DataUtil.CopyTable(resulttable, table); TableUtil.SetProperty(table, "DataSource", outparams.GetStrParamValue("DataSource")); TableUtil.SetProperty(table, "Command", outparams.GetStrParamValue("Command")); return(true); } catch (Exception e) { System.Console.Out.WriteLine("DataServices.OpenSql Exception: {0}", e); throw e; } }