private void tip_SelectedHandler(uc_statusbar_datasource source)
{
txtprovider.Text = source.provider;
dbaddr.Text = source.dbaddr;
username.Text = source.username;
userpwd.Text = source.userpwd;
}
public DbHelper SetDbHelper(uc_statusbar_datasource config)
{
DbHelper db = new DbHelper();
db.dbProviderName = "System.Data.SqlClient";
string dbConnectionString = "server={0};uid={1};pwd={2}";
db.dbConnectionString = (string.Format(dbConnectionString, config.dbaddr, config.username, config.userpwd));
db.CreateConnection();
return(db);
}
public List <string> GetAllDatabaseName(uc_statusbar_datasource config)
{
List <string> result = new List <string>();
DbHelper db = SetDbHelper(config);
DataTable dt =
db.ExecuteDataTable(db.GetSqlStringCommond("Select Name FROM Master..SysDatabases order BY Name"));
foreach (DataRow dr in dt.Rows)
{
result.Add(dr["Name"].ToString());
}
return(result);
}
static DataBaseStaticConfig()
{
Config = new uc_statusbar_datasource();
}
