就打算在组件里面,可以增减直接操作单行格,但不知道怎么保存操作结果,并且数据库的表页跟着变化
以下是组件实现代码
string tableName = (radioButtonMyTable1.Checked == true ? "student_table" : "MyTable2");
string connectionString = Properties.Settings.Default.c_ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select * from " + tableName, conn);
adapter = sqlDataAdapter;
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
adapter.InsertCommand = builder.GetInsertCommand();
adapter.DeleteCommand = builder.GetDeleteCommand();
adapter.UpdateCommand = builder.GetUpdateCommand();
DataTable table;
table = new DataTable();
adapter.Fill(table);