陕西师范大学可视化程序设计-C#实验报告

.

数据库设计：

程序代码：

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, \); //添加表联系

.