Determining SQL Server datetime

[Trancedified]

Hello,

I have a listbox w/ names of SQL Server 2000 fields loaded into it.
I looped through the listbox to include square brackets [ ] incase the fields have a blank.

Here is my code:

Dim i As Integer 
strSQL = "SELECT Toc.Name AS [Document Name], " 
                For i = 0 To lstSelection.Items.Count - 1 
                    lstSelection.SelectedIndex = i 'Read through list box 
                        strSQL &= "[" & lstSelection.Items(i).ToString & "]" & ", " 
       
                Next 
               'Removes the last comma 

                strSQL = strSQL.Substring(0, strSQL.Length - 2)
                strSQL &= " FROM TD4"

Is there a way to tell which field is a SQL Server datetime field automatically then grab that field and CONVERT it with:

strSQL &= "CONVERT(VARCHAR(10), 101) AS " 'Whatever the datetime field is

(That cuts off the time in the field)

Thanks!

Chris

 

[chiph]

Listboxes can contain more than just string values -- the list is actually a list of Objects (big O).

This means that you can write a class that describes a SQL Server field ... including it's datatype, and use several of them to populate your list (you would override the ToString method).

When you concatenate your SQL from the selected field in the listbox, the selecteditem property would return your field object, and you'd have your datatype.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[RiverGuy]

Look in syscolumns

 

[Trancedified]

Thanks for posting!

Any samples?