[RESOLVED] how to get only time from datetime part

[anirai]

hi..i have a table where in date column i have datetime datatype..i want to get only time in textbox...but i m getting both date and time by this below code..help anyone...thanks
i m using vs 2005...sql 2005

Try
                cn = New SqlConnection("server=localhost;database=attendance1;uid=sa;password=;")

              
                cn.Open()
                cmd = New SqlCommand("select * from shift where shift_name='" & ComboBox1.Text & "' ", cn)
                dr = cmd.ExecuteReader
                While dr.Read()
                    TextBox1.Text = dr(1) 
                   
                End While
            Catch
            End Try
            dr.Close()
            cn.Close()

[jmcilhinney]

The DateTime structure has methods to return a string representation. To get the time only you can call ToLongTimeString or ToShortTimeString. You can also call ToString and specify any standard or custom format string you want to get the date and/or time in any format. MSDN provides all the information you need on date and time format string. As an example, ToString("t") is equivalent to ToShortTimeString() and ToString("T") is equivalent to ToLongTimeString().

[anirai]

i got blank by doing that....nothing appeared..do you have any code?

[jmcilhinney]

do you have any code?

Do you? If you don't show us what you did then we can't tell you what you did wrong.

[anirai]

i posted my code into the first reply above...

[jmcilhinney]

That was your original code. I've told you what you need to do to achieve your goal and you said that you tried it and it didn't work. You need to show us that new code that you tried so we can tell what's wrong with it. If you change your code then the original is useless to us.

[anirai]

thanks for your help//at first i used tostring("t")..no result..then i used toshorttimestring then i got only time...wonderfull....

TextBox1.Text = dr(1).toshorttimestring