C#整周实习报告

1、C#实习报告班 级:10计算机应用技术姓 名:学 号;专 业：计算机应用指导教师：赵中营实习题目：制作一个简单的通讯录管理系统一、实习目的这学期通过对C#可视化程序的学习，掌握了解了可视化程序的简单编写和C#程序的应用，C#是一种面向对象的程序编辑，通过这次实习让我们在实践中理解运用C#编程，基础上进一步熟悉了visual studio2005，为以后的学习和工作打下了良好的基础。同时也增强我们编程的能力。二、实习要求要完成这个题目首先要做好数据库的设计要满足要求，了解Visual Studio 2005的基本使用方法，基本属性以及使用VC2005编写C#程序的基本规范；了解使用VC2005编

2、写、调试程序的基本步骤与方法，能够通过调试发现并修改程序的一般错误。三、功能模块的结构1、系统登录模块2、系统功能模块3、通讯录信息的查询模块4、通讯录信息的修改模块5、通讯录信息的添加模块6、通讯录信息的删除模块四、实习成果程序设计1.系统登陆模块程序代码private void button1_Click(object sender, EventArgs e) if (textBox1.Text = ) MessageBox.Show(用户名不能为空！); if (textBox2.Text = ) MessageBox.Show(请输入密码！); OleDbConnection con

3、= new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=2.mdb); con.Open(); string Sql = SELECT * FROM 蒋英杰 WHERE 姓名 = + textBox1.Text.Trim() + and 密码= + textBox2.Text.Trim() + order by 学号; OleDbCommand cmd = new OleDbCommand(Sql, con); OleDbDataReader myReader = cmd.ExecuteReader(); if (m

4、yReader.Read() Form2 frm = new Form2(); frm.ShowDialog(); else MessageBox.Show(你的密码或用户名出错！请重新输入！); return; con.Close();2.系统功能模块程序代码public partial class Form2 : Form public Form2() InitializeComponent(); private void button1_Click(object sender, EventArgs e) Form3 frm = new Form3(); frm.Show(); priva

5、te void button2_Click(object sender, EventArgs e) Form4 frm = new Form4(); frm.Show(); private void button3_Click(object sender, EventArgs e) Form5 frm = new Form5(); frm.Show(); private void button4_Click(object sender, EventArgs e) Form6 frm = new Form6(); frm.Show(); 3.信息查询模块程序代码public partial cl

6、ass Form3 : Form public Form3() InitializeComponent(); private void button1_Click(object sender, EventArgs e) OleDbConnection con = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=2.mdb); ; con.Open(); OleDbDataAdapter myAdapter; string Sql = Select * From 蒋英杰 where 姓名= + textBox1.T

7、ext.Trim() + Order By 姓名; myAdapter = new OleDbDataAdapter(Sql, con); DataSet myDataSet = new DataSet(); myAdapter.Fill(myDataSet, 2); dataGridView1.DataSource = myDataSet.Tables2; 4.信息修改模块程序代码private void button2_Click_1(object sender, EventArgs e) OleDbConnection con = new OleDbConnection(Provider

8、=Microsoft.Jet.OLEDB.4.0;Data Source=2.mdb); con.Open(); OleDbDataAdapter myAdapter; string Sq1 = Select * From 蒋英杰 Where 姓名 = + textBox1.Text.Trim() + Order By 姓名; myAdapter = new OleDbDataAdapter(Sq1, con); DataSet myDataSet = new DataSet(); myAdapter.Fill(myDataSet, 2); dataGridView1.DataSource =

9、 myDataSet.Tables2; con.Close(); textBox2.Text = Convert.ToString(dataGridView1 .Rows 0.Cells 2.Value ); textBox3.Text = Convert.ToString(dataGridView1.Rows0.Cells1.Value); textBox4.Text = Convert.ToString(dataGridView1.Rows0.Cells8.Value); textBox5.Text = Convert.ToString(dataGridView1.Rows0.Cells4

10、.Value); textBox6.Text = Convert.ToString(dataGridView1.Rows0.Cells5.Value); textBox7.Text = Convert.ToString(dataGridView1.Rows0.Cells7.Value); textBox8.Text = Convert.ToString(dataGridView1.Rows0.Cells9.Value); private void button1_Click_1(object sender, EventArgs e) try OleDbConnection con = new

11、OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=2.mdb); con.Open(); string Sql = update 蒋英杰 Set 学号 = + textBox2.Text + ,学号 = + textBox2.Text + ,性别 = + comboBox1.SelectedItem.ToString() + ,身份证号 = + textBox4.Text + ,手机号码 = + textBox5.Text + ,家庭住址 = + textBox6.Text + ,QQ号 = + textBox7.Text

12、 + ,密码 = + textBox8.Text + + Where 姓名 = + textBox1.Text.Trim() + ; OleDbCommand cmd = new OleDbCommand(Sql, con); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show(修改成功！, 提示); catch MessageBox.Show(修改失败！请重新修改。, 提示); return; 5.信息添加模块程序代码private void button1_Click_2(object sender, EventArgs e) try O

13、leDbConnection con = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=2.mdb); con.Open(); string Sql = Insert Into 蒋英杰(姓名,学号,性别,手机号码,QQ号,家庭住址,权限,密码) Values( + textBox1.Text.Trim() + , + textBox2.Text.Trim() + , + comboBox1.SelectedItem.ToString() + , + textBox4.Text.Trim() + , + text

14、Box5.Text.Trim() + , + textBox6.Text.Trim() + , + textBox7.Text.Trim() + , + comboBox2.SelectedItem.ToString() + ); OleDbCommand cmd = new OleDbCommand(Sql, con); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show(添加信息成功！,提示); catch MessageBox.Show(添加信息失败！,提示); private void button2_Click_1(object s

15、ender, EventArgs e) textBox1.Text = ; textBox2.Text = ; comboBox1.Text = ; textBox4.Text = ; textBox5.Text = ; textBox6.Text = ; comboBox2.Text = ; textBox7.Text = ; 6.信息删除模块程序代码private void button1_Click(object sender, EventArgs e) OleDbConnection con = new OleDbConnection(Provider=Microsoft.Jet.OL

16、EDB.4.0;Data Source=2.mdb); con.Open(); OleDbDataAdapter myAdapter; string Sq1 = Select * From 蒋英杰 Where 姓名 = + textBox1.Text.Trim() + Order By 姓名; myAdapter = new OleDbDataAdapter(Sq1, con); DataSet myDataSet = new DataSet(); myAdapter.Fill(myDataSet, 2); dataGridView1.DataSource = myDataSet.Tables

17、2; con.Close(); private void button2_Click(object sender, EventArgs e) try OleDbConnection con = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=2.mdb); con.Open(); string Sql = Delete From 蒋英杰 Where 姓名 = + textBox1.Text.Replace(, ) + ; OleDbCommand cmd = new OleDbCommand(Sql, con); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show(删除成功！, 提示); catch MessageBox.Show(删除失败！, 提示