SharpDevelop 5.1 调试一个简单会员管理系统

下面使用SharpDevelop 5.1 调试一个简单会员管理系统，源码来自

http://www.softhy.net/soft/35411.htm

在SharpDevelop 5.1打开，运行该项目；

出现下图错误；

多个入口点；注释了Login.cs中的一个测试类，该类包含一个Main（）函数；

再运行，出现下图错误；

网上查找bclient，不知为何物；注释掉相关语句；

再运行，出现下图错误；

修改目标CPU为32位Intel兼容，如下图；

跑起来后，需要登录；

用MDB查看工具打开数据库可看到表的内容；MDB查看工具在

http://blog.csdn.net/bcbobo21cn/article/details/51000041

运行起来，仅有个人信息查看和修改功能；

下面看下其主要代码；

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.OleDb; //Download by http://www.codefans.net namespace 会员管理系统_桌面级_ {public partial class Edit : Form{public Edit( )//接UserName数据{InitializeComponent( );lblUserName.Text = Login.loginedUserName;}private void Edit_Load(object sender, EventArgs e){// TODO: 这行代码将数据加载到表“memberDataSet1.Users”中。您可以根据需要移动或移除它。this.usersTableAdapter.Fill(this.memberDataSet1.Users);// TODO: 这行代码将数据加载到表“memberDataSet1.Users”中。您可以根据需要移动或移除它。this.usersTableAdapter.Fill(this.memberDataSet1.Users);// TODO: 这行代码将数据加载到表“memberDataSet1.Users”中。您可以根据需要移动或移除它。this.usersTableAdapter.Fill(this.memberDataSet1.Users);ShowUserInfo( );}private void ShowUserInfo( ){string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\..\\..\\member.mdb";//最新方法，能把数据库放在项目文件夹目录中读取//和网页版会员管理系统差不多，代码也是先粘贴过来再修改的OleDbConnection conn = new OleDbConnection(strConn);string sql = "SELECT * FROM Users WHERE UserName='" + lblUserName.Text + "'";OleDbCommand cmd = new OleDbCommand(sql, conn);conn.Open( );OleDbDataReader reader = cmd.ExecuteReader( );reader.Read( );txtRealName.Text = reader["RealName"].ToString( );string ValueSex = reader["Sex"].ToString( );//性别显示，要加判断if ( ValueSex == "女" ){rbSexWoman.Checked = true;}else{rbSexMan.Checked = true;}cboQuestion.Text = reader["Question"].ToString();//cboQuestion无法正常显示//cboQuestion.SelectedValue = reader["Question"].ToString( );//cboQuestion.DisplayMember = reader["Question"].ToString( );//cboQuestion.ValueMember = reader["Question"].ToString( );txtAnswer.Text = reader["Answer"].ToString( );txtEmail.Text = reader["Email"].ToString( );reader.Close( );conn.Close( );}private void btnSumbit_Click(object sender, EventArgs e){string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +Application.StartupPath + "\\..\\..\\member.mdb";OleDbConnection conn = new OleDbConnection(strConn);string name, realName, sex, question, answer, email;//, address;name = lblUserName.Text;realName = txtRealName.Text.Trim( );if ( rbSexWoman.Checked == true )//性别输入用了个变通的方法，不规范的，有机会要学会用正确的{sex = "女";}elsesex = "男";question = cboQuestion.SelectedItem.ToString( );answer = txtAnswer.Text.Trim( );email = txtEmail.Text.Trim( );//address = txtAddress.Text.Trim( );string sql = @"UPDATE Users SET RealName=?, Sex=?," +"Question=?, Answer=?, Email=? WHERE UserName='" + name + "'";OleDbCommand cmd = new OleDbCommand(sql, conn);cmd.Parameters.Add(new OleDbParameter("@RealName", OleDbType.WChar));cmd.Parameters.Add(new OleDbParameter("@Sex", OleDbType.WChar));cmd.Parameters.Add(new OleDbParameter("@Question", OleDbType.WChar));cmd.Parameters.Add(new OleDbParameter("@Answer", OleDbType.WChar));cmd.Parameters.Add(new OleDbParameter("@Email", OleDbType.WChar));//cmd.Parameters.Add(new OleDbParameter("@Address", OleDbType.WChar));cmd.Parameters["@RealName"].Value = realName;cmd.Parameters["@Sex"].Value = sex;cmd.Parameters["@Question"].Value = question;cmd.Parameters["@Answer"].Value = answer;cmd.Parameters["@Email"].Value = email;//cmd.Parameters["@Address"].Value = address;conn.Open( );cmd.ExecuteNonQuery( );conn.Close( );Main mymain = new Main( );mymain.Show( );this.Close( );}private void btnReset_Click(object sender, EventArgs e){this.txtRealName.ResetText( );this.txtAnswer.ResetText( );this.txtEmail.ResetText( );//this.cboQuestion.SelectedIndex = 1; //1为你所要选中的默认值的序号，一般从0开始 程序对该代码没反应}private void fillByToolStripButton_Click(object sender, EventArgs e){///try{this.usersTableAdapter.FillBy(this.memberDataSet1.Users);}///catch ( System.Exception ex ){System.Windows.Forms.MessageBox.Show(ex.Message);}}private void txtRealName_Validating(object sender, CancelEventArgs e){if (txtRealName.Text.Length == 0)errRealName.SetError(txtRealName, "用户名不能为空！");elseerrRealName.Clear( );}private void gbxSex_Validating(object sender, CancelEventArgs e){}private void cboQuestion_Validating(object sender, CancelEventArgs e){if (cboQuestion.SelectedItem == null)errQuestion.SetError(cboQuestion, "请选择密码提示问题！");elseerrQuestion.Clear( );}private void txtAnswer_Validating(object sender, CancelEventArgs e){if (txtAnswer.Text.Length == 0)errAnswer.SetError(txtAnswer, "请输入密码查询答案！");elseerrAnswer.Clear( );}private void txtEmail_Validating(object sender, CancelEventArgs e){if (txtEmail.Text.Length == 0)errEmail.SetError(txtEmail, "请输入电子邮件地址！");elseerrEmail.Clear( );}} }

使用了OLEDB的方式访问Access；数据提供者是Microsoft.Jet.OLEDB.4.0;
数据库在程序的启动路径；
用OleDbDataReader读取到数据以后显示；


更新数据时使用了OleDbCommand对象的参数属性，先添加参数，然后设置参数的值；然后用OleDbCommand对象的ExecuteNonQuery方法执行SQL语句；

总结

以上是生活随笔为你收集整理的SharpDevelop 5.1 调试一个简单会员管理系统的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。