请教怎么手工绑定bindingNavigator？

Question

用下面的代码绑定后 bindingNavigator只能显示记录条数，其它按钮都无效，怎么让bindingNavigator能和datagridview关联起来呢？
               dadapter = new SqlDataAdapter();
                dadapter.SelectCommand = new SqlCommand(selectString, myConn);
                dset = new DataSet();
                dadapter.Fill(dset, "UserTable");
                builder = new SqlCommandBuilder(dadapter);
                this.dataGridView1.DataSource = dset;
                dataGridView1.DataMember = "UserTable";
                bindingSource2 = new BindingSource();
                bindingSource2.DataSource = dset;
                bindingSource2.DataMember = "UserTable";
                bindingNavigator2.BindingSource = bindingSource2;改成下面的 bindingNavigator 就能正常显示，但builder又无效了，不能存盘，为什么两个控件的DataSource一个要设成BindingSource，另一个要设为table呢？
                bindingSource2 = new BindingSource();
                bindingSource2.DataSource = dset;
                bindingSource2.DataMember = "UserTable";
                bindingNavigator2.BindingSource = bindingSource2;
                dadapter = new SqlDataAdapter();
                dadapter.SelectCommand = new SqlCommand(selectString, myConn);
                dset = new DataSet();
                dadapter.Fill(dset, "UserTable");
                builder = new SqlCommandBuilder(dadapter);
                this.dataGridView1.DataSource = bindingSource2;请大家帮我改一下代码，让bindingNavigator、dataGridView1、builder同时有效。

Answer 1

没测试过。dadapter = new SqlDataAdapter();
dadapter.SelectCommand = new SqlCommand(selectString, myConn);
dset = new DataSet();
dadapter.Fill(dset, "UserTable");
builder = new SqlCommandBuilder(dadapter);bindingSource2 = new BindingSource();bindingSource2.DataSource = dset;
bindingSource2.DataMember = "UserTable";this.dataGridView1.DataSource = bindingSource2;bindingNavigator2.BindingSource = bindingSource2;