请各位高手指点一下,怎么修改,非常感谢!代码如下:
.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