Encrypted data in datagridview

[wassssup]

hi guys..im new to datagridview and im wondering is there a way to convert an encrypted data in access and show it in a datagridview? im using C# and microsoft access

normally this is how to show data in datagridview:

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="");
OleDbCommand command = conn.CreateCommand();
string strSQL = "SELECT * FROM Employee";
ds = new DataSet();
conn.Open();

command.CommandText = strSQL;
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
adapter.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.ReadOnly = true;
conn.Close();
where should i change to decrypt those data before showing it in the datagrid?

[Plater]

Do you know how to un-encrypt it? If so, just run the decrypting on the data kep in the dataset?

[wassssup]

Do you know how to un-encrypt it? If so, just run the decrypting on the data kep in the dataset?

yes..i know how to decrypt it. but what im doing is to decrypt it 1 at a time
eg. temp=(string)read["Username"];
encryption.decrypt(temp, true);
this decrypts the username only..the problem is i dont know how to show this in the datagrid. all this while i used this method only in a while loop.
eg.
while(read.read())
{
//decrypt
}

[Plater]

Well, populate your DataSet, then loop through the dataset.

[wassssup]

Well, populate your DataSet, then loop through the dataset.

can you example please..:)

[Plater]

//myq is a string with my SELECT sql statement
//dbcon is my database connection
//you will probably not use the Sql namespace but like odb namespace
DataSet retval= new DataSet();
SqlDataAdapter dba = new SqlDataAdapter(myq, dbcon);
dba.Fill(retval);
//now your dataset is populated with values
//retval.Tables[0] will give you your DataTable
 
//then you can loop through
foreach(DataRow r in retval.Tables[0].Rows)
{
   //decrypt the data in each column of the row and save it back to the row
}
 

Maybe someone knows a better way, but this is what came to my mind.

[wassssup]

//myq is a string with my SELECT sql statement
//dbcon is my database connection
//you will probably not use the Sql namespace but like odb namespace
DataSet retval= new DataSet();
SqlDataAdapter dba = new SqlDataAdapter(myq, dbcon);
dba.Fill(retval);
//now your dataset is populated with values
//retval.Tables[0] will give you your DataTable
 
//then you can loop through
foreach(DataRow r in retval.Tables[0])
{
   //decrypt the data in each column of the row and save it back to the row
}
 

Maybe someone knows a better way, but this is what came to my mind.

it says that foreach statement cannot operate on variables of type system.data.datatable because it does not contain public definition for getenumerator...

[Plater]

it says that foreach statement cannot operate on variables of type system.data.datatable because it does not contain public definition for getenumerator...

Oops!
(I fixed it in the above code as well)
Use:

foreach(DataRow r in retval.Tables[0].Rows)
 

[wassssup]

foreach(DataRow r in retval.Tables[0].Rows)
 

this works fine:) but i cant seem to get values out of the datagrid
is this even correct?
object value=datagridview1.columns["EmployeeUsername"];
then how do i change objects to strings and putting it back to the grid?

[Plater]

Try this:

//then you can loop through
foreach(DataRow r in retval.Tables[0])
{
   //decrypt the data in each column of the row and save it back to the row
   object o = r["mycolumnname"].Value;
   //r["mycolumnname"] should also have a like .ColumnType property or something to tell you what the object really is
   //If need be you can use o.GetType() to determine the valuetype too
}
 

[wassssup]

foreach(DataRow r in retval.Tables[0])
{
   //decrypt the data in each column of the row and save it back to the row
   object o = r["mycolumnname"].Value;
   //r["mycolumnname"] should also have a like .ColumnType property or something to tell you what the object really is
   //If need be you can use o.GetType() to determine the valuetype too
}
 

foreach(datarow r in retval.tables[0]) cannot be executed
i've head of cell formatting but how does it applies..

[Plater]

foreach(datarow r in retval.tables[0]) cannot be executed
i've head of cell formatting but how does it applies..

Did you switch it to:
foreach(datarow r in retval.tables[0].Rows)

???

[wassssup]

Did you switch it to:
foreach(datarow r in retval.tables[0].Rows)
???

yes i did....
foreach(datarow r in retval.tables[0].Rows)
{
object o = r["EmployeeUserName"];
string a = (string) o;
string b = Encryption.Decrypt(a, true);
}
i used a messageBox.show(); to see the result it did change the values
next is to put the decrypted values inside the datagridview..any ideal how?

[Plater]

next is to put the decrypted values inside the datagridview..any ideal how?

Just assign them back again?

foreach(datarow r in retval.tables[0].Rows)
{
  object o = r["EmployeeUserName"];
  string a = (string) o;
  string b = Encryption.Decrypt(a, true);
  //like this maybe?
  r["EmployeeUserName"].value=b;
}
 

[wassssup]

foreach(datarow r in retval.tables[0].Rows)
{
object o = r["EmployeeUserName"];
string a = (string) o;
string b = Encryption.Decrypt(a, true);
}
i got it!!!!
just add the r["employeename"] = 'decrypted value'; inside the foreeach loop

thanks man!!!!!!!!!
thank you for ur precious time!!!!!!!!!
thank you so much Plater!!!! really appriciate your help!!!!!!!