GetSchemaTable方法

GetSchemaTable()方法返回一个带有预定义结构的DataTable。

                SqlDataReader reader = cmd.ExecuteReader();
                DataTable tb = reader.GetSchemaTable();
                foreach (DataRow row in tb.Rows)
                {
                   label1.Text= ((SqlDbType)row["ProviderType"]).ToString();
                   label2.Text = row["ColumnName"].ToString();
                }