【求助】无法用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