在gridview中下拉,数据未插入数据库 [英] drop down in gridview , data not inserted into database
本文介绍了在gridview中下拉,数据未插入数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
<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>
推荐答案
ConnectionStrings:constr %>\"
ProviderName=\"<%
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 %>" 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="<%
这篇关于在gridview中下拉,数据未插入数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文