access数据库里面有一张表,想通过listview控件显示出来.我该怎么做

[霜寒月冷]

access数据库里面有一张表,想通过listview控件显示出来.我该怎么做?

[霜寒月冷]

麻烦详细点,刚刚接触数据库这部分,有许多地方都碰壁!先谢了大家

[firefoxxx]

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Windows.Forms;
using System.Windows;

namespace WindowsApplication1
{
    class Class1
    {
        public static OleDbConnection GreatConn()
        {
            string strConnection = "provider=Microsoft.jet.OLEDB.4.0;data Source=" + Application.StartupPath + "/db1.mdb;";
            OleDbConnection objCon = new OleDbConnection(strConnection);
            return objCon;
        }
        public static DataTable GetTabel(string strsql)
        {
            OleDbConnection Ocon = GreatConn();
            Ocon.Open();
            OleDbDataAdapter oda = new OleDbDataAdapter(strsql, Ocon);
            DataTable dt = new DataTable("uinfo");
            oda.Fill(dt);
            return dt;
        }
        public static void BindListView(ListView lv, DataTable dt) //将DataTable写入ListView
        {
            lv.Clear();
            lv.View = View.Details;
            lv.FullRowSelect = true;
            foreach (DataColumn dc in dt.Columns)
            {
                lv.Columns.Add(dc.ColumnName);
            }
            foreach (DataRow dr in dt.Rows)
            {
                ListViewItem lvi = new ListViewItem(dr[0].ToString());
                lvi.SubItems.Add(dr[1].ToString());
                lv.Items.Add(lvi);
            }
        }
    }
}


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            DataAll();
        }
        void DataAll()
        {

            listView1.Items.Clear();
            DataTable dt =Class1.GetTabel("select UName, UCity from Uinfo");
            Class1.BindListView(listView1, dt);
        }
    }
}

[firefoxxx]

楼主刚接触数据库？ 简单的SQL语句会写吧？

[霜寒月冷]

[Quote=引用 3 楼 firefoxxx 的回复:]
楼主刚接触数据库？ 简单的SQL语句会写吧？
[/Quote]
非常感谢,你写得已经很详细了啊!!
sql简单语句我还是会的啊.呵呵..等会儿结贴给分啊

[霜寒月冷]

我access数据库里面总共有四列的,显示出来的只有两列.这是什么原因啊?

[霜寒月冷]

自己解决了啊.呵呵...没仔细看代码..呵呵.见笑了啊
ListViewItem lvi = new ListViewItem(dr[0].ToString());
lvi.SubItems.Add(dr[1].ToString());
lv.Items.Add(lvi);

[firefoxxx]

添加行数据的代码改成这样就可以了 是我的失误

public static void BindListView(ListView lv, DataTable dt) //将DataTable写入ListView
        {
            lv.Clear();
            lv.View = View.Details;
            lv.FullRowSelect = true;
            foreach (DataColumn dc in dt.Columns)
            {
                lv.Columns.Add(dc.ColumnName);
            }
            foreach (DataRow dr in dt.Rows)
            {
                ListViewItem lvi = new ListViewItem(dr[0].ToString());
                for (int i = 1; i < dr.ItemArray.Length; i++)
                {
                    lvi.SubItems.Add(dr[i].ToString());
                }lv.Items.Add(lvi);
            }
        }