Query data type of column in DB table

Hi All

I want to retrieve the data type of table column and validate the input data whether same as data type of table column before insert into database. Any suggestion?

I use asp.net + msde

Thank you.

You could use TypedDataSets or TableAdapters to ensure your data type.|||

Thank you for your help.

Could I use both functions in web programming?

I searched both functions in MSDN and seems was used by visual studio.

Thank you.

|||Yes, Typed DataSets have been around since ASP.Net 1.1, and Table Adapters are new to ASP.Net 2.0. I use Table Adapters quite extensively now. They're really easy to use once you know how to set them up.|||

Thank you very much.

any web site I can read to know the syntax? Because I am a beginner of ASP.NET

THANKS!!

|||Here's a couple of links to a good tutorial on how to create a Data Access Layer and Business Logic Layer which includes usage of TableAdapters:

http://msdn.microsoft.com/asp.net/reference/data/default.aspx?pull=/library/en-us/dnaspnettut/html/aspnet_tutorial01_dataaccesslayer_cs.asp
http://msdn.microsoft.com/asp.net/reference/data/default.aspx?pull=/library/en-us/dnaspnettut/html/aspnet_tutorial02_businesslogiclayer_cs.asp|||

Thanks a lot.