How to fill sql value into datagridview with decrypts value

Srm Matin

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 *

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
Accepted answer
1. void displaypersonal()
2. {
3. sdp.SelectCommand = command;
4. sdp.SelectCommand.Connection = connection;
5. sdp.SelectCommand.CommandText = "SELECT * FROM personnal";
6. sdp.Fill(ds, "personnal");
7. dgpersonal.DataSource = ds;
8. dgpersonal.DataMember = "personnal";
9. dgpersonal.Columns[0].HeaderText = "????? ??????";
10. dgpersonal.Columns[0].Frozen = true;
11. dgpersonal.Columns[1].HeaderText = "???";
12. dgpersonal.Columns[2].HeaderText = "??? ????????";
13. dgpersonal.Columns[3].HeaderText = "??? ???";
14. dgpersonal.Columns[4].HeaderText = "????? ????";
15. .
16. .
17. .
18. int rowIndex = 0;
19. while (dr.Read())
20. {
21. //dgpersonal is my datagridview
22. var inputname = dr["name"].ToString();
23. var passwordname = password;
24. var resultname = AesCryptography.DecryptText(inputname,
25. passwordname);
26. dgpersonal.Rows[rowIndex].Cells[1].Value = resultname;
28. var inputlname = dr["lname"].ToString();
29. var passwordlname = password;
30. var resultlname = AesCryptography.DecryptText(inputlname,
31. passwordlname);
32. dgpersonal.Rows[rowIndex].Cells[2].Value = resultlname;
34. var inputdadname = dr["dadname"].ToString();
35. var passworddadname = password;
36. var resultdadname = AesCryptography.DecryptText(inputdadname,
37. passworddadname);
38. dgpersonal.Rows[rowIndex].Cells[3].Value = resultdadname;
39. .
40. .
41. .
42. rowIndex ++;
43. }
44. dr.Close();
45. }
46. private void frmpersonal_Load(object sender, EventArgs e)
47. {
48. displaypersonal();
49. }

Srm Matin6y ago

Thank thank thank Workkkkkkkkkkkkkkkkkkk Very very thank

Rajanikant Hawaldar6y ago

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

Vinay Singh6y ago

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 Hawaldar6y ago

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 Kumar6y ago

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 Matin6y ago

Thank o lot , I will check

Rajanikant Hawaldar6y ago

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 Hawaldar6y ago

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 Kumar6y ago

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