Click here to Skip to main content
15,395,276 members
Home / Discussions / C#
   

C#

 
GeneralRe: how to reject the invalid row adding to datatable? Pin
wangier11-Jan-04 18:24
Memberwangier11-Jan-04 18:24 
Questionhow to prevent changing columns' width in datagrid? Pin
wangier8-Jan-04 16:38
Memberwangier8-Jan-04 16:38 
AnswerRe: how to prevent changing columns' width in datagrid? Pin
Heath Stewart8-Jan-04 17:12
protectorHeath Stewart8-Jan-04 17:12 
GeneralRe: how to prevent changing columns' width in datagrid? Pin
wangier8-Jan-04 20:51
Memberwangier8-Jan-04 20:51 
AnswerRe: how to prevent changing columns' width in datagrid? Pin
Guillermo Rivero8-Jan-04 19:04
MemberGuillermo Rivero8-Jan-04 19:04 
GeneralQuestion about GUI techniques... Interesting, I promise. Pin
madjeux8-Jan-04 15:01
Membermadjeux8-Jan-04 15:01 
GeneralRe: Question about GUI techniques... Interesting, I promise. Pin
Christian Graus8-Jan-04 15:29
mveChristian Graus8-Jan-04 15:29 
GeneralRe: Question about GUI techniques... Interesting, I promise. Pin
madjeux9-Jan-04 14:34
Membermadjeux9-Jan-04 14:34 
Questionhow to create Componet of my favourite Pict in the ToolBox Pin
meetweb8-Jan-04 14:11
Membermeetweb8-Jan-04 14:11 
AnswerRe: how to create Componet of my favourite Pict in the ToolBox Pin
Heath Stewart8-Jan-04 16:50
protectorHeath Stewart8-Jan-04 16:50 
GeneralFIX Gateway Server Pin
Kingvest8-Jan-04 12:53
MemberKingvest8-Jan-04 12:53 
GeneralCrystal Reports and Sql Server 2000 Pin
obelisk298-Jan-04 12:34
Memberobelisk298-Jan-04 12:34 
GeneralRe: Crystal Reports and Sql Server 2000 Pin
Heath Stewart8-Jan-04 12:46
protectorHeath Stewart8-Jan-04 12:46 
You can keep the password in the connection string:
Provider=...; User ID=user; Password=pwd; ...
This isn't very secure, but then again nothing you can store in the assembly isn't because anyone can use ildasm.exe or a similar tool to see what you have in the application.

If you're using SQL Server, perhaps a better way is to use integrated authentication, or SSPI, by excluding the User ID and Password params of the connection string and instead using Integrated Security=SSPI. This will use the credentials of the current (or impersonated) user to attach to SQL Server. The server must be configured to support mixed mode authentication, though (both SQL Server and Integrated Windows authentication).

The best practice is to not store secret information in your app because it's never secret. If you aren't using SQL Server and want you connection to be more secure, rely on either the user specifying the connection string in your application (perhaps as an option) or use ODBC.NET and let them configure their own DSN.

So, as long as this connection string is used for the DB connection for the CR report, you shouldn't have to worry about a password prompt.

 

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
GeneralRe: Crystal Reports and Sql Server 2000 Pin
obelisk298-Jan-04 13:01
Memberobelisk298-Jan-04 13:01 
GeneralRe: Crystal Reports and Sql Server 2000 Pin
Heath Stewart8-Jan-04 13:11
protectorHeath Stewart8-Jan-04 13:11 
GeneralRe: Crystal Reports and Sql Server 2000 Pin
obelisk298-Jan-04 13:20
Memberobelisk298-Jan-04 13:20 
GeneralRe: Crystal Reports and Sql Server 2000 Pin
obelisk298-Jan-04 14:10
Memberobelisk298-Jan-04 14:10 
GeneralRe: Crystal Reports and Sql Server 2000 Pin
obelisk298-Jan-04 14:30
Memberobelisk298-Jan-04 14:30 
GeneralDynamic Casting for use in Polymorphic/overloaded methods. Pin
Scott Barr8-Jan-04 11:12
MemberScott Barr8-Jan-04 11:12 
GeneralRe: Dynamic Casting for use in Polymorphic/overloaded methods. Pin
Heath Stewart8-Jan-04 11:50
protectorHeath Stewart8-Jan-04 11:50 
GeneralRe: Dynamic Casting for use in Polymorphic/overloaded methods. Pin
Scott Barr9-Jan-04 4:42
MemberScott Barr9-Jan-04 4:42 
GeneralRe: Dynamic Casting for use in Polymorphic/overloaded methods. Pin
Heath Stewart9-Jan-04 5:15
protectorHeath Stewart9-Jan-04 5:15 
GeneralRe: Dynamic Casting for use in Polymorphic/overloaded methods. Pin
Scott Barr9-Jan-04 5:30
MemberScott Barr9-Jan-04 5:30 
GeneralType convertion and Unmanaged code Pin
Shahin778-Jan-04 10:48
MemberShahin778-Jan-04 10:48 
GeneralRe: Type convertion and Unmanaged code Pin
Heath Stewart8-Jan-04 11:39
protectorHeath Stewart8-Jan-04 11:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.