-
大小: 861KB文件類型: .rar金幣: 2下載: 1 次發(fā)布日期: 2021-07-26
- 語言: C#
- 標(biāo)簽: 數(shù)據(jù)庫??課設(shè)??c#??源碼??
資源簡介
這是數(shù)據(jù)庫課設(shè)時(shí)做的,用的時(shí)候可能需要改一下代碼中服務(wù)器的地址,管理員賬戶wayne 密碼hannah 進(jìn)去后可以查看所有會員信息,會員登陸可以查看查找社團(tuán)內(nèi)人的信息和修改自己的信息,等等...

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?MySchool
{
????public?partial?class?AddStudentForm?:?Form
????{
????????public?AddStudentForm()
????????{
????????????InitializeComponent();
????????}
????????private?void?button2_Click(object?sender?EventArgs?e)
????????{
????????????this.Close();
????????}
????????private?string?Getbumen()
????????{
????????????string?bumen?=?““;
????????????string?sql?=?string.Format(“SELECT?部門?FROM?bumen?WHERE?部門=‘{0}‘“cbobumen.Text);
????????????try?
????????????{
????????????????SqlCommand?command?=?new?SqlCommand(sql?DBHelper.connection);
????????????????DBHelper.connection.Open();
????????????????SqlDataReader?daraReader?=?command.ExecuteReader();
????????????????if?(daraReader.Read())
????????????????{
????????????????????bumen?=?(string)daraReader[0];
????????????????}
????????????????daraReader.Close();
????????????}
????????????catch(Exception?ex)
????????????{
????????????????MessageBox.Show(“操作數(shù)據(jù)庫出錯(cuò)!“);
????????????????Console.WriteLine(ex.Message);
????????????}
????????????finally
????????????{
????????????????DBHelper.connection.Close();
????????????}
????????????return?bumen;
????????}
??????/*??private?void?AddStudentForm_Load(object?sender?EventArgs?e)
????????{
????????????try
????????????{
????????????????//查詢班級的sql語句
????????????????string?sql?=?“SELECT?班級?FROM?student“;
????????????????//定義command對象
????????????????SqlCommand?Command?=?new?SqlCommand(sql?DBHelper.connection);
????????????????DBHelper.connection.Open();
????????????????SqlDataReader?datareader?=?Command.ExecuteReader();
????????????????string?classname?=?““;
????????????????//循環(huán)獨(dú)處所有班級名,并添加進(jìn)班級組合框
????????????????while?(datareader.Read())
????????????????{
????????????????????classname?=?(string)datareader[0];
????????????????????cboclass.Items.Add(classname);
????????????????}
????????????????datareader.Close();
????????????}
????????????catch?(Exception?ex)
????????????{
????????????????MessageBox.Show(“操作數(shù)據(jù)庫出錯(cuò)!“);
????????????????Console.WriteLine(ex.Message);
????????????}
????????????finally
????????????{
????????????????DBHelper.connection.Close();
????????????}
????????}*/
????????private?void?btnsave_Click(object?sender?EventArgs?e)
????????{
????????????string?loginId?=?txtLoginId.Text;
????????????string?loginPwd?=?txtLoginPwd.Text;
????????????string?loginPwd2?=?txtLoginPwd2.Text;
????????????if?(loginPwd?!=?loginPwd2)
????????????{
????????????????MessageBox.Show(“您兩次輸入的密碼不一致,請重新輸入“?“輸入提示“?MessageBoxButtons.OK?MessageBoxIcon.Warning);
????????????????txtLoginPwd.Focus();
????????????}
????????????else
????????????{
????????????????//?string?userStateId?=?rdoactive.Checked???(string)rdoactive.Tag?:?(string)rdoInActive.Tag;
????????????????string?name?=?txtSt
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件???????5612??2011-12-23?15:57??MySchool\MySchool\Properties\Resources.resx
?????文件????????249??2011-12-23?15:57??MySchool\MySchool\Properties\Settings.settings
?????文件???????1164??2011-12-23?15:57??MySchool\MySchool\Properties\AssemblyInfo.cs
?????文件???????2838??2012-03-05?20:07??MySchool\MySchool\Properties\Resources.Designer.cs
?????文件???????1104??2012-03-05?20:07??MySchool\MySchool\Properties\Settings.Designer.cs
?????文件??????17233??2011-11-29?13:47??MySchool\MySchool\AddStudentForm.Designer.cs
?????文件???????5430??2011-11-30?14:07??MySchool\MySchool\16-32.ico
?????文件???????8267??2011-11-30?14:08??MySchool\MySchool\MySchool.csproj
?????文件???????5632??2005-11-11?22:25??MySchool\MySchool\bin\Debug\MySchool.vshost.exe
?????文件???????1689??2012-03-05?20:08??MySchool\MySchool\bin\Debug\MySchool.vshost.application
?????文件???????2654??2012-03-05?20:08??MySchool\MySchool\bin\Debug\MySchool.vshost.exe.manifest
?????文件???????2806??2011-12-28?17:57??MySchool\MySchool\bin\Debug\pagerror.gif
?????文件??????20284??2011-12-28?18:01??MySchool\MySchool\bin\Debug\back.gif
?????文件??????30638??2012-03-05?20:08??MySchool\MySchool\bin\Debug\back.png
?????文件???????2654??2012-03-05?20:08??MySchool\MySchool\bin\Debug\MySchool.exe.manifest
?????文件???????1689??2012-03-05?20:08??MySchool\MySchool\bin\Debug\MySchool.application
?????文件??????69632??2012-03-05?20:08??MySchool\MySchool\bin\Debug\MySchool.exe
?????文件?????114176??2012-03-05?20:08??MySchool\MySchool\bin\Debug\MySchool.pdb
?????文件??????36724??2011-11-30?11:40??MySchool\MySchool\bin\Debug\Forever.png
?????文件???????6394??2011-11-30?14:08??MySchool\MySchool\bin\Debug\MySchool.publish\MySchool_1_0_1_5\MySchool.exe.manifest
?????文件??????69632??2011-11-30?14:08??MySchool\MySchool\bin\Debug\MySchool.publish\MySchool_1_0_1_5\MySchool.exe.deploy
?????文件???????5430??2011-11-30?14:07??MySchool\MySchool\bin\Debug\MySchool.publish\MySchool_1_0_1_5\16-32.ico.deploy
?????文件?????423936??2011-11-30?14:08??MySchool\MySchool\bin\Debug\MySchool.publish\setup.exe
?????文件???????5482??2011-11-30?14:08??MySchool\MySchool\bin\Debug\MySchool.publish\MySchool.application
?????文件???????8540??2011-11-30?14:08??MySchool\MySchool\bin\Debug\MySchool.publish\publish.htm
?????文件???????5632??2005-11-11?22:25??MySchool\MySchool\bin\Release\MySchool.vshost.exe
?????文件???????1689??2011-11-29?15:44??MySchool\MySchool\bin\Release\MySchool.vshost.application
?????文件???????2198??2011-11-29?15:44??MySchool\MySchool\bin\Release\MySchool.vshost.exe.manifest
?????文件??????30638??2011-11-29?15:44??MySchool\MySchool\bin\Release\back.png
?????文件???????2198??2011-11-29?15:44??MySchool\MySchool\bin\Release\MySchool.exe.manifest
............此處省略104個(gè)文件信息
評論
共有 條評論