ASP.NET RADIOBUTTON CONTROLS

Akhilesh Patel

Hi.......All.

        I'm new and working on a project and I'm want to insert radio buttons values into database through c#
here is the code of Unit.aspx page

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Unit.aspx.cs" Inherits="Unit" %>

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 Unit.aspx.cs source code...........

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)
    {

    }
}

Please help me ............thanks......

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akhilesh Patel14y ago
Actually I have a table called unit and in this table a column is bit type. And now I want to insert the value into db.
In the form design mode IsActivate contain yes or no.how i can do this......thanks
0

Satyapriya Nayak14y ago

Hi Akhilesh,

Try this...

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.WebForm1" %>

    Untitled Page

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(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

karthik v14y ago
Hi Akhilesh Patel

what is the problem you are facing?
0