Which data type is used to store password in database ??

Question

Hello, I created a form using some fields including password....so plz tell me which data type should i use to store password....also if i set textmode of the textbox to password, them blank textbox displays on the form..how should i get the password in dots or asterisk?

Rafnas T P · Answer

no one will retrive password from database, this is a secured one,user has to enter that, thats why when you made textmode to password its not displaying, if you change this mode to text then it will show but it wont show as dots, I do not know why are you retriving password and showing to textbox, which is wrong

Kapil Singh Kumawat · Answer

you can use nvarchar datatype to store the passwords.

Rafnas T P · Answer

hi, you can use nvarchar(50) datatype for saving password

suvakeenruban thomas · Answer

change the textbox mode to password use nvarchar(specified size) in sql

Krutika Karekar · Answer

Yes sir...this is right

Krutika Karekar · Answer

Yes sir...its giving dots..bt when i retrieve the data from database, it displays blank textbox...if i won't set textmode, it displays normal text

Rafnas T P · Answer

you can use javascript, try below link https://stackoverflow.com/questions/17540953/how-to-set-passwordchar-property-to-asp-net-textbox

Rafnas T P · Answer

in web form, you can use as you said textmode to password, that is default dot will come, here you can not give any other character

Krutika Karekar · Answer

Yes sir its web form

Rafnas T P · Answer

i think you are using asp.net, web form check that

Krutika Karekar · Answer

I do not know sir...bt its not there...and my namespace is System.Web.UI.WebControls

Rafnas T P · Answer

or you can just double click on the form now you can see form load event, inside that you can write as below textBox1.PasswordChar = '*'; instead of textBox1 you can give your textbox name

Nitin Sontakke · Answer

Thats not much likely if it is really a Windows Forms Application. This property is there, if i remember it rightly, ever since the first version of Visual Studio.

Krutika Karekar · Answer

Sir...I did not get property like PasswordChar....

Nitin Sontakke · Answer

If this is still not resolved, click on the text-box on the Windows Form, the press F4, which should open properties window. Locate PasswordChar property and type your preferred char (*, ., etc.) there. While you are there, I suggest you also set MaxLength property to an appropriate value.

Rafnas T P · Answer

if you are using sql then you can use nvarchar(50) as I have said before or you can use any string datatype

Rafnas T P · Answer

then select text box, in prperties you ca see PasswordChar their you can give any character that you wanted to display

Krutika Karekar · Answer

It is windows form

Rafnas T P · Answer

which application are you working, is this windows form or wpf

Krutika Karekar · Answer

Can you plz explain it sir..? means where to set it..?

Rafnas T P · Answer

to display password in dots or asterik, you can set PasswordChar to dots or asterik

Which data type is used to store password in database ??

Answers (21)