请各位高手指点一下,怎么修改,非常感谢!代码如下:
.aspx 文件:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" Font-Size="Smaller"
AutoGenerateColumns="False" DataKeyNames="dwbm,rybh,qsrq" DataSourceID="SqlDataSource1" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" >
<Columns>
<asp:BoundField DataField="dwbm" HeaderText="dwbm" ReadOnly="True" SortExpression="dwbm" />
<asp:BoundField DataField="rybh" HeaderText="rybh" ReadOnly="True" SortExpression="rybh" />
<asp:BoundField DataField="cjmc" HeaderText="cjmc" ReadOnly ="true" SortExpression="cjmc" />
<asp:BoundField DataField="bzmc" HeaderText="bzmc" ReadOnly ="true" SortExpression="bzmc" />
<asp:BoundField DataField="xm" HeaderText="xm" ReadOnly ="true" SortExpression="xm" />
<asp:BoundField DataField="qsrq" HeaderText="qsrq" ReadOnly ="true" SortExpression="qsrq" />
<asp:BoundField DataField="zzrq" HeaderText="zzrq" SortExpression="zzrq" />
<asp:BoundField DataField="ccdd" HeaderText="ccdd" SortExpression="ccdd" />
<asp:BoundField DataField="ccsy" HeaderText="ccsy" SortExpression="ccsy" />
<asp:BoundField DataField="pzr" HeaderText="pzr" SortExpression="pzr" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ycwhConnectionString2 %>"
SelectCommand="SELECT ChuChai.dwbm, ChuChai.rybh, DanWei.cjmc, DanWei.bzmc, ChuChai.xm, (ltrim(str(year(ChuChai.qsrq))) + '-' + ltrim(str(month(ChuChai.qsrq))) + '-' + ltrim(str(day(ChuChai.qsrq)))) as qsrq,(ltrim(str(year(ChuChai.zzrq))) + '-' + ltrim(str(month(ChuChai.zzrq))) + '-' + ltrim(str(day(ChuChai.zzrq)))) as zzrq, ChuChai.ccdd, ChuChai.ccsy, ChuChai.pzr FROM ChuChai INNER JOIN DanWei ON ChuChai.dwbm = DanWei.dwbm"
UpdateCommand="UPDATE ChuChai SET zzrq = @zzrq, ccdd = @ccdd, ccsy = @ccsy, pzr = @pzr WHERE dwbm = @dwbm AND rybh = @rybh and qsrq = @qsrq"
InsertCommand="INSERT INTO ChuChai (dwbm,rybh,xm,qsrq,zzrq,ccdd,ccsy,pzr) VALUES (@dwbm,@rybh,@xm,@qsrq,@zzrq,@ccdd,@ccsy,@pzr)"
DeleteCommand="DELETE FROM ChuChai WHERE dwbm = @dwbm AND rybh = @rybh and qsrq = @qsrq">
<UpdateParameters>
<asp:Parameter Name="zzrq" Type ="DateTime" />
<asp:Parameter Name="ccdd" Type="String" />
<asp:Parameter Name="ccsy" Type="String" />
<asp:Parameter Name="pzr" Type="String" />
<asp:Parameter Name="dwbm" Type="String" />
<asp:Parameter Name="rybh" Type="String" />
<asp:Parameter Name="qsrq" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:SessionParameter SessionField="login_dwbm" Type="String"/>
<asp:SessionParameter SessionField="login_rybh" Type="String"/>
<asp:SessionParameter SessionField="login_xm" Type="String"/>
<asp:ControlParameter ControlID="TxtBqsrq" Type="DateTime" PropertyName="Text"/>
<asp:ControlParameter ControlID="TxtBzzrq" Type="DateTime" PropertyName="Text" />
<asp:ControlParameter ControlID="TxtBccdd" Type="String" PropertyName="Text"/>
<asp:ControlParameter ControlID="TxtBccsy" Type="String" PropertyName="Text"/>
<asp:ControlParameter ControlID="TxtBpzr" Type="String" PropertyName="Text" />
</InsertParameters>
<DeleteParameters>
<asp:Parameter Name="dwbm" Type="String" />
<asp:Parameter Name="rybh" Type="String" />
<asp:Parameter Name="qsrq" Type="String" />
</DeleteParameters>
</asp:SqlDataSource>.aspx.vb 文件:
Protected Sub Btn_ok_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Btn_ok.Click Me.SqlDataSource1.Insert()
End Sub
.aspx 文件:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" Font-Size="Smaller"
AutoGenerateColumns="False" DataKeyNames="dwbm,rybh,qsrq" DataSourceID="SqlDataSource1" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" >
<Columns>
<asp:BoundField DataField="dwbm" HeaderText="dwbm" ReadOnly="True" SortExpression="dwbm" />
<asp:BoundField DataField="rybh" HeaderText="rybh" ReadOnly="True" SortExpression="rybh" />
<asp:BoundField DataField="cjmc" HeaderText="cjmc" ReadOnly ="true" SortExpression="cjmc" />
<asp:BoundField DataField="bzmc" HeaderText="bzmc" ReadOnly ="true" SortExpression="bzmc" />
<asp:BoundField DataField="xm" HeaderText="xm" ReadOnly ="true" SortExpression="xm" />
<asp:BoundField DataField="qsrq" HeaderText="qsrq" ReadOnly ="true" SortExpression="qsrq" />
<asp:BoundField DataField="zzrq" HeaderText="zzrq" SortExpression="zzrq" />
<asp:BoundField DataField="ccdd" HeaderText="ccdd" SortExpression="ccdd" />
<asp:BoundField DataField="ccsy" HeaderText="ccsy" SortExpression="ccsy" />
<asp:BoundField DataField="pzr" HeaderText="pzr" SortExpression="pzr" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ycwhConnectionString2 %>"
SelectCommand="SELECT ChuChai.dwbm, ChuChai.rybh, DanWei.cjmc, DanWei.bzmc, ChuChai.xm, (ltrim(str(year(ChuChai.qsrq))) + '-' + ltrim(str(month(ChuChai.qsrq))) + '-' + ltrim(str(day(ChuChai.qsrq)))) as qsrq,(ltrim(str(year(ChuChai.zzrq))) + '-' + ltrim(str(month(ChuChai.zzrq))) + '-' + ltrim(str(day(ChuChai.zzrq)))) as zzrq, ChuChai.ccdd, ChuChai.ccsy, ChuChai.pzr FROM ChuChai INNER JOIN DanWei ON ChuChai.dwbm = DanWei.dwbm"
UpdateCommand="UPDATE ChuChai SET zzrq = @zzrq, ccdd = @ccdd, ccsy = @ccsy, pzr = @pzr WHERE dwbm = @dwbm AND rybh = @rybh and qsrq = @qsrq"
InsertCommand="INSERT INTO ChuChai (dwbm,rybh,xm,qsrq,zzrq,ccdd,ccsy,pzr) VALUES (@dwbm,@rybh,@xm,@qsrq,@zzrq,@ccdd,@ccsy,@pzr)"
DeleteCommand="DELETE FROM ChuChai WHERE dwbm = @dwbm AND rybh = @rybh and qsrq = @qsrq">
<UpdateParameters>
<asp:Parameter Name="zzrq" Type ="DateTime" />
<asp:Parameter Name="ccdd" Type="String" />
<asp:Parameter Name="ccsy" Type="String" />
<asp:Parameter Name="pzr" Type="String" />
<asp:Parameter Name="dwbm" Type="String" />
<asp:Parameter Name="rybh" Type="String" />
<asp:Parameter Name="qsrq" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:SessionParameter SessionField="login_dwbm" Type="String"/>
<asp:SessionParameter SessionField="login_rybh" Type="String"/>
<asp:SessionParameter SessionField="login_xm" Type="String"/>
<asp:ControlParameter ControlID="TxtBqsrq" Type="DateTime" PropertyName="Text"/>
<asp:ControlParameter ControlID="TxtBzzrq" Type="DateTime" PropertyName="Text" />
<asp:ControlParameter ControlID="TxtBccdd" Type="String" PropertyName="Text"/>
<asp:ControlParameter ControlID="TxtBccsy" Type="String" PropertyName="Text"/>
<asp:ControlParameter ControlID="TxtBpzr" Type="String" PropertyName="Text" />
</InsertParameters>
<DeleteParameters>
<asp:Parameter Name="dwbm" Type="String" />
<asp:Parameter Name="rybh" Type="String" />
<asp:Parameter Name="qsrq" Type="String" />
</DeleteParameters>
</asp:SqlDataSource>.aspx.vb 文件:
Protected Sub Btn_ok_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Btn_ok.Click Me.SqlDataSource1.Insert()
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货