陕西师范大学可视化程序设计C#实验报告文档格式.docx
《陕西师范大学可视化程序设计C#实验报告文档格式.docx》由会员分享,可在线阅读,更多相关《陕西师范大学可视化程序设计C#实验报告文档格式.docx(17页珍藏版)》请在冰豆网上搜索。
namespaceDataBase1
{
publicpartialclassForm1:
Form
{
publicForm1()
InitializeComponent();
}
privatevoidForm1_Load(objectsender,EventArgse)
//TODO:
这行代码将数据加载到表“bOOKDBDataSet2.BOOK”中。
您可以根据需要移动或删除它。
this.bOOKTableAdapter.Fill(this.bOOKDBDataSet2.BOOK);
privatevoidbutton1_Click(objectsender,EventArgse)
this.bOOKTableAdapter.Update(this.bOOKDBDataSet2.BOOK);
}
程序运行:
2.制作一个可插入、删除、修改PERSON数据表的员工工资系统。
usingSystem.Data.OleDb;
namespaceperson
//连接数据库
stringconnStr="
Provider=Microsoft.Jet.OLEDB.4.0;
DataSource=PERSONDB.mdb"
;
//显示数据库
publicvoidShowPerson()
OleDbConnectionmycon=newOleDbConnection(connStr);
mycon.Open();
stringselectCmd="
Selectid_noas编号,nameas姓名,id_positionas职称,telas电话,salaryas工资FromPERSONOrderByid_noDESC"
OleDbCommandcommand=newOleDbCommand(selectCmd,mycon);
OleDbDataAdaptermyAdapter=newOleDbDataAdapter();
myAdapter.SelectCommand=command;
DataSetmyDataSet=newDataSet();
myAdapter.Fill(myDataSet,"
PERSON"
);
dataGrid1.DataSource=myDataSet.Tables["
].DefaultView;
}
ShowPerson();
//增加
privatevoidbtnAdd_Click(objectsender,EventArgse)
stringinsertCmd;
OleDbConnectionmycon=newOleDbConnection(connStr);
insertCmd="
insertintoPERSON(name,id_position,tel,salary)values('
"
+txtName.Text+"
'
'
+txtPosition.Text+"
+txtTel.Text+"
+txtSalary.Text+"
)"
OleDbCommandmyCmd=newOleDbCommand(insertCmd,mycon);
myCmd.ExecuteNonQuery();
mycon.Close();
MessageBox.Show("
添加成功!
"
txtName.Text="
txtPosition.Text="
txtTel.Text="
txtSalary.Text="
//更改
privatevoidbtnChange_Click(objectsender,EventArgse)
stringchangeCmd;
changeCmd="
updatePERSONsetid_position='
+this.txtPosition.Text+"
tel='
+this.txtTel.Text+"
salary='
+this.txtSalary.Text+"
wherename='
+this.txtName.Text+"
OleDbCommandmyCmd=newOleDbCommand(changeCmd,mycon);
//删除
privatevoidbtnDel_Click(objectsender,EventArgse)
stringdelCmd="
DeleteFromPERSONWherename='
OleDbCommandmyCmd=newOleDbCommand(delCmd,mycon);
删除成功!
privatevoiddataGrid1_Navigate(objectsender,NavigateEventArgsne)
3.使用DataView对象对SCOREDB.mdb数据库的SCORE数据表作排序,过滤学生的成绩。
namespaceDataView1
Selectid_noas学号,nameas姓名,chias语文,engas英语,mathas数学FromSCORE"
privateDataViewCreateView(stringDBName,stringSQLcmd,stringTabName)
DataSource="
+DBName;
OleDbConnectionconn=newOleDbConnection(connStr);
conn.Open();
OleDbDataAdaptermyAdapter=newOleDbDataAdapter(SQLcmd,conn);
myAdapter.Fill(myDataSet,TabName);
returnmyDataSet.Tables[TabName].DefaultView;
dataGrid1.DataSource=CreateView("
SCOREDB.mdb"
selectCmd,"
SCORE"
privatevoidbtnOk_Click(objectsender,EventArgse)
stringsortStr="
if(rdbChina.Checked)
sortStr=rdbChina.Text;
elseif(rdbEnglish.Checked)
sortStr=rdbEnglish.Text;
elseif(rdbMath.Checked)
sortStr=rdbMath.Text;
elseif(rdbDesc.Checked)
sortStr="
DESC"
elseif(rdbIncrease.Checked)
sortStr="
ASC"
DataViewmyDataView=newDataView();
myDataView=CreateView("
myDataView.RowFilter=textBox1.Text;
myDataView.Sort=sortStr;
dataGrid1.DataSource=myDataView;
4.将MEMBER数据表的数据记录与TextBox、ComboBox、DataGrid控件做数据绑定。
namespaceDataBuinding1
Select*fromMEMBER"
DataSource=MEMBERDB.mdb"
OleDbConnectionconn=newOleDbConnection(connStr