How to insert radio button control value into dabase

Question

Hi..... I'm new and working on a project and want to inserting the radio button values into database. I did try many times but can't succeed. Please help me............. The designe page code os unit.aspx is here........ .style1 { height: 28px; } protected void radiobutton_checkedchange(object sender System.EventArgs e) { if (RB1.Checked == true) { Label1.Text = You select Yes; } else { Label1.Text = Please select Yes or No.; } if (RB2.Checked == true) { Label1.Text = You select No; } else { Label1.Text = Please select Yes or No.; } }     Stores & Inventory Management System   Unit Master Entry Unit's Name C Date C Client M Date M Client Is Activate oncheckedchanged=RB1_CheckedChanged AutoPostBack=True GroupName=x />      oncheckedchanged=RB2_CheckedChanged AutoPostBack=True GroupName=x/>        Demo Version 1.0 Copy Right All Right Reserved 2011 and the source code of unit.aspx.cs is ................ using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.IO; using System.Text; public partial class Unit : System.Web.UI.Page { protected void Page_Load(object sender EventArgs e) { } protected void B1_Click(object sender EventArgs e) { string conn = Data Source=SVPSL-PC; Initial Catalog=SUNBEAMSCHOOL; User Id=sa; Password=sa@1234;; SqlConnection con = new SqlConnection(conn); con.Open(); string str; if(RB1.Checked==true) { str = Convert.ToString(1); } else if(RB2.Checked==true) { str = Convert.ToString(0); } string qur = Insert into SS_Mst_Unit(UnitNameIsActiveCDateCUserMDateMUser) values(' + T1.Text + '' + T2.Text + '' + T3.Text + '' + T4.Text + '' + T5.Text + '); SqlCommand cmd = new SqlCommand(qur con); cmd.ExecuteNonQuery(); con.Close(); } private string BitConverter(string str) { throw new NotImplementedException(); } protected void B2_Click(object sender EventArgs e) { T1.Text = ; T2.Text = ; T3.Text = ; T4.Text = ; T5.Text = ; //T6.Text = ; RB1.Checked = false; RB2.Checked = false; } protected void RB1_CheckedChanged(object sender EventArgs e) { } protected void RB2_CheckedChanged(object sender EventArgs e) { } }

Satyapriya Nayak · Answer

Hi Akhilesh Try this.... Untitled Page .style1 { height: 28px; } .style2 { height: 28px; }     Stores & Inventory Management System   Unit Master Entry Unit's Name C Date C Client M Date M Client Is Activate GroupName=x />      GroupName=x/>        Demo Version 1.0 Copy Right All Right Reserved 2011 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 WebApplication1 { public partial class WebForm1 : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlCommand com; DataSet ds; string str; protected void B1_Click(object sender EventArgs e) { if (RB1.Checked == true) { SqlConnection con = new SqlConnection(connStr); con.Open(); str = Insert into SS_Mst_Unit(UnitNameIsActiveCDateCUserMDateMUser) values(' + T1.Text + '' + RB1.Text + '' + T2.Text + '' + T3.Text + '' + T4.Text + '' + T5.Text + '); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } else if(RB2.Checked==true) { SqlConnection con = new SqlConnection(connStr); con.Open(); str = Insert into SS_Mst_Unit(UnitNameIsActiveCDateCUserMDateMUser) values(' + T1.Text + '' + RB2.Text + '' + T2.Text + '' + T3.Text + '' + T4.Text + '' + T5.Text + '); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } } protected void B2_Click(object sender EventArgs e) { T1.Text = ; T2.Text = ; T3.Text = ; T4.Text = ; T5.Text = ; //T6.Text = ; RB1.Checked = false; RB2.Checked = false; } } } Thanks If this post helps you mark it as answer