插入后，Datagridview会自动从form2更新 [英] Datagridview automatically update from form2 after insert

问题描述

大家好，



我有小问题，我在form1中有datagridview，我使用SQL命令从form2插入数据，但点击按钮后包括INSERT命令新插入的值不会出现在form1的datagridview中。有什么方法可以解决这个问题吗？



所以我必须在form1中创建刷新按钮，这样每次插入内容时我都可以刷新它。



提前致谢。



这是在表单2中点击按钮的插入代码：

Hello guys,

I have small issue, I have datagridview in form1 to which I insert data from form2 using SQL commands, but after button click which includes INSERT command the newly inserted value doesn't appear in form1's datagridview. Is there any way to solve this ?

So I had to make refresh button in form1 so I can refresh it every time something is inserted.

Thanks in advance.

This is the insert code in button click in form2:

private void btn_zaj_uloz_Click(object sender, EventArgs e)
      {



          SqlCommand prikaz = new SqlCommand
              ("INSERT INTO ....)", spojeni);


          prikaz.Parameters.AddWithValue("param1", textbox.Text);
         ....

          spojeni.Open();
          prikaz.ExecuteNonQuery();
          System.Data.DataTable dt = new System.Data.DataTable();
          System.Data.SqlClient.SqlDataAdapter SDA = new System.Data.SqlClient.SqlDataAdapter("SELECT * FROM column", spojeni);
          SDA.Fill(dt);


          spojeni.Close();

          this.Close();



      }

这将从我的表中选择所有zajezd in SQL

this selects all from my table zajezd in SQL

public  void zvol_klienty()
     {
         System.Data.DataTable dt = new System.Data.DataTable();
         System.Data.SqlClient.SqlDataAdapter SDA = new System.Data.SqlClient.SqlDataAdapter("SELECT * FROM column", spojeni);
         SDA.Fill(dt);

推荐答案

从表单2插入后，创建表单1的对象并调用form1 load事件。

After inserting from Form 2 , create a object of form 1 & call form1 load event.

嗯，

在你完成你在form2中插入数据的过程后，你必须在页面加载事件上再次绑定form1网格，因为如果你没有绑定它或不刷新它形成它应该看到旧记录，所以你必须在页面加载时为绑定网格编写代码。



这肯定会解决你的问题：



http://stackoverflow.com/questions/ 7797975 /如何从另一种形式刷新形式 [ ^ ]



HTTP：// STAC koverflow.com/questions/15896135/how-to-reload-form-in-c-sharp-when-button-submit-in-another-form-is-click [ ^ ]



如果解决问题，请接受解决方案并投票。

Well,
after you complete you process inserting data in form2 you have to bind form1 grid again on page load event because if you are not bind it or not refresh that form it should saw old record so you have to write code on page load for binding grid.

This will definitely solve you problem:

http://stackoverflow.com/questions/7797975/how-to-refresh-a-form-from-another-form[^]

http://stackoverflow.com/questions/15896135/how-to-reload-form-in-c-sharp-when-button-submit-in-another-form-is-click[^]

And accept as solution and vote if solve your problem.

这篇关于插入后，Datagridview会自动从form2更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！