資源簡介
這是數據庫課設時做的,用的時候可能需要改一下代碼中服務器的地址,管理員賬戶wayne 密碼hannah 進去后可以查看所有會員信息,會員登陸可以查看查找社團內人的信息和修改自己的信息,等等...

代碼片段和文件信息
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(“操作數據庫出錯!“);
????????????????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?=?““;
????????????????//循環獨處所有班級名,并添加進班級組合框
????????????????while?(datareader.Read())
????????????????{
????????????????????classname?=?(string)datareader[0];
????????????????????cboclass.Items.Add(classname);
????????????????}
????????????????datareader.Close();
????????????}
????????????catch?(Exception?ex)
????????????{
????????????????MessageBox.Show(“操作數據庫出錯!“);
????????????????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
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????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個文件信息
- 上一篇:Asp.net在線考試系統源碼
- 下一篇:ASP.NET 2.0 中的創建母版頁
評論
共有 條評論