201004/26/0_1272284735HN7W.gif" alt="" />

 

代码1

private DataSet ds; //数据集 private SqlDataAdapter adapter; //适配器

 

代码2

public DataSet GetData(ref SqlDataAdapter adapt) { <a class="tags" href="/tags/STRING.html" title=string>string</a> str = @"Data Source=PC-<a class="tags" href="/tags/2010.html" title=2010>2010</a>03181231;Integrated Security=SSPI;Initial Catalog=bankDB"; SqlConnection conn = new SqlConnection(str); try { <a class="tags" href="/tags/STRING.html" title=string>string</a> 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(<a class="tags" href="/tags/OBJECT.html" title=object>object</a> 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(<a class="tags" href="/tags/OBJECT.html" title=object>object</a> sender, EventArgs e) { adapter.Update(ds); }

 

运行效果

201004/26/0_1272285525pxPB.gif" alt="" />