How to fill sql value into datagridview with decrypts value

Question

I have problem with datagridview view CELLS i put my decrypt sql value into cell,value and load datagridview fill in form_load now when form loaded sql connection and other code is ok but just on row decrypted and other not please help me to decrypt other rows *

Rajanikant Hawaldar · Answer

void displaypersonal() { sdp.SelectCommand = command; sdp.SelectCommand.Connection = connection; sdp.SelectCommand.CommandText = "SELECT * FROM personnal" ; sdp.Fill(ds, "personnal" ); dgpersonal.DataSource = ds; dgpersonal.DataMember = "personnal" ; dgpersonal.Columns[0].HeaderText = "????? ??????" ; dgpersonal.Columns[0].Frozen = true ; dgpersonal.Columns[1].HeaderText = "???" ; dgpersonal.Columns[2].HeaderText = "??? ????????" ; dgpersonal.Columns[3].HeaderText = "??? ???" ; dgpersonal.Columns[4].HeaderText = "????? ????" ; . . . int rowIndex = 0; while (dr.Read()) { //dgpersonal is my datagridview var inputname = dr[ "name" ].ToString(); var passwordname = password; var resultname = AesCryptography.DecryptText(inputname, passwordname); dgpersonal.Rows[rowIndex].Cells[1].Value = resultname; var inputlname = dr[ "lname" ].ToString(); var passwordlname = password; var resultlname = AesCryptography.DecryptText(inputlname, passwordlname); dgpersonal.Rows[rowIndex].Cells[2].Value = resultlname; var inputdadname = dr[ "dadname" ].ToString(); var passworddadname = password; var resultdadname = AesCryptography.DecryptText(inputdadname, passworddadname); dgpersonal.Rows[rowIndex].Cells[3].Value = resultdadname; . . . rowIndex ++; } dr.Close(); } private void frmpersonal_Load( object sender, EventArgs e) { displaypersonal(); }

Srm Matin · Answer

Thank thank thank Workkkkkkkkkkkkkkkkkkk Very very thank

Rajanikant Hawaldar · Answer

Your casting to but there no value which can convert to int

Vinay Singh · Answer

To bind the decrypted value you need to first bind the data and then decrypt the bond recod on row data bound of grid view

Rajanikant Hawaldar · Answer

if (dr.Read()) should be => While (dr.Read()) because using if condition only one row is getting decrypted. tutorpinoy.blogspot.com/2014/04 this link I provided you to know how datagridview will bind row column wise

Jignesh Kumar · Answer

Hi Sam, If it is possible to decrypt values while querying sql then you can do it at SQL Level. Which technique you are using to encrypt and decrypt.

Srm Matin · Answer

Thank o lot , I will check

Rajanikant Hawaldar · Answer

Hey your binding only Current row again and again, should you bind like dgpersonal.Rows[i].Cells[0].Value http://tutorpinoy.blogspot.com/2014/04/populate-data-into-datagridview-csharp.html?m=1

Rajanikant Hawaldar · Answer

That's what I am telling you the movement datagridview binds in form load event automatically row added event will trigger so only i am suggesting to keep decrypting part at row added event otherwise call datagridview bind function then call decrypt function. Please post your form load code

Jignesh Kumar · Answer

Hi Martin, Please check this link which will help you, https://forums.asp.net/t/1661360.aspx?How+to+decrypt+one+Gridview+column+values+before+displaying+it+in+the+Gridview