Question

C#中如何在点击Button后让DataGridView刷新数据列表?

Button2的代码:private void button2_Click(object sender, EventArgs e)        {            string GetName = textBox2.Text;            using (SqlConnection conn = new SqlConnection(@"Data Source=.\;AttachDbFilename=|DataDirectory|\DBTest.mdf;Integrated Security=True;"))            {                conn.Open();                using (SqlCommand cmd = conn.CreateCommand())                {                    cmd.CommandText = "delete from Tb_User where 姓名=@Name";                    cmd.Parameters.Add(new SqlParameter("Name", GetName));                    cmd.ExecuteNonQuery();                    //dataGridView1.Refresh();这个不是这么用的吧?                }            }我想在点击以后刷新数据列表~不知该如何实现?

Answer 1

刷新列表就是重新绑定一次就好了！
conn.Open();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
//sql是你的sql语句
using (SqlDataAdapter ada =new SqlDataAdapter(sql,conn))
{

ada.Fill(ds);
dt = ds.Tables[0];
}
dataGridView1.DataSource = dt;

Answer 2

cmd.Parameters.Add(new SqlParameter("Name", GetName)); cmd.ExecuteNonQuery();
//再次绑定数据即可~~
bindDataSet();

///<summary>
///假设bindDataSet()是你绑定数据的方法
///</summary>
private void bindDataSet()
{

}

Answer 3

其实很简单，你只要再次帮顶数据就好了
using (SqlConnection conn = new SqlConnection(@"Data Source=.\;AttachDbFilename=|DataDirectory|\DBTest.mdf;Integrated Security=True;")) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "delete from Tb_User where 姓名=@Name"; cmd.Parameters.Add(new SqlParameter("Name", GetName)); cmd.ExecuteNonQuery();
你执行完这步之后，再执行gridview绑定数据的方法，就好了

Answer 4

在 cmd.ExecuteNonQuery();后面追加
cmd.CommadText="select * from Tb_User";
adapter.fill(dtable); dtable是data table,因为我不知你有什么方式连接。。你自己定义。。。
datagridview1.datasource=dtable；