使用C＃从SQL Server检索radioButton值

本文介绍了使用C＃从SQL Server检索radioButton值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

您好！ 我正在尝试从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); }