软件注册问题

Question

我现在要写个注册Form，Form的样子就是平时的注册表单，然后下面一个ListView控件，在填入注册信息后，点注册按钮后在ListView控件中显示刚刚注册的信息。
碰到如下问题：
UserStateId（数据库中是int型）是用户类型，分别是”活动“和”非活动“，我现在用的是radiobutton，用tag传输0和1，我原来想用string类型的，后来想想不对。Form代码：
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;namespace MySchool
{
    public partial class AddTeacherForm : Form
    {
        public AddTeacherForm()
        {
            InitializeComponent();
        }        private void btnAdd_Click(object sender, EventArgs e)
        {
            TeacherServer teas = new TeacherServer();
            List<TeacherInfo> ls = teas.GetAllTeaInfo(txtLoginId.Text, txtLoginPwd.Text, cboUSI.Text, txtTeaName.Text, txtSex.Text);
            foreach (TeacherInfo ti in ls)
            {
                ListViewItem lvi = new ListViewItem(ti.TeacherId);
                lvi.SubItems.AddRange(new string[] {ti.LoginId,ti.LoginPwd,ti.UserStateId1,ti.TeacherName,ti.Sex});
                this.lvteacher.Items.Add(lvi);
            }
        }
    }
}

Answer 1

TeacherInfo.csusing System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;namespace MySchool
{
    public class TeacherServer
    {
        public List<TeacherInfo> GetAllTeaInfo(string aloginid,string aloginpwd,string  aUSI,string ateacherName,string asex)
        {
            List<TeacherInfo> ls = new List<TeacherInfo>();
            SqlDataReader sdr = null;
            try
            {
                DBHelper.conn.Open();
                string sql = string.Format("insert into teacher (loginid,loginpwd,userstateid,teacherName,sex) values('{0}','{1}','{2}','{3}','{4}','{5}')",aloginid,aloginpwd,aUSI,ateacherName,asex);
                SqlCommand com = new SqlCommand(sql, DBHelper.conn);
                sdr = com.ExecuteReader();
                if (sdr.HasRows)
                {
                    while (sdr.Read())
                    {
                        TeacherInfo teaInfo = new TeacherInfo();
                        teaInfo.LoginId = sdr["loginId"].ToString();
                        teaInfo.LoginPwd = sdr["loginPwd"].ToString();
                        teaInfo.UserStateId1 = sdr["UserStateId"].ToString();
                        teaInfo.TeacherName = sdr["teacherName"].ToString();
                        teaInfo.Sex = sdr["sex"].ToString();
                        ls.Add(teaInfo);
                    }
                }            }
            catch (Exception)
            {            }
            finally
            {
                sdr.Close();
                DBHelper.conn.Close();
            }
            return ls;
        }
    }
}

Answer 2

TeacherInfo.csusing System;
using System.Collections.Generic;
using System.Text;namespace MySchool
{
    public class TeacherInfo
    {
        string teacherId;        public string TeacherId
        {
            get { return teacherId; }
            set { teacherId = value; }
        }
        string loginId;        public string LoginId
        {
            get { return loginId; }
            set { loginId = value; }
        }
        string loginPwd;        public string LoginPwd
        {
            get { return loginPwd; }
            set { loginPwd = value; }
        }
        string UserStateId;        public string UserStateId1
        {
            get { return UserStateId; }
            set { UserStateId = value; }
        }        
        string teacherName;        public string TeacherName
        {
            get { return teacherName; }
            set { teacherName = value; }
        }
        string sex;        public string Sex
        {
            get { return sex; }
            set { sex = value; }
        }
    }
}

Answer 3

只有0和1，数据库用bit就行了，

Answer 4

问题是上面给下来的数据库就是int....