This is a migrated thread and some comments may be shown as answers.

Gird & export excel

0 Answers 34 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Sunrise
Top achievements
Rank 1
Sunrise asked on 21 Sep 2012, 01:59 AM

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
.

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Sunrise
Top achievements
Rank 1
Share this question
or