public static DataSet Get(string tableQuery) { QueryServiceClient client = new QueryServiceClient(); DataSet dataSet = new DataSet(); Paging paging = null; try { if (string.IsNullOrEmpty(Logon.User) && string.IsNullOrEmpty(Logon.Password)) { client.ClientCredentials.Windows.ClientCredential.Domain = Logon.Domain; client.ClientCredentials.Windows.ClientCredential.UserName = Logon.DefaultUser; client.ClientCredentials.Windows.ClientCredential.Password = Logon.DefaultPassword; } else { client.ClientCredentials.Windows.ClientCredential.Domain = Logon.Domain; client.ClientCredentials.Windows.ClientCredential.UserName = Logon.User; client.ClientCredentials.Windows.ClientCredential.Password = Logon.Password; } dataSet = client.ExecuteStaticQuery(tableQuery, ref paging); } catch (Exception ex) { string msg = ex.Message; } return(dataSet); }
public static DataSet Paging() { QueryServiceClient client = new QueryServiceClient(); Paging paging = new ValueBasedPaging() { RecordLimit = 20 }; DataSet dataset; int page = 10; int i = 0; do { dataset = client.ExecuteStaticQuery("STMSalesDaily", ref paging); DataRow row = dataset.Tables[0].Rows[0]; i++; if (i == page) { return(dataset); } }while (((ValueBasedPaging)paging).Bookmark != null); return(dataset); }
public static DataSet Get(string tableQuery) { QueryServiceClient client = new QueryServiceClient(); DataSet dataSet = new DataSet(); Paging paging = null; try { client.ClientCredentials.Windows.ClientCredential.Domain = UserAccount.Domain; client.ClientCredentials.Windows.ClientCredential.UserName = UserAccount.Username; client.ClientCredentials.Windows.ClientCredential.Password = UserAccount.Password; dataSet = client.ExecuteStaticQuery(tableQuery, ref paging); } catch (Exception ex) { string msg = ex.Message; } return(dataSet); }