使用C＃从SQL Server检索radioButton值 [英] retrieving radioButton value from SQL Server using C#

问题描述

您好！

我正在尝试从SQL Server Compact中检索数据库中的radioButton值

但我的代码不起作用..出了什么问题？

谢谢

Hello!
I'm trying to retrieve a radioButton value from database from SQL Server Compact
But my code doesn't work.. what is wrong?
thanks

if (con.State != ConnectionState.Open)
    con.Open();

Boolean genderval = false;
SqlCeCommand gendercmnd = new SqlCeCommand(@"SELECT Gender FROM Std_info WHERE Std_id='" + TextBox1.Text + "'", con);
genderval = Convert.ToBoolean(gendercmnd);
            if (genderval == true)
                Convert.ToBoolean(radioButton1.Checked);
            else
                Convert.ToBoolean(radioButton2.Checked);  
con.Close();   

推荐答案

如果您在genderval变量中获得True或False值，则直接将值分配给单选按钮，如下所示 -

If you are getting True or False value in genderval variable then assign value directly to the radio button like given below -

if(genderval==true)
{
radioButton1.Checked=genderval;
}

它解决了..！

It is solved..!

//........ retrieving radioButton value ....... 

if (conn.State != ConnectionState.Open) 
    conn.Open(); 
try { 
      Boolean genderval = SqlCeCommand gendercmnd = new SqlCeCommand(@"SELECT Gender FROM Std_Info     WHERE Std_id='" + TextBox1.Text + "'", con); 

genderval = (Boolean)gendercmnd.ExecuteScalar(); 
if (genderval == true) 
    Convert.ToBoolean(radioButton1.Checked=true); 
else 
    Convert.ToBoolean(radioButton2.Checked = true); 
conn.Close(); 
} 
catch (Exception ex)
       {
             MessageBox.Show(ex.Message);
       }

这篇关于使用C＃从SQL Server检索radioButton值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！