You should not edit the TableAdapter as shown. You can use the following class ConnectionStringSecure for runtime. Then before the TableAdapter.Fill use DecryptFile then EncryptFile.
How to use encrypted DB connectionString at DataSet.xsd?
Min
0
Reputation points
Hello.
I'm want use DataSet.xsd in .Net Framework 4.5 c# winform project with encrypted connection string.
I execute below
- adding TableAdapter in DataSet from Designer view
- connecting TableAdapter with db using by ConnectionString
- ConnectionString for TableAdapter saved project/settings by plain. no encrypted.
I can redesign code for encrypted connection string from DataSet.Designer.cs/TableAdapter.InitConnection()
and delete plain connection string that stored in project/settings for secure. but it occurs error when execute some command in DataSet Designer view.
I know its natural things. but its neccerary to secure program.
This is the question.
- How to use encrypted connection string in DataSet designer view without error?
Developer technologies | C#
11,580 questions
1 answer
Sort by: Most helpful
-
Karen Payne MVP 35,586 Reputation points Volunteer Moderator
2025-05-02T17:49:42.2833333+00:00