Hi Roman, can you provide more detail?
I've tried instead to declare a SQLDataSource control on the web part...
<cms:SQLDataSource id="testDataSource" runat="server" />
...then change my code behind to this:
testDataSource.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["CMSConnectionString"].ConnectionString;
testDataSource.QueryText = "SELECT * FROM [dbo].[MYTABLE]";
testDataSource.QueryType = CMS.DataEngine.QueryTypeEnum.SQLQuery;
testDataSource.UniPagerControl = uniPager;
CMSRepeater2.DataSource = testDataSource.DataSource;
But this also just loads all records and doesn't neither obeys the UniPager settings nor displays the UniPager.
This must be a common requirement. Please can anyone explain how to create a web part with a repeater and a pager?