protected
void
Button1_Click(
object
sender, EventArgs e)
{
DataTable dt =
new
DataTable();
OleDbDataAdapter da=
new
OleDbDataAdapter(
"Select NAME, PHONE FROM TBL_CITY WHERE POP='"+TextBox1.Text+"' and ROWNUM<150"
,conn);
da.Fill(dt);
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
<
telerik:RadGrid
ID
=
"RadGrid2"
runat
=
"server"
AllowPaging
=
"True"
>
</
telerik:RadGrid
>
<
telerik:RadGrid
ID
=
"RadCagri"
runat
=
"server"
CellSpacing
=
"0"
Culture
=
"tr-TR"
Height
=
"380px"
GridLines
=
"None"
AllowPaging
=
"True"
AutoGenerateColumns
=
"False"
CssClass
=
"Grid_Modul"
AllowFilteringByColumn
=
"True"
AllowSorting
=
"True"
Skin
=
"Simple"
>
<
MasterTableView
DataKeyNames
=
"GERCEKADI"
HierarchyLoadMode
=
"Client"
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
>
</
EditFormSettings
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
/>
<
RowIndicatorColumn
FilterControlAltText
=
"Filter RowIndicator column"
></
RowIndicatorColumn
>
<
ExpandCollapseColumn
FilterControlAltText
=
"Filter ExpandColumn column"
></
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"GERCEKADI"
HeaderText
=
"Çağrı Merkezi Uzm."
FilterControlAltText
=
"Filter GERCEKADI column"
UniqueName
=
"GERCEKADI"
FilterControlWidth
=
"250px"
><
ItemStyle
Wrap
=
"False"
/></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"TXTUNVAN"
HeaderText
=
"Müşteri Adı"
FilterControlAltText
=
"Filter TXTUNVAN column"
UniqueName
=
"AG"
DataType
=
"System.String"
FilterControlWidth
=
"400px"
>
<
ItemStyle
Wrap
=
"False"
/></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"TXTPROJEADI"
HeaderText
=
"Proje"
FilterControlAltText
=
"Filter TXTPROJEADI column"
DataType
=
"System.String"
UniqueName
=
"TXTPROJEADI"
>
<
ItemStyle
Wrap
=
"False"
/></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"LNGMERKEZKOD"
HeaderText
=
"merkez Kod"
FilterControlAltText
=
"Filter LNGMERKEZKOD column"
DataType
=
"System.Int32"
UniqueName
=
"LNGMERKEZKOD"
Display
=
"false"
>
<
ItemStyle
Wrap
=
"False"
/></
telerik:GridBoundColumn
>
<
telerik:GridDateTimeColumn
DataField
=
"TRHTARIH"
DataFormatString
=
"{0:dd/MM/yyyy}"
DataType
=
"System.DateTime"
FilterControlAltText
=
"Filter TRHTARIH column"
FilterControlWidth
=
"150px"
HeaderText
=
"Arama Tarihi"
UniqueName
=
"TRHTARIH"
>
<
ItemStyle
Wrap
=
"False"
/></
telerik:GridDateTimeColumn
>
<
telerik:GridDateTimeColumn
DataField
=
"TXTSAAT"
DataFormatString
=
"{0:HH:mm:ss}"
DataType
=
"System.DateTime"
FilterControlWidth
=
"100px"
FilterControlAltText
=
"Filter TXTSAAT column"
HeaderText
=
"Arama Saati"
MinDate
=
""
UniqueName
=
"TXTSAAT"
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridBoundColumn
DataField
=
"TXTDEPARTMAN"
HeaderText
=
"Çağrı Kuyruğu"
FilterControlAltText
=
"Filter TXTDEPARTMAN column"
DataType
=
"System.String"
UniqueName
=
"TXTDEPARTMAN"
>
<
ItemStyle
Wrap
=
"False"
/></
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
>
<
DataBinding
Location
=
"GridMasterDetailsService.svc"
FilterParameterType
=
"Linq"
SelectMethod
=
"GetCLG"
SortParameterType
=
"Linq"
ShowEmptyRowsOnLoad
=
"True"
>
</
DataBinding
>
<
ClientEvents
OnDataBound
=
"RadCagri_DataBound"
OnDataBinding
=
"RadCagri_DataBinding"
OnGridCreated
=
"RadCagriCriteria"
/>
<
Selecting
AllowRowSelect
=
"True"
></
Selecting
>
<
Scrolling
AllowScroll
=
"True"
></
Scrolling
>
</
ClientSettings
>
<
FilterMenu
EnableImageSprites
=
"False"
>
</
FilterMenu
>
<
HeaderContextMenu
CssClass
=
"GridContextMenu GridContextMenu_Default"
></
HeaderContextMenu
></
telerik:RadGrid
>
RadCagri.ExportSettings.ExportOnlyData =
True
RadCagri.ExportSettings.IgnorePaging =
True
RadCagri.ExportSettings.OpenInNewWindow =
True
RadCagri.MasterTableView.HierarchyLoadMode = GridChildLoadMode.ServerBind
RadCagri.MasterTableView.ExportToExcel()
<
telerik:RadToolTipManager
ID
=
"RadToolTipManager1"
OffsetY
=
"-1"
HideEvent
=
"ManualClose"
ShowEvent
=
"OnClick"
Skin
=
"Office2010Silver"
Width
=
"500"
Height
=
"175"
runat
=
"server"
OnAjaxUpdate
=
"OnAjaxUpdate"
RelativeTo
=
"Element"
Position
=
"MiddleLeft"
/>
<
asp:Repeater
ID
=
"rptrMyRepeater"
runat
=
"server"
OnItemDataBound
=
"myRepeater_OnItemDataBound"
>
<
ItemTemplate
>
<
div
>
<
asp:LinkButton
runat
=
"server"
ID
=
"btnEmailAttachment"
Text
=
"Open Popup"
OnClientClick
=
"return false;"
/>
</
div
>
</
ItemTemplate
>
</
asp:Repeater
>
MyPage.aspx.cs
protected
void
myRepeater_OnItemDataBound(
object
o, RepeaterItemEventArgs e)
{
if
(e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
RadToolTipManager1.TargetControls.Add(((LinkButton)e.Item.FindControl(
"btnEmailAttachment"
)).ClientID, Convert.ToString(DataBinder.Eval(e.Item.DataItem,
"RequestID"
)),
true
);
}
}
protected
void
OnAjaxUpdate(
object
sender, ToolTipUpdateEventArgs args)
{
int
requestID = Convert.ToInt32(args.Value);
Control ctrl = Page.LoadControl(
"EmailBox.ascx"
);
args.UpdatePanel.ContentTemplateContainer.Controls.Add(ctrl);
CollateralCentral_EmailBox emailBox = (CollateralCentral_EmailBox)ctrl;
emailBox.RequestID = requestID;
}
EmailBox.ascx
<
telerik:RadAjaxPanel
ID
=
"RadAjaxPanel1"
runat
=
"server"
>
<
telerik:RadComboBox
ID
=
"drpdwnEmail1"
runat
=
"server"
Width
=
"350px"
Height
=
"140px"
EnableLoadOnDemand
=
"True"
OnItemsRequested
=
"RadComboBox1_ItemsRequested"
/>
</
telerik:RadAjaxPanel
>
EmailBox.ascx.cs
protected
void
RadComboBox1_ItemsRequested(
object
o, RadComboBoxItemsRequestedEventArgs e)
{
drpdwnEmail1.Items.Clear();
if
(e.Text.Trim().Length > 2)
// make them type at least 3 letters
{
DataTable dt = GetDataTable();
for
(
int
i = 0; i < dt.Rows.Count; i++)
{
drpdwnEmail1.Items.Add(
new
RadComboBoxItem((
string
)dt.Rows[i][
"Email_addr"
], Convert.ToString(dt.Rows[i][
"Email_addr"
])));
}
dt.Dispose();
}
}
I am not sure in this example how to get past this error - I need to load the control in the manner I am loading it and can't do it each time a postback happens, and I need to populate the email dropdown server-side because there are about 100,000 email addresses so I want them to start typing before they see anything...
Any help would be greatly appreciated!!!
RadGrid4.ExportSettings.ExportOnlyData =
False
RadGrid4.ExportSettings.IgnorePaging =
True
RadGrid4.ExportSettings.OpenInNewWindow =
True
RadGrid4.MasterTableView.ExportToExcel()
and it works just fine, but i would like to know if there is a way to export columns that are hidden, because i'm only showing 4 columns and there are like 50 columns on the table and i need to export all of them but i'm just getting the ones that are not hidden, is there a way get them all?
thanks in advanced.