private static void ExecuteSAPQuery(R3Connection con)
{
using (con)
{
con.Open(false);
// Create Query object Query q;
Query q;
try
{
q = con.CreateQuery(WorkSpace.GlobalArea, "/SAPQUERY/QD", "CONNECTIONS_02");
//q.Variant = "ALL";
q.MaxRows = 1000;
}
catch (Exception e1)
{
Console.WriteLine(e1.ToString());
return;
}
// Add a criteria (in this case the material number)
//q.SelectionParameters["SP$00017"].Ranges.Add(Sign.Include, RangeOption.Equals, "100-100");
// Add a second criteria (in this case the currency)
//q.SelectionParameters["S_WAERS"].Ranges.Add(Sign.Include, RangeOption.Equals, "EUR");
// Run the Query
q.Execute();
// Bind result to datagrid
DataTable table = q.Result;
Console.Read();
}
}