Fill DataSet from SQL Database

Question

0.00/5 (No votes)

See more:

Hello everyone. Now I'm trying to fill a DataSet from a table in a SQL Database.
Normally I can use the SqlDataAdapter, but now I have other problem.

The table is composed by 3 columns ID, UserName, Password.
UserName and Password are Encrypted, so I need to do the next thing:

Get all items of the table, decrypt all items from UserName column, and later fill the DataSet with that new data.

Can you provide to me some ideas?

Thanks

Posted 10-Sep-12 14:27pm

TANicox

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kuthuparakkal · Answer 1 · 2012-09-10T15:45:00

Solution 1

Read thru :
http://msdn.microsoft.com/en-us/library/ms173744[^]

Posted 10-Sep-12 15:45pm

Kuthuparakkal

Comments

TANicox 11-Sep-12 10:43am

Yes, I tried with that, but my hosting not allows to me do that

Kuthuparakkal 11-Sep-12 10:48am

Ask your hosting guyz to define data retreival policy

TANicox 11-Sep-12 11:09am

Ok, now I'm sending an Email, suggesting the change of the policy.
Otherwise, don't exist another way to do this?
Thanks for your support

Fill DataSet from SQL Database

1 solution

Solution 1

Add your solution here

Preview 0

Fill DataSet from SQL Database

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us