DataGridView控件的使用 1207

DataGridView控件的使用 1207

1.

2.

3.

代码块

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

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

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //创建仓库
            DataSet ds = new DataSet();
            //创建小车
            string connStr = "Data Source=.;Initial Catalog=SangGuo;Integrated Security=True";
            SqlConnection conn = new SqlConnection(connStr);
            string sql = "select * from Table_1";
            SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
            //小车卸货
            adapter.Fill(ds, "SangGuo");
            //关闭dgv的自动生成列的功能
            dataGridView1.AutoGenerateColumns = false;
            //让控件绑定数据库
            //控件名.DataSource = 某个数据表（仓库中的数据表）
            dataGridView1.DataSource = ds.Tables["SangGuo"];
        }
    }
}