Ex9-8-11 DataGridViewExample.docVIP

[例9-8至11] 演示DataGridView控件的用法。 创建一个名为DataGridViewExample的Windows窗体应用程序。 将MyDatabase.mdf文件添加到当前项目中。 从[工具箱]中向设计窗体拖放一个BindingSource组件、一个BindingNavigator组件、一个DataGridView控件和若干按钮，设计如下图的界面。其中导航条上的“保存”按钮（name：toolStripSaveButton）是利用鼠标右击导航条选择[插入标准项]命令得到的，再在导航条上添加“绑定/取消绑定到数据源”按钮（name：toolStripButtonBindingDataSource）。 添加一个名为SqlClass.cs的文件。 //SqlClass.cs using System.Data.SqlClient; using System.Data; using System.Windows.Forms; namespace DataGridViewExample { class SqlClass { public DataTable DataTable1 { get; set; } //表示内存中的表 //Adapters are used to exchange data between a data source and a dataset. public SqlDataAdapter SqlDataAdapter1; //数据适配器 public string ConnectionString { get; set; } public SqlClass(string selectSqlString) { ConnectionString = Properties.Settings.Default.MyDatabaseConnectionString; try { SqlDataAdapter1 = new SqlDataAdapter(selectSqlString, ConnectionString); DataTable1 = new DataTable(); //Adds a DataTable to a DataSet and configures the schema to match that in the data source. SqlDataAdapter1.FillSchema(DataTable1, SchemaType.Source); //Automatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database. SqlCommandBuilder builder = new SqlCommandBuilder(SqlDataAdapter1); } catch (SqlException ex) { MessageBox.Show(ex.Message, 创建适配器错误); } } } } Form1.cs //Form1.cs using System; using System.Windows.Forms; using System.Drawing; namespace DataGridViewExample { public partial class Form1 : Form { private SqlClass SqlClass1; //表示MyTable1 private SqlClass SqlClass2; //表示MyTable2 public Form1() { InitializeComponent(); SqlClass1 = new SqlCl