how to insert values in sql server through radio button

Question

I previously use this code for insert operation but along with this I want to save the radiobutton values:

cmd.CommandText="INSERT INTO Table1 (username,password,gender VALUES(@username,@password,gender)";
cmd.Parameters.AddWithValue("@username", textBox1.Text);
cmd.Parameters.AddWithValue("@password", textBox2.Text);

I have two radio buttons for male and female, I want to save only one value in the database so I have used groupbox for selecting only one radio button but how to insert into database as male or female.

I am working on windows form.

tucaz · Accepted Answer · 2012-12-18 18:48:38Z

4

How about:


cmd.CommandText="INSERT INTO Table1 (username,password,gender) VALUES (@username,@password,@gender)";
cmd.Parameters.AddWithValue("@username", textBox1.Text);
cmd.Parameters.AddWithValue("@password", textBox2.Text);

if(radioMale.Checked)
    cmd.Parameters.AddWithValue("@gender", "Male");
else
    cmd.Parameters.AddWithValue("@gender", "Female");

answered Dec 18, 2012 at 18:48

tucaz

6,6946 gold badges41 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

shariq_khan Over a year ago

thank you sir, that was very easy, why i didint thought i dont know, i thot it would be a complex step, can you tell me can i save bool values in the sql server? what is the data type for that?

Trevor Pilley Over a year ago

@shariq_khan you can indeed, the data type is bit.

shariq_khan Over a year ago

stackoverflow.com/questions/14162839/… CAN YOU HELP ME BHAI PLEASE

Trevor Pilley · Accepted Answer · 2012-12-18 18:56:10Z

1

Another option is to use a combo box with 2 values in it, one for male and one for female and just insert the selected value. This would also take up less space on the form which may or may not be useful.

cmd.Parameters.AddWithValue("@gender", genderCombo.SelectedValue);

answered Dec 18, 2012 at 18:56

Trevor Pilley

16.5k6 gold badges47 silver badges61 bronze badges

1 Comment

shariq_khan Over a year ago

stackoverflow.com/questions/14162839/… CAN YOU HELP ME PLEASE

user3053791 · Accepted Answer · 2013-12-01 05:47:14Z

 private string selectedValue, date;
        private int i;
        private SqlCommand xcmd;
        private SqlConnection xcon;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                day_DropDownList.Items.Insert(0, new ListItem("DD", "DD"));
                month_DropDownList.Items.Insert(0, new ListItem("MM", "MM"));
                year_DropDownList.Items.Insert(0, new ListItem("YY", "YY"));
                for (i = 1; i < 32; i++)
                {
                    day_DropDownList.Items.Add(i.ToString());
                }
                for (i = 1; i < 13; i++)
                {
                    month_DropDownList.Items.Add(i.ToString());
                }
                for (i = 1950; i < 2014; i++)
                {
                    year_DropDownList.Items.Add(i.ToString());
                }
                employeeName_Txt.Focus();
            }


        }



        protected void submit_Button_Click(object sender, EventArgs e)
        {
            selectedValue = gender_RadioButtonList.SelectedValue;

            xcon = new SqlConnection("Data Source=.; DataBase=AptechDB; UID=sa; Password=123;");

            xcon.Open();
            date = day_DropDownList.Text.ToString() + "/" + month_DropDownList.Text.ToString() + "/" + year_DropDownList.Text.ToString();
            xcmd = new SqlCommand("insert into tblEmployee values('" + employeeName_Txt.Text + "','" + date + "','" + selectedValue + "','" + post_Txt.Text + "','" + city_Txt.Text + "','" + country_Txt.Text + "','" + mobileno_Txt.Text + "')", xcon);
            xcmd.ExecuteNonQuery();
            Label1.Text = "Information submitted successfully";
            xcon.Close();
            clear();
        }

        public void clear()
        {
            employeeName_Txt.Text = "";
            day_DropDownList.SelectedIndex = 0;
            month_DropDownList.SelectedIndex = 0;
            year_DropDownList.SelectedIndex = 0;
            post_Txt.Text = "";
            city_Txt.Text = "";
            country_Txt.Text = "";
            mobileno_Txt.Text = "";
        }

    }
}

Andrey Korneyev · Accepted Answer · 2014-09-23 07:42:39Z

0

Try this one

cmd.CommandText="INSERT INTO Table1 (username,password,gender) VALUES (@username,@password,@gender)";
cmd.Parameters.AddWithValue("@username", textBox1.Text);
cmd.Parameters.AddWithValue("@password", textBox2.Text);

if(radioMale.Checked)
    cmd.Parameters.AddWithValue("@gender", "Male");
else
    cmd.Parameters.AddWithValue("@gender", "Female");

edited Sep 23, 2014 at 7:42

Andrey Korneyev

26.9k16 gold badges73 silver badges72 bronze badges

answered Oct 30, 2013 at 12:26

user2936317

Comments

Anil · Accepted Answer · 2015-11-24 07:43:21Z

-1

        SqlCommand cmd = new SqlCommand("insert into table1 (Name,Mail,Phone,Addres,Gender) values (@Name,@Mail,@Phone,@Addres,@Gender)", con);
        cmd.Parameters.AddWithValue("@Name", textBox1.Text);
        cmd.Parameters.AddWithValue("@Mail", textBox2.Text);
        cmd.Parameters.AddWithValue("@Phone", textBox3.Text);
        cmd.Parameters.AddWithValue("@Addres", textBox4.Text);
        if (radioButton1.Checked==true)
            cmd.Parameters.AddWithValue("@gender", "Male");
        else
            cmd.Parameters.AddWithValue("@gender", "Female");

edited Nov 24, 2015 at 7:43

answered Nov 24, 2015 at 6:50

Anil

11 bronze badge

1 Comment

APC Over a year ago

How does this code improve on any of the previously posted answers?

Collectives™ on Stack Overflow

how to insert values in sql server through radio button

5 Answers 5

3 Comments

1 Comment

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related