How Do I Use Time(7) In Sql In My Asp.Net

Question

0.00/5 (No votes)

See more:

, +

i have a column in database in sql server 2012 that his type is Time (7)
and i want to use it in asp.net but i don't know how.!!

i want from this Time the hours and minutes.

Posted 29-Dec-14 6:46am

Bestfofo

Add a Solution

Comments

DamithSL 29-Dec-14 12:52pm

what have you tried so far?

Bestfofo 29-Dec-14 13:19pm

trans.Clear();

SqlCommand COMM = new SqlCommand("select *from [DDD]");
COMM.Connection = cnn;
cnn.Open();

try
{
SqlDataReader dr = COMM.ExecuteReader();
while (dr.Read())
{
Transaction x = new Transaction();

x.UserName = dr.GetString(0);
x.Action = dr.GetString(1);

x.Time = dr.GetTimeSpan(2);

if (!(dr["ToAccount"].Equals(System.DBNull.Value)))
{
x.ToAccount = dr["ToAccount"].ToString();
}
if (!(dr["FromAccount"].Equals(System.DBNull.Value)))
{
x.FromAccount = dr["FromAccount"].ToString();
}
x.Amount = dr[6] != null ? dr.GetDecimal(5) : 0;
trans.Add(x);
}

i try this but i didn't use the type Time before and i get error in using timespan

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Answer 1 · 2014-12-29T06:56:00

Solution 1

These two articles are show you how to map SQL time data type to .NET data type...
http://msdn.microsoft.com/en-us/library/ms131092.aspx[^]
http://msdn.microsoft.com/en-us/library/bb675168.aspx[^]

Posted 29-Dec-14 6:56am

Kornfeld Eliyahu Peter

Comments

Bestfofo 29-Dec-14 13:21pm

thanx, i have already see them but i didn't know how to get the time using timespan

Kornfeld Eliyahu Peter 29-Dec-14 13:27pm

To get time from TimeSpan, you can use TimeSpan.Hours and TimeSpan.Minutes...
http://msdn.microsoft.com/en-us/library/system.timespan(v=vs.110).aspx

DamithSL · Answer 2 · 2014-12-29T07:00:00

Solution 2

refer : http://msdn.microsoft.com/en-us/library/bb675168.aspx[^]
for sql server Time, matching C# .NET Framework type is TimeSpan
if you check the TimeSpan properties you can get the values you want [^]

Posted 29-Dec-14 7:00am

DamithSL