• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2765
  • Last Modified:

sqlserver + timespan column datatype

I'm using sqlserver and I have
One Column in a Table   whose DataType  is Timespan

How can I retrieve  Timespan Column  Value  on the Form using VB.Net

e.g:
txtcode.text=myDataReader("code")
txtname.text=myDataReader("name")
txttimespan.text=myDataReader("timespancolumn")

0
sohrabus
Asked:
sohrabus
1 Solution
 
Sham HaqueSenior SAP CRM ConsultantCommented:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=182986&SiteID=1

"SQL Server 2005 does not support timespan datatypes directly.

You can wrap the CLR timespan type using the SQL CLR functionality and provide a cast that accepts the string format..."
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now