public static int ConnectDatabase(string Datasource, string UserId, string Pass, string Database)
{
QuanLyKhoDongLucEntities db = new QuanLyKhoDongLucEntities();
db.Database.Connection.ConnectionString = "data source=" + Datasource + ";initial catalog=" + Database + ";persist security info=True;user id=" + UserId + ";password="******";MultipleActiveResultSets=True;";
try
{
db.Database.Connection.Open();
return(1);
}
catch (Exception)
{
return(0);
}
}
private void frmTonKho_Load(object sender, EventArgs e)
{
var db = new QuanLyKhoDongLucEntities();
dtFrom.DateTime = DateTime.Now - TimeSpan.FromDays(30);
dtTo.DateTime = DateTime.Now;
if (ID_ton_dau_ky != 0)
{
var tondauky = db.STO_TonDauKy.First(t => t.ID_ton == ID_ton_dau_ky);
if (tondauky != null)
{
ledKhoVT.EditValue = tondauky.ID_kho;
ledTonDauKy.EditValue = tondauky.ID_ton;
}
}
}
public static List <string> GetDatabaseList(string Datasource, string UserId, string Pass)
{
string connectionString = "Data Source=" + Datasource + ";Initial Catalog=master;Persist Security Info=True;User ID=" + UserId + ";Password="******";MultipleActiveResultSets=True;";
QuanLyKhoDongLucEntities db = new QuanLyKhoDongLucEntities();
db.Database.Connection.ConnectionString = connectionString;
try
{
var databases = db.Database.SqlQuery <string>("SELECT [name] FROM sys.databases where [name] = 'QuanLyKhoDongLuc'").ToList();
return(databases);
}
catch
{
return(new List <string>());
}
}