å
åå»æ³¨åæé®ç¶åè¿å°åå°ä»£ç åºï¼å
å¤æé空ç¶ååè·åç¨æ·åå°æ°æ®åºå»æ¥è¯¢æ¯å¦åå¨è¦æ¯åå¨å°±æ示已åå¨ä¸åå¨å°±æ§è¡æ·»å æ¹æ³ã//è¿ä¸ªæ¯éªè¯é空publicstringValidate(){if(this.txtUserName.Text.Trim()==""){return"ç¨æ·åä¸è½ä¸ºç©º";}elseif(this.txtPassWord.Text.Trim()==""){return"å¯ç ä¸è½ä¸ºç©º";}elseif(.){..çç¥äºèªå·±åã}else{return"";}}//è¿ä¸ªæ¯æé®çäºä»¶protectedvoidbtnRegister_Click(objectsender,EventArgse){if(Validate()==""){if(UserNameIsExist(this.txtUserName.Text.Trim())){stringsql="insertintoTable(UserName,Password,Address,Phone)values(@UserName,@Password,@Address,@Phone)";Listparas=newList();paras.Add(newSqlParameter("@UserName",this.txtUserName.Text.Trim()));paras.Add(newSqlParameter("@Password",this.txtPwd.Text.Trim()));paras.Add(newSqlParameter("@Address",this.txtAddress.Text.Trim()));paras.Add(newSqlParameter("@Phone",this.txtPhone.Text.Trim()));SqlConnectionconnection=newSqlConnection("server=ä½ çæ°æ®åºæå¡å¨å;database=ä½ çæ°æ®åºåå;uid=sa;pwd=ä½ çæ°æ®åºè¿æ¥å¯ç ");SqlCommandcmd=newSqlCommand(sql,connection);cmd.parameter.AddRange(paras.ToArray());connection.Open();if(Convert.ToInt32(cmd.ExecuteNonQuery())==1){MessageBox.Show("注åæå");}else{MessageBox.Show("注å失败");}}else{MessageBox.Show("ç¨æ·åå·²ç»åå¨ï¼");}}else{MessageBox.Show(Validate());}}pubicboolUserNameIsExist(stringName){stringsql="selectcount(*)fromTablewhereUserName="+Name;SqlConnectionconnection=newSqlConnection("server=ä½ çæ°æ®åºæå¡å¨å;database=ä½ çæ°æ®åºåå;uid=sa;pwd=ä½ çæ°æ®åºè¿æ¥å¯ç ");SqlCommandcmd=newSqlCommand(sql,connection);connection.Open();intCount=Convert.ToInt32(cmd.ExcuteScalar());connection.Close();returnCount>0?false:true;}ä¸è¬æ
åµéç½®çåè½å°±æ¯å°ææ¬æ¡æ¸
空ç并ä¸æ¯ä½ 说çå é¤çåè½ä½ è¦æ¯ççæ³åæé£æ ·ä¹æ¯å¯ä»¥çãå
·ä½çå°±æ¯ä»æ°æ®åºæ¥è¯¢ä½ ææ°æ·»å çä¸æ¡ä¿¡æ¯ç¶åå é¤å°±OKäºä»£ç æ¯ææçæ没æé误çæä¸æ¯å¾æ¸
æ¥ä½æ¯éé¢çæäºåæ°ä½ èªå·±å¾ççè·ä½ åçè¯å®æ¯ä¸ä¸æ ·çæä»¥ä½ å¾æ´æ¹ãè¿ä¸ªåºè¯¥æ¯æ详ç»çäºè¦æ¯ä¸ç»åé£æå°±ç½å¿æ´»äº..
温馨提示:内容为网友见解,仅供参考