<
telerik:RadGrid
AutoGenerateColumns
=
"False"
ID
=
"xgrdApprovedAuths"
AllowSorting
=
"True"
OnSortCommand
=
"xgrdApprovedAuths_SortCommand"
OnNeedDataSource
=
"xgrdApprovedAuths_NeedDataSource"
Height
=
"200px"
Width
=
"9in"
runat
=
"server"
CellSpacing
=
"0"
>
<
ExportSettings
ExportOnlyData
=
"true"
IgnorePaging
=
"true"
OpenInNewWindow
=
"true"
/>
<
mastertableview
tablelayout
=
"Auto"
width
=
"100%"
allownaturalsort
=
"false"
>
<
Columns
>
<
telerik:GridBoundColumn
HeaderText
=
"Status"
DataField
=
"ApprovalStatus"
UniqueName
=
"ApprovalStatus"
SortExpression
=
"ApprovalStatus"
HeaderStyle-VerticalAlign
=
"Bottom"
HeaderStyle-HorizontalAlign
=
"Center"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Bottom"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"AuthID"
DataField
=
"AuthID"
UniqueName
=
"AuthID"
SortExpression
=
"AuthID"
Visible
=
"False"
HeaderStyle-VerticalAlign
=
"Bottom"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
>
<
HeaderStyle
VerticalAlign
=
"Bottom"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Auth Number"
DataField
=
"AuthNumber"
UniqueName
=
"AuthNumber"
SortExpression
=
"AuthNumber"
HeaderStyle-VerticalAlign
=
"Bottom"
HeaderStyle-HorizontalAlign
=
"Center"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Bottom"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Auth Adj #"
DataField
=
"AuthAmendment"
UniqueName
=
"AuthAmendment"
SortExpression
=
"AuthAmendment"
ItemStyle-Wrap
=
"False"
HeaderStyle-VerticalAlign
=
"Bottom"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
HeaderStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Originator"
DataField
=
"CreatedBy"
UniqueName
=
"CreatedBy"
SortExpression
=
"CreatedBy"
ItemStyle-Wrap
=
"False"
HeaderStyle-VerticalAlign
=
"Bottom"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
>
<
HeaderStyle
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"MemberID"
DataField
=
"MemberID"
UniqueName
=
"MemberID"
SortExpression
=
"MemberID"
Visible
=
"False"
HeaderStyle-VerticalAlign
=
"Bottom"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
>
<
HeaderStyle
VerticalAlign
=
"Bottom"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Member Name"
DataField
=
"Member Name"
UniqueName
=
"Member Name"
SortExpression
=
"Member Name"
ItemStyle-Wrap
=
"False"
HeaderStyle-VerticalAlign
=
"Bottom"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
>
<
HeaderStyle
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Start Date"
DataField
=
"StartDate"
UniqueName
=
"StartDate"
SortExpression
=
"StartDate"
HeaderStyle-VerticalAlign
=
"Bottom"
DataType
=
"System.DateTime"
ItemStyle-Wrap
=
"False"
DataFormatString
=
"{0:MM/dd/yyyy}"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
>
<
HeaderStyle
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"End Date"
DataField
=
"EndDate"
UniqueName
=
"EndDate"
SortExpression
=
"EndDate"
HeaderStyle-VerticalAlign
=
"Bottom"
DataType
=
"System.DateTime"
ItemStyle-Wrap
=
"False"
DataFormatString
=
"{0:MM/dd/yyyy}"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
>
<
HeaderStyle
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Max Units"
DataField
=
"MaxUnits"
UniqueName
=
"MaxUnits"
SortExpression
=
"MaxUnits"
HeaderStyle-VerticalAlign
=
"Bottom"
ItemStyle-Wrap
=
"False"
DataType
=
"System.Int32"
DataFormatString
=
"{0:###,##0}"
ItemStyle-HorizontalAlign
=
"Right"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
HeaderStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Units Used"
DataField
=
"Units Used"
UniqueName
=
"Units Used"
SortExpression
=
"Units Used"
HeaderStyle-VerticalAlign
=
"Bottom"
DataType
=
"System.Int32"
ItemStyle-Wrap
=
"False"
DataFormatString
=
"{0:###,##0}"
ItemStyle-HorizontalAlign
=
"Right"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
HeaderStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Division"
DataField
=
"Division"
UniqueName
=
"Division"
SortExpression
=
"Division"
HeaderStyle-VerticalAlign
=
"Bottom"
ItemStyle-Wrap
=
"False"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
ItemStyle-HorizontalAlign
=
"Center"
>
<
HeaderStyle
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
HorizontalAlign
=
"Center"
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Service Description"
DataField
=
"Service Description"
UniqueName
=
"Service Description"
SortExpression
=
"Service Description"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
HeaderStyle-VerticalAlign
=
"Bottom"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
ItemStyle-Wrap
=
"False"
>
<
HeaderStyle
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Reject Reason"
DataField
=
"RejectReason"
UniqueName
=
"RejectReason"
SortExpression
=
"RejectReason"
HeaderStyle-VerticalAlign
=
"Bottom"
ItemStyle-Wrap
=
"False"
ShowSortIcon
=
"False"
ShowFilterIcon
=
"False"
ReadOnly
=
"True"
AllowFiltering
=
"False"
>
<
HeaderStyle
VerticalAlign
=
"Bottom"
/>
<
ItemStyle
Wrap
=
"False"
/>
</
telerik:GridBoundColumn
>
</
Columns
>
</
mastertableview
>
<
clientsettings
>
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
SaveScrollPosition
=
"True"
>
</
Scrolling
>
</
clientsettings
>
</
telerik:RadGrid
>
<
asp:Button
ID
=
"cmdExport"
runat
=
"server"
Text
=
"Export to CSV File"
OnClick
=
"cmdExport_Click"
/>
protected void cmdExport_Click(object sender, System.EventArgs e)
{
xgrdApprovedAuths.MasterTableView.ExportToExcel();
}
protected void xgrdApprovedAuths_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
try
{
clsAuthorizations auth = new clsAuthorizations(ss.dbConnect);
DateTime FromDate;
DateTime ToDate;
if (txtProcessedStartDate.SelectedDate == null)
{
FromDate = System.DateTime.Now.AddYears(-50);
}
else
{
FromDate = txtProcessedStartDate.SelectedDate.Value;
}
if (txtProcessedEndDate.SelectedDate == null)
{
ToDate = System.DateTime.Now.AddYears(50);
}
else
{
ToDate = txtProcessedEndDate.SelectedDate.Value;
}
int ProviderID = ss.ProviderID;
this.xgrdApprovedAuths.DataSource = auth.GetViewOnlyApprovedAuths(ProviderID, FromDate, ToDate, cboProcessedStatus.SelectedItem.Text, cboProcessedDivision.SelectedItem.Text, ss.listDivisionString);
//this.xgrdApprovedAuths.DataBind();
this.updApprovedAuths.Update();
}
catch (Exception ex)
{
clsPortalErrorLog err = new clsPortalErrorLog(ss.dbConnect);
err.LogError(ex.ToString(), User.Identity.Name, "AuthsMain.aspx", "BindApprovedAuths");
}
}
I'm trying to export the grid to Excel.
<
telerik:GridTemplateColumn
DataField
=
"16"
HeaderStyle-Font-Size
=
"8pt"
FooterStyle-Font-Bold
=
"true"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"16"
ItemStyle-HorizontalAlign
=
"Center"
SortExpression
=
"16"
UniqueName
=
"16"
Visible
=
"true"
>
<
ItemTemplate
>
<%# Eval("16")%>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txt16"
runat
=
"server"
MaxValue
=
"24"
MinValue
=
"0"
NumberFormat-DecimalDigits
=
"1"
TabIndex
=
"90"
Text='<%# Bind("16") %>'
Width="20px" />
</
EditItemTemplate
>
<
FooterStyle
Font-Bold
=
"True"
HorizontalAlign
=
"Center"
VerticalAlign
=
"Middle"
Width
=
"26px"
/>
<
HeaderStyle
Font-Size
=
"8pt"
HorizontalAlign
=
"Center"
VerticalAlign
=
"Middle"
Width
=
"26px"
/>
<
ItemStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Middle"
Width
=
"26px"
/>
</
telerik:GridTemplateColumn
>
//Hide date columns that are needed for this reporting period (14 day and 15 day reporting periods)
if
(dateheaderdisplaytext ==
"hide"
)
{
//hide the columns that are not in this reporting date range.
RadGrid1.MasterTableView.GetColumn(sequence).Visible =
false
;
}
else
{
header[sequence].Text = dateheaderdisplaytext;
}
Using VS 2008 SP1 with RadControls for ASP.NET 2011.2.712.V 2.
I copied below example into my Project.
After adding the FilteringTemplateColumns.cs in APP_Code folder, I am getting attached error message.
The results are OK except the error shows in Visual Studio Design/Split Mode. This error does not
show in Telerik Demo.
<%@ Page Language="c#" AutoEventWireup="false" CodeFile="DefaultCS.aspx.cs" Inherits="Telerik.GridExamplesCSharp.Programming.FilteringTemplateColumns.DefaultCS" %>
<%@ Register TagPrefix="custom" Namespace="FilteringTemplateColumns" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
</
head
>
<
body
>
<
form
id
=
"mainForm"
method
=
"post"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
/>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadGrid1"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadGrid
ID
=
"RadGrid1"
DataSourceID
=
"SqlDataSource1"
Width
=
"97%"
AllowFilteringByColumn
=
"True"
AllowSorting
=
"True"
PageSize
=
"12"
ShowFooter
=
"True"
AllowPaging
=
"True"
runat
=
"server"
AutoGenerateColumns
=
"False"
GridLines
=
"None"
ShowStatusBar
=
"true"
>
<
GroupingSettings
CaseSensitive
=
"false"
/>
<
MasterTableView
EditMode
=
"InPlace"
AllowFilteringByColumn
=
"True"
ShowFooter
=
"True"
DataKeyNames
=
"CustomerID"
TableLayout
=
"Auto"
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"ContactName"
HeaderText
=
"Contact name"
>
<
HeaderStyle
Width
=
"25%"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ContactTitle"
HeaderText
=
"Contact title"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"false"
>
<
HeaderStyle
Width
=
"25%"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"City"
HeaderText
=
"TemplateColumn City"
>
<
HeaderStyle
Width
=
"25%"
/>
<
ItemTemplate
>
<%# Eval("City") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
custom:MyCustomFilteringColumn
DataField
=
"Country"
FilterControlWidth
=
"180px"
HeaderText
=
"Custom TemplateColumn Country"
>
<
headerstyle
width
=
"25%"
/>
<
itemtemplate
>
<
img
src='Img/<%# Eval("Country") %>.gif'
alt="" style="vertical-align:middle;margin-right:7px;"/><%# Eval("Country") %>
</
itemtemplate
>
</
custom:MyCustomFilteringColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
br
/>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
ConnectionString="<%$ ConnectionStrings:NorthWindConnectionString %>"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT CustomerID, ContactName, ContactTitle, Country, City FROM Customers"
runat="server"></
asp:SqlDataSource
>
</
form
>
</
body
>
</
html
>
DefaultCS.aspx.cs
_____________
using Telerik.Web.UI;
using System.Web.UI.WebControls;
namespace Telerik.GridExamplesCSharp.Programming.FilteringTemplateColumns
{
public partial class DefaultCS : System.Web.UI.Page
{
}
}
_________
FilteringTemplateColumns.cs
using Telerik.Web.UI;
using System.Data;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
namespace FilteringTemplateColumns
{
public class MyCustomFilteringColumn : GridTemplateColumn
{
public DataTable GetDataTable(string queryString)
{
string ConnString = ConfigurationManager.ConnectionStrings["NorthWindConnectionString"].ConnectionString;
SqlConnection MySqlConnection = new SqlConnection(ConnString);
SqlDataAdapter MySqlDataAdapter = new SqlDataAdapter();
MySqlDataAdapter.SelectCommand = new SqlCommand(queryString, MySqlConnection);
DataTable myDataTable = new DataTable();
MySqlConnection.Open();
try
{
MySqlDataAdapter.Fill(myDataTable);
}
finally
{
MySqlConnection.Close();
}
return myDataTable;
}
protected override void SetupFilterControls(TableCell cell)
{
RadComboBox rcBox = new RadComboBox();
rcBox.ID = "DropDownList1";
//rcBox.Width = Unit.Percentage(100);
rcBox.AutoPostBack = true;
rcBox.DataTextField = this.DataField;
rcBox.DataValueField = this.DataField;
rcBox.SelectedIndexChanged += rcBox_SelectedIndexChanged;
DataTable table = GetDataTable(string.Format("SELECT DISTINCT {0} FROM {1}", this.DataField, "Customers"));
DataRow row = table.NewRow();
row[this.DataField] = "";
table.Rows.InsertAt(row, 0);
rcBox.DataSource = table;
cell.Controls.Add(rcBox);
}
protected override void SetCurrentFilterValueToControl(TableCell cell)
{
if (!(this.CurrentFilterValue == ""))
{
((RadComboBox)cell.Controls[0]).Items.FindItemByText(this.CurrentFilterValue).Selected = true;
}
}
protected override string GetCurrentFilterValueFromControl(TableCell cell)
{
string currentValue = ((RadComboBox)cell.Controls[0]).SelectedItem.Value;
this.CurrentFilterFunction = (currentValue != "")? GridKnownFunction.EqualTo : GridKnownFunction.NoFilter;
return currentValue;
}
private void rcBox_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
((GridFilteringItem)(((RadComboBox)sender).Parent.Parent)).FireCommandEvent("Filter", new Pair());
}
}
}
Any help will be appreciated.
Thanks
<
telerik:RadTextBox ID="txtComuneBene" runat="server" Width="350px" AutoPostBack="true" ClientEvents-OnFocus="javascript:setControlFocus('txtComuneBene');">
</telerik:RadTextBox>
I also tried with :
<telerik:RadTextBox ID="txtComuneBene" runat="server" Width="350px" ClientEvents-OnFocus="javascript:setControlFocus('txtComuneBene');">
</telerik:RadTextBox>
and
<telerik:RadTextBox ID="txtComuneBene" runat="server" Width="350px" ClientEvents-OnFocus="setControlFocus('txtComuneBene');">
</telerik:RadTextBox>
and
<telerik:RadTextBox ID="txtComuneBene" runat="server" Width="350px" ClientEvents-OnFocus="setControlFocus('txtComuneBene')">
</telerik:RadTextBox>
and finally I try with a js alert to test if I write something wrong but the result is always the same.
<telerik:RadTextBox ID="txtComuneBene" runat="server" Width="350px" ClientEvents-OnFocus="alert('test alert');">
</telerik:RadTextBox>
And this is the ajax registration ( the problem is the italic style text):
Sys.Application.add_init(
function() {
$create(Telerik.Web.UI.RadTextBox, {
"_focused":false,"_postBackEventReferenceScript":"setTimeout(\"__doPostBack(\\\u0027ctl00$MainContent$ucRichiestaServizio$txtComuneBene\\\u0027,\\\u0027\\\u0027)\", 0)","_skin":"Default","clientStateFieldID":"ctl00_MainContent_ucRichiestaServizio_txtComuneBene_ClientState","enabled":true,"styles":{HoveredStyle: ["width:350px;", "riTextBox riHover"],InvalidStyle: ["width:350px;", "riTextBox riError"],DisabledStyle: ["width:350px;", "riTextBox riDisabled"],FocusedStyle: ["width:350px;", "riTextBox riFocused"],EmptyMessageStyle: ["width:350px;", "riTextBox riEmpty"],ReadOnlyStyle: ["width:350px;", "riTextBox riRead"],EnabledStyle: ["width:350px;", "riTextBox riEnabled"]}}, {"focus":javascript:setControlFocus('txtComuneBene');}, null, $get("ctl00_MainContent_ucRichiestaServizio_txtComuneBene"));
});
<telerik:RadGrid ID="Grid_products" AllowPaging="true" PageSize="25" Skin="Vista" runat="server" |
OnNeedDataSource="Grid_products_NeedDataSource" Width="100%" AutoGenerateColumns="false" HorizontalAlign="NotSet" |
OnUpdateCommand="Grid_products_UpdateCommand" OnInsertCommand="Grid_products_InsertCommand" OnDeleteCommand="Grid_products_DeleteCommand"> |
<PagerStyle Mode="NextPrevAndNumeric" /> |
<MasterTableView Width="100%" CommandItemDisplay="Top" DataKeyNames="ProductID" EditMode ="InPlace"> |
<Columns> |
<telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderText="Edit" UniqueName="EditCommandColumn"> |
<ItemStyle CssClass="MyImageButton" /> |
</telerik:GridEditCommandColumn> |
<telerik:GridBoundColumn UniqueName="ProductName" HeaderText="Product Name" DataField="ProductName" ColumnEditorID = "Grid_ProductsTextBox_ProductName"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn UniqueName="RetailPrice" HeaderText="Retail Price" DataField="RetailPrice" ColumnEditorID = "Grid_ProductsTextBox_RetailPrice"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn UniqueName="WholesalePrice" HeaderText="WholesalePrice Name" DataField="WholesalePrice" ColumnEditorID = "Grid_ProductsTextBox_WholesalePrice"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn UniqueName="CustomerPrice" HeaderText="CustomerPrice Name" DataField="CustomerPrice" ColumnEditorID = "Grid_ProductsTextBox_CustomerPrice"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn UniqueName="Description" HeaderText="Description" DataField="Description" ColumnEditorID = "Grid_ProductsTextBox_Description"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn UniqueName="UsageTime" HeaderText="Usage Time" DataField="UsageTime" ColumnEditorID = "Grid_ProductsTextBox_UsageTime"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn UniqueName="FollowupTime" HeaderText="Followup Time" DataField="FollowupTime" ColumnEditorID = "Grid_ProductsTextBox_FollowupTime"> |
</telerik:GridBoundColumn> |
<telerik:GridBoundColumn UniqueName="ReminderTime" HeaderText="Reminder Time" DataField="ReminderTime" ColumnEditorID = "Grid_ProductsTextBox_ReminderTime"> |
</telerik:GridBoundColumn> |
<telerik:GridButtonColumn HeaderText="Delete" ConfirmText="Delete this product?" ConfirmDialogType="RadWindow" |
ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete" |
UniqueName="DeleteColumn"> |
<ItemStyle HorizontalAlign="Center" CssClass="MyImageButton" /> |
</telerik:GridButtonColumn> |
</Columns> |
<ExpandCollapseColumn Visible="False"> |
<HeaderStyle Width="10px" /> |
</ExpandCollapseColumn> |
<RowIndicatorColumn Visible="False"> |
<HeaderStyle Width="20px" /> |
</RowIndicatorColumn> |
</MasterTableView> |
<ClientSettings> |
<ClientEvents OnRowDblClick="RowDblClick" OnGridCreated="GridCreated" |
OnCommand="GridCommand" /> |
</ClientSettings> |
</telerik:RadGrid> |
<telerik:GridTextBoxColumnEditor ID="Grid_ProductsTextBox_ProductName" |
runat="server"/> |
<telerik:GridTextBoxColumnEditor ID="Grid_ProductsTextBox_Description" |
runat="server"/> |
<telerik:GridNumericColumnEditor ID="Grid_ProductsTextBox_RetailPrice" runat="server"> |
<NumericTextBox ID="NumericTextBox1" runat="server" Type="Number"> |
<NumberFormat KeepNotRoundedValue="false" AllowRounding="true" DecimalDigits="2" /> |
</NumericTextBox> |
</telerik:GridNumericColumnEditor> |
<telerik:GridNumericColumnEditor ID="Grid_ProductsTextBox_WholesalePrice" runat="server"> |
<NumericTextBox ID="NumericTextBox2" runat="server" Type="Number"> |
<NumberFormat KeepNotRoundedValue="false" AllowRounding="true" DecimalDigits="2" /> |
</NumericTextBox> |
</telerik:GridNumericColumnEditor> |
<telerik:GridNumericColumnEditor ID="Grid_ProductsTextBox_CustomerPrice" runat="server"> |
<NumericTextBox runat="server" Type="Number"> |
<NumberFormat KeepNotRoundedValue="false" AllowRounding="true" DecimalDigits="2" /> |
</NumericTextBox> |
</telerik:GridNumericColumnEditor> |
<telerik:GridNumericColumnEditor ID="Grid_ProductsTextBox_UsageTime" runat="server"> |
<NumericTextBox ID="NumericTextBox3" runat="server" Type="Number"> |
<NumberFormat KeepNotRoundedValue="true" AllowRounding="false"/> |
</NumericTextBox> |
</telerik:GridNumericColumnEditor> |
<telerik:GridNumericColumnEditor ID="Grid_ProductsTextBox_FollowupTime" runat="server"> |
<NumericTextBox ID="NumericTextBox4" runat="server" Type="Number"> |
<NumberFormat KeepNotRoundedValue="true" AllowRounding="false"/> |
</NumericTextBox> |
</telerik:GridNumericColumnEditor> |
<telerik:GridNumericColumnEditor ID="Grid_ProductsTextBox_ReminderTime" runat="server"> |
<NumericTextBox ID="NumericTextBox5" runat="server" Type="Number"> |
<NumberFormat KeepNotRoundedValue="true" AllowRounding="false"/> |
</NumericTextBox> |
</telerik:GridNumericColumnEditor> |
#region Products Grid |
protected void Grid_products_NeedDataSource(object source, GridNeedDataSourceEventArgs e) |
{ |
Grid_products.DataSource = GetDataTable(); |
} |
//string connectionString = WebConfigurationManager.ConnectionStrings["SchedulerConnectionString"].ConnectionString; |
private DataTable GetDataTable() |
{ |
DataTable datatable; |
if (txt_productsearch.Text.Trim() != "") |
{ |
string selectSQL = "SELECT [ProductID], [ProductName], [RetailPrice], [WholesalePrice], [CustomerPrice], [Description],[UsageTime],[FollowupTime],[ReminderTime] FROM [Products] where ProductName LIKE '%" + txt_productsearch.Text + "%' and AdminID =1"; |
//string selectSQL = "SELECT ProductID,ProductName FROM [Products] Where ProductName LIKE '%" + txt_productsearch.Text + "%' and AdminID =1"; |
SqlConnection con = new SqlConnection(connectionString); |
SqlCommand cmd = new SqlCommand(selectSQL, con); |
//SqlDataReader reader; |
SqlDataAdapter da = new SqlDataAdapter(selectSQL, connectionString); |
datatable = new DataTable(); |
//da.Fill(datatable); |
//OleDbConnection connection1 = new OleDbConnection(); |
//OleDbDataAdapter adapter1 = new OleDbDataAdapter(); |
//adapter1.SelectCommand = new OleDbCommand(query, connection1); |
//DataTable table1 = new DataTable(); |
//connection1.Open(); |
try |
{ |
//adapter1.Fill(table1); |
da.Fill(datatable); |
} |
finally |
{ |
//connection1.Close(); |
} |
} |
else |
{ |
string selectSQL = "SELECT [ProductID], [ProductName], [RetailPrice], [WholesalePrice], [CustomerPrice], [Description],[UsageTime],[FollowupTime],[ReminderTime] FROM [Products] Where ProductName= ' ' and AdminID =1"; |
SqlConnection con = new SqlConnection(connectionString); |
SqlCommand cmd = new SqlCommand(selectSQL, con); |
//SqlDataReader reader; |
SqlDataAdapter da = new SqlDataAdapter(selectSQL, connectionString); |
datatable = new DataTable(); |
da.Fill(datatable); |
} |
return datatable; |
} |
protected void RadAjaxManager1_AjaxRequest(object sender, Telerik.Web.UI.AjaxRequestEventArgs e) |
{ |
if (e.Argument.IndexOf("FilterGrid") != -1) |
{ |
Grid_products.Rebind(); |
} |
} |
protected void Grid_products_InsertCommand(object source, GridCommandEventArgs e) |
{ |
GridEditableItem editedItem = e.Item as GridEditableItem; |
//(editedItem.EditManager.GetColumnEditor("") as GridNumericColumnEditor). |
//GridTextBoxColumnEditor itemupdate = e.Item.DataItem as GridTextBoxColumnEditor; |
//Get the primary key value using the DataKeyValue. |
//int ProductID = Convert.ToInt32(editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ProductID"].ToString()); |
string ProductName = (editedItem.EditManager.GetColumnEditor("ProductName") as GridTextBoxColumnEditor).Text; |
string RetailPrice = (editedItem.EditManager.GetColumnEditor("RetailPrice") as GridNumericColumnEditor).Text; |
string WholesalePrice = (editedItem.EditManager.GetColumnEditor("WholesalePrice") as GridNumericColumnEditor).Text; |
string CustomerPrice = (editedItem.EditManager.GetColumnEditor("CustomerPrice") as GridNumericColumnEditor).Text; |
string Description = (editedItem.EditManager.GetColumnEditor("Description") as GridTextBoxColumnEditor).Text; |
string UsageTime = (editedItem.EditManager.GetColumnEditor("UsageTime") as GridNumericColumnEditor).Text; |
string FollowupTime = (editedItem.EditManager.GetColumnEditor("FollowupTime") as GridNumericColumnEditor).Text; |
string ReminderTime = (editedItem.EditManager.GetColumnEditor("ReminderTime") as GridNumericColumnEditor).Text; |
//string RetailPrice = (editedItem.EditManager.GetColumnEditor("RetailPrice") as GridNumericColumnEditor).Text; |
//string FirstName = (itemupdate.FindControl("Grid_contactsTextBox_FirstName") as GridTextBoxColumnEditor).Text; |
string InsertSQL = "Insert into Products(ProductName,RetailPrice,WholesalePrice,CustomerPrice,Description,UsageTime,FollowupTime,ReminderTime,AdminID) Values('" + ProductName +","+ Convert.ToInt32(RetailPrice) + "," + Convert.ToInt32(WholesalePrice) + "," + Convert.ToInt32(CustomerPrice) + "," + Description + "," + Convert.ToInt32(UsageTime) + "," + Convert.ToInt32(FollowupTime) + "," + Convert.ToInt32(ReminderTime) + "',1)"; |
SqlConnection con = new SqlConnection(connectionString); |
SqlCommand cmd = new SqlCommand(InsertSQL, con); |
int flag; |
try |
{ |
con.Open(); |
flag = cmd.ExecuteNonQuery(); |
} |
catch (Exception Error) |
{ |
} |
finally |
{ |
con.Close(); |
} |
} |
protected void Grid_products_DeleteCommand(object source, GridCommandEventArgs e) |
{ |
} |
protected void Grid_products_UpdateCommand(object source, GridCommandEventArgs e) |
{ |
GridEditableItem editedItem = e.Item as GridEditableItem; |
//GridTextBoxColumnEditor itemupdate = e.Item.DataItem as GridTextBoxColumnEditor; |
//Get the primary key value using the DataKeyValue. |
int ProductID = Convert.ToInt32(editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ProductID"].ToString()); |
string ProductName = (editedItem.EditManager.GetColumnEditor("ProductName") as GridTextBoxColumnEditor).Text; |
//string FirstName = (itemupdate.FindControl("Grid_contactsTextBox_FirstName") as GridTextBoxColumnEditor).Text; |
string UpdateSQL = "Update Products set ProductName='" + ProductName + "' where ProductID =" + ProductID + " where AdminID =1"; |
SqlConnection con = new SqlConnection(connectionString); |
SqlCommand cmd = new SqlCommand(UpdateSQL, con); |
int flag; |
try |
{ |
con.Open(); |
flag = cmd.ExecuteNonQuery(); |
} |
catch (Exception Error) |
{ |
} |
finally |
{ |
con.Close(); |
} |
} |
#endregion |
protected
void
Page_Load(object sender, EventArgs e)
{
DateTime start =
new
DateTime(2009, 10, 1, 0, 0, 0);
DateTime end =
new
DateTime(2012, 10, 1, 0, 0, 0);
BusinessObject.Objects.Survey svy =
new
BusinessObject.Objects.Survey();
DataSet ds =
new
DataSet();
ds = BusinessObject.Objects.Survey.GetSurveyDetailsBySurveyId(
"233"
, start, end);
RadGrid1.MasterTableView.DataSource = ds.Tables[0];
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test2.aspx.cs" Inherits="MoZeus.Report.Web.WebRole.ReportViewer.test2" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!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
>kjggkgjh</
title
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
Runat
=
"server"
>
</
telerik:RadScriptManager
>
<
telerik:RadAjaxPanel
ID
=
"RadAjaxPanel1"
runat
=
"server"
>
<
div
class
=
"dvGrid"
id
=
"dvGrid"
style
=
"width:1000px"
>
<
telerik:RadGrid
ID
=
"RadGrid1"
OnNeedDataSource
=
"RadGrid1_NeedDataSource"
AllowSorting
=
"True"
AllowPaging
=
"True"
PageSize
=
"20"
runat
=
"server"
Width
=
"1000px"
Height
=
"600px"
AllowFilteringByColumn
=
"True"
AutoGenerateColumns
=
"true"
ShowStatusBar
=
"true"
Skin
=
"Black"
AllowAutomaticUpdates
=
"true"
AllowAutomaticInserts
=
"true"
ShowHeader
=
"true"
OnItemDataBound
=
"RadGrid1_ItemDataBound"
OnPreRender
=
"RadGrid1_PreRender"
AllowMultiRowEdit
=
"true"
HeaderStyle-HorizontalAlign
=
"Center"
EnableAjaxSkinRendering
=
"true"
ShowHeadersWhenNoRecords
=
"true"
EnableNoRecordsTemplate
=
"true"
OnItemCommand
=
"RadGrid1_ItemCommand"
ShowFooter
=
"true"
EnableLinqExpressions
=
"false"
>
<
HeaderContextMenu
CssClass
=
"GridContextMenu GridContextMenu_Default"
>
</
HeaderContextMenu
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
Position
=
"TopAndBottom"
></
PagerStyle
>
<
MasterTableView
EditMode
=
"InPlace"
ShowFooter
=
"true"
AutoGenerateColumns
=
"true"
CommandItemDisplay
=
"TopAndBottom"
EnableNoRecordsTemplate
=
"true"
GridLines
=
"None"
AllowFilteringByColumn
=
"true"
>
<
NoRecordsTemplate
>No records found.</
NoRecordsTemplate
>
<
CommandItemTemplate
>
<
div
style
=
"padding: 5px 5px;text-align:right;"
>
<
asp:LinkButton
ID
=
"btnRebind"
runat
=
"server"
CommandName
=
"RebindGrid"
>
<
img
style
=
"border:0px;vertical-align:middle;"
alt
=
""
src
=
"img/Refresh.gif"
/>Refresh</
asp:LinkButton
>
</
div
>
</
CommandItemTemplate
>
<
Columns
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
>
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
/>
</
ClientSettings
>
<
FilterMenu
EnableImageSprites
=
"False"
>
</
FilterMenu
>
</
telerik:RadGrid
>
</
div
>
</
telerik:RadAjaxPanel
>
</
form
>
</
body
>
</
html
>