sqldataadapter and smalldatetime fields

  • Thread starter Thread starter Dan Owens
  • Start date Start date
D

Dan Owens

Am I missing something or does the System.Data.SqlClient.SqlDataAdapter not
handle smalldatetime fields when pulling records down from a sql 2000
database? Everytime I hit a date field, I get an error that I can only
solve by removing the date field or casting it to varchar.

Is this a limitation of the adapter or the something I am doing wrong?

Dan
 
Hi Dan,

Can you post the code that you are seeing the issue? Also, what is the
exception and error you receive when this fails?

Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
Reply-To: "Dan Owens" <[email protected]>
From: "Dan Owens" <[email protected]>
Subject: sqldataadapter and smalldatetime fields
Date: Wed, 27 Aug 2003 21:18:33 -0700
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <[email protected]>
Newsgroups: microsoft.public.dotnet.framework.compactframework
NNTP-Posting-Host: 12-231-76-111.client.attbi.com 12.231.76.111
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:32217
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Am I missing something or does the System.Data.SqlClient.SqlDataAdapter not
handle smalldatetime fields when pulling records down from a sql 2000
database? Everytime I hit a date field, I get an error that I can only
solve by removing the date field or casting it to varchar.

Is this a limitation of the adapter or the something I am doing wrong?

Dan
 
Back
Top