如何检索数据表（分不够再加)

Question

用SQL server 
请说详细些.

Answer 1

//与数据库无关
            this.oleDbConnection1.Open();            DataTable schemaTable = oleDbConnection1.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns,//Columns->Tables取表
                new object[] {null, null, null,null});
            //this.DataGrid1.DataSource=schemaTable;
            //this.DataGrid1.DataBind();
            System.Data.DataRowCollection drc=schemaTable.Rows;
            foreach(DataRow dr in drc)
            {
               this.TextBox1.Text+=dr["COLUMN_NAME"]+":"+dr["DESCRIPTION"].ToString()+"\r\n";
            }

Answer 2

对象ID:
select distinct id from syscolumns
取对象名称SELECT OBJECT_NAME(@ObjectID)
现在太忙,没时间搞这些,sorry