C#整周實(shí)習(xí)報(bào)告

1、精選優(yōu)質(zhì)文檔-傾情為你奉上精選優(yōu)質(zhì)文檔-傾情為你奉上專心-專注-專業(yè)專心-專注-專業(yè)精選優(yōu)質(zhì)文檔-傾情為你奉上專心-專注-專業(yè)C#實(shí)習(xí)報(bào)告班 級:10計(jì)算機(jī)應(yīng)用技術(shù)姓 名:學(xué) 號;專 業(yè)：計(jì)算機(jī)應(yīng)用指導(dǎo)教師：趙中營實(shí)習(xí)題目：制作一個(gè)簡單的通訊錄管理系統(tǒng)一、實(shí)習(xí)目的這學(xué)期通過對C#可視化程序的學(xué)習(xí)，掌握了解了可視化程序的簡單編寫和C#程序的應(yīng)用，C#是一種面向?qū)ο蟮某绦蚓庉?，通過這次實(shí)習(xí)讓我們在實(shí)踐中理解運(yùn)用C#編程，基礎(chǔ)上進(jìn)一步熟悉了visual studio2005，為以后的學(xué)習(xí)和工作打下了良好的基礎(chǔ)。同時(shí)也增強(qiáng)我們編程的能力。二、實(shí)習(xí)要求要完成這個(gè)題目首先要做好數(shù)據(jù)庫的設(shè)計(jì)要滿足要求，了解

2、Visual Studio 2005的基本使用方法，基本屬性以及使用VC2005編寫C#程序的基本規(guī)范；了解使用VC2005編寫、調(diào)試程序的基本步驟與方法，能夠通過調(diào)試發(fā)現(xiàn)并修改程序的一般錯(cuò)誤。三、功能模塊的結(jié)構(gòu)1、系統(tǒng)登錄模塊2、系統(tǒng)功能模塊3、通訊錄信息的查詢模塊4、通訊錄信息的修改模塊5、通訊錄信息的添加模塊6、通訊錄信息的刪除模塊四、實(shí)習(xí)成果程序設(shè)計(jì)1.系統(tǒng)登陸模塊程序代碼private void button1_Click(object sender, EventArgs e) if (textBox1.Text = ) MessageBox.Show(用戶名不能為空！); if (

3、textBox2.Text = ) MessageBox.Show(請輸入密碼！); OleDbConnection con = 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 學(xué)號; OleDbCommand cmd = new OleDbCommand(S

4、ql, con); OleDbDataReader myReader = cmd.ExecuteReader(); if (myReader.Read() Form2 frm = new Form2(); frm.ShowDialog(); else MessageBox.Show(你的密碼或用戶名出錯(cuò)！請重新輸入！); return; con.Close();2.系統(tǒng)功能模塊程序代碼public partial class Form2 : Form public Form2() InitializeComponent(); private void button1_Click(object

5、sender, EventArgs e) Form3 frm = new Form3(); frm.Show(); private 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) For

6、m6 frm = new Form6(); frm.Show(); 3.信息查詢模塊程序代碼public partial class 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 m

7、yAdapter; string Sql = Select * From 蔣英杰 where 姓名= + textBox1.Text.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,

8、EventArgs e) OleDbConnection con = new OleDbConnection(Provider=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 Data

9、Set(); myAdapter.Fill(myDataSet, 2); dataGridView1.DataSource = 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.Valu

10、e); textBox5.Text = Convert.ToString(dataGridView1.Rows0.Cells4.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_Cli

11、ck_1(object sender, EventArgs e) try OleDbConnection con = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=2.mdb); con.Open(); string Sql = update 蔣英杰 Set 學(xué)號 = + textBox2.Text + ,學(xué)號 = + textBox2.Text + ,性別 = + comboBox1.SelectedItem.ToString() + ,身份證號 = + textBox4.Text + ,手機(jī)號碼 = + t

12、extBox5.Text + ,家庭住址 = + textBox6.Text + ,QQ號 = + textBox7.Text + ,密碼 = + textBox8.Text + + Where 姓名 = + textBox1.Text.Trim() + ; OleDbCommand cmd = new OleDbCommand(Sql, con); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show(修改成功！, 提示); catch MessageBox.Show(修改失敗！請重新修改。, 提示); return; 5.信息添加模塊程序代

13、碼private void button1_Click_2(object sender, EventArgs e) try OleDbConnection con = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=2.mdb); con.Open(); string Sql = Insert Into 蔣英杰(姓名,學(xué)號,性別,手機(jī)號碼,QQ號,家庭住址,權(quán)限,密碼) Values( + textBox1.Text.Trim() + , + textBox2.Text.Trim() + , + comboBox

14、1.SelectedItem.ToString() + , + textBox4.Text.Trim() + , + textBox5.Text.Trim() + , + textBox6.Text.Trim() + , + textBox7.Text.Trim() + , + comboBox2.SelectedItem.ToString() + ); OleDbCommand cmd = new OleDbCommand(Sql, con); cmd.ExecuteNonQuery(); con.Close(); MessageBox.Show(添加信息成功！,提示); catch Mes

15、sageBox.Show(添加信息失??！,提示); private void button2_Click_1(object sender, 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) OleD

16、bConnection con = new OleDbConnection(Provider=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.

17、Fill(myDataSet, 2); dataGridView1.DataSource = myDataSet.Tables2; 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(刪除失??！,