C#如何更新DataGridView中的数据？

我刚刚学校C#，遇到了点问题。请高手指教。我想用按钮控制另一个窗体中的DataGridView更新数据，不知怎么回事就是没效果。下面是我的代码：<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />Form2 f2 = new Form2();<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />string date = dateTimePicker1.Value.Date.ToShortDateString();<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />string sql = "Server=(local);Database=Fst;uid=sa;pwd=sa";<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />string str = "select Ia,Ib,Ic,I0 from IData where User='保定供电公司'";<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />SqlConnection con = new SqlConnection(sql);<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />con.Open();<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />SqlDataAdapter da = new SqlDataAdapter(str,con);<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />DataSet ds = new DataSet();<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />da.Fill(ds);<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />f2.dataGridView1.DataSource =ds.Tables[0].DefaultView;<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />con.Close();<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />this.Close();<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" /><br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />DataGridView控件在Form2上面，在窗体载入时已经给它制定了一个数据源，现在要用另一个窗体Form3上的按钮来更新数据。<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />是不是数据源这样定义不对啊？高手不要见笑，请赐教！谢~~

分享到：

举报| 2008-06-10 15:17提问者采纳

这样吧，你试试啊，我没有试<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />你在你显示数据的那个窗体的CS文件中新建一个PUBLIC的方法，在这个法方里写上你写的那段代码(我改了一点儿)：<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />string date = dateTimePicker1.Value.Date.ToShortDateString(); <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />string sql = "Server=(local);Database=Fst;uid=sa;pwd=sa"; <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />string str = "select Ia,Ib,Ic,I0 from IData where User='<a target=_blank target="_blank" class="inner-link decor-none" href="http://zhidao.baidu.com/search?word=%E4%BF%9D%E5%AE%9A%E4%BE%9B%E7%94%B5%E5%85%AC%E5%8F%B8&fr=qb_search_exp&ie=utf8" rel="nofollow" style="text-decoration: none; transition: color 0s ease-out; -webkit-transition: color 0s ease-out; color: rgb(202, 0, 0); font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;">保定供电公司</a>'"; <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />SqlConnection con = new SqlConnection(sql); <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />con.Open(); <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />SqlDataAdapter da = new SqlDataAdapter(str,con); <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />DataSet ds = new DataSet(); <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />da.Fill(ds); <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />dataGridView1.DataSource =ds.Tables[0].DefaultView; <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />dataGridView1.DataBind();<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />con.Close(); <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />然后你在要刷新数据的那个窗体中的按钮点击事件下这样写：<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />Form2 f2 = new Form2(); <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />f2.你的那个法方<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />你看看行不行啊，我也不知道，不过我想是可以的。呵呵呵

提问者评价

这样还是不可以，我解决了，谢谢你们的热心帮忙！祝大家工作愉快！

更多0

• 上一篇比较经典的为C# Winform程序设置登录窗体先启动，成功后再启动主窗口。
• 下一篇SqlDataAdapter用法