如何通过程序在数据库中添加bit型数据！

[梦璐]

在SQL Server 2005数据库中管理员表（T_Admin)包含字段（AdminID,LoginName,RealName,Password,E_mail,Sex,Specialty,Address,Phone）Sex字段 是bit型，默认值都为1，代表男！
现在在Asp.net中做页面，目的是网数据库中添加数据！性别是通过选择来实现的（选择值为男，女）！我编写的添加代码如下
public partial class AdminAdd : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=PC-201109251726;AttachDbFilename='D:\\SQL Server 2005 安装\\MSSQL.1\\MSSQL\\Data\\Trading Site.mdf';Initial Catalog=Trading Site;Integrated Security=True");

string strcmd = "insert into T_Admin (LoginName,RealName,Password,E_mail,Sex,Specialty,Address,Phone) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + RadioButtonList1.SelectedValue.ToString() + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "')";
SqlCommand cmd = new SqlCommand(strcmd, con);
con.Open();

// int i = cmd.ExecuteNonQuery();
if (cmd .ExecuteNonQuery ()==1)
{
Response.Write("<script language=javascript>alert('添加成功');location='AdminAdd.aspx'</script>");

}
else
{
Response.Write("<script language=javascript>alert('添加失败');location='javascript:history.go(-1)'</script>");
}
con.Close();
Response.Redirect("~/AdminManage.aspx");
}

protected void Button2_Click(object sender, EventArgs e)
{
this.TextBox1.Text = "";
this.TextBox2.Text = "";
this.TextBox3.Text = "";
this.TextBox4.Text = "";
this.RadioButtonList1.SelectedValue = "";
this.TextBox6.Text = "";
this.TextBox7.Text = "";
this.TextBox8.Text = "";
}
}

运行时出现错误——在将 varchar 值 '男' 转换成数据类型 bit 时失败。
请高手指点如何修改代码，才能添加成功！！

[bdmh]

bit的用True和False

[lcaiyhh]

替换

string strcmd = "insert into T_Admin (LoginName,RealName,Password,E_mail,Sex,Specialty,Address,Phone) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + RadioButtonList1.SelectedValue.ToString() + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "')";

代码为

string SexN = RadioButtonList1.SelectedValue.ToString()=="男"?"1":"0";

string strcmd = "insert into T_Admin (LoginName,RealName,Password,E_mail,Sex,Specialty,Address,Phone) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + SexN  + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "')";

在以后读取数据时 1代表男0代表女，true代码男false代表女
楼主 请给分