private static List<datatable> SplitTable(DataTable originalTable, int batchSize)
{
List<datatable> tables = new List<datatable>();
int i = 0;
int j = 1;
DataTable newDt = originalTable.Clone();
newDt.TableName = "Table_" + j;
newDt.Clear();
foreach (DataRow row in originalTable.Rows)
{
DataRow newRow = newDt.NewRow();
newRow.ItemArray = row.ItemArray;
newDt.Rows.Add(newRow);
i++;
if (i == batchSize)
{
tables.Add(newDt);
j++;
newDt = originalTable.Clone();
newDt.TableName = "Table_" + j;
newDt.Clear();
i = 0;
}
}
{
if ((SampleDatagrid.ScrollInfo.VerticalOffset) > 400)
if (((SampleDatagrid.Records.Count / 4) * 3) < SampleDatagrid.ScrollInfo.VerticalOffset)
{
SampleDatagrid.DataSource = SystemDataHelpers.RowList(dt, 0, 300+Convert.ToInt32(SampleDatagrid.ScrollInfo.VerticalOffset));
Scrollcount = Scrollcount + 1;
scrollsize = scrollsize + 500;
fillDatagrid(ldtdt);
}
}
i am using Infragistics controls
{
if ((SampleDatagrid.ScrollInfo.VerticalOffset) > 400)
if (((SampleDatagrid.Records.Count / 4) * 3) < SampleDatagrid.ScrollInfo.VerticalOffset)
{
SampleDatagrid.DataSource = SystemDataHelpers.RowList(dt, 0, 300+Convert.ToInt32(SampleDatagrid.ScrollInfo.VerticalOffset));
Scrollcount = Scrollcount + 1;
scrollsize = scrollsize + 500;
fillDatagrid(ldtdt);
}
}
SampleDatagrid.DataSource = dt.DefaultView;
I got Solution but my Scroll is going top when i load data
but i want to My scroll should stay there only