http://msmvps.com/blogs/egoldin/archive/2006/12/20/programmatically-determining-the-sqldbtype-of-a-field.aspxI found this remarkable info in a newsgroup post from David Sceppa from Microsoft: You can build a SqlCommand to query the table and retrieve this schema information from the SqlDataReader through its GetSchemaTable method. This method returns a DataTableenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/egoldin/archive/2006/12/20/programmatically-determining-the-sqldbtype-of-a-field.aspx#1641181Thu, 17 Jul 2008 05:12:55 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1641181Jon B<p>Yes, thanks, that did the trick.</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1641181" width="1" height="1">http://msmvps.com/blogs/egoldin/archive/2006/12/20/programmatically-determining-the-sqldbtype-of-a-field.aspx#1623281Fri, 16 May 2008 08:49:58 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1623281manjuantha<p>Thanks a ton ! </p> <p>It saved us so much time ...thank u </p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1623281" width="1" height="1">http://msmvps.com/blogs/egoldin/archive/2006/12/20/programmatically-determining-the-sqldbtype-of-a-field.aspx#1571355Fri, 04 Apr 2008 10:48:58 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1571355Ron<p>Excellent ! Like the others I was searching for this for hours.</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1571355" width="1" height="1">http://msmvps.com/blogs/egoldin/archive/2006/12/20/programmatically-determining-the-sqldbtype-of-a-field.aspx#1490943Sat, 02 Feb 2008 00:16:46 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1490943BH<p>Very grateful.</p> <p>Wasted about 3 hours Googling before I came across this !</p> <p>Thanks again.</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1490943" width="1" height="1">http://msmvps.com/blogs/egoldin/archive/2006/12/20/programmatically-determining-the-sqldbtype-of-a-field.aspx#1284169Mon, 05 Nov 2007 22:28:03 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1284169DG<p>Thanks so much!! &nbsp;I also needed this!</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1284169" width="1" height="1">http://msmvps.com/blogs/egoldin/archive/2006/12/20/programmatically-determining-the-sqldbtype-of-a-field.aspx#962196Thu, 14 Jun 2007 10:14:14 GMTd67277c4-116b-43f1-b688-e9ef184ea916:962196Daniel GradThank you so much... I was going crazy trying to find this<div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=962196" width="1" height="1">