02 Nov 2014 08:45

Joined:	07/10/2012
Level:	Silver
Points:	151

Points:	5

Gender storage in database

SqlConnection cnn = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=basoft;Integrated Security=True;Pooling=False");
SqlCommand cmd = new SqlCommand("insert into Registration values('" +
TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text +
"','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" +
DropDownList1.SelectedValue + "','" + DropDownList2.SelectedValue + "','" +
DropDownList3.SelectedValue + "','" + TextBox8.Text + "','" + DropDownList4.SelectedValue + "','" + RadioButton1.checked.ToString() + "')", cnn);
cnn.Open();

var n = cmd.ExecuteNonQuery();
cnn.Close();

if (n == 1)
Response.Write("<script>alert('Registration Success');</script>");
else
Response.Write("<script>alert('Registration Failed');</script>");
{

sir from these code i am able to store the gender true and false my coulumn gender datatype is varchar sir how can i able to store male and female or m & f in database/

#753334

02 Nov 2014 11:57

Joined:	08/07/2010
Level:	Gold
Points:	6482

Points:	2

assuming that RadioButton1 is displays the text male. please follow the below code

string gender = RadioButton1.Checked ? "Male" : "Female";

SqlConnection cnn = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=basoft;Integrated Security=True;Pooling=False");
SqlCommand cmd = new SqlCommand("insert into Registration values('" +
TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text +
"','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" +
DropDownList1.SelectedValue + "','" + DropDownList2.SelectedValue + "','" +
DropDownList3.SelectedValue + "','" + TextBox8.Text + "','" + DropDownList4.SelectedValue + "','" + gender + "')", cnn);
cnn.Open();

var n = cmd.ExecuteNonQuery();
cnn.Close();

Miss. Jain
Microsoft Certified Technology Specialist in .Net

#753354

02 Nov 2014 23:05

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	1

Hi,

Can you please post your gender binding part of design. You need to store the value of that particular database based on that field.

Hope this will helpful to you..

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#753386

03 Nov 2014 05:03

Joined:	28/06/2007
Level:	Diamond
Points:	56294

Points:	2

Instead of storing Radio Button value you can store male of Female as below.


string strGender = RadioButton1.Checked ? "Male" : "Female";

And Replace the value as 

,'" + strGender +"')",

Thanks & Regards
Anil Kumar Pandey
Microsoft MVP, DNS MVM

#753392

03 Nov 2014 05:48

Joined:	29/10/2014
Level:	Gold
Points:	1106

Points:	3

Hi sachin,

If u taken the gender field as Varchar then this process u can follow:

SqlCommand cmd = new SqlCommand("insert into Registration(code,names,m_name,desgnation,gender) values ('" + textBox1.Text + "',
'" + textBox2.Text + "',
'" + textBox3.Text + "',
'" + textBox4.Text + "',
'" + textBox5.Text + "',
'"+ radioButton1.Checked ? "Male" : "Female" +"' )");

Or

if u taken that value as bit then u can follow this way:

use this code before insert record into database:
Plz refer the below sample code,it may help u out
Boolean gender=false;
if( radioMale.IsChecked)
gender= true;
else
gender= false;

Then pass the gender variable into the Db.

#753410

03 Nov 2014 18:02

Joined:	30/04/2012
Level:	Gold
Points:	7233

Points:	1

You need to use condition operators in your RadioButton1 to check gender according to you database .

Gender storage in database

About dotnetspider.com

Quick Links

General

Services