我向数据库插入数据成功，在datagridview中却看不到帮忙看下，新手学习中

Question

  private void 保存SToolStripButton_Click(object sender, EventArgs e)
        {            string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\VS2005 Project\Test\Test\bin\Debug\Data\DBCommunity.mdb";
            OleDbConnection conn = new OleDbConnection(conStr);
            try
            {
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }
            }
            catch
            {
                throw new Exception("连接异常");
            }
            finally
            {
                conn.Close();
            }
            string sql = "insert into 服务投诉(投诉编号,楼栋名称,业主编号,业主姓名,投诉日期,接待人员,投诉主题,投诉内容,处理日期,处理人员,处理意见,处理结果,业主反馈,补充说明) values(@投诉编号,'"+this.楼栋名称comboBox1.Text+"',@业主编号,'"+this.业主姓名comboBox2.Text+"','"+this.投诉日期dateTimePicker投诉日期1.Text+"',@接待人员,@投诉主题,@投诉内容,'"+this.处理日期dateTimePicker2.Text+"',@处理人员,@处理意见,@处理结果,@业主反馈,@补充说明)";
            OleDbDataAdapter adp = new OleDbDataAdapter(sql,conStr);
            OleDbCommand cmdStr = new OleDbCommand(sql, conn);
            OleDbParameter parm1 = new OleDbParameter("@投诉编号", this.投诉编号textBox1.Text);
            cmdStr.Parameters.Add(parm1);
            OleDbParameter parm2 = new OleDbParameter("@业主编号", this.业主编号textBox4.Text);
            cmdStr.Parameters.Add(parm2);
            OleDbParameter parm3 = new OleDbParameter("@接待人员", this.接待人员textBox2.Text);
            cmdStr.Parameters.Add(parm3);
            OleDbParameter parm4 = new OleDbParameter("@投诉主题", this.投诉主题textBox3.Text);
            cmdStr.Parameters.Add(parm4);
            OleDbParameter parm5 = new OleDbParameter("@投诉内容", this.投诉内容textBox5.Text);
            cmdStr.Parameters.Add(parm5);
            OleDbParameter parm6 = new OleDbParameter("@处理人员", this.处理人员textBox6.Text);
            cmdStr.Parameters.Add(parm6);
            OleDbParameter parm7 = new OleDbParameter("@处理意见", this.处理意见textBox7.Text);
            cmdStr.Parameters.Add(parm7);
            OleDbParameter parm8 = new OleDbParameter("@处理结果", this.处理结果textBox8.Text);
            cmdStr.Parameters.Add(parm8);
            OleDbParameter parm9 = new OleDbParameter("@业主反馈", this.业主反馈extBox9.Enabled);
            cmdStr.Parameters.Add(parm9);
            OleDbParameter parm10 = new OleDbParameter("@补充说明", this.补充说明textBox10.Text);
            cmdStr.Parameters.Add(parm10);
          
            cmdStr.Connection.Open();
            int arrow = cmdStr.ExecuteNonQuery();
            if (arrow > 0)
            {
                MessageBox.Show("操作成功");
            }
            else
            {
                MessageBox.Show("操作失败");
            }
            conn.Close();
改怎么改？新手学习中，各位高手大侠，指导下

Answer 1

保存后把你绑定DataGridView的方法调用一下就可以了我靠，，楼主数据库字段用的都是中文

Answer 2

把绑定datagridview数据源方法，再重新绑定一次。也就是执行多一次SQL语句啦

Answer 3

那你怎么让dgv显示的数据，就应该怎么绑定

Answer 4

查查你的代码里面有没有类似这样的语句 ->DataGridView1.DataSource = dataTable;
就是从新从数据库读出数据放到dataTable或dataSet中，然后指定DataGridView1数据源PS：
不会是一行代码都没写 直接就鼠标点几下绑定的数据源吧。。

Answer 5

代码中都没有看到DataGridView1.DataSource的绑定啊，
如DataGridView1.DataSource = dataTable

Answer 6

我重新写了个，是不是这样子绑定的？帮忙看看
namespace Test
{
    public partial class EventForm : Form
    {
        public EventForm()
        {
            InitializeComponent();
        }
        OleDbDataAdapter adp;
        DataSet ds;
        public void shwow()
        {
            OleDbConnection conn = new OleDbConnection();
            // string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\VS2005 Project\Test\Test\bin\Debug\Data\DBCommunity.mdb";
            // OleDbConnection conn = new OleDbConnection(conStr);
            try
            {
                conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\VS2005 Project\Test\Test\bin\Debug\Data\DBCommunity.mdb");                conn.Open();
                string sql = "select *from 突发事件";
                adp = new OleDbDataAdapter(sql, conn);
                ds = new DataSet();
                adp.Fill(ds, "突发事件");
                bindingSource1.DataSource = ds.Tables["突发事件"];
                dataGridView1.DataSource = bindingSource1;
                OleDbCommandBuilder cmd = new OleDbCommandBuilder(adp);
                adp.Update(ds, "突发事件");
            }
            catch
            {                throw new Exception("异常");
            }
            finally
            {
                conn.Close();
            }
        
        }
        private void EventForm_Load(object sender, EventArgs e)
        {
            shwow();
        }        private void 保存SToolStripButton_Click(object sender, EventArgs e)
        {            OleDbConnection conn = new OleDbConnection();
            try
            {
                
               conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\VS2005 Project\Test\Test\bin\Debug\Data\DBCommunity.mdb");
                conn.Open();
                string sql = "insert into 突发事件(事件编号,发生日期,处理人员,事件主题,事件内容,处理结果,补充说明) values('" + this.事件编号textBox1.Text + "','" + this.处理日期dateTimePicker1.Text + "','" + this.处理人员textBox2.Text + "','" + this.事件主题textBox3.Text + "','" + this.事件内容textBox4.Text + "','" + this.处理结果textBox5.Text + "','" + this.补充说明textBox6.Text + "')";
                adp = new OleDbDataAdapter(sql, conn);
                ds = new DataSet();
                adp.Fill(ds, "突发事件");
                bindingSource1.DataSource = ds.Tables["突发事件"];
                dataGridView1.DataSource = bindingSource1;
                OleDbCommandBuilder cmd = new OleDbCommandBuilder(adp);
                adp.Update(ds, "突发事件");
            }
            catch
            {                throw new Exception("异常");
            }
            finally
            {
                conn.Close();
            }
            shwow();
        }
    }
}

Answer 7

重新绑定的时候是不是调用前面的shwow（）方法？还是？