Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to develop Winform to achieve student management system in C#". In daily operation, I believe that many people have doubts about how to develop Winform to achieve student management system in C#. The editor has consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to develop Winform to realize student management system in C#". Next, please follow the editor to study!

First, the realization of the case function

Data:

-- create table ProfessionInfo (ProfessionID int primary key identity),-- Specialty No. ProfessionName varchar (50) not null unique-- Specialty name)-- Student create table StudentInfo (StuID varchar (20) primary key,-- Student ID StuName varchar (50) not null,-- Student name StuAge int not null check (StuAge > 0 and StuAge < 130) -- Student age StuSex char (2) not null check (StuSex in ('male', 'female')),-- Student gender StuHobby nvarchar (100),-- hobby ProfessionID int not null references ProfessionInfo (ProfessionID) -- Professional number)-- add professional information insert into ProfessionInfo (professionName) values ('e-sports') insert into ProfessionInfo (professionName) values ('software development') insert into ProfessionInfo (professionName) values ('medical care')-insert student information insert into StudentInfo (StuID,StuName,StuAge,StuSex,StuHobby,ProfessionID) values 'Guan Yu', 2050 'male',', 2) insert into StudentInfo (StuID,StuName,StuAge,StuSex,StuHobby,ProfessionID) values ('003Jing' Zhang Fei', 19PM''male','2) insert into StudentInfo (StuID,StuName,StuAge,StuSex,StuHobby,ProfessionID) values ('004Jing' Sun Shangxiang', 17th'', 3)

Business requirements:

(1) the professional drop-down box binds the professional table data, the grid control binds the student data, and clicks the "search" button to combine the query with multiple conditions.

(2) Select a row, right-click to pop up the "Delete" menu, click the "Delete" menu to delete student data.

(3) Click the "add" button, pop up the new form, and complete the new operation of the students in this form.

(4) Select a row, click the "Edit" button, pop up the editing form, and complete the modification of the data in this form.

Note: the gender check box and the hobby multi-box are contained in two Pannel containers respectively.

Implementation code:

(1) query form binding professional information, binding student information and search function code:

# region binds professional information to the drop-down box private void BindProfession () {DataTable dt = new DataTable (); DBHelper.PrepareSql ("select * from ProfessionInfo"); dt = DBHelper.ExecQuery (); DataRow dr = dt.NewRow (); dr ["ProfessionID"] = 0; dr ["professionName"] = "--Please select--; dt.Rows.InsertAt (dr, 0); this.cmbPro.DataSource = dt; this.cmbPro.DisplayMember =" professionName " This.cmbPro.ValueMember = "ProfessionID";} # endregion#region bind student data private void BindData () {string sql = "select * from StudentInfo inner join ProfessionInfo on StudentInfo.ProfessionID=ProfessionInfo.ProfessionID where 1 = 1"; if (! this.cmbPro.SelectedValue.ToString (). Equals ("0")) sql + = "and StudentInfo.ProfessionID=" + this.cmbPro.SelectedValue.ToString () If (! this.txtName.Text.Equals (")) sql + =" and StuName like'% "+ this.txtName.Text +"% "; this.dataGridView1.AutoGenerateColumns = false; DBHelper.PrepareSql (sql); this.dataGridView1.DataSource = DBHelper.ExecQuery ();} # endregionprivate void Form1_Load (object sender, EventArgs e) {BindProfession (); BindData ();} private void btSearch_Click (object sender, EventArgs e) {BindData ();}

(2) delete the menu code:

Private void delete ToolStripMenuItem_Click (object sender, EventArgs e) {/ / add a dialog box DialogResult result = MessageBox.Show ("are you sure you want to delete data? it cannot be recovered after deletion!" , "prompt box", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result = = DialogResult.Cancel) return; string stuid = this.dataGridView1.SelectedRows [0] .cells [0] .Value.ToString (); string sql = "delete from StudentInfo where StuID = @ StuID"; DBHelper.PrepareSql (sql); DBHelper.SetParameter ("StuID", stuid); int rowCount = DBHelper.ExecNonQuery () If (rowCount = = 1) MessageBox.Show ("deletion succeeded!"); else MessageBox.Show ("deletion failed!"); BindData ();}

(3) add the code of student information form:

# region binds professional information to the drop-down box private void BindProfession () {DataTable dt = new DataTable (); DBHelper.PrepareSql ("select * from ProfessionInfo"); dt = DBHelper.ExecQuery (); DataRow dr = dt.NewRow (); dr ["ProfessionID"] = 0; dr ["professionName"] = "--Please select--; dt.Rows.InsertAt (dr, 0); this.cmbPro.DataSource = dt; this.cmbPro.DisplayMember =" professionName " This.cmbPro.ValueMember = "ProfessionID";} # endregionprivate void FrmAdd_Load (object sender, EventArgs e) {BindProfession ();} private void btAdd_Click (object sender, EventArgs e) {string sql = "insert into StudentInfo (StuID,StuName,StuAge,StuSex,StuHobby,ProfessionID) values (@ StuID,@StuName,@StuAge,@StuSex,@StuHobby,@ProfessionID)"; DBHelper.PrepareSql (sql); DBHelper.SetParameter ("StuID", this.txtId.Text) DBHelper.SetParameter ("StuName", this.txtName.Text); DBHelper.SetParameter ("StuAge", this.txtAge.Text); / / gender processing string sex = ""; if (this.rbBoy.Checked = = true) sex = this.rbBoy.Text; if (this.rbGirl.Checked = = true) sex = this.rbGirl.Text; DBHelper.SetParameter ("StuSex", sex); / / hobby string hobby = "" Foreach (CheckBox ck in this.panel2.Controls) {if (ck.Checked = = true) {if (! hobby.Equals (")) hobby + =", "; hobby + = ck.Text;}} DBHelper.SetParameter (" StuHobby ", hobby); DBHelper.SetParameter (" ProfessionID ", this.cmbPro.SelectedValue.ToString ()); int rowCount = DBHelper.ExecNonQuery () If (rowCount = = 1) {MessageBox.Show ("New success!"); this.Close ();} else {MessageBox.Show ("New failed!");}}

(4) Edit the code of the student information form:

Public string StuID {get; set;} / / Student ID # region binds professional information to drop-down box private void BindProfession () {DataTable dt = new DataTable (); DBHelper.PrepareSql ("select * from ProfessionInfo"); dt = DBHelper.ExecQuery (); DataRow dr = dt.NewRow (); dr ["ProfessionID"] = 0; dr ["professionName"] = "--Please select--; dt.Rows.InsertAt (dr, 0) This.cmbPro.DataSource = dt; this.cmbPro.DisplayMember = "professionName"; this.cmbPro.ValueMember = "ProfessionID";} # endregionprivate void BindDetail () {string sql = "select * from StudentInfo where StuID =" + this.StuID; DBHelper.PrepareSql (sql); DataTable dt = new DataTable (); dt = DBHelper.ExecQuery (); this.txtId.Text = dt.Rows [0] ["StuID"] .ToString () This.txtName.Text = dt.Rows [0] ["StuName"] .ToString (); this.txtAge.Text = dt.Rows [0] ["StuAge"] .ToString (); this.cmbPro.SelectedValue = dt.Rows [0] ["ProfessionID"] .ToString (); / / gender processing if (dt.Rows [0] ["StuSex"] .ToString (). Equals ("male") this.rbBoy.Checked = true Else this.rbGirl.Checked = true; / / like to deal with string [] arrHobby = dt.Rows [0] ["StuHobby"] .ToString () .Split (','); foreach (string hobby in arrHobby) {foreach (CheckBox ck in this.panel2.Controls) {if (ck.Text.Equals (hobby)) ck.Checked = true } private void FrmEdit_Load (object sender, EventArgs e) {BindProfession (); BindDetail ();} private void btUpdate_Click (object sender, EventArgs e) {string sql = "update StudentInfo set StuName=@StuName,StuAge=@StuAge,StuSex=@StuSex,StuHobby=@StuHobby,ProfessionID=@ProfessionID where StuID=@StuID"; DBHelper.PrepareSql (sql); DBHelper.SetParameter ("StuName", this.txtName.Text); DBHelper.SetParameter ("StuAge", this.txtAge.Text) / / gender processing string sex = ""; if (this.rbBoy.Checked = = true) sex = this.rbBoy.Text; if (this.rbGirl.Checked = = true) sex = this.rbGirl.Text; DBHelper.SetParameter ("StuSex", sex); / / hobby string hobby = "" Foreach (CheckBox ck in this.panel2.Controls) {if (ck.Checked = = true) {if (! hobby.Equals (")) hobby + =", "; hobby + = ck.Text;}} DBHelper.SetParameter (" StuHobby ", hobby); DBHelper.SetParameter (" ProfessionID ", this.cmbPro.SelectedValue.ToString ()) DBHelper.SetParameter ("StuID", this.StuID); int rowCount = DBHelper.ExecNonQuery (); if (rowCount = = 1) {MessageBox.Show ("modified successfully!"); this.Close ();} else {MessageBox.Show ("modify failed!");}}

(5) query the "add" and "Edit" button codes in the form:

Private void btAdd_Click (object sender, EventArgs e) {FrmAdd frm = new FrmAdd (); / / frm.Owner = this; frm.Show ();} private void btEdit_Click (object sender, EventArgs e) {string stuid = this.dataGridView1.SelectedRows [0] .cells [0] .Value.ToString (); FrmEdit frm = new FrmEdit (); frm.StuID = stuid; frm.Show (); second, add: connection string configuration

Write the database connection string directly in the C # code. If the connection string needs to be changed, it must be modified in the C # code and recompiled, which brings trouble to the implementation of the software.

To resolve this problem, you can store the database connection string in the configuration file.

(1) find the App.config file in the project. If you don't have this file, you can add an application configuration file, and add the following configuration inside the configuration node of this configuration file:

(2) add the reference "System.Configuration" to the project, and modify the assignment of the connection string in C# as follows:

Public static string connStr = ConfigurationManager.ConnectionStrings ["DefaultConn"] .ConnectionString; at this point, the study on "how to develop Winform to implement student management system in C #" is over. I hope to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.