註冊按鈕事件：
private void btnRegister_Click(object sender, EventArgs e)
{
string username = txtUserName.Text;
string userpwd = txtUserPwd.Text;
string tel = txtTel.Text;
string email = txtEmail.Text;
string name = txtName.Text;
int dept = Convert.ToInt32(txtDept.Text);
if (string.IsNullOrEmpty(username) && string.IsNullOrEmpty(userpwd))
{
MessageBox.Show(“使用者名稱和密碼不能為空！”,”提示”,MessageBoxButtons.OK,MessageBoxIcon.Information);
return;
}
string sql = “INSERT INTO [UserInfo]([username],[userpwd],[name],[deptId],[tel],[email],[state],[registerTime],[lastLoginTime],[remark])” +
“VALUES(@username,@userpwd,@name,@deptId,@tel,@email,@state,GETDATE(),GETDATE(),`null`)”;
SqlParameter[] param =
{
new SqlParameter(“@username”,SqlDbType.VarChar),
new SqlParameter(“@userpwd”,SqlDbType.VarChar),
new SqlParameter(“@name”,SqlDbType.VarChar),
new SqlParameter(“@deptId”,SqlDbType.Int),
new SqlParameter(“@tel”,SqlDbType.VarChar),
new SqlParameter(“@email”,SqlDbType.VarChar),
new SqlParameter(“@state”,SqlDbType.VarChar)
};
param[0].Value = username;
param[1].Value = userpwd;
param[2].Value = name;
param[3].Value = dept;
param[4].Value = tel;
param[5].Value = email;
param[6].Value = “”;
int count = DataManager.Set(sql, param);
if (count > 0)
{
DialogResult dr = MessageBox.Show(“註冊成功，是否登入？”, “提示”, MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
FrmLogin login = new FrmLogin();
login.Show();
this.Hide();
}
else
{
this.Show();
}
}
else
{
MessageBox.Show(“註冊失敗！”,”提示”,MessageBoxButtons.AbortRetryIgnore,MessageBoxIcon.Hand);
}
}
呼叫底層的方法：
DataManager類：
public static int Set(string sql, SqlParameter[] pars)
{
return new DataService().Set(sql, pars);
}
DataService類：
public int Set(string sql, SqlParameter[] pars)
{
Init(sql, pars, SysControl.ConnectionString);
return Set();
}
private int Set()
{
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return i;
}
SysControl類：
/// <summary>
/// 資料庫連線字串
/// </summary>
public static string ConnectionString = ConfigurationManager.AppSettings[“connectionString”];
在app配置檔案裡面新增連結：
<appSettings>
<add key =”connectionString” value=”server=.;user id=sa; password=123456; database=db;”/>
</appSettings>