QQ注册窗体代码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using MyQQ;
namespace qq
{
    public partial class RegisterFrm : Form
    {
        public RegisterFrm()
        {
            InitializeComponent();
        }
        //获得星座
        public void GetStarName()
        {
            SqlCommand cmd = new SqlCommand("SELECT STAR FROM STAR", DbHelper.conn);
            SqlDataReader reader = null;
            try
            {
                DbHelper.opendb();
                reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    this.cboStar.Items.Add(reader[0]);
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                DbHelper.closedb();
            }
        }
        //获的血型
        public void GetBloodName()
        {
            SqlCommand cmd = new SqlCommand("select BloodType from BloodType", DbHelper.conn);
            SqlDataReader reader = null;
            try
            {
                DbHelper.opendb();
                reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    this.cboBlood.Items.Add(reader[0]);
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                DbHelper.closedb();
            }
        }
        //保存头像ID
        int faceid;
        private void RegisterFrm_Load(object sender, EventArgs e)
        {
            this.cboStar.Items.Add("--请选择--");
            this.cboBlood.Items.Add("--请选择--");
            this.cboBlood.Text = "--请选择--";
            this.cboStar.Text = "--请选择--";
            GetStarName();
            GetBloodName();
            //靠随机数生成头像
            Random rd = new Random();
            faceid = rd.Next(0, 100);
        }
        //获得星座ID
        public int GetStarIdByName()
        {
            int starId = 0;
            string sql = string.Format("select id from star where Star = '{0}'",this.cboStar.Text);
            SqlCommand cmd=new SqlCommand (sql,DbHelper.conn);
            try
            {
                DbHelper.opendb();
                starId = Convert.ToInt32(cmd.ExecuteScalar());
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }