private void frmClientStatements_ConfigureDataConnection(object sender, ConfigureDataConnectionEventArgs e)
{
string ip = ""; string db = ""; string dbuser = ""; string dbpass = "";
using (SqlConnection conn = new SqlConnection(ClassDBUtils.DBConnString))
{
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("select dbserverip, dbname, dbusername, dbpassword from tblSystemParams", conn);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
ip = rd[0].ToString();
db = rd[1].ToString();
dbuser = rd[2].ToString();
dbpass = rd[3].ToString();
}
rd.Close();
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to database! " + ex.Message);
}
}
e.ConnectionParameters = new MsSqlConnectionParameters(ip, db, dbuser, dbpass, MsSqlAuthorizationType.SqlServer);
}
private void Form1_ConfigureDataConnection(object sender, ConfigureDataConnectionEventArgs e)
{
MSRegistro RegOut = new MSRegistro();
Crypto DesencriptarTexto = new Crypto();
string valServer = RegOut.GetSetting("ConexionSQL", "Server");
string valDB = RegOut.GetSetting("ConexionSQL", "DBase");
string valLogin = RegOut.GetSetting("ConexionSQL", "User");
string valPass = RegOut.GetSetting("ConexionSQL", "Password");
if (valServer != string.Empty && valDB != string.Empty && valLogin != string.Empty && valPass != string.Empty)
{
valServer = DesencriptarTexto.Desencriptar(valServer);
valDB = DesencriptarTexto.Desencriptar(valDB);
valLogin = DesencriptarTexto.Desencriptar(valLogin);
valPass = DesencriptarTexto.Desencriptar(valPass);
e.ConnectionParameters = new MsSqlConnectionParameters(valServer, valDB, valLogin, valPass, MsSqlAuthorizationType.SqlServer);
}
}
