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 WindowsFormsApplication23 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { // 建立仓库 DataSet ds = new DataSet(); // 建立小车 String connStr = "Data Source=.;Initial Catalog=kksk;User ID=sa;Password=root123456"; SqlConnection conn = new SqlConnection(connStr); String sql = "select * from tkk"; SqlDataAdapter adapter = new SqlDataAdapter(sql,conn); // 小车卸货 adapter.Fill(ds,"hero"); // 关闭dgv的自动生成列的功能 dataGridView1.AutoGenerateColumns = false; // 控件绑定仓库中的表中的数据 // 控件名.datasource = 某个数据表(仓库中的数据表) dataGridView1.DataSource = ds.Tables["hero"]; } } }