private void sqlDataSource1_ConfigureDataConnection(object sender, DevExpress.DataAccess.Sql.ConfigureDataConnectionEventArgs e)
{
//string connectionString = @"XpoProvider=MSSqlServer;Data Source=('" + ClassGenLib.ServerIP + "');User ID=sa;Password=;Initial Catalog=database;Persist Security Info=true;";
//CustomStringConnectionParameters connectionParameters = new CustomStringConnectionParameters(connectionString);
//SqlDataSource ds = new SqlDataSource(connectionParameters);
//this.DataSource = ds;
string connectionString = @"XpoProvider=MSSqlServer;Data Source=('" + ClassGenLib.ServerIP + "');User ID=sa;Password=;Initial Catalog=database;Persist Security Info=true;";
CustomStringConnectionParameters connectionParameters = new CustomStringConnectionParameters(connectionString);
SqlDataSource ds = new SqlDataSource(connectionParameters);
sqlDataSource1.Connection.ConnectionString = ClassDBUtils.DBConnString;
}
private void sqlDataSource1_ConfigureDataConnection(object sender, DevExpress.DataAccess.Sql.ConfigureDataConnectionEventArgs e)
{
//using (var settings = new ApplicationSettings())
//{
// var sqlConnection = new SqlConnection(settings.GetConnectionString("connBNOTE"));
// var sqlConnectionStringBuilder = new SqlConnectionStringBuilder(sqlConnection.ConnectionString);
// var dataConnectionParametersBase = new MsSqlConnectionParameters
// {
// ServerName = sqlConnectionStringBuilder.DataSource,
// DatabaseName = sqlConnectionStringBuilder.InitialCatalog,
// UserName = sqlConnectionStringBuilder.UserID,
// Password = sqlConnectionStringBuilder.Password,
// AuthorizationType = sqlConnectionStringBuilder.IntegratedSecurity ? MsSqlAuthorizationType.Windows : MsSqlAuthorizationType.SqlServer
// };
// e.ConnectionParameters = dataConnectionParametersBase;
//}
//string connectionString = @"XpoProvider=MSSqlServer;Data Source=('"+ClassGenLib.ServerIP+"');User ID=sa;Password=;Initial Catalog=database;Persist Security Info=true;";
string connectionString = @"XpoProvider=MSSqlServer;data source=.;User ID=sa;Password=;Initial Catalog=NewFalconTest;Persist Security Info=true;";
CustomStringConnectionParameters connectionParameters = new CustomStringConnectionParameters(connectionString);
SqlDataSource ds = new SqlDataSource(connectionParameters);
//this.DataSource = ds;
}
private void sqlDataSource1_ConfigureDataConnection(object sender, DevExpress.DataAccess.Sql.ConfigureDataConnectionEventArgs e)
{
e.ConnectionParameters = new MsSqlConnectionParameters(".", "Newfalcon20", "sa", "", MsSqlAuthorizationType.SqlServer);
}
private void ConfigureDataConnection(object sender, DevExpress.DataAccess.Sql.ConfigureDataConnectionEventArgs e)
{
e.ConnectionParameters = new MsSqlConnectionParameters(ArsLibrary.dbServerName, ArsLibrary.dbName, ArsLibrary.dbUserName, ArsLibrary.dbPassword, MsSqlAuthorizationType.SqlServer);
}
