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?
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,431 questions