Private
Sub
PopulateMyData()
' initialize variables
Dim
sqlConn
As
New
SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings(
"SQLConn2010"
).ToString)
Dim
sqlCmd
As
New
SqlCommand(
""
, sqlConn)
' open sql connection
sqlConn.Open()
With
sqlCmd
.CommandType = CommandType.StoredProcedure
If
ThisVariable.Length > 0
Then
' passed array search
.CommandText =
"prRunThisProcedure"
.Parameters.AddWithValue(
"@VariableList"
, ThisVariable)
Else
' standard search
.CommandText =
"prRunThatProcedureInstead"
.Parameters.AddWithValue(
"@someVariable"
, NullString(SomeParameter))
.Parameters.AddWithValue(
"@anotherVariable"
, NullString(AnotherParameter))
End
If
End
With
' execute query and read into sql data adapter
Dim
daTestObject
As
New
SqlDataAdapter(sqlCmd)
' fill datatable with results from sql adapter
Dim
dtTestObject
As
New
DataTable()
dtTestObject.Columns.Add(
"Name"
, Type.
GetType
(
"System.String"
))
dtTestObject.Columns.Add(
"ReportInfoID"
, Type.
GetType
(
"System.String"
))
daTestObject.Fill(dtTestObject)
' retrieve rowcount
Dim
RowCount
As
Integer
= dtTestObject.Rows.Count
' set datasource and bind if records were returned from stored procedure
If
(RowCount > 0)
Then
' bind datasource
rgTestGrid.DataSource = dtTestObject
rgTestGrid.DataBind()
End
If
End
Sub
<
telerik:RadGrid
ID
=
"rgTestGrid"
runat
=
"server"
GridLines
=
"None"
Width
=
"700px"
AllowPaging
=
"true"
PageSize
=
"25"
EnableViewState
=
"true"
>
<
MasterTableView
Caption
=
"This is the data"
CommandItemDisplay
=
"Top"
CommandItemSettings-ShowAddNewRecordButton
=
"false"
DataKeyNames
=
"ReportInfoID"
AllowPaging
=
"true"
NoDetailRecordsText
=
"Nothing Found."
>
<
PagerStyle
Mode
=
"NumericPages"
/>
<
CommandItemSettings
ShowExportToExcelButton
=
"true"
ShowExportToPdfButton
=
"true"
/>
<
Columns
>
<
telerik:GridTemplateColumn
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblRowCount"
runat
=
"server"
Width
=
"30px"
/>
</
ItemTemplate
>
<
HeaderStyle
Width
=
"30px"
/>
</
telerik:GridTemplateColumn
>
<
telerik:GridButtonColumn
UniqueName
=
"ReportURL"
DataTextField
=
"Name"
CommandName
=
"Select"
></
telerik:GridButtonColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
telerik:RadGrid
ID
=
"RadGrid2"
runat
=
"server"
AutoGenerateColumns
=
"False"
GridLines
=
"None"
Skin
=
"Sunset"
onitemdatabound
=
"RadGrid2_ItemDataBound"
AllowPaging
=
"True"
AllowSorting
=
"True"
onitemcommand
=
"RadGrid2_ItemCommand"
onpageindexchanged
=
"RadGrid2_PageIndexChanged"
onselectedindexchanged
=
"RadGrid2_SelectedIndexChanged"
AllowFilteringByColumn
=
"True"
onneeddatasource
=
"RadGrid2_NeedDataSource"
EnableLinqExpressions
=
"False"
Culture
=
"es-MX"
onitemcreated
=
"RadGrid2_ItemCreated"
>
<
GroupingSettings
CaseSensitive
=
"False"
/>
<
ClientSettings
EnablePostBackOnRowClick
=
"True"
>
<
Selecting
AllowRowSelect
=
"True"
/>
</
ClientSettings
>
<
MasterTableView
>
<
CommandItemSettings
ExportToPdfText
=
"Export to Pdf"
></
CommandItemSettings
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"fiCircuito"
HeaderText
=
"Circuito"
UniqueName
=
"columnCirc"
AutoPostBackOnFilter
=
"true"
ShowFilterIcon
=
"false"
FilterDelay
=
"500"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"nom_edo"
HeaderText
=
"Estado"
UniqueName
=
"columnEdo"
AutoPostBackOnFilter
=
"true"
ShowFilterIcon
=
"false"
FilterDelay
=
"500"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"nom_cd"
HeaderText
=
"Ciudad"
UniqueName
=
"columnCd"
AutoPostBackOnFilter
=
"true"
ShowFilterIcon
=
"false"
FilterDelay
=
"500"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"fiIdSolicitud"
HeaderText
=
"Folio"
UniqueName
=
"columnFolio"
AutoPostBackOnFilter
=
"true"
ShowFilterIcon
=
"false"
FilterDelay
=
"250"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"nom_padre"
HeaderText
=
"Nombre Madre/Padre"
UniqueName
=
"columnPadre"
AutoPostBackOnFilter
=
"true"
ShowFilterIcon
=
"false"
FilterDelay
=
"500"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"nom_menor"
HeaderText
=
"Nombre del Menor"
UniqueName
=
"column1"
AutoPostBackOnFilter
=
"true"
ShowFilterIcon
=
"false"
FilterDelay
=
"500"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"columnIdM"
DataField
=
"fiIdMenor"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Fecha"
UniqueName
=
"column4"
DataField
=
"fech_baja"
AllowFiltering
=
"false"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ind_baja"
HeaderText
=
"Estatus Empleado"
UniqueName
=
"columnEstatus"
AllowFiltering
=
"false"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridButtonColumn
ButtonType
=
"ImageButton"
HeaderText
=
"Avisos"
UniqueName
=
"column2"
ImageUrl
=
"~/imgs/new-message-icon.png"
CommandName
=
"Avisos"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridButtonColumn
>
<
telerik:GridButtonColumn
ButtonType
=
"ImageButton"
HeaderText
=
"Actualiza Estado"
UniqueName
=
"column3"
ImageUrl
=
"~/imgs/refresh_document-icon.gif"
CommandName
=
"Actualiza"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridButtonColumn
>
<
telerik:GridBoundColumn
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Estatus"
DataField
=
"fcDescEdoSol"
UniqueName
=
"fcDescEdoSol"
Visible
=
"False"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
></
HeaderStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Adscripción Actual"
UniqueName
=
"columnAdscAct"
DataField
=
"area_Nueva"
Visible
=
"false"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Expediente "
DataField
=
"fiExpEmpleado"
UniqueName
=
"EXPEDIENTE"
Visible
=
"False"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
></
HeaderStyle
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
Afternoon folks.
I am using a radgrid as this has lots of functionality that I wish to keep (exporting, line selection, scrolling, etc) but I have come across a request I'm not sure how to handle and as such, I'd like some advice!
I have a radgrid attached to an object datasource implementing a SelectMethod of GetProductList and a SelectCountMethod of CountProductItems.This would return something along the lines of:
With CountProductItems returning 9.
What I need to do with this is dynamically set the radgrid so that the paging is defined by the guid i.e. one page for each guid present.
So in the above example, we'd have 3 pages.
On page load you'd be shown Page 1:
With the pager items displaying 1, 2, 3.
Click on page 2 and you'd see:
and clicking on page 3:
Does that makes sense? Is it possible and if so, any pointers greatly appreciated.
<%
@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!
DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html xmlns="http://www.w3.org/1999/xhtml">
<
head runat="server">
<title></title>
<telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" />
<style type="text/css">
div.wrapper {
width:100%;
}
div.left_column {
width:150px;
float:left;
text-align:center;
vertical-align:middle;
}
div.right_column {
width:150px;
float:right;
text-align:center;
vertical-align:middle;
}
</style>
</
head>
<
body>
<form id="form1" runat="server">
<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
<Scripts>
<%
--Needed for JavaScript IntelliSense in VS2010--%>
<%
--For VS2008 replace RadScriptManager with ScriptManager--%>
<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />
<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />
<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />
</Scripts>
</telerik:RadScriptManager>
<script type="text/javascript">
//Put your JavaScript code here.
</script>
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
</telerik:RadAjaxManager>
<div>
<%
-- does not work --%>
<telerik:RadToolBar runat="server" ID="RadToolBar1" Width="100%">
<Items>
<telerik:RadToolBarButton>
<ItemTemplate>
<div class="wrapper">
<div class="left_column">
left Collumn
</div>
<div class="right_column">
right Collumn
</div>
</div>
</ItemTemplate>
</telerik:RadToolBarButton>
</Items>
</telerik:RadToolBar>
<br />
<%
-- works fine --%>
<div class="wrapper">
<div class="left_column">
left Collumn
</div>
<div class="right_column">
right Collumn
</div>
</div>
</div>
</form>
</
body>
</
html>