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 01) Changed To DOB -datetime MAIL- varchar(20) GENDER- varchar(10)( radiobtn as Male &Female) Status - bit with (combobox 01) And also please check combo box value 01 if not 01 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 femaleotherwise 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 01) 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.