How to get value from SqlServer and populate it into its corrspond radio button

See more:

C#

WinForms

form

, +

In my table there is a column name 'Gender' and say its value is Male stored in that column. And now i want to retrieve the value of that column in the RadioButton. And based on the value of Gender Column automatically correspond radio button get selected.
Here is some code for your references

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCN"].ConnectionString))
                    {
        SqlCommand cmd = new SqlCommand("Select * from EmpRegister", con);
                        con.Open();
                        
                        SqlDataAdapter da = new SqlDataAdapter();
                        
                        DataTable dt = new DataTable();
                        da.SelectCommand = cmd;
                        da.Fill(dt);
                        if (dt != null && dt.Rows.Count > 0)
                        {
        
        
                            txtName.Text = dt.Rows[0]["EmpName"].ToString();
                            txtPassword.Text = dt.Rows[0]["Password"].ToString();
        
        string Gender = null;
                            if (radioButtonMale.Checked)
                            {
                                Gender = "Male";
                            }
                            else
                            {
                                Gender = "Female";
                            }
                            radioButtonMale.Checked = dt.Rows[0]["Gender"].ToString();  
        }

In last line i am getting error saying cannot implicitly convert string to bool.