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
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(UnitName,IsActive,CDate,CUser,MDate,MUser) 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
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(UnitName,IsActive,CDate,CUser,MDate,MUser) 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(UnitName,IsActive,CDate,CUser,MDate,MUser) 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

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