Store Radio Button values in database

Question

can u please tell me the command for storing user input values in database for radio button ?

Satyapriya Nayak · Answer

Hi dhanya, Try this... Untitled Page Registraion Name: Email Gender onclick="btn_register_Click" /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Radio_button_values { public partial class WebForm1 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; protected void btn_register_Click(object sender, EventArgs e) { if (rb1.Checked == true) { SqlConnection con = new SqlConnection(strConnString); com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = "insert into login values(@Name,@Email,@Gender)"; com.Parameters.Clear(); com.Parameters.AddWithValue("@Name", txtName.Text); com.Parameters.AddWithValue("@Email", txtEmail.Text); com.Parameters.AddWithValue("@gender", rb1.Text); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = "Data entered successfully!!!"; clear(); } else { SqlConnection con = new SqlConnection(strConnString); com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = "insert into login values(@Name,@Email,@Gender)"; com.Parameters.Clear(); com.Parameters.AddWithValue("@Name", txtName.Text); com.Parameters.AddWithValue("@Email", txtEmail.Text); com.Parameters.AddWithValue("@gender", rb2.Text); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = "Data entered successfully!!!"; clear(); } } void clear() { txtName.Text = ""; txtEmail.Text = ""; rb1.Checked = false; rb2.Checked = false; } } } Thanks If this post helps you mark it as answer

Satyapriya Nayak · Answer

If this post helps you mark it as answer Thanks

dhanya rai · Answer

my question was if we put RadioButton instead of RadioButtonList then how can we store user input in database??? for eg. if we put RadioButton ID="RadioButton1" runat="server" GroupName="Gender" Text="Male" />    Text="Female" /> instead of RadioButtonList ID="rbtGender" runat="server" RepeatDirection="Horizontal"> Male Female @suthish nair if i cud..i would not post question here

Sam Hobbs · Answer

Your question is actually two or more questions. One question is how to get the status of a group of RadioButtons; in other words, the index of which one (if any) is selected. Another question is how to store that value into a table. As Suthish suggests, just try to do it, then ask specific questions about whatever part you do not understand.

Suthish Nair · Answer

come on.. try at your end also... :)

dhanya rai · Answer

thnxx....but not radiobutton list ...i wanted command for " radio button"

Satyapriya Nayak · Answer

Hi dhanya, Try this... Untitled Page Registraion Name: Email Gender Male Female onclick="btn_register_Click" /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Radio_button_values { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; protected void btn_register_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); com = new SqlCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = "insert into login values(@Name,@Email,@Gender)"; com.Parameters.Clear(); com.Parameters.AddWithValue("@Name", txtName.Text); com.Parameters.AddWithValue("@Email", txtEmail.Text); com.Parameters.AddWithValue("@gender", rbtGender.SelectedValue); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = "Data entered successfully!!!"; } } } Thanks If this post helps you mark it as answer