how to insert RadioButton into sql server uwp c#

Question

how to insert RadioButton into sql server uwp ? having two options. <RadioButton x:Uid="RBVaron" x:Name="radiovaron" GroupName="Gener"/>

Answer 1

how can I get with this code that there are three radiobutton. as I can get with this code that there are three radiobutton. Having these RbBajo, RBMedio, Rbalto

cmd.Parameters.Add("@risk", SqlDbType.VarChar, 40). Value = (bool)rRBbajo.IsChecked
? RBBajo.Content : RbMedio.Content;`

Answer 2

As I can another Radiobutton code:

cmd.Parameters.Add("@Risk ", SqlDbType.VarChar, 40). Value = (bool)rRBbajo.IsChecked
? RBBajo.Content : RbMedio.Content;`

Answer 3

I have a problem with the RadioButton in Sql Server.

Answer 4

 RadioButton rb = RadioButtonPanel.Children.OfType<RadioButton>().FirstOrDefault(r => r.IsChecked == true);
            RadioButton rb1 = RadioButtonPanel1.Children.OfType<RadioButton>().FirstOrDefault(r => r.IsChecked == true);

            const  string  SqlString = "insert into PetItem(DuoDate,PetName,PetRace, PetColor, PetChip,PetGender,PetSterile) values (@duoDate,@petName,@petRace,@petColor,@PetChip,@petGender,@petSterile)";
            try
            {


                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    if (conn.State == System.Data.ConnectionState.Open)
                    {
                        using (SqlCommand cmd = conn.CreateCommand())
                        {

                            cmd.CommandText = SqlString;
                            cmd.Parameters.Clear();
                            cmd.Parameters.Add("@duoDate", SqlDbType.Date).Value = DateNac;
                            cmd.Parameters.Add("@petName", SqlDbType.Char, 40).Value = txtName.Text;
                            cmd.Parameters.Add("@petRace", SqlDbType.Char, 40).Value = txtRace.Text;
                            cmd.Parameters.Add("@petColor", SqlDbType.Char, 40).Value = txtColor.Text;
                            cmd.Parameters.Add("@petChip", SqlDbType.VarChar, 40).Value = txtChip.Text;
                            cmd.ExecuteNonQuery();


                        }
                    }
                }
            }

            catch(Exception ex)
            {
                //mesagedialog
            }
        }

Answer 5

using (SqlConnection conn = new SqlConnection())
            {

                using (SqlCommand cmd = new SqlCommand(SqlString, conn))
                    {
                    cmd.CommandType = CommandType.Text; 
                        cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("@DuoDate", txtName.Text );
                    cmd.Parameters.AddWithValue("@PetName",  txtName.Text);
                    cmd.Parameters.AddWithValue("@PetRace",  txtRace.Text );
                    cmd.Parameters.AddWithValue("@PetColor", txtColor.Text);
                    cmd.Parameters.AddWithValue("PetChip", txtCchip.Text);

                    if(radioMale.IsChecked == true)
                    {
                        cmd.Parameters.AddWithValue("@PetSex", "RBVaron");
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@PetSex", "RBHembra");
                    }

                        if(radioyessterile.IsChecked == true)
                    {
                        cmd.Parameters.AddWithValue("@PetSterile","RBsteriles" );
                    }
                    else
                    {
                        cmd.Parameters.AddWithValue("@PetSterile", "RBsteriles");
                    }




                    conn.Open();
                        cmd.ExecuteNonQuery();


                    }