Radio button control

Under Button Click

string gender=radiobutto1.SelectedItem.Text;



Sqlcommand cmd=new SqlCommand("insert into emp(gender)values('"+gender+"')",conStr);



cmd.ExecuteNonQuery();

BangaruBabu Pureti
http://bangarubabupureti.spaces.live.com/

Seger, if this helps please login to Mark As Answer. | Alert Moderator

thanks a lot for ur revert..

in which event is it on page load or button click

Seger, if this helps please login to Mark As Answer. | Alert Moderator

conn.Open();
cmd.Connection = conn;
cmd.CommandText = "insert into employeedetail values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "''"+s+"','" + TextBox10.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "')";
cmd.ExecuteNonQuery();
conn.Close();
Response.Write("<script>alert('record added')</script>");
Response.Redirect("Employee Official Detail.aspx");


I have all the fields in my database so i need to update the gender as male or female in my databse.here fourth column is gender i have represented as "s".

Seger, if this helps please login to Mark As Answer. | Alert Moderator

You should take event CheckedChanged of radioButton.
then get the Value/text whatever you want like this.
string sGenderText = RadioButton1.text.

Make a Query for Update :
string sQuery = Update TableName set columnname = Value where condition.

conn.Open();
cmd.Connection = conn;

cmd.ExecuteNonQuery();
conn.Close();

Paurush Sharma

Seger, if this helps please login to Mark As Answer. | Alert Moderator

Please check the IsPostback property before sending to the database using the Button click,

Or, it depends on your requirement when you want to save in database

Seger, if this helps please login to Mark As Answer. | Alert Moderator

thnkx.....i got it..

Seger, if this helps please login to Mark As Answer. | Alert Moderator