资源描述:
《数据库注册界面代码》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、namespacedataQQ1{publicpartialclassRegisterForm:Form{publicRegisterForm(){InitializeComponent();}privatevoidbtnCancel_Click(objectsender,EventArgse){Close();}stringsql;privatevoidbtnRegister_Click(objectsender,EventArgse){InFo();//连¢?接¨®字Á?符¤?串ä?strings
2、tr=@"DataSource=WCH-20140516NND;initialcatalog=MyQQ;trusted_connection=true;";if(tbxRealName.Text==""&&combStar.SelectedIndex<0&&combBoolType.SelectedIndex<0)//000{sql=string.Format("insertintousers(loginpwd,NickName,Age,sex)values('{0}','{1}',{2},'{3}'
3、);select@@identity",tbxPwd.Text,tbxNickName.Text,tbxAge.Text,rdbMale.Checked?"男D":"女?");}if(tbxRealName.Text==""&&combStar.SelectedIndex<0&&combBoolType.SelectedIndex>=0)//001{sql=string.Format("insertintousers(loginpwd,NickName,Age,sex,bloodtypeid)valu
4、es('{0}','{1}',{2},'{3}',{4});select@@identity",tbxPwd.Text,tbxNickName.Text,tbxAge.Text,rdbMale.Checked?"男D":"女?",combBoolType.SelectedIndex);}if(tbxRealName.Text==""&&combStar.SelectedIndex>=0&&combBoolType.SelectedIndex<0)//010{sql=string.Format("ins
5、ertintousers(loginpwd,NickName,Age,sex,starid)values('{0}','{1}',{2},'{3}',{4});select@@identity",tbxPwd.Text,tbxNickName.Text,tbxAge.Text,rdbMale.Checked?"男D":"女?",combStar.SelectedIndex);}if(tbxRealName.Text!=""&&combStar.SelectedIndex<0&&combBoolType
6、.SelectedIndex<0)//100{sql=string.Format("insertintousers(loginpwd,NickName,Age,sex,[name])values('{0}','{1}',{2},'{3}','{4}');select@@identity",tbxPwd.Text,tbxNickName.Text,tbxAge.Text,rdbMale.Checked?"男D":"女?",tbxRealName.Text);}if(tbxRealName.Text!="
7、"&&combStar.SelectedIndex>=0&&combBoolType.SelectedIndex>=0)//111{sql=string.Format("insertintousers(loginpwd,NickName,Age,sex,[name],starid,bloodtypeid)values('{0}','{1}',{2},'{3}','{4}',{5},{6});select@@identity",tbxPwd.Text,tbxNickName.Text,tbxAge.Te
8、xt,rdbMale.Checked?"男D":"女?",tbxRealName.Text,combStar.SelectedIndex,combBoolType.SelectedIndex);}if(tbxRealName.Text!=""&&combStar.SelectedIndex>=0&&combBoolType.SelectedIndex<0)//110{sql=string.Format("insertintousers(loginpwd,