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=Micr osoft.Jet.OLEDB .4.0;Data Source="");
OleDbCommand command = conn.CreateComm and();
string strSQL = "SELECT * FROM Employee";
ds = new DataSet();
conn.Open();

command.Command Text = strSQL;
OleDbDataAdapte r adapter = new OleDbDataAdapte r(command);
adapter.Fill(ds );
dataGridView1.D ataSource = ds.Tables[0];
dataGridView1.R eadOnly = 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)re ad["Username"];
encryption.decr ypt(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.dat atable because it does not contain public definition for getenumerator.. .

[Plater]

it says that foreach statement cannot operate on variables of type system.data.dat atable 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=datagridv iew1.columns["EmployeeUserna me"];
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
}