Get column default values with ADO.NET

Question

I want to get the default values of all columns of a table so I can display them in the data-entry form, is there a way to do this using ADO.NET ? I know I can query the information_schema database for this info, I'm just wondering if there's a built-in way to do this in ADO.NET

You can get almost everything else you'd want to know about the table schema by using FillSchema, but I don't see the default value among the available items - msdn.microsoft.com/en-us/library/229sz0y5.aspx — DOK
– DOK, Commented Sep 10, 2010 at 19:42

Max Toro · Accepted Answer · 2010-10-15 19:11:39Z

2

You can use DbConnection.GetSchema to get the default column values:

DbConnection conn = SqlClientFactory.Instance.CreateConnection("server=.\\SQLEXPRESS;database=northwind;integrated security=true");
conn.Open();

DataTable schema;

try {

   schema = conn.GetSchema("Columns", new string[4] { conn.Database, null, "products", null });

   foreach (DataRow row in schema.Rows) {
      Console.WriteLine("Name: {0}, Default: {1}", row["COLUMN_NAME"], row["COLUMN_DEFAULT"]);
   }

} finally {
   if (conn.State != ConnectionState.Closed)
      conn.Close();
}

edited Oct 15, 2010 at 19:11

answered Oct 15, 2010 at 18:57

Max Toro

28.7k11 gold badges81 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

CodingGorilla · Accepted Answer · 2010-09-10 19:37:49Z

1

Nope, you'll have to query the database schema, or hard code the values yourself.

answered Sep 10, 2010 at 19:37

CodingGorilla

19.9k4 gold badges48 silver badges65 bronze badges

Collectives™ on Stack Overflow

Get column default values with ADO.NET

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related