Oracle 12c数据库基础教程-Oracle 12c数据库办公事务管理系统（Visual C#）.pptVIP

DataRefresh ()函数 // 从数据源中读取数据,刷新表格中显示 private void DataRefresh() { CADOConn m_ado = new CADOConn(); String sql; // 定义SELECT语句,根据培训状态读取培训信息 sql = SELECT InfoNo AS 资料编号, InfoName AS 资料名称, InfoType AS 分类名称, ICount AS 数量, IPrice AS 价格, + CreateDate AS 登记日期, Detail AS 说明FROM Information + WHERE InfoName LIKE % + txtInfoName.Text.Trim() + % ORDER BY InfoNo; // 使用OracleDataAdapter对象执行SELECT语句 OracleDataAdapter da = new OracleDataAdapter(sql, m_ado.conn); da.Selectmand.mandType = mandType.Text; // 设置命令地执行类型为SQL语句 m_ado.conn.Open(); // 使用DataTable对象提供数据源 DataTable table = new DataTable(); da.Fill(table); // 将结果集数据填充到DataTable对象中 m_ado.conn.Close(); dataGridView1.DataSource = table; dataGridView1.Refresh(); dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[1].Width =100; …… } 单击借阅按钮 private void btnLend_Click(object sender, EventArgs e) { if (dataGridView1.RowCount = 0) { MessageBox.Show(请选择借阅记录); return; } FrmInfoLendEdit form = new FrmInfoLendEdit(); form.cId = ; // 表示添加借阅记录 form.cInfoNo = dataGridView1.SelectedCells[0].Value.ToString(); form.ShowDialog(); } 12.6.2 设计资料信息编辑窗体 用户单击确定按钮 private void btnOK_Click(object sender, EventArgs e) { if (txtInfoNo.Text.Trim() == ) { MessageBox.Show(this, 请输入资料编号); txtInfoNo.Focus(); this.DialogResult = DialogResult.None; } else if (txtInfoType.Text.Trim() == ) { MessageBox.Show(请输入资料分类); txtInfoType.Focus(); this.DialogResult = DialogResult.None; } else if (txtInfoName.Text.Trim() == ) { MessageBox.Show(请输入资料名称); txtInfoName.Focus(); this.DialogResult = DialogResult.None; } else { // 对eetingRooms对象赋值 CInformation info = new CInformation(); info.InfoNo = txtI