C# 下擷取資料庫表的行列名

c#下擷取資料庫行列資訊。

添加應用：

system

system.configuration

system.data

system.deployment

system.drawing

system.windows.forms

system.xml

using system;

using system.data;

using system.collections.generic;

using system.data.sqlclient;

using system.componentmodel;

class dataset_1

{

    static void main()

    {

        sqlconnection thisconnect = new sqlconnection("data source=(local);initial catalog=xianlu;integrated security=true");

        //thisconnect.open();

        sqldataadapter thisadapter = new sqldataadapter(

            "select * from dbo.xianlu",

            thisconnect

            );

        dataset thisdataset = new dataset();

        thisadapter.fill(thisdataset, "myxianlu");

        int i = 0;

        //foreach (datacolumn clo in thisdataset.tables["myxianlu"].columns)

        //{

           // console.writeline(therow["id"] + "/t" + therow["xl_podu"]);

          //  console.writeline(clo[i]);

            //i++;

            //console.readline();

        //}

        for (i = 0; i < thisdataset.tables["myxianlu"].columns.count; i++)

        {

           // if (thisdataset.tables["myxianlu"].columns[i] == null)

              //  break;

            console.writeline(thisdataset.tables["myxianlu"].columns[i].tostring());

            console.readline();

        }

            thisconnect.close();

        console.writeline("program finished");

        console.readline();

    }

}