187
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();
}
}
最後更新：2017-04-02 04:26:02