.
数据库设计：
程序代码：
namespace DataView1 {
public partial class Form1 : Form {
string selectCmd = \学号, name as , chi as 语文, eng as 英语, math as 数学 From SCORE\;
public Form1() {
InitializeComponent(); }
private DataView CreateView(string DBName, string SQLcmd, string TabName) {
string connStr = \ + DBName; OleDbConnection conn = new OleDbConnection(connStr); conn.Open();
OleDbDataAdapter myAdapter = new OleDbDataAdapter(SQLcmd,conn); DataSet myDataSet = new DataSet();
myAdapter.Fill(myDataSet, TabName);
return myDataSet.Tables[TabName].DefaultView; }
.
.
private void Form1_Load(object sender, EventArgs e) {
dataGrid1.DataSource = CreateView(\, selectCmd, \); }
private void btnOk_Click(object sender, EventArgs e) {
string sortStr = \; if (rdbChina.Checked) {
sortStr = rdbChina.Text; }
else if (rdbEnglish.Checked) {
sortStr = rdbEnglish.Text; }
else if (rdbMath.Checked) {
sortStr = rdbMath.Text; }
else if (rdbDesc.Checked) {
sortStr = \; }
else if(rdbIncrease.Checked) {
sortStr=\; }
DataView myDataView = new DataView();
myDataView = CreateView(\, selectCmd, \); myDataView.RowFilter = textBox1.Text; myDataView.Sort = sortStr;
dataGrid1.DataSource = myDataView;
} } }
程序运行：
.
.
4. 将MEMBER数据表的数据记录与TextBox、ComboBox、DataGrid控件做数据绑定。 程序设计：
数据库设计：
程序代码：
namespace DataBuinding1 {
public partial class Form1 : Form {
public Form1() {
InitializeComponent(); }
.
.
private void Form1_Load(object sender, EventArgs e) {
string selectCmd = \;
string connStr = \Source=MEMBERDB.mdb\;
OleDbConnection conn = new OleDbConnection(connStr); DataSet myDataSet = new DataSet(); conn.Open();
OleDbDataAdapter myAdapter = new OleDbDataAdapter(selectCmd,conn); myAdapter.Fill(myDataSet, \); cboId.DataSource = myDataSet;
cboId.DisplayMember = \;
txtName.DataBindings.Add(\, myDataSet, \); txtTel.DataBindings.Add(\, myDataSet, \); txtSex.DataBindings.Add(\, myDataSet, \); txtAdd.DataBindings.Add(\, myDataSet, \);
dataGrid1.DataSource = myDataSet; dataGrid1.DataMember = \;
} } }
程序运行：
5. 制作两个关系数据表的数据库应用程序。 程序设计：
.
.
数据库设计：
程序代码：
namespace relations {
public partial class Form1 : Form {
public Form1() {
InitializeComponent(); }
private void Form1_Load(object sender, EventArgs e) { //连接数据库
string connStr = \Source=ORDERSDB.mdb\;
string selectCmd1 = \订单编号, customers as 客户名称, order_date as 订购日期 From ORDERTITLE\;
string selectCmd2 = \订单编号, PRODUCT as 订购产品, price as 产品单价, qty as 订购数量 From ORDERDETAIL\;
OleDbConnection conn = new OleDbConnection(connStr); DataSet myDataSet=new DataSet(); conn.Open();
OleDbDataAdapter myAdapter1 = new OleDbDataAdapter(selectCmd1,conn); myAdapter1.Fill(myDataSet, \);
OleDbDataAdapter myAdapter2 = new OleDbDataAdapter(selectCmd2, conn); myAdapter2.Fill(myDataSet, \); //添加表联系
.
陕西师范大学可视化程序设计-C#实验报告
