<div>
a timespan is an interval of time or the time since midnight so 3:00pm doesn't qualify perhaps convert to datetime instead
</div>


a timespan is an interval of time or the time since midnight so 3:00pm doesn't qualify perhaps convert to datetime instead

<div>
How about this?<br />
&nbsp;DateTime.Parse(&quot;03:00 PM&quot;).TimeOfDay<br />
<br />
TimeOfDay is of type TimeSpan
</div>


How about this?
 DateTime.Parse("03:00 PM").TimeOfDay

TimeOfDay is of type TimeSpan

<div>
I had the same issue. &nbsp;However, elkhawajah's answer is the one that worked for me. &nbsp;I use VS 2008 and SS 2008 which allows storing as a Time type. &nbsp;When I tried cmrobertson's solution, it would not convert a string to a Timespan. &nbsp;However, when I used the following, it worked fine.<br />
<br />
Dim tsTime as Timespan = DateTime.Parse(txtTime.Tex<wbr />t).TimeOfD<wbr />ay<br />
<br />
Just wanted to add the comment for anyone else seeking an answer to storing to the Time type in SS 08.
</div>


I had the same issue.  However, elkhawajah's answer is the one that worked for me.  I use VS 2008 and SS 2008 which allows storing as a Time type.  When I tried cmrobertson's solution, it would not convert a string to a Timespan.  However, when I used the following, it worked fine.

Dim tsTime as Timespan = DateTime.Parse(txtTime.Text).TimeOfDay

Just wanted to add the comment for anyone else seeking an answer to storing to the Time type in SS 08.

<div>
<div class="content wysiwyg-content">
I have a text box (txtTime) that retrieves a user inputted value as time (ex. 3:00 PM). &nbsp;I have a field (StartTime) in my database of type time(7) to store this value in. &nbsp;<br />
<br />
Unfortunately, I'm unable to convert the string from the textbox to this timespan value. &nbsp;Any help would be appreciated. &nbsp;<br />
<br />
txtTime.Text &nbsp;is equal to 3:00 PM (the time can change), but the following doesn't work. &nbsp;<br />
<br />
&nbsp;Timespan Time = Timespan.Parse(txtTime.Tex<wbr />t);
</div>
</div>


I have a text box (txtTime) that retrieves a user inputted value as time (ex. 3:00 PM).  I have a field (StartTime) in my database of type time(7) to store this value in.  

Unfortunately, I'm unable to convert the string from the textbox to this timespan value.  Any help would be appreciated.  

txtTime.Text  is equal to 3:00 PM (the time can change), but the following doesn't work.  

 Timespan Time = Timespan.Parse(txtTime.Text);

Convert/Parse string to Timespan

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.