i'm using ADO.NET to get some information from the database on a server,
so this is what i do:
string conStr = "Data Source=myServerSQLEXPRESS;Initial Catalog=DBName;User ID=myUser;Password=myPassword";
SqlConnection conn = new SqlConnection(conStr);
conn.Open();
// do stuff
conn.Close();
but after calling Open method i noticed that conn.ConnectionString is losing the password so it becomes:
"Data Source=myServerSQLEXPRESS;Initial Catalog=DBName;User ID=myUser;"
which causes exception with any SqlCommand afterwords
how to fix this?
Note:The strange thing is that does not happen always
Edit: i don't think it has anything to do with the command it self but anyway
SqlCommand command = new SqlCommand("select GetDate()", conn);
SqlDataReader reader = command.ExecuteReader();
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…