Accessing SQL table attributes using datatable
Hi guys... I just want to ask if there's a way to access table attributes.. so i could use the property after filling a datatable... Im using SQL Server.
This is my example : Given
1. Table named EMPLOYEE w/ fields, datatype, length
employeeID - nvarchar, 25
employeename - nvarchar, 100
2. I have declared a datatable dtemployee.. using the DAL, i fill the datatable...
Is there a way i could access the datatype, length, allow nulls of the table by using the datatable...? How can i make this attribute available to my datatable?