Populate GridView in Server Mode Using Tables Provided at Runtime

Hi thanks for the reply. Currently using the code in Q13841 it seems to be getting column names but not actually populating rows. I'll continue to look into that but I was wondering if I could maybe get a roundup of any solutions proposed to Q33919 as that particular case is marked as private therefore I can't get any help from that point currently. If there was anything mentioned in that case that is relevant to this one I would be grateful for it to be regurgitated here.
thanks

to assist further heres the code currently. Column names are showing up fine but as mentioned above no rows are being populated
            InitializeComponent();
            SqlConnection conn = new SqlConnection("server=(local); Initial Catalog=Contoso_NAV_Staging_2; Integrated Security=SSPI");
            conn.Open();
            SqlCommand cmd = new SqlCommand("Select top 1 * from [dbo].[G_L Entry]", conn);
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.KeyInfo);
            DataTable table = new DataTable("myTable");
            table.Load(reader);
            conn.Close();
            ReflectionDictionary dict = new ReflectionDictionary();
            XPClassInfo classInfo = new XPDataObjectClassInfo(dict.GetClassInfo(typeof(LiteDataObject)), "dataset");
            List<string> keyColumns = new List<string>();
            foreach (DataColumn key in table.PrimaryKey)
            {
                keyColumns.Add(key.ColumnName);
            }
            foreach (DataColumn col in table.Columns)
            {
                if (keyColumns.Contains(col.ColumnName)) {
                    classInfo.CreateMember(col.ColumnName, col.DataType, new KeyAttribute());
                }
                else
                {
                    classInfo.CreateMember(col.ColumnName, col.DataType);
                }
            }
            xpServerCollectionSource1 = new XPServerCollectionSource(session1, classInfo);
            XpoDefault.DataLayer = XpoDefault.GetDataLayer(DevExpress.Xpo.DB.MSSqlConnectionProvider.GetConnectionString(@"(local)", "Contoso_NAV_Staging_2"), dict, AutoCreateOption.None);

gridControl1.ServerMode = true;
            gridControl1.DataSource = xpServerCollectionSource1;

Don't worry I believe I just got it working. I haven't tested it fully but I have got it going for a table with 300,000 rows in it. I'll post the solution up Monday if I remember after checking over it a bit so that future users can make use of the code.
Thanks