<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="TEMPLATES" DataMember="DefaultView" AllowSorting="True" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Vertical" PageSize="25" > <RowStyle BackColor="#F7F7DE" /> <Columns> <asp:BoundField DataField="SPOC" HeaderText="SPOC" ReadOnly="true " SortExpression="SPOC" /> <asp:BoundField DataField="MODULE" HeaderText="MODULE" ReadOnly="true" SortExpression="MODULE" /> <asp:HyperLinkField HeaderText="TEMPLATES" DataNavigateUrlFields ="TEMP" DataNavigateUrlFormatString= "/erp/modules/{0}" DataTextField="TEMPLATES" NavigateUrl="~/login/erp/modules/{0}" /> <asp:TemplateField HeaderText="ASSIGNED" SortExpression="ASSIGNED"> <ItemTemplate > <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true" DataSourceID="SqlDataSource25a" DataTextField="STAFF" DataValueField="MOBILE" onselectedindexchanged="DropDownList1_SelectedIndexChanged"> </asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource25a" runat="server" ConnectionString="<%$ ConnectionStrings:constr %>" ProviderName="<%$ ConnectionStrings:constr.ProviderName %>" SelectCommand="SELECT "STAFF","MOBILE" FROM "LOGIN1""> </asp:SqlDataSource> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="CONTACT" SortExpression="CONTACT"> <ItemTemplate> <asp:Label ID="lbl_cont" runat="server"></asp:Label> <%--<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ACCOUNT_CODING_MATRIX_SK") %>'></asp:TextBox>--%> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="COMPLETED" HeaderText="COMPLETED" SortExpression="COMPLETED" /> <asp:BoundField DataField="MAILED_SPOC" HeaderText="MAILED_SPOC" SortExpression="MAILED_SPOC" /> <asp:BoundField DataField="MAILED_CIROFF" HeaderText="MAILED_CIROFF" SortExpression="MAILED_CIROFF" /> <asp:BoundField DataField="REMARKS" HeaderText="REMARKS" SortExpression="REMARKS" /> <asp:CommandField ShowEditButton="True" /> </Columns> <FooterStyle BackColor="#CCCC99" /> <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" /> <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="White" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:constr %>" ProviderName="<%$ ConnectionStrings:constr.ProviderName %>" SelectCommand="SELECT * FROM ERPUPD" UpdateCommand="UPDATE ERPUPD SET "ASSIGNED" = :ASSIGNED, "CONTACT" = :CONTACT, "COMPLETED" = :COMPLETED, "MAILED_SPOC" = :MAILED_SPOC, "MAILED_CIROFF" = :MAILED_CIROFF, "REMARKS" = :REMARKS WHERE ("TEMPLATES" = :TEMPLATES)"> <UpdateParameters> <asp:Parameter Name="ASSIGNED" /> <asp:Parameter Name="CONTACT" /> <asp:Parameter Name="COMPLETED" /> <asp:Parameter Name="MAILED_SPOC" /> <asp:Parameter Name="MAILED_CIROFF" /> <asp:Parameter Name="REMARKS" /> <asp:Parameter Name="TEMPLATES" /> </UpdateParameters> </asp:SqlDataSource>
<asp:controlparameter name="ASSIGNED" controlid="DropDownList1" propertyname="SelectedValue" />
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)