如何从SqlServer获取值并将其填充到corrspond单选按钮中 [英] How to get value from SqlServer and populate it into its corrspond radio button
问题描述
在我的表格中有一个列名为 Gender
,并说该值存储在该列中的 Male
。现在我想在RadioButton中检索该列的值。并根据Gender Column的值自动对应单选按钮被选中。
以下是您的参考文献的一些代码
使用(SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings [ DBCN]。ConnectionString))
{
SqlCommand cmd = new SqlCommand( 从EmpRegister中选择* ,con);
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = cmd;
da.Fill(dt);
if (dt!= null && dt.Rows.Count > 0 )
{
txtName.Text = dt.Rows [ 0 ] [ EmpName跨度>]的ToString();
txtPassword.Text = dt.Rows [ 0 ] [ 密码跨度>]的ToString();
string 性别= null ;
if (radioButtonMale.Checked)
{
Gender = 男性;
}
其他
{
性别= 女性;
}
radioButtonMale.Checked = dt.Rows [ 0 ] [ < span class =code-string> Gender]。ToString();
}
在最后一行我收到错误,说不能隐含地将字符串转换为bool。
< blockquote>。单击一个单选按钮是true还是false。所以,你不能把它的值设置为男性。
请改为:
radioButtonMale.Checked = dt.Rows [ 0 ] [ Gender]。ToString()。ToLower()== 男性跨度>;
我没有查看代码,但这些行没有意义if (radioButtonMale.Checked)
{
Gender = 男性;
}
其他
{
性别= 女性;
}
radioButtonMale.Checked = dt.Rows [ 0 ] [ < span class =code-string> Gender]。ToString();
您应该检查收到的值,而不是检查radioButtonMale.Checked
。如果是男性,请设置
radioButtonMale.Checked = true ;
只接受布尔值。
问候..
if (dt.Rows [ 0 ] [ 性别]。ToString()== 男)
{
radioButtonMale.Checked = true ;
}
else if (dt。行[ 0 ] [ 性别 ] .ToString()== 女性)
{
radioButtonFemale。 Checked = true ;
}
In my table there is a column name 'Gender
' and say its value is Male
stored in that column. And now i want to retrieve the value of that column in the RadioButton. And based on the value of Gender Column automatically correspond radio button get selected.
Here is some code for your references
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCN"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("Select * from EmpRegister", con);
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = cmd;
da.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
txtName.Text = dt.Rows[0]["EmpName"].ToString();
txtPassword.Text = dt.Rows[0]["Password"].ToString();
string Gender = null;
if (radioButtonMale.Checked)
{
Gender = "Male";
}
else
{
Gender = "Female";
}
radioButtonMale.Checked = dt.Rows[0]["Gender"].ToString();
}
In last line i am getting error saying cannot implicitly convert string to bool.
.Checked on a radio button is either true or false. So, you can't set it's value to "Male".
Do this instead:
radioButtonMale.Checked = dt.Rows[0]["Gender"].ToString().ToLower()=="male";
I have not gone through the code but these lines makes no senseif (radioButtonMale.Checked) { Gender = "Male"; } else { Gender = "Female"; } radioButtonMale.Checked = dt.Rows[0]["Gender"].ToString();
Instead of checkingradioButtonMale.Checked
, you should check for the received value. If its Male,set
radioButtonMale.Checked=true;
It only accepts boolean values.
Regards..
if (dt.Rows[0]["Gender"].ToString() == "Male") { radioButtonMale.Checked = true; } else if (dt.Rows[0]["Gender"].ToString() == "Female") { radioButtonFemale.Checked = true; }
这篇关于如何从SqlServer获取值并将其填充到corrspond单选按钮中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!