如何从radiobutton中的数据库中获取数据 [英] How to fetch data from database in a radiobutton

问题描述

如何通过单选按钮从数据库中获取数据，例如我已婚并且未婚两个单选按钮......



代码;

 SqlConnection conn =  new  SqlConnection（ConfigurationManager.ConnectionStrings [  HousingConnectionString]。ConnectionString）; 
 SqlCommand com =  new  SqlCommand（ 选择First_Name，Middle_Name，Last_Name，Mobile_No，Email_DOB，Age，Education，Office_Add，Native_Add，PAN_Card，Aadhar_Card，Religion，Business_Job，Married_Unmarried，No_Of_Members from Primary_Member Where Flat =' + Request.QueryString [  fnum] +  '，conn）; 
 conn.Open（）; 
 SqlDataReader dr = com.ExecuteReader（）; 
  if （dr.Read（））
 {
 TextBoxFN.Text = dr [  First_Name]。ToString（）; 
 TextBoxMN.Text = dr [  Middle_Name]。ToString（）; 
 TextBoxLN.Text = dr [  Last_Name]。ToString（）; 
 TextBoxMO.Text = dr [  Mobile_No]。ToString（）; 
 TextBoxE.Text = dr [  Email]。ToString（）; 
 TextBoxDOB.Text = dr [  DOB]。ToString（）; 
 TextBoxA.Text = dr [ 年龄]。ToString（）; 
 TextBoxEQ.Text = dr [  Education]。ToString（）; 
 TextBoxOA.Text = dr [  Office_Add]。ToString（）; 
 TextBoxNA.Text = dr [  Native_Add]。ToString（）; 
 TextBoxPCN.Text = dr [  PAN_Card]。ToString（）; 
 TextBoxACN.Text = dr [  Aadhar_Card]。ToString（）; 
 TextBoxR.Text = dr [  Religion]。ToString（）; 
 TextBoxNOM.Text = dr [  No_Of_Members]。ToString（）; 
 
 dr.Close（）; 
 conn.Close（）; 
} 

解决方案

一旦你拥有了数据表，你就可以这样的事情，

 rdbMarried.SelectedIndex = Convert.ToInt32（rdbMarried.Items.IndexOf（rdbMarried.Items.FindByText（dt.Rows [0] [Married]的ToString（））））; 
 //因为你没有共享你的代码，我用我的假设做了
 // dt是一个数据表
 //结婚是一个列名

-KR

假设您的数据在数据表中并根据条件我们可以选择如下的单选按钮。

  string  strGender = dt.Rows [ 0 ] [ 性别]。ToString（）; 
  if （strGender ==  男 ）
 rbdGender.SelectedIndex =  0 ; 
  else  
 rbdGender.SelectedIndex =  1 ; 

How to fetch data from database in a radio button,for example i have married and unmarried two radio buttons....

Code;

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["HousingConnectionString"].ConnectionString);
 SqlCommand com = new SqlCommand("Select First_Name , Middle_Name , Last_Name , Mobile_No , Email, DOB , Age , Education , Office_Add , Native_Add , PAN_Card , Aadhar_Card , Religion , Business_Job , Married_Unmarried , No_Of_Members from Primary_Member where Flat = '" + Request.QueryString["fnum"] + "'", conn);
 conn.Open();
 SqlDataReader dr = com.ExecuteReader();
 if (dr.Read())
 {
 TextBoxFN.Text = dr["First_Name"].ToString();
 TextBoxMN.Text = dr["Middle_Name"].ToString();
 TextBoxLN.Text = dr["Last_Name"].ToString();
 TextBoxMO.Text = dr["Mobile_No"].ToString();
 TextBoxE.Text = dr["Email"].ToString();
 TextBoxDOB.Text = dr["DOB"].ToString();
 TextBoxA.Text = dr["Age"].ToString();
 TextBoxEQ.Text = dr["Education"].ToString();
 TextBoxOA.Text = dr["Office_Add"].ToString();
 TextBoxNA.Text = dr["Native_Add"].ToString();
 TextBoxPCN.Text = dr["PAN_Card"].ToString();
 TextBoxACN.Text = dr["Aadhar_Card"].ToString();
 TextBoxR.Text = dr["Religion"].ToString();
 TextBoxNOM.Text = dr["No_Of_Members"].ToString();

 dr.Close();
 conn.Close();
 }

解决方案

Once you have the datatable, you can go something like this,

rdbMarried.SelectedIndex = Convert.ToInt32(rdbMarried.Items.IndexOf(rdbMarried.Items.FindByText(dt.Rows[0]["Married"].ToString())));
// as you haven't shared your code, I did it with my assumption
// dt is a datatable
// Married is a column name

-KR

Assume that your data in datatable and based on condition we can select the radio button like below.

string strGender=dt.Rows[0]["Gender"].ToString();
if(strGender=="Male")
   rbdGender.SelectedIndex=0;
else
   rbdGender.SelectedIndex=1;

这篇关于如何从radiobutton中的数据库中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！