将SQL数据库中的表格显示在Form页面上

 public void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            string str = "select * from 基础表";
            string source = "server=(local);" + "integrated security=SSPI;" + "database=PhoneWork";
            SqlConnection conn = new SqlConnection(source);
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(str, source);
            da.Fill(ds, "基础表");
            dataGridView1.AutoGenerateColumns = true;
            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "基础表";

        }

数据库访问的是本地数据库，要在form页面上添加datagridview控件，很简单的实现；

转载于:https://www.cnblogs.com/zhangyunyun/archive/2013/02/18/2915799.html