gender in c#

Question

How to create Gender with 2 radiobtns i.e M/f and datetimepicker in winforms ..Plz Help

Raja T · Answer

Hello Ashok, alter the column data type DOB -datetime MAIL- varchar(20) GENDER- char(1),( radiobtn as Male &Female) Status - bit with (combobox 0,1) Changed To DOB -datetime MAIL- varchar(20) GENDER- varchar(10),( radiobtn as Male &Female) Status - bit with (combobox 0,1) And also please check combo box value 0,1 if not 0,1 change again status data type bit to char(10).

Rajeesh Menoth · Answer

Hi, Put a varchar or int for radio button value.If you are saving male or female selected value then use in like 1 is male 0 mean female,otherwise directly add the text.

Ashok Kumar · Answer

I got an Error while inserting values to DB string or binary data would be truncated. Statement has been terminated My datatypes are: DOB -datetime MAIL- varchar(20) GENDER- char(1),( radiobtn as Male &Female) Status - bit with (combobox 0,1) Is there any corrections regarding dis?..pls Help me

Rajeesh Menoth · Answer

Hi, Check the below reference. http://guidecoders.blogspot.in/2012/01/radio-button-example-male-and-female.html?m=1

Rajeesh Menoth · Answer

Hi, In your query only one gender column so why u use 2 radiobutton ? If you want to select male and female details in single radiobutton then use radiobuttonlist..inside the radiobutton add two list and add same group name

Ashok Kumar · Answer

i need datetimepicker for DOB ..how shouldwe declare private void dateTimePicker1_ValueChanged( object sender, EventArgs e) { } plz help..!

Raja T · Answer

Hello Ashok, Try like ASPX CODE: Codebehide .CS code string gender =""; if (RadioButton1.Checked) { gender = RadioButton1.Text; } if (RadioButton2.Checked) { gender = RadioButton2.Text; } now insert the gender like SqlDataAdapter SDA = new SqlDataAdapter("INSERT INTO Employee ( EmpId ,Name, DOB Country, Gender) VALUES ('" + textBox1.Text +"','" + textBox2.Text + "','" + dateTimePicker1.Text +'" + comboBox2.Text + "','+ gender +')", con);

Ashok Kumar · Answer

sorry can u explain clearly. SqlDataAdapter SDA = new SqlDataAdapter ( "INSERT INTO Employee ( EmpId ,Name, DOB Country, Gender) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "', '" + dateTimePicker1.Text + '" + comboBox2.Text + "','" + radioButton1.Text + "','" + radioButton2.Text + "')" , con); This is my code I declared a string gender; //in radiobtn1(click) gender="male"; // radiobtn2(click) gender="Female";

Rajeesh Menoth · Answer

Hi, put a same groupname in radio button.then you can select one radiobutton at a time.

gender in c#

Answers (9)