且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

复选框从SQL数据库值中选择值

更新时间:2023-02-08 17:00:37

使用以下代码:



Use the Following Code:

private void NavigateRecords()
  {
   dRow = _ds.Tables[0].Rows[Inc];
   tbUserId.Text = dRow.ItemArray.GetValue( 1 ).ToString();
   tbPrimeLoc.Text = dRow.ItemArray.GetValue( 2 ).ToString();
   tbUserName.Text = dRow.ItemArray.GetValue( 3 ).ToString();
   tbEmail.Text = dRow.ItemArray.GetValue( 4 ).ToString();
   tbDob.Text = dRow.ItemArray.GetValue( 5 ).ToString();
   tbEmpId.Text = dRow.ItemArray.GetValue( 6 ).ToString();
  //Need checkbox here... Read value from (7) if "M" then cboxMale = checked else if "F" then cboxFemale = checked
   string str="";
   str = dRow.ItemArray.GetValue(7).ToString();
   if (str == "M")
   {
	cboMale.Checked = true;
	cboFemale.Checked = false;	
   }
   else
   {
	cboMale.Checked = false;
	cboFemale.Checked = true;	
   }
  }