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

[Solved] Filter in Radgrid with subGrid not working

1 Answer 108 Views

Grid

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

Felice asked on 31 Oct 2013, 03:30 PM

I have this Radgrid:

<%@ 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>