当前位置:编程学习 > C#/ASP.NET >>

【求助】无法用SqlDatesours中查询数据库中的datetime类。数据库都没绑定上




这是代码
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:SMSConnectionString1 %>" 
                        DeleteCommand="DELETE FROM [card] WHERE [stuID] = @stuID" 
                        InsertCommand="INSERT INTO [card] ([stuID], [cardRegistered], [cardLossTime], [cardFillTime]) VALUES (@stuID, @cardRegistered, @cardLossTime, @cardFillTime)" 
                        SelectCommand="SELECT * FROM [card] WHERE ([cardLossTime] = @cardLossTime)" 
                        
                        
                        UpdateCommand="UPDATE [card] SET [cardRegistered] = @cardRegistered, [cardLossTime] = @cardLossTime, [cardFillTime] = @cardFillTime WHERE [stuID] = @stuID">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="TextBox1" DbType="DateTime" Name="cardLossTime" 
                                PropertyName="Text" />
                        </SelectParameters>
                        <DeleteParameters>
                            <asp:Parameter Name="stuID" Type="String" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="cardRegistered" DbType="DateTime" />
                            <asp:Parameter Name="cardLossTime" DbType="DateTime" />
                            <asp:Parameter Name="cardFillTime" DbType="DateTime" />
                            <asp:Parameter Name="stuID" Type="String" />
                        </UpdateParameters>
                        <InsertParameters>
                            <asp:Parameter Name="stuID" Type="String" />
                            <asp:Parameter Name="cardRegistered" DbType="DateTime" />
                            <asp:Parameter Name="cardLossTime" DbType="DateTime" />
                            <asp:Parameter Name="cardFillTime" DbType="DateTime" />
                        </InsertParameters>
                    </asp:SqlDataSource> 数据库 ASP SqlDatesource datetime --------------------编程问答-------------------- 嗯 ,知道了。 --------------------编程问答-------------------- 用的什么数据库?
补充:.NET技术 ,  ASP.NET
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,