Accessing Table Attributes

korn_bo2

New member
Joined
Feb 15, 2005
Messages
3
Programming Experience
1-3
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?


thanks in advance...
 

korn_bo2

New member
Joined
Feb 15, 2005
Messages
3
Programming Experience
1-3
TPM said:
Look into the datasets get,read,write XlmSchema.

TPM

I tried using the SQLADapter.FillSchema.. but i cant access the default value set in the SQL Database... regarding XMLSchema, i noticed that when you fill a table or dataset, the default values is not initialized... thanks for your reply...
 
Top Bottom