<telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" PageSize="10" > <MasterTableView CommandItemDisplay="TopAndBottom" DataKeyNames="COA_ACCOUNT_ID" DataSourceID="SqlDataSource1" HorizontalAlign="NotSet" EditMode="Batch" AutoGenerateColumns="False"> <BatchEditingSettings EditType="Row" /> <SortExpressions> <telerik:GridSortExpression FieldName="ACCOUNT_CODE" SortOrder="Ascending" /> </SortExpressions> <Columns> <telerik:GridBoundColumn DataField="ACCOUNT_CODE" HeaderStyle-Width="210px" HeaderText="ACCOUNT CODE" SortExpression="ACCOUNT_CODE" UniqueName="CODE"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ForeColor="Red" Text="*This field is required" Display="Dynamic"> </RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ACCOUNT_DESCRIPTION" HeaderStyle-Width="210px" HeaderText="ACCOUNT DESCRIPTION" SortExpression="ACCOUNT_DESCRIPTION" UniqueName="DESIGNATION_NATIVE"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ForeColor="Red" Text="*This field is required" Display="Dynamic"> </RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridTemplateColumn HeaderText="ACCOUNT TYPE" DefaultInsertValue="R" HeaderStyle-Width="150px" UniqueName="ACCOUNT_TYPE_ID" DataField="ACCOUNT_TYPE"> <ItemTemplate> <%# Eval("ACCOUNT_TYPE") %> </ItemTemplate> <EditItemTemplate> <telerik:RadDropDownList runat="server" ID="RadddlAcctType" DataValueField="COA_ACCOUNT_TYPE_ID" DataTextField="ACCOUNT_TYPE_NAME" DataSourceID="SqlDataSource2"> </telerik:RadDropDownList> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="ACCOUNT PAYABLE" DefaultInsertValue="Dr./Cr." HeaderStyle-Width="150px" UniqueName="PAYBLE" DataField="ACCOUNT_PAYABLE"> <ItemTemplate> <%# Eval("ACCOUNT_PAYABLE") %> </ItemTemplate> <EditItemTemplate> <telerik:RadDropDownList runat="server" ID="RadddlAcctPayable"> <Items> <telerik:DropDownListItem Text="Debit" Value="0" /> <telerik:DropDownListItem Text="Credit" Value="1" /> <telerik:DropDownListItem Text="Dr./Cr." Value="2" Selected="true" /> </Items> </telerik:RadDropDownList> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridCheckBoxColumn DataField="ACTIVE" HeaderStyle-Width="80px" HeaderText="Status" SortExpression="ACTIVE" UniqueName="ACTIVE"> </telerik:GridCheckBoxColumn> <telerik:GridButtonColumn ConfirmText="Delete this product?" ConfirmDialogType="RadWindow" ConfirmTitle="Delete" HeaderText="Delete" HeaderStyle-Width="50px" ButtonType="ImageButton" CommandName="Delete" Text="Delete" UniqueName="DeleteColumn"> </telerik:GridButtonColumn> </Columns> </MasterTableView> <ClientSettings AllowKeyboardNavigation="true"></ClientSettings> </telerik:RadGrid> </div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sacweb_db_devConnectionString%>" SelectCommandType="StoredProcedure" SelectCommand="SP_FIN_COA_ACCOUNT_READ" DeleteCommandType="StoredProcedure" DeleteCommand="SP_FIN_COA_ACCOUNT_DELETE" UpdateCommandType="StoredProcedure" UpdateCommand="SP_FIN_COA_ACCOUNT_UPDATE" InsertCommandType="StoredProcedure" InsertCommand="SP_FIN_COA_ACCOUNT_INSERT"> <DeleteParameters> <asp:Parameter Name="ACCOUNT_ID" Type="Int32" /> </DeleteParameters> <%--<SelectParameters> <asp:Parameter Name="LANGUAGE" Type="Int32" /> </SelectParameters>--%> <UpdateParameters> <asp:Parameter Name="ACCOUNT_ID" Type="Int32" /> <asp:Parameter Name="CATALOG_ID" Type="Int32" /> <asp:Parameter Name="ACCOUNT_TYPE_ID" Type="Int32" /> <asp:Parameter Name="CODE" Type="Int32" /> <asp:Parameter Name="DESIGNATION_NATIVE" Type="String" /> <asp:Parameter Name="DESIGNATION_OTHER" Type="String" /> <asp:Parameter Name="PAYBLE" Type="Int32" /> <asp:Parameter Name="ACTIVE" Type="Boolean" /> <asp:Parameter Name="UPDATED_USER_ID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="CATALOG_ID" Type="Int32" DefaultValue="1"/> <asp:Parameter Name="ACCOUNT_TYPE_ID" Type="Int32" /> <asp:Parameter Name="CODE" Type="Int32" /> <asp:Parameter Name="DESIGNATION_NATIVE" Type="String" /> <asp:Parameter Name="DESIGNATION_OTHER" Type="String" DefaultValue="Pt"/> <asp:Parameter Name="PAYBLE" Type="Int32" /> <asp:Parameter Name="ACTIVE" Type="Boolean" /> <asp:Parameter Name="CREATED_USER_ID" Type="Int32" DefaultValue="1"/> <asp:Parameter Name="UPDATED_USER_ID" Type="Int32" DefaultValue="1"/> </InsertParameters> </asp:SqlDataSource>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)