First you need to retrieve the table schema from the database. Read this answer for instructions on how to do that. Once you have the structure, the DataTable object exposes all the available columns in it, and each column object exposes all the properties you may need, such as AllowDBNull, AutoIncrement, DefaultValue, etc. You can access a specific column by name or ordinal:
DataTable dt = ds.Tables["Customers"]; bool nulls = dt.Columns["id"].AllowDBNull;
Dig Deeper on Win Development Resources
Related Q&A from Daniel Cazzulino
Here Daniel Cazzulino explains how to load a DSL (domain specific language) domain model instance file programmatically. This requires the .NET type ... Continue Reading
Here we offer a glimpse at 12 of .NET development expert Danny Cazzulino's top ASP.NET questions and answers. Continue Reading
C# developers should NOT be modifying InitializeComponent method in the code-behind (or any of the variable definitions) by hand. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.