代码1 private DataSet ds; //数据集 private SqlDataAdapter adapter; //适配器 代码2 public DataSet GetData(ref SqlDataAdapter adapt) { string str = @"Data Source=PC-201003181231;Integrated Security=SSPI;Initial Catalog=bankDB"; SqlConnection conn = new SqlConnection(str); try { string cmdtxt = "SELECT * FROM Stock"; adapt = new SqlDataAdapter(cmdtxt, conn); DataSet da = new DataSet(); adapter.Fill(da); SqlCommandBuilder cb = new SqlCommandBuilder(adapter); return da; } catch (Exception) { throw; } finally { conn.Close(); } } 代码3 private void Form1_Load(object sender, EventArgs e) { ds = GetData(ref adapter); //数据集 BindingSource bs = new BindingSource(); bs.DataSource = ds.Tables[0]; dgv.DataSource = bs; navBank.BindingSource = bs; #region 更改列名 dgv.Columns[0].HeaderText = "名称"; dgv.Columns[1].HeaderText = "开盘价"; dgv.Columns[2].HeaderText = "成交价"; dgv.Columns[3].HeaderText = "市盈率"; dgv.Columns[4].HeaderText = "成交量"; dgv.Columns[5].HeaderText = "日期"; #endregion } 代码4 private void btnRefresh_Click(object sender, EventArgs e) { adapter.Update(ds); } 运行效果