radiobutton to store in database

Question

0.00/5 (No votes)

See more:

C#

C#4.0

i have doubt when clicking on radio button how the value is storing in the database.

Posted 5-Dec-12 20:04pm

karthikeyan9966

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Krunal Rohit · Answer 1 · 2012-12-05T20:12:00

Solution 1

First select the radiobutton and pass it as parameter in query..

C#

sting query = insert into emp(name, gender) values ("AAA", genderRadioBtn.SelectedItem.ToString());

Posted 5-Dec-12 20:12pm

Krunal Rohit

Deenuji · Answer 2 · 2012-12-05T20:18:00

example: my designing page like this

XML

<body>
    <form id="form1" runat="server">
    <div>

        <table align="center" class="style1">
            <tr>
                <td colspan="2">
                    <h3>
                        Sample Registraion</h3>
                </td>
            </tr>
            <tr>
                <td class="style3">
                    Name:</td>
                <td>
                    <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="style3">
                    Email</td>
                <td>
                    <asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td class="style3">
                    Gendere</td>
                <td>
                    <asp:RadioButtonList ID="rbtGender" runat="server" RepeatDirection="Horizontal">
                        <asp:ListItem>Male</asp:ListItem>
                        <asp:ListItem>Female</asp:ListItem>
                    </asp:RadioButtonList>
                </td>
            </tr>
            <tr>
                <td align="center" class="style2" colspan="2">
                    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Submit" />
&nbsp;&nbsp;
                </td>
            </tr>
            <tr>
                <td align="center" class="style2" colspan="2">
                    <asp:Label ID="lblmsg" runat="server"></asp:Label>
                </td>
            </tr>
        </table>

    </div>
    </form>
</body>

In this gender option i use radio button...

this gender value i wanna store in database....for that i use this coding for save this value in database...

i wrote this code in button control:

protected void Button1_Click(object sender, EventArgs e)
    {
        string cs = ConfigurationManager.ConnectionStrings["srinivasdb"].ConnectionString;
        SqlConnection cn = new SqlConnection(cs);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = cn;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "insert into GenderSample values(@Name,@Email,@Gender)";
        cmd.Parameters.Clear();
        cmd.Parameters.AddWithValue("@Name", txtName.Text);
        cmd.Parameters.AddWithValue("@Email", txtEmail.Text);
        cmd.Parameters.AddWithValue("@gender", rbtGender.SelectedValue);
        if (cn.State == ConnectionState.Closed)
            cn.Open();
        cmd.ExecuteNonQuery();
        cn.Close();
        lblmsg.Text = "Data entered successfully!!!";
    }

If u feel my answer is useful ur programming ..mark this... as accept solution...
thank u:) Happy coding:)

Surendra0x2 · Answer 3 · 2012-12-05T20:21:00

C#

protected void Button1_Click(object sender, ImageClickEventArgs e)
    {
string a="";
 if (RadioButton1.Checked == true)
            {
                a = RadioButton1.Text;
            }
            else if (RadioButton2.Checked == true)
            {
                a = RadioButton2.Text;
            }

SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=db;integrated security=true");
            SqlCommand sqlcomm = new SqlCommand("insert into reg(gender) values(@gender)", sqlconn);
sqlcomm.Parameters.Add("@gender", SqlDbType.VarChar, 50).Value = a.ToString();
sqlconn.Open();
            sqlcomm.ExecuteNonQuery();
sqlconn.close();
}

radiobutton to store in database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

radiobutton to store in database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us