学步园

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();

    }

}