Hi, folks!

This is a simple questions (hopefully with a simple answer).

I need to include the fractional seconds from a DateTime field from an
MS-SQL server when I run a query. Currently, ADO.NET does not return the
fractional seconds into VB.NET (or C# for that matter) in the sample code
included below.

How can I get the fractional seconds included in the myTime string?

TIA...


'***SAMPLE CODE***
sqlDataSource.ConnectionString = "Provider=SQLOLEDB.1;driver=SQL
Server;server=localhost;uid=user;pwd=pwd;"
sqlStmt = "SELECT ID, aDateTimeField, Blah,... FROM myTable"
sqlDataSource.SelectCommand = sqlStmt
sqlDataSource.SelectCommandType = SqlDataSourceCommandType.Text

Try
DataView = sqlArticle.Select(DataSourceSelectArguments.Empty)
DataTable = DataView.ToTable()
myTime = DataTable.Rows(0).Item("aDateTimeField")
Catch err As Exception
...
Finally
DataTable.Dispose()
DataView.Dispose()
End Try