本文介绍了使用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); }
更多推荐
使用C#从SQL Server检索radioButton值
发布评论