protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = "";
try
{
DataSet ds = new DataSet();
SqlConnection myConnection = new SqlConnection("server=localhost;uid=sa;pwd=860712;database=Northwind");
string strSQL = "select distinct Title from Employees";
SqlDataAdapter myCommand = new SqlDataAdapter(strSQL, myConnection);
myCommand.Fill(ds, "Employees");
RadioButtonList1.DataSource = ds.Tables["Employees"].DefaultView;
RadioButtonList1.DataValueField = ds.Tables["Employees"].Columns[0].ColumnName;
RadioButtonList1.DataTextField = ds.Tables["Employees"].Columns[0].ColumnName;
RadioButtonList1.DataBind();
RadioButtonList1.RepeatDirection = System.Web.UI.WebControls.RepeatDirection.Horizontal;
RadioButtonList1.RepeatColumns = 2;
}
catch
{
Response.Write("<script language='javascript'>alert('连接失败!')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string ss = "性别:";
if (RadioButton1.Checked == true)
{
ss += RadioButton1.Text;
}
if (RadioButton2.Checked == true)
{
ss += RadioButton2.Text;
}
ss += ";职位:";
if (RadioButtonList1.SelectedIndex > -1)
{
ss += RadioButtonList1.SelectedItem.Text;
}
Label1.Text = ss;
}
不过运行以后有出错,就是可以选择职位,但是Label1不能显示“职位”后面的内容,不知道是什么原因,而且
运行以后,版面布局变得乱七八糟的。