How do you read table design (column names, datatypes) in C#?
Use a combination of DataTable and DataAdapter objects, as follows:
SqlConnection conn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Pubs"); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Authors", conn); conn.Open(); DataSet ds = new DataSet(); DataTable data = da.FillSchema(ds, SchemaType.Source);
Both the dataset as well as the data DataTable array will have the table schema from the query. You can select from multiple tables to get multiple schemas. From there you can use DataTable.Columns collection to access each column and its full definition and properties.
Dig deeper on C# programming language
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.