/// <summary>
/// Initializes a new instance of the <see cref="SqlServerDataSource" /> class.
/// </summary>
/// <param name="name">Optional name of the data source.</param>
/// <param name="connectionStringBuilder">The connection string builder.</param>
/// <param name="settings">Optional settings object.</param>
/// <exception cref="ArgumentNullException">connectionStringBuilder;connectionStringBuilder is null.</exception>
public OleDbSqlServerDataSource(string name, OleDbConnectionStringBuilder connectionStringBuilder, SqlServerDataSourceSettings settings = null) : base(settings)
{
if (connectionStringBuilder == null)
{
throw new ArgumentNullException("connectionStringBuilder", "connectionStringBuilder is null.");
}
m_ConnectionBuilder = connectionStringBuilder;
if (string.IsNullOrEmpty(name))
{
Name = m_ConnectionBuilder.DataSource;
}
else
{
Name = name;
}
m_DatabaseMetadata = new OleDbSqlServerMetadataCache(m_ConnectionBuilder);
if (settings != null)
{
XactAbort = settings.XactAbort;
ArithAbort = settings.ArithAbort;
}
m_ExtensionCache = new ConcurrentDictionary <Type, object>();
m_Cache = DefaultCache;
}
public void ApplyEventDialogs(Architecture a)
{
this.Scenario = a.Scenario;
if (this.OnApplyEvent != null)
{
this.OnApplyEvent(this, a);
}
if (nextScenario.Length > 0)
{
base.Scenario.EnableLoadAndSave = false;
List <int> factionIds = new List <int>();
foreach (Faction f in this.Scenario.PlayerFactions)
{
factionIds.Add(f.ID);
}
OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder
{
DataSource = "GameData/Scenario/" + nextScenario,
Provider = "Microsoft.Jet.OLEDB.4.0"
};
this.Scenario.LoadGameScenarioFromDatabase(builder.ConnectionString, factionIds);
this.Scenario.GameScreen.ReloadScreenData();
base.Scenario.EnableLoadAndSave = true;
}
}
private static void InsertIntoExcel()
{
OleDbConnectionStringBuilder conString = new OleDbConnectionStringBuilder();
conString.Provider = "Microsoft.ACE.OLEDB.12.0";
conString.DataSource = FullFilePath;
conString.Add("Extended Properties", "Excel 12.0 Xml;HDR=YES");
using (var dbCon = new OleDbConnection(conString.ConnectionString))
{
dbCon.Open();
var command = new OleDbCommand("INSERT INTO [Sheet1$] VALUES (@vendor, @incomes, @expences, @taxes, @financialResults)");
command.Parameters.AddWithValue("@vendor", "Vendor");
command.Parameters.AddWithValue("@incomes", "Incomes");
command.Parameters.AddWithValue("@expences", "Expences");
command.Parameters.AddWithValue("@taxes", "Taxes");
command.Parameters.AddWithValue("@finanvialResults", "Financial Results");
//string command = "SELECT * FROM [Sales$]";
//using (var adapter = new OleDbDataAdapter(command, dbCon))
//{
// adapter.Fill(sheet);
//}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="OleDbSqlServerDataSource" /> class.
/// </summary>
/// <param name="name">Name of the data source.</param>
/// <param name="connectionString">The connection string.</param>
/// <param name="settings">Optional settings object.</param>
/// <exception cref="ArgumentException">connectionString is null or empty.;connectionString</exception>
public OleDbSqlServerDataSource(string?name, string connectionString, SqlServerDataSourceSettings?settings = null) : base(settings)
{
if (string.IsNullOrEmpty(connectionString))
{
throw new ArgumentException($"{nameof(connectionString)} is null or empty.", nameof(connectionString));
}
m_ConnectionBuilder = new OleDbConnectionStringBuilder(connectionString);
if (string.IsNullOrEmpty(name))
{
Name = m_ConnectionBuilder.DataSource;
}
else
{
Name = name;
}
m_DatabaseMetadata = new OleDbSqlServerMetadataCache(m_ConnectionBuilder);
if (settings != null)
{
XactAbort = settings.XactAbort;
ArithAbort = settings.ArithAbort;
}
m_ExtensionCache = new ConcurrentDictionary <Type, object>();
m_Cache = DefaultCache;
}
protected void Page_Load(object sender, EventArgs e)
{
//Define connection
OleDbConnectionStringBuilder sb = new OleDbConnectionStringBuilder();
sb.Provider = "Microsoft.ACE.OLEDB.12.0";
sb.DataSource = Server.MapPath("~/../uploads/db1.accdb");
OleDbConnection conn = new OleDbConnection(sb.ConnectionString);
string sqlQuery = "SELECT [BagID],[BagName], [Quantity],[UserName], [Color], [Cost], [Status]FROM [Orders]";
_myAdapter = new OleDbDataAdapter(sqlQuery, conn);
//Event handlers
dlstDataList.ItemCommand += new DataListCommandEventHandler(dlstDataList_ItemCommand);
Save.Click += new EventHandler(Save_Click);
Clear.Click += new EventHandler(Clear_Click);
if (!this.IsPostBack)
{
this.LoadDelegates();
//Load table
//No need to open and close connection. DataAdapter does it.
_myAdapter.Fill(_myDs, _orderItemsName);
_myDs.Clear();
this.Session[_orderName] = _myDs;
}
}
private static DataTable GetDataUsingOleDb(
string selectCommandText,
FileInfo excelFile,
int[] primaryKeyColumns,
OleDbConnectionStringBuilder builder)
{
var dt = new DataTable(GetTableNameFromSelectStatement(selectCommandText));
using (var da = new OleDbDataAdapter(selectCommandText, builder.ConnectionString))
{
var rows = da.Fill(dt);
var primaryKey = new DataColumn[primaryKeyColumns.Length];
for (var i = 0; i < primaryKeyColumns.Length; i++)
{
primaryKey[i] = dt.Columns[primaryKeyColumns[i]];
}
dt.PrimaryKey = primaryKey;
if (Debugger.IsAttached)
{
Console.WriteLine($"\nOLE DB Connection String: {builder.ConnectionString}");
Console.WriteLine($"IMPORT from FILE {excelFile.Name} to DATATABLE {dt.TableName}: {rows} rows.");
}
}
return(dt);
}
/// <summary>
/// Open a VFP .PJX Project file, load a DataTable with the PJX contents
/// </summary>
/// <param name="theProject">Path and file name of the .PJX file to open</param>
private void OpenProject(string theProject)
{
pjxPath = Path.GetFullPath(theProject);
pjxName = Path.GetFileName(theProject);
pjxPathOnly = Path.GetDirectoryName(theProject);
OleDbConnectionStringBuilder cb = new OleDbConnectionStringBuilder();
cb.Provider = "VFPOLEDB";
cb.DataSource = pjxPath;
using (OleDbConnection conn = new OleDbConnection(cb.ConnectionString))
{
conn.Open();
vfpProject.Clear();
vfpProject.Clear();
// 12/30/2011 - Add 'T' to select statement to pull Include records
OleDbDataAdapter da = new OleDbDataAdapter(
"select name, type from '" + pjxName +
"' where inlist(type, 'P', 'M', 'V', 'T', 'K', 'R') order by type", conn);
try
{
da.Fill(vfpProject);
pjxLines = vfpProject.Rows.Count;
}
catch (OleDbException ode)
{
MessageBox.Show("Error opening Project:\n\n" +
ode.Message);
}
}
}
public DataTable GetExcelDataTable(string filePath, string commandText)
{
DataTable table = new DataTable();
try
{
OleDbConnectionStringBuilder connectionString = new OleDbConnectionStringBuilder();
connectionString.Provider = "Microsoft.ACE.OLEDB.12.0";
connectionString.DataSource = filePath;
connectionString["Extended Properties"] = "Excel 12.0;HDR=Yes;IMEX=2";
using (OleDbConnection connection = new OleDbConnection(connectionString.ConnectionString))
{
connection.Open();
OleDbCommand command = new OleDbCommand();
command.CommandType = CommandType.Text;
command.CommandText = commandText;
command.Connection = connection;
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
adapter.Fill(table);
}
return(table);
}
catch (Exception ex)
{
tracer.Error(ex.ToString());
return(null);
}
}
// ====================================================================================================
// ====================================================================================================
#region MÉTODOS PÚBLICOS
// ====================================================================================================
// public string GetCadenaConexion(Centros centro) {
// // Si no se ha establecido el centro, devolvemos null.
// if (centro == Centros.Desconocido) return null;
// // Definimos el archivo de base de datos
// string archivo = Utils.CombinarCarpetas(Configuracion.CarpetaDatos, centro.ToString() + ".accdb");
// // Si no existe el archivo, devolvemos null
// if (!File.Exists(archivo)) return null;
// // Establecemos la cadena de conexión
// string cadenaConexion = "Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;";
// cadenaConexion += "Data Source=" + archivo + ";";
// // Devolvemos la cadena de conexión.
// return cadenaConexion;
//}
public string GetCadenaConexion(Centros centro)
{
// Si no se ha establecido el centro, devolvemos null.
if (centro == Centros.Desconocido)
{
return(null);
}
// Definimos el archivo de base de datos
string archivo = Utils.CombinarCarpetas(Configuracion.CarpetaDatos, centro.ToString() + ".accdb");
// Si no existe el archivo, devolvemos null
if (!File.Exists(archivo))
{
return(null);
}
// Establecemos la cadena de conexión
OleDbConnectionStringBuilder cadenaConexionB = new OleDbConnectionStringBuilder {
DataSource = archivo,
Provider = "Microsoft.ACE.OLEDB.12.0",
PersistSecurityInfo = false
};
string cadenaConexion = cadenaConexionB.ToString();
// Devolvemos la cadena de conexión.
return(cadenaConexion);
}
private void button3_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount > 0)
{
try
{
using (SaveFileDialog saveFileDialog1 = new SaveFileDialog())
{
saveFileDialog1.AddExtension = true;
saveFileDialog1.DefaultExt = "xls";
saveFileDialog1.Filter = "Excel文件(*.xls)|*.xls";
saveFileDialog1.RestoreDirectory = true;
saveFileDialog1.FileName = DateTime.Now.ToString("药品结余 yyyy-MM-dd");
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
OleDbConnectionStringBuilder osb = new OleDbConnectionStringBuilder();
osb.Provider = "Microsoft.Jet.OLEDB.4.0";
osb.DataSource = saveFileDialog1.FileName;
osb.Add("Extended Properties", "Excel 8.0;HDR=YES;IMEX=2");
StringBuilder sb = new StringBuilder();
string TableName = DateTime.Now.ToString("hh_mm_ss");
sb.Append(string.Format("CREATE TABLE [{0}](", TableName));
using (DataTable DatDB = dataGridView1.DataSource as DataTable)
{
foreach (DataColumn dc in DatDB.Columns)
{
sb.Append(string.Format("[{0}]{1},", dc.ColumnName, OleDbType.VarChar));
}
using (OleDbConnection cn = new OleDbConnection(osb.ConnectionString))
{
using (OleDbCommand cmd = new OleDbCommand(sb.ToString().TrimEnd(',') + ")", cn))
{
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
using (OleDbDataAdapter oda = new OleDbDataAdapter(string.Format("select * from [{0}]", TableName), cn))
{
using (OleDbCommandBuilder cb = new OleDbCommandBuilder(oda))
{
cb.DataAdapter.Update(DatDB);
}
}
}
}
MessageBox.Show("保存成功");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("没有结余数据，勿需保存！！！");
}
}
/// <summary>
/// Gets table schema information about an OLE database
/// </summary>
/// <returns>DataTable with schema information</returns>
//This function has been fixed in parent class, It should work for all database type // zack 1/30/08
//public override DataTable GetTableSchema()
//{
//DataTable schema = base.GetSchema("Tables");
//foreach (DataRow row in schema.Rows)
//{
// // TODO: This isn't asbolute, should be replaced with search on...
// // exact system table names
// if (row[ColumnNames.SCHEMA_TABLE_NAME].ToString().StartsWith("MSys", true, CultureInfo.InvariantCulture))
// {
// row.Delete();
// }
//}
//schema.AcceptChanges();
// return schema;
//}
public static string BuildConnectionString(string filePath, string password)
{
StringBuilder builder = new StringBuilder();
if (filePath.EndsWith(".mdb", true, System.Globalization.CultureInfo.InvariantCulture))
{
builder.Append("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=");
}
else if (filePath.EndsWith(".accdb", true, System.Globalization.CultureInfo.InvariantCulture))
{
builder.Append("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=");
}
builder.Append(EncodeOleDbConnectionStringValue(filePath));
builder.Append(";");
builder.Append("User Id=admin;Password=;");
if (!string.IsNullOrEmpty(password))
{
builder.Append("Jet OLEDB:Database Password="******";");
}
// sanity check
OleDbConnectionStringBuilder connectionBuilder = new OleDbConnectionStringBuilder(builder.ToString());
return(connectionBuilder.ToString());
}
/// <summary>
/// Generates a cache key for <paramref name="connection"/>.
/// The generated key is a string "<c>MsAccess:database path</c>".
/// </summary>
/// <param name="connection">Database connection.</param>
/// <returns>String.</returns>
/// <exception cref="ArgumentNullException">Value of <paramref name="connection"/> is <see langword="null"/>.</exception>
public string GenerateKey(OleDbConnection connection)
{
Check.NotNull(connection, nameof(connection));
OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder(connection.ConnectionString);
return("MsAccess:" + builder.DataSource.ToLower());
}
public AccessErrorLogProvider()
{
if (File.Exists(FilePath))
{
return;
}
lock (key)
{
if (File.Exists(FilePath))
{
return;
}
TryExecute(() =>
{
var directory = Path.GetDirectoryName(FilePath);
if (!(directory == null || Directory.Exists(directory)))
{
Directory.CreateDirectory(directory);
}
var builder = new OleDbConnectionStringBuilder(ConnectionString);
var dataSource = builder.DataSource;
if (dataSource.StartsWith(".") || dataSource.StartsWith(dataDirectoryMacroString))
{
builder.DataSource = FilePath;
ConnectionString = builder.ConnectionString;
}
new ADOX.Catalog().Create(ConnectionString);
using (var conn = Connection)
{
conn.Execute(Properties.Resources.Table);
}
});
}
}
public void LoadGameFromDisk()
{
base.Scenario.EnableLoadAndSave = false;
if (!File.Exists("GameData/Save/" + this.LoadFileName))
{
base.Scenario.EnableLoadAndSave = true;
}
else
{
this.Plugins.DateRunnerPlugin.Reset();
this.Plugins.GameRecordPlugin.Clear();
this.Plugins.GameRecordPlugin.RemoveDisableRects();
this.Plugins.AirViewPlugin.RemoveDisableRects();
OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder
{
DataSource = "GameData/Save/" + this.LoadFileName,
Provider = "Microsoft.Jet.OLEDB.4.0"
};
base.Scenario.LoadSaveFileFromDatabase(builder.ConnectionString, this.LoadFileName);
//this.mainMapLayer.jiazaibeijingtupian();
this.chushihuajianzhubiaotiheqizi();
this.gengxinyoucelan();
base.Scenario.EnableLoadAndSave = true;
}
}
bool CargarHojasCombo()
{
try
{
OleDbConnectionStringBuilder cb = new OleDbConnectionStringBuilder();
cb.DataSource = ruta;
if (Path.GetExtension(cb.DataSource).ToUpper() == ".XLS")
{
cb.Provider = "Microsoft.Jet.OLEDB.4.0";
cb.Add("Extended Properties", "Excel 8.0;HDR=YES;IMEX=0;");
}
else if (Path.GetExtension(cb.DataSource).ToUpper() == ".XLSX")
{
cb.Provider = "Microsoft.ACE.OLEDB.12.0";
cb.Add("Extended Properties", "Excel 12.0 Xml;HDR=YES;IMEX=0;");
}
dt.Clear();
bool flag = false;
// String strconn2 = "";
// strconn2 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ruta + ";Extended Properties=Excel 12.0;";
OleDbConnection mconn2 = new OleDbConnection(cb.ConnectionString);
//abre una conexion de tipo oledb
mconn2.Open();
dt = mconn2.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
//Lo agrega a mi datatable
if (dt != null)
{
String[] excelSheets = new String[dt.Rows.Count];
int i = 0;
// Add the sheet name to the string array.
cmbHoja.Items.Clear();
foreach (DataRow row in dt.Rows)
{
excelSheets[i] = row["TABLE_NAME"].ToString();
cmbHoja.Items.Add(excelSheets[i].Substring(0, excelSheets[i].Length - 1)); //$
i++;
}
cmbHoja.SelectedIndex = 0;
//cierra una conexion de tipo oledb
flag = true;
}
else
{
flag = false;
}
mconn2.Close();
return(flag);
}
catch (Exception ex)
{
Log_Error_bus.Log_Error(ex.ToString());
dt = new DataTable();
return(false);
}
}
private List <String> GetExcelSheetNames(string filePath)
{
OleDbConnectionStringBuilder sbConnection = new OleDbConnectionStringBuilder();
String strExtendedProperties = String.Empty;
sbConnection.DataSource = filePath;
sbConnection.Provider = "Microsoft.ACE.OLEDB.12.0";
strExtendedProperties = "Excel 12.0;HDR=Yes;IMEX=1";
sbConnection.Add("Extended Properties", strExtendedProperties);
List <string> listSheet = new List <string>();
using (OleDbConnection conn = new OleDbConnection(sbConnection.ToString()))
{
conn.Open();
DataTable dtSheet = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
foreach (DataRow drSheet in dtSheet.Rows)
{
if (drSheet["TABLE_NAME"].ToString().Contains("$"))//checks whether row contains '_xlnm#_FilterDatabase' or sheet name(i.e. sheet name always ends with $ sign)
{
listSheet.Add(drSheet["TABLE_NAME"].ToString());
}
}
}
return(listSheet);
}
static void Main()
{
OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder();
builder.Provider = "Microsoft.Jet.Oledb.4.0";
builder.DataSource = @"C:\Sample.mdb";
// Set properties using the Item property (the indexer, in C#).
builder["Jet OLEDB:Database Password"] = "******";
builder["Jet OLEDB:Encrypt Database"] = true;
builder["Jet OLEDB:System database"] = @"C:\Workgroup.mdw";
Console.WriteLine(builder.ConnectionString);
Console.WriteLine();
// Use the Item property to retrieve values as well.
Console.WriteLine(builder["Jet OLEDB:System database"]);
Console.WriteLine(builder["Jet OLEDB:Encrypt Database"]);
// You can set or retrieve any of the "default" values for the
// provider, even if you didn't set their values.
Console.WriteLine(builder["Jet OLEDB:Database Locking Mode"]);
Console.WriteLine(builder["Jet OLEDB:Global Partial Bulk Ops"]);
Console.WriteLine("Press Enter to continue.");
Console.ReadLine();
}
static void Main()
{
OleDbConnectionStringBuilder builder =
new OleDbConnectionStringBuilder();
builder.PersistSecurityInfo = true;
builder.Provider = "Microsoft.Jet.Oledb.4.0";
builder.DataSource = @"C:\Sample.mdb";
// Store the connection string.
string savedConnectionString = builder.ConnectionString;
Console.WriteLine(savedConnectionString);
// Reset the object. This resets all the properties to their
// default values.
builder.Clear();
// Investigate the PersistSecurityInfo property before
// and after assigning a connection string value.
Console.WriteLine("Default : " + builder.PersistSecurityInfo);
builder.ConnectionString = savedConnectionString;
Console.WriteLine("Modified: " + builder.PersistSecurityInfo);
Console.WriteLine("Press Enter to finish.");
Console.ReadLine();
}
private void btnSelectBD_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
using (openFileDialog1)
{
//ldb — копия_be.accdb
openFileDialog1.Filter = "файл MS Access (*.accdb)|*.accdb";
openFileDialog1.Multiselect = false;
openFileDialog1.FileName = "";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
string name = "Gaudit.Properties.Settings.gisdbConnectionString";
//System.Data.OleDb.OleDbConnection ole = new System.Data.OleDb.OleDbConnection();
string cs = System.Configuration.ConfigurationManager.ConnectionStrings[name].ConnectionString;//= @"Provider = Microsoft.ACE.OLEDB.16.0; Data Source = C:\Learn\Access\ldb — копия_be.accdb ";
System.Data.OleDb.OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder(cs);
builder.DataSource = openFileDialog1.FileName;// @"C:\Work\Access\ldb — копия_be.accdb";
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
config.ConnectionStrings.ConnectionStrings[name].ConnectionString = builder.ConnectionString;
config.Save(ConfigurationSaveMode.Modified, true);
ConfigurationManager.RefreshSection("connectionStrings");
Application.Exit();
System.Diagnostics.Process.Start(Application.ExecutablePath);
}
}
Cursor.Current = Cursors.Default;
}
static void Main()
{
OleDbConnectionStringBuilder builder =
new OleDbConnectionStringBuilder();
builder.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Sample.mdb;" +
"Jet OLEDB:System Database=C:\\system.mdw;";
Console.WriteLine(builder.ConnectionString);
// Try to remove an existing item.
TryRemove(builder, "Provider");
// Try to remove a nonexistent item.
TryRemove(builder, "User ID");
// try to remove an existing item,
// demonstrating that the search isn't
// case sensitive.
TryRemove(builder, "DATA SOURCE");
Console.WriteLine("Press Enter to continue.");
Console.ReadLine();
}
public void Import()
{
try
{
DataTable dtData = new DataTable();
OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder();
builder.Provider = "Microsoft.ACE.OLEDB.12.0";
builder.DataSource = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "BaseData\\");
builder["Extended Properties"] = "text;HDR=YES;FMT=Delimited";
string file = "MeasureTopics.csv";
string query = "SELECT * FROM [" + file + "]";
//create an OleDbDataAdapter to execute the query
OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, builder.ConnectionString);
dAdapter.Fill(dtData);
dAdapter.Dispose();
foreach (DataRow dr in dtData.Rows)
{
AddToDB(dr["ParentName"].ToString(), dr["Name"].ToString(), dr["Longtitle"].ToString(), dr["description"].ToString());
}
dtData.Dispose();
}
catch (Exception ex)
{
Logger.Write(ex);
}
}
public void RefreshConnection(string dataSource)
{
var connectionStringBuilder = new OleDbConnectionStringBuilder(connectionString);
connectionStringBuilder.DataSource = dataSource;
connectionString = connectionStringBuilder.ConnectionString;
}
public DataTable Consulta(string c)
{
DataTable dt = new DataTable();
//try
//{
OleDbDataAdapter da = new OleDbDataAdapter();
DataSet ds = new DataSet();
OleDbConnectionStringBuilder documentos = new OleDbConnectionStringBuilder();
documentos.DataSource = "documentos.accdb";
documentos.Provider = "Microsoft.Jet.OLEDB.4.0";
OleDbConnection conexion = new OleDbConnection(documentos.ToString());
da.SelectCommand = new OleDbCommand(c, conexion);
da.Fill(ds);
dt = ds.Tables[0];
//label5.Text =Convert.ToString(dt.Rows[0].ItemArray[6]);
//label5.Text = Convert.ToString(dt.Rows.Count);
//}
//catch(System.Data.OleDb.OleDbException)
//{
// MessageBox.Show("Por favor cierre el archivo documentos.accdb", "Advertencia Ingreso de datos", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//}
return(dt);
}
static void Main()
{
OleDbConnectionStringBuilder builder =
new OleDbConnectionStringBuilder();
builder.ConnectionString = @"Data Source=c:\Sample.mdb";
// Call the Add method to explicitly add key/value
// pairs to the internal collection.
builder.Add("Provider", "Microsoft.Jet.Oledb.4.0");
builder.Add("Jet OLEDB:Database Password", "MyPassword!");
builder.Add("Jet OLEDB:System Database", @"C:\Workgroup.mdb");
// set up row-level locking.
builder.Add("Jet OLEDB:Database Locking Mode", 1);
// Dump the contents of the "filled-in"
// OleDbConnectionStringBuilder
// to the console window.
DumpBuilderContents(builder);
// Clear current values and reset known keys to their
// default values.
builder.Clear();
// Dump the contents of the newly emptied
// OleDbConnectionStringBuilder
// to the console window.
DumpBuilderContents(builder);
Console.WriteLine("Press Enter to continue.");
Console.ReadLine();
}
public void LoadDelegates()
{
OleDbConnectionStringBuilder sb = new OleDbConnectionStringBuilder();
sb.Provider = "Microsoft.ACE.OLEDB.12.0";
sb.DataSource = Server.MapPath("~/../uploads/db1.accdb");
OleDbConnection conn = new OleDbConnection(sb.ConnectionString);
string sqlQuery = "SELECT * FROM Bag";
OleDbCommand command = new OleDbCommand(sqlQuery, conn);
OleDbDataReader myReader;
//Open connection
conn.Open();
//Retrieve the data and display by using a DataList
myReader = command.ExecuteReader();
dlstDataList.DataSource = myReader;
dlstDataList.DataBind();
myReader.Close();
//Close connection
conn.Close();
}
private void ButtonConnect_OnClick(object sender, RoutedEventArgs e)
{
var builder = new OleDbConnectionStringBuilder();
try
{
builder.ConnectionString = textBoxConnectionString.Text;
Mouse.OverrideCursor = Cursors.Wait;
using (var connection = new OleDbConnection(builder.ConnectionString))
{
try
{
connection.Open();
ConnectionString = builder.ConnectionString;
DialogResult = true;
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failed to connect.");
}
finally
{
Mouse.OverrideCursor = null;
}
}
}
catch (ArgumentException ae)
{
MessageBox.Show(ae.Message, "Invalid OLE DB connection string.");
}
}
private static string ExcelConnectionString(string filePath)
{
try
{
OleDbConnectionStringBuilder sbConnection = new OleDbConnectionStringBuilder();
String strExtendedProperties = String.Empty;
sbConnection.DataSource = filePath;
if (Path.GetExtension(filePath).Equals(".xls"))//for 97-03 Excel file
{
sbConnection.Provider = "Microsoft.Jet.OLEDB.4.0";
strExtendedProperties = "Excel 8.0;HDR=Yes;IMEX=1"; //HDR=ColumnHeader,IMEX=InterMixed
}
else if (Path.GetExtension(filePath).Equals(".xlsx")) //for 2007 Excel file
{
sbConnection.Provider = "Microsoft.ACE.OLEDB.12.0";
strExtendedProperties = "Excel 12.0;HDR=Yes;IMEX=1";
}
sbConnection.Add("Extended Properties", strExtendedProperties);
return(sbConnection.ToString());
}
catch (Exception)
{
throw;
}
}
public static string GetConnectionString(string fileName)
{
OleDbConnectionStringBuilder builder = new OleDbConnectionStringBuilder();
string[] newExtensions = new string[]
{
".xlsx", ".xlsb", ".xlsm"
};
string[] oldExtensions = new string[]
{
".xsl"
};
string extension = Path.GetExtension(fileName);
if (newExtensions.Contains(extension))
{
builder.Provider = "Microsoft.ACE.OLEDB.12.0";
builder.Add("Extended Properties", "Excel 12.0 Xml; HDR=No; READONLY=true; IMEX=1");
}
else if (oldExtensions.Contains(extension))
{
builder.Provider = "Microsoft.Jet.OLEDB.4.0";
builder.Add("Extended Properties", "Excel 8.0; HDR=No; READONLY=true; IMEX=1");
}
else
{
throw new ArgumentException(Resources.UnknownExcelExtension, "fileName");
}
builder.DataSource = fileName;
return(builder.ConnectionString);
}
/// <summary>
/// 读取Access中数据
/// </summary>
/// <param name="strDBFileFolderPath"></param>
/// <param name="strDBFileName"></param>
/// <param name="sql"></param>
/// <returns></returns>
public DataTable GetDataFromAccess(string strDBFileFolderPath, string sql = "select * from ams")
{
//OleDbConnection oleDb = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\c0c04nc\Documents\C# Access SQL\ams1.mdb");
// strDBFileName= @"C:\Users\c0c04nc\Documents\C# Access SQL\ams.accdb";
OleDbConnectionStringBuilder connStrBuild = new OleDbConnectionStringBuilder();
connStrBuild.Provider = "Microsoft.ACE.OLEDB.12.0";
connStrBuild.DataSource = strDBFileFolderPath; //+ strDBFileName;
OleDbConnection conn = new OleDbConnection(connStrBuild.ConnectionString);
conn.Open();
OleDbDataAdapter dbDataAdapter = new OleDbDataAdapter(sql, conn); //创建适配对象
DataTable dt = new DataTable(); //新建表对象
dbDataAdapter.Fill(dt); //用适配对象填充表对象
Debug.Print(dt.Rows[0][1].ToString());
conn.Close();
return(dt);
//OleDbConnection oleDb = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\c0c04nc\Documents\C# Access SQL\ams1.mdb; Persist Security Info = True");
//获取表1的内容
//oleDb.Open();
//OleDbDataAdapter dbDataAdapter = new OleDbDataAdapter(sql, oleDb); //创建适配对象
//DataTable dt = new DataTable(); //新建表对象
//dbDataAdapter.Fill(dt); //用适配对象填充表对象
//Debug.Print(dt.Rows[0][1].ToString());
//oleDb.Close();
//return dt;
}
private OleDbSqlServerDataSource(string name, OleDbConnectionStringBuilder connectionStringBuilder, SqlServerDataSourceSettings settings, OleDbSqlServerMetadataCache databaseMetadata, ICacheAdapter cache, ConcurrentDictionary <Type, object> extensionCache) : base(settings)
{
if (connectionStringBuilder == null)
{
throw new ArgumentNullException("connectionStringBuilder", "connectionStringBuilder is null.");
}
m_ConnectionBuilder = connectionStringBuilder;
if (string.IsNullOrEmpty(name))
{
Name = m_ConnectionBuilder.DataSource;
}
else
{
Name = name;
}
m_DatabaseMetadata = databaseMetadata;
if (settings != null)
{
XactAbort = settings.XactAbort;
ArithAbort = settings.ArithAbort;
}
m_ExtensionCache = extensionCache;
m_Cache = cache;
}
