C#读取表某个表的字段

//C#读取表某个表的字段

private void MSSQL_CONN()
{
    //MSSQLSQL标准连接方式
    string strConnection = "user id=sa;password=yongfa365;initial catalog=Northwind;Server=yongfa365;Connect Timeout=30";
    SqlConnection conn = new SqlConnection(strConnection);
    conn.Open();
    SqlCommand cmd = new SqlCommand("select * from Customers where 1<>1", conn);
    SqlDataReader sdr = cmd.ExecuteReader();
    string ret = "";
    checkedListBox1.Items.Clear();
    for (int i = 0; i < sdr.FieldCount; i++)
    {
        checkedListBox1.Items.Add(sdr.GetName(i));
        ret += sdr.GetName(i) + "\r\n";
        // MessageBox.Show(sdr.GetName(i));
    }
    textBox1.Text = ret;
}

private void ACCESS_OLE_CONN()
{
    //ACCESS的连接方法,得用Ole连接.
    string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\采集\maya\img.mdb";
    OleDbConnection objConnection = new OleDbConnection(strConnection);
    objConnection.Open();
    OleDbCommand cmd = new OleDbCommand("select * from imgURL where 1<>1", objConnection);
    OleDbDataReader sdr = cmd.ExecuteReader();
    string ret = "";
    checkedListBox1.Items.Clear();
    for (int i = 0; i < sdr.FieldCount; i++)
    {
        checkedListBox1.Items.Add(sdr.GetName(i));
        ret += sdr.GetName(i) + "\r\n";
        // MessageBox.Show(sdr.GetName(i));
    }
    textBox1.Text = ret;
}

private void MSSQL_OLE_CONN()
{
    //MSSQL用Ole连接而不是专用连接,也可以
    string strConnection = @"Provider=SQLOLEDB.1; Persist Security Info=True; Data Source=yongfa365; Initial Catalog=Northwind; User ID=sa; Password=yongfa365";
    OleDbConnection objConnection = new OleDbConnection(strConnection);
    objConnection.Open();
    OleDbCommand cmd = new OleDbCommand("select * from Customers where 1<>1", objConnection);
    OleDbDataReader sdr = cmd.ExecuteReader();
    string ret = "";
    checkedListBox1.Items.Clear();
    for (int i = 0; i < sdr.FieldCount; i++)
    {
        checkedListBox1.Items.Add(sdr.GetName(i));
        ret += sdr.GetName(i) + "\r\n";
        // MessageBox.Show(sdr.GetName(i));
    }
    textBox1.Text = ret;
}

从这里可以看出，虽然C#提供了好几种连接数据库的方法，但如果他们都支持Ole连接的话，也都可以使用这种链接．当然以上主要是介绍如何显示一个表的所有字段．