Hi! can you help me.

i have a radgrid  with a lot of data ( more 10 pages, and 14 items/pages) , i want
i have add 1 column "auto number to radgrid"  to display numbers record.
 <Columns>
            <telerik:GridBoundColumn DataField="STT" HeaderText="STT" DataType="System.Int32"  UniqueName="STT"
             <HeaderStyle Width="70px" />
            </telerik:GridBoundColumn>
...
<Columns />
-  Database i don't have field "STT".
in "RadGrid1_ItemDataBound"  is

--- int rowCount = (RadGrid1.MasterTableView.CurrentPageIndex * RadGrid1.MasterTableView.PageSize) + (e.Item.ItemIndex + 1);

----------                item["STT"].Text = rowCount.ToString();

-  set of export
---<ExportSettings Excel-Format="Html"
    ----       HideStructureColumns="true"
    ----       ExportOnlyData="true"
    ----       IgnorePaging="true" 
     ---      OpenInNewWindow="true">
    ----    </ExportSettings>

 and exportExcel_OnClick

--- RadGrid1.MasterTableView.ExportToExcel();

Proplem: when I was  opening  in pages 3 ( other first page) of datagirdview.( rowcount from 33 to 44 ex)  . so item [STT ] is  33 to 44

 I click button “Export excel” , file excel was exported include : all record of database but

IN ITEM [STT] DISLAY  FROM  33 to ALL. (NOT  FROM 1)

. I WANT WHEN I OPEN  AT RANDOM PAGE (other first page) , I EXPORT ALL DATABASE, AND  item [STT ] is  1 to ALL

THANKS YOU! PLEASE HELP ME
.

public DataTable PivotTable(DataTable source)

{

DataTable dest = new DataTable("Pivoted" + source.TableName);

dest.Columns.Add(

" ");

foreach (DataRow r in source.Rows)

dest.Columns.Add(r[0].ToString());

for (int i = 0; i < source.Columns.Count - 1; i++)

{

dest.Rows.Add(dest.NewRow());

}

for (int r = 0; r < dest.Rows.Count; r++)

{

for (int c = 0; c < dest.Columns.Count; c++)

{

if (c == 0)

dest.Rows[r][0] = source.Columns[r + 1].ColumnName;

else

return dest;

}

protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

RadGrid1.DataSource = PivotTable(GetDataTable(

"SELECT CONVERT(varchar,StatDate,101) StatDate,FelonyArrests,MisdArrests,NTA,FSAO,TrafficArrests,WarrantArrests,DispCalls,SelfInitActivities,[BackUp] BackUps,FIR," +

"VehRecov,TrafficCitations,CourtesyNotices,TrafficStops,WarrantsServed,WarrantsObtained,NewGangFiles,GangFileUpd,Presentations,InvestHours," +

"IntelRpts,PropValRecov,GunsRecov,IntelBullitens,SearchWarrantHours,TasksAssigned,TasksTrans,TasksCleared,AssignedActive,Transfered," +

"ClearedByArrest,EC,Unfounded,Closed,Inactive,Surveillance,Callouts,SearchWarrants FROM Gang_Stats ORDER BY StatDate asc"));

protected void RadGrid1_ColumnCreated(object sender, Telerik.Web.UI.GridColumnCreatedEventArgs e)

{

if (e.Column.UniqueName == "StatDate")

{

GridBoundColumn boundColumn = e.Column as GridBoundColumn;

boundColumn.DataFormatString =

"{0:d}";

boundColumn.ItemStyle.Font.Bold =

true;

}

}