I have this Radgrid:
since a subgrid was added I am unable to make the filter working. Any help will be appreciated.
What should I do /change to make the filter working again?
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="projects.aspx.cs" Inherits="projects" %>
<%@ 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
>Projects</
title
>
</
head
>
<
body
>
<
table
width
=
"100%"
>
<
tr
>
<
td
><
img
src
=
"images/logo.PNG"
/></
td
>
</
tr
>
</
table
>
<
form
id
=
"form1"
runat
=
"server"
>
<
div
>
</
div
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<
telerik:RadCodeBlock
ID
=
"RadCodeBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
//
<![CDATA[
//On insert and update buttons click temporarily disables ajax to perform upload actions
function conditionalPostback(sender, eventArgs) {
var theRegexp = new RegExp("\.UpdateButton$|\.PerformInsertButton$", "ig");
if (eventArgs.get_eventTarget().match(theRegexp)) {
var upload = $find(window['UploadId']);
//alert(upload);
if (upload == null) {
eventArgs.set_enableAjax(false);
return;
}
//AJAX is disabled only if file is selected for upload
if (upload.getFileInputs()[0].value != "") {
eventArgs.set_enableAjax(false);
}
}
}
function validateRadUpload(source, e) {
e.IsValid = false;
var upload = $find(source.parentNode.getElementsByTagName('div')[0].id);
if (upload == null) {
return;
}
var inputs = upload.getFileInputs();
for (var i = 0; i < inputs.length; i++) {
//check for empty string or invalid extension
if (inputs[i].value != "" && upload.isExtensionValid(inputs[i].value)) {
e.IsValid = true;
break;
}
}
}
// ]]>
</
script
>
</
telerik:RadCodeBlock
>
<
table
width
=
"100%"
>
<
tr
>
<
td
>
<
telerik:RadMenu
ID
=
"RadMenu1"
runat
=
"server"
Skin
=
"Default"
Width
=
"100%"
Font-Size
=
"Large"
>
<
Items
>
<
telerik:RadMenuItem
Text
=
"Login"
runat
=
"server"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Home"
runat
=
"server"
NavigateUrl
=
"home.aspx"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Data Administration"
runat
=
"server"
NavigateUrl
=
"~/dataAdmin.aspx"
>
<
Items
>
<
telerik:RadMenuItem
runat
=
"server"
NavigateUrl
=
"customers.aspx"
Text
=
"Customers"
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
runat
=
"server"
NavigateUrl
=
"manufacturers.aspx"
Text
=
"Manufactures"
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
runat
=
"server"
NavigateUrl
=
"product.aspx"
Text
=
"Products"
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
runat
=
"server"
NavigateUrl
=
"events.aspx"
Text
=
"Events"
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
runat
=
"server"
Selected
=
"True"
Text
=
"Projects"
>
</
telerik:RadMenuItem
>
</
Items
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Search"
runat
=
"server"
NavigateUrl
=
"search.aspx"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Indust. Reports"
runat
=
"server"
NavigateUrl
=
"industry_report.aspx"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
runat
=
"server"
NavigateUrl
=
"~/reports_Start_page.aspx"
Text
=
"Reports Section"
>
</
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Administration"
runat
=
"server"
NavigateUrl
=
"users.aspx"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Help"
runat
=
"server"
NavigateUrl
=
"help.aspx"
></
telerik:RadMenuItem
>
<
telerik:RadMenuItem
Text
=
"Log Out"
runat
=
"server"
NavigateUrl
=
"logout.aspx"
></
telerik:RadMenuItem
>
</
Items
>
</
telerik:RadMenu
>
</
td
>
</
tr
>
</
table
>
<
table
>
<
tr
>
<
td
><
asp:Button
ID
=
"Button2"
runat
=
"server"
Text
=
"Export XL"
OnClick
=
"Button2_Click"
/></
td
>
</
tr
>
</
table
>
<
table
width
=
"100%"
>
<
tr
>
<
td
>
<
telerik:RadAjaxPanel
ID
=
"RadAjaxPanel1"
runat
=
"server"
clientevents-onrequeststart
=
"conditionalPostback"
RestoreOriginalRenderDelegate
=
"false"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"RadGrid1"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"RadGrid1"
></
telerik:AjaxUpdatedControl
>
<
telerik:AjaxUpdatedControl
ControlID
=
"RequiredFieldValidator1"
></
telerik:AjaxUpdatedControl
>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
Skin
=
"Telerik"
>
</
telerik:RadAjaxLoadingPanel
>
<
telerik:RadGrid
runat
=
"server"
ID
=
"RadGrid1"
AllowPaging
=
"True"
AllowFilteringByColumn
=
"True"
AllowSorting
=
"True"
AllowMultiRowSelection
=
"true"
AutoGenerateColumns
=
"False"
AllowAutomaticInserts
=
"True"
AllowAutomaticUpdates
=
"True"
AllowAutomaticDeletes
=
"True"
ShowStatusBar
=
"True"
OnDetailTableDataBind
=
"RadGrid1_DetailTableDataBind"
GridLines
=
"None"
DataSourceID
=
"SqlDataSource1"
PageSize
=
"10"
CellSpacing
=
"0"
OnDeleteCommand
=
"RadGrid1_DeleteCommand"
OnItemCreated
=
"RadGrid1_ItemCreated"
OnItemCommand
=
"RadGrid1_ItemCommand"
OnItemInserted
=
"RadGrid1_ItemInserted"
OnItemUpdated
=
"RadGrid1_ItemUpdated"
OnItemDataBound
=
"RadGrid1_ItemDataBound"
OnUpdateCommand
=
"RadGrid1_UpdateCommand"
oninsertcommand
=
"RadGrid1_InsertCommand"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
AlwaysVisible
=
"true"
></
PagerStyle
>
<
MasterTableView
Width
=
"100%"
CommandItemDisplay
=
"Top"
DataKeyNames
=
"proj_id"
Name
=
"Master"
>
<
Columns
>
<
telerik:GridClientSelectColumn
UniqueName
=
"ChkSel"
>
</
telerik:GridClientSelectColumn
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
>
<
HeaderStyle
Width
=
"36px"
></
HeaderStyle
>
</
telerik:GridEditCommandColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"ProjectID"
UniqueName
=
"proj_id"
DataField
=
"proj_id"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblid"
runat
=
"server"
Text='<%# Bind("proj_id") %>'></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:TextBox
ID
=
"txtid"
Width
=
"300px"
runat
=
"server"
Text='<%# Bind("proj_id") %>' ReadOnly="true">
</
asp:TextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Project Name"
UniqueName
=
"proj_name"
DataField
=
"proj_name"
SortExpression
=
"proj_name"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblpn"
runat
=
"server"
Text='<%# Bind("proj_name") %>'></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:TextBox
ID
=
"txtpn"
Width
=
"300px"
runat
=
"server"
Text='<%# Bind("proj_name") %>' >
</
asp:TextBox
>
<
asp:RequiredFieldValidator
ID
=
"RequiredFieldValidator1"
ControlToValidate
=
"txtpn"
ErrorMessage
=
"This field is required"
runat
=
"server"
Display
=
"Dynamic"
>
</
asp:RequiredFieldValidator
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridDropDownColumn
DataSourceID
=
"SqlDataSource2"
ListTextField
=
"custname"
ListValueField
=
"custid"
UniqueName
=
"ddl"
SortExpression
=
"proj_cust_id"
EmptyListItemText
=
"Select Customer"
EnableEmptyListItem
=
"true"
HeaderText
=
"Customer"
DropDownControlType
=
"RadComboBox"
DataField
=
"proj_cust_id"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridDropDownColumn
DataSourceID
=
"SqlDataSource3"
ListTextField
=
"manname"
ListValueField
=
"manid"
UniqueName
=
"ddl2"
SortExpression
=
"proj_man_id"
EmptyListItemText
=
"Select Manufacturer"
EnableEmptyListItem
=
"true"
HeaderText
=
"Manufacturer"
DropDownControlType
=
"RadComboBox"
DataField
=
"proj_man_id"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridDropDownColumn
DataSourceID
=
"SqlDataSource4"
ListTextField
=
"prodname"
ListValueField
=
"prodid"
UniqueName
=
"ddl3"
SortExpression
=
"proj_prod_id"
EmptyListItemText
=
"Select Product"
EnableEmptyListItem
=
"true"
HeaderText
=
"Product"
DropDownControlType
=
"RadComboBox"
DataField
=
"proj_prod_id"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridDateTimeColumn
UniqueName
=
"proj_date"
PickerType
=
"DatePicker"
HeaderText
=
"Proj Date"
DataField
=
"proj_date"
DataFormatString
=
"{0:MM/dd/yyyy}"
>
<
ItemStyle
Width
=
"120px"
></
ItemStyle
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Num Of Vehicle"
UniqueName
=
"proj_num_of_vehicles"
DataField
=
"proj_num_of_vehicles"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblnov"
runat
=
"server"
Text='<%# Eval("proj_num_of_vehicles") %>' width="50px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtnov"
Width
=
"50px"
runat
=
"server"
Text='<%# Bind("proj_num_of_vehicles") %>' >
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
<
asp:RequiredFieldValidator
ID
=
"RequiredFieldValidator2"
ControlToValidate
=
"txtnov"
ErrorMessage
=
"This field is required"
runat
=
"server"
Display
=
"Dynamic"
>
</
asp:RequiredFieldValidator
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Coach per Vehicle"
UniqueName
=
"proj_coach_vehicle"
DataField
=
"proj_coach_vehicle"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblcv"
runat
=
"server"
Text='<%# Eval("proj_coach_vehicle") %>' width="50px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtcv"
Width
=
"50px"
runat
=
"server"
Text='<%# Bind("proj_coach_vehicle") %>' >
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
<
asp:RequiredFieldValidator
ID
=
"RequiredFieldValidator3"
ControlToValidate
=
"txtcv"
ErrorMessage
=
"This field is required"
runat
=
"server"
Display
=
"Dynamic"
>
</
asp:RequiredFieldValidator
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Contract Value(€)"
UniqueName
=
"proj_contract_value"
DataField
=
"proj_contract_value"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblcval"
runat
=
"server"
Text='<%# Eval("proj_contract_value") %>' width="150px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtcval"
Width
=
"150px"
runat
=
"server"
Text='<%# Bind("proj_contract_value") %>' >
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
<
asp:RequiredFieldValidator
ID
=
"RequiredFieldValidator4"
ControlToValidate
=
"txtcval"
ErrorMessage
=
"This field is required"
runat
=
"server"
Display
=
"Dynamic"
>
</
asp:RequiredFieldValidator
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Avg Price per Coach(€)"
UniqueName
=
"proj_avg_price_per_coach"
DataField
=
"proj_avg_price_per_coach"
display
=
"false"
>
<
ItemTemplate
></
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtppc"
Width
=
"150px"
runat
=
"server"
ReadOnly
=
"true"
>
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Length(m)"
UniqueName
=
"proj_length"
DataField
=
"proj_length"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblpl"
runat
=
"server"
Text='<%# Eval("proj_length") %>' width="50px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtpl"
Width
=
"50px"
runat
=
"server"
Text='<%# Bind("proj_length") %>' >
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Width(mm)"
UniqueName
=
"proj_width"
DataField
=
"proj_width"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblpw"
runat
=
"server"
Text='<%# Eval("proj_width") %>' width="50px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtpw"
Width
=
"50px"
runat
=
"server"
Text='<%# Bind("proj_width") %>' >
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Height(mm)"
UniqueName
=
"proj_height"
DataField
=
"proj_height"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblph"
runat
=
"server"
Text='<%# Eval("proj_height") %>' width="50px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtph"
Width
=
"50px"
runat
=
"server"
Text='<%# Bind("proj_height") %>' >
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Passenger Seats"
UniqueName
=
"proj_passenger_seats"
DataField
=
"proj_passenger_seats"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblps"
runat
=
"server"
Text='<%# Eval("proj_passenger_seats") %>' width="50px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtps"
Width
=
"50px"
runat
=
"server"
Text='<%# Bind("proj_passenger_seats") %>' >
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Passengers Total"
UniqueName
=
"proj_passenger_total"
DataField
=
"proj_passenger_seats"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblpat"
runat
=
"server"
Text='<%# Eval("proj_passenger_total") %>' width="50px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtpat"
Width
=
"50px"
runat
=
"server"
Text='<%# Bind("proj_passenger_total") %>' >
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Brand"
UniqueName
=
"proj_brand"
DataField
=
"proj_brand"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblbr"
runat
=
"server"
Text='<%# Eval("proj_brand") %>' width="100px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:textbox
ID
=
"txtbr"
Width
=
"100px"
runat
=
"server"
Text='<%# Bind("proj_brand") %>' >
</
asp:textbox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"System Voltage"
UniqueName
=
"proj_systemvoltage"
DataField
=
"proj_systemvoltage"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblsv"
runat
=
"server"
Text='<%# Eval("proj_systemvoltage") %>' width="100px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:textbox
ID
=
"txtsv"
Width
=
"100px"
runat
=
"server"
Text='<%# Bind("proj_systemvoltage") %>' >
</
asp:textbox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Gauge"
UniqueName
=
"proj_gauge"
DataField
=
"proj_gauge"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblga"
runat
=
"server"
Text='<%# Eval("proj_gauge") %>' width="100px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:textbox
ID
=
"txtga"
Width
=
"100px"
runat
=
"server"
Text='<%# Bind("proj_gauge") %>' >
</
asp:textbox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Service Speed"
UniqueName
=
"proj_service_speed"
DataField
=
"proj_service_speed"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblss"
runat
=
"server"
Text
=
"Service Speed (Km/h)"
width
=
"100px"
></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:textbox
ID
=
"txtss"
Width
=
"100px"
runat
=
"server"
Text='<%# Bind("proj_service_speed") %>' >
</
asp:textbox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Available Attachments"
UniqueName
=
"proj_attach"
DataField
=
"proj_attach"
display
=
"false"
>
<
ItemTemplate
></
ItemTemplate
>
<
EditItemTemplate
>
<
asp:TextBox
ID
=
"txtprojattach"
Width
=
"300px"
runat
=
"server"
Text='<%# Bind("proj_attach") %>' ReadOnly="true">
</
asp:TextBox
>
<
asp:Button
id
=
"btn"
OnClick
=
"btn_Click"
runat
=
"server"
Text
=
"View Attachments"
/>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:gridtemplatecolumn
uniquename
=
"Upload"
HeaderText
=
"Select attachments (jpg, jpeg, pdf, txt)"
Display
=
"false"
>
<
ItemTemplate
></
ItemTemplate
>
<
edititemtemplate
>
<
telerik:radupload
id
=
"RadUpload1"
runat
=
"server"
MaxFileInputsCount
=
"1"
AllowedFileExtensions
=
".jpg,.jpeg,.pdf,.txt"
TargetFolder
=
"~/Proj_AttachFiles"
ControlObjectsVisibility
=
"None"
/>
</
edititemtemplate
>
</
telerik:gridtemplatecolumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Notes"
UniqueName
=
"proj_notes"
DataField
=
"proj_notes"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblnotes"
runat
=
"server"
Text='<%# Eval("proj_notes") %>' width="300px"></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadTextBox
ID
=
"txtnotes"
Width
=
"500px"
runat
=
"server"
Text='<%# Bind("proj_notes") %>' Height="100px" TextMode="MultiLine" >
</
telerik:RadTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
UniqueName
=
"uname"
DataField
=
"uname"
HeaderText
=
"Modified By"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lbluname"
runat
=
"server"
Text='<%# Bind("uname") %>'></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:TextBox
ID
=
"uname"
runat
=
"server"
Text='<%# Bind("uname") %>' ReadOnly="true">
</
asp:TextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridButtonColumn
UniqueName
=
"Delete_col"
Text
=
"Delete"
CommandName
=
"Delete"
ConfirmText
=
"Delete this record ?"
ConfirmDialogType
=
"RadWindow"
ButtonType
=
"ImageButton"
>
<
HeaderStyle
Width
=
"36px"
></
HeaderStyle
>
</
telerik:GridButtonColumn
>
</
Columns
>
<
DetailTables
>
<
telerik:GridTableView
DataKeyNames
=
"proj_id"
ClientDataKeyNames
=
"proj_id"
HierarchyLoadMode
=
"ServerBind"
Width
=
"100%"
runat
=
"server"
CommandItemDisplay
=
"Top"
Name
=
"Details"
>
<
ParentTableRelation
>
<
telerik:GridRelationFields
DetailKeyField
=
"proj_id"
MasterKeyField
=
"proj_id"
></
telerik:GridRelationFields
>
</
ParentTableRelation
>
<
Columns
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
UniqueName
=
"EditCommandColumn1"
>
<
HeaderStyle
Width
=
"36px"
></
HeaderStyle
>
</
telerik:GridEditCommandColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"ID"
UniqueName
=
"id"
DataField
=
"id"
display
=
"false"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblid"
runat
=
"server"
Text='<%# Bind("id") %>'></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:TextBox
ID
=
"txtid"
Width
=
"70px"
runat
=
"server"
Text='<%# Bind("id") %>' ReadOnly="true">
</
asp:TextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridDropDownColumn
DataSourceID
=
"SqlDataSource3"
ListTextField
=
"manname"
ListValueField
=
"manname"
UniqueName
=
"ddl7"
SortExpression
=
"b_man_id"
EmptyListItemText
=
"Select Manufacturer"
EnableEmptyListItem
=
"true"
HeaderText
=
"Manufacturer"
DropDownControlType
=
"RadComboBox"
DataField
=
"b_man_id"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridNumericColumn
DataField
=
"b_contract_price"
HeaderText
=
"Contract Value(€)"
UniqueName
=
"b_contract_price"
>
</
telerik:GridNumericColumn
>
<
telerik:GridTemplateColumn
UniqueName
=
"b_avg_price"
DataField
=
"b_avg_price"
HeaderText
=
"Avg Price per Coach(€)"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblavgp"
runat
=
"server"
Text='<%# Bind("b_avg_price") %>'></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadNumericTextBox
ID
=
"txtavgp"
runat
=
"server"
Text='<%# Bind("b_avg_price") %>'
ReadOnly="true" Width="100px" >
<
NumberFormat
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridButtonColumn
UniqueName
=
"Delete_col2"
Text
=
"Delete"
CommandName
=
"Delete"
ConfirmText
=
"Delete this record ?"
ConfirmDialogType
=
"RadWindow"
ButtonType
=
"ImageButton"
>
<
HeaderStyle
Width
=
"36px"
></
HeaderStyle
>
</
telerik:GridButtonColumn
>
</
Columns
>
</
telerik:GridTableView
>
</
DetailTables
>
<
EditFormSettings
>
<
EditColumn
ButtonType
=
"ImageButton"
>
</
EditColumn
>
</
EditFormSettings
>
</
MasterTableView
>
<
ClientSettings
>
<
Selecting
AllowRowSelect
=
"true"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
</
telerik:RadAjaxPanel
>
</
td
>
</
tr
>
</
table
>
<
asp:SqlDataSource
runat
=
"server"
ID
=
"SqlDataSource2"
ConnectionString="<%$ ConnectionStrings:stad_conn %>"
SelectCommand="SELECT cust_id as custid,cust_name as custname FROM customers order by cust_name">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
runat
=
"server"
ID
=
"SqlDataSource22"
ConnectionString="<%$ ConnectionStrings:stad_conn %>"
SelectCommand="SELECT cust_name,cust_id FROM customers order by cust_name">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
runat
=
"server"
ID
=
"SqlDataSource3"
ConnectionString="<%$ ConnectionStrings:stad_conn %>"
SelectCommand="SELECT man_id as manid,man_name as manname FROM manufacturers order by man_name">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
runat
=
"server"
ID
=
"SqlDataSource4"
ConnectionString="<%$ ConnectionStrings:stad_conn %>"
SelectCommand="SELECT prod_id as prodid,prod_type as prodname FROM products order by prod_type">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:stad_conn %>"
DeleteCommand="DELETE FROM [projects] WHERE [ID] = @ID"
InsertCommand="INSERT INTO [projects] ([proj_id],[proj_cust_id], [proj_man_id], [proj_date],[proj_num_of_vehicles],
[proj_coach_vehicle],[proj_contract_value],[proj_length],[proj_width],
[proj_height],[proj_passenger_seats],[proj_passenger_total],[proj_notes],
[uname],[proj_name],[proj_prod_id],[proj_brand],[proj_systemvoltage],[proj_gauge],[proj_service_speed])
VALUES (@proj_id,@proj_cust_id,@proj_man_id, @proj_date,@proj_num_of_vehicles,@proj_coach_vehicle,
@proj_contract_value,@proj_length, @proj_width,@proj_height,@proj_passenger_seats,
@proj_passenger_total,@proj_notes,@uname,@proj_name,@proj_prod_id,@proj_brand,@proj_systemvoltage,@proj_gauge,@proj_service_speed)"
SelectCommand="SELECT [id],[proj_id],[proj_cust_id], [proj_man_id], [proj_date],[proj_num_of_vehicles],[proj_coach_vehicle],
[proj_contract_value],[proj_length],[proj_width],[proj_height] ,[proj_attach],[proj_prod_id],[proj_service_speed],
[proj_passenger_seats],[proj_passenger_total],[proj_notes],[uname],[proj_name],[proj_brand],[proj_systemvoltage],[proj_gauge]
from projects"
UpdateCommand="UPDATE [projects] SET [proj_id] = @proj_id,[proj_cust_id] = @proj_cust_id,
[proj_man_id] = @proj_man_id, [proj_date] = @proj_date,[proj_prod_id] = @proj_prod_id,
[proj_num_of_vehicles] = @proj_num_of_vehicles, [proj_coach_vehicle] = @proj_coach_vehicle,
[proj_contract_value] = @proj_contract_value, [proj_service_speed] = @proj_service_speed,
[proj_length] = @proj_length, [proj_width] = @proj_width,
[proj_height] = @proj_height, [proj_passenger_seats] = @proj_passenger_seats,
[proj_passenger_total] = @proj_passenger_total, [proj_notes] = @proj_notes,[proj_name]=@proj_name,
[proj_brand]=@proj_brand,[proj_systemvoltage]=@proj_systemvoltage,[proj_gauge]=@proj_gauge
WHERE [ID] = @ID">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
></
asp:Parameter
>
</
DeleteParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"proj_cust_id"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_prod_id"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_brand"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_systemvoltage"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_gauge"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_man_id"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_service_speed"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_date"
Type
=
"DateTime"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_num_of_vehicles"
Type
=
"Int16"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_coach_vehicle"
Type
=
"Int16"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_contract_value"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_length"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_width"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_system_voltage"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_height"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_passenger_seats"
Type
=
"Int16"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_passenger_total"
Type
=
"Int16"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_notes"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_name"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"uname"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_id"
Type
=
"String"
></
asp:Parameter
>
</
InsertParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"proj_cust_id"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_prod_id"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_man_id"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_brand"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_service_speed"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_systemvoltage"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_gauge"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_date"
Type
=
"DateTime"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_num_of_vehicles"
Type
=
"Int16"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_coach_vehicle"
Type
=
"Int16"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_contract_value"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_length"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_width"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_system_voltage"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_height"
Type
=
"Double"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_passenger_seats"
Type
=
"Int16"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_passenger_total"
Type
=
"Int16"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_notes"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"proj_name"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
></
asp:Parameter
>
</
UpdateParameters
>
</
asp:SqlDataSource
>
</
form
>
</
body
>
</
html
>
What should I do /change to make the filter working again?