12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- using System;
- using System.Collections.Generic;
- using System.Text;
- using System.Data;
- using System.Data.Common;
- using System.Data.OleDb;
- using FastReport.Utils;
- using FastReport.Forms;
- using FastReport.Data.ConnectionEditors;
- namespace FastReport.Data
- {
- partial class OleDbDataConnection
- {
- private void GetDBObjectNames(string name, List<string> list)
- {
- DataTable schema = null;
- DbConnection conn = GetConnection();
- try
- {
- using (OleDbCommandBuilder builder = new OleDbCommandBuilder())
- {
- OpenConnection(conn);
- schema = conn.GetSchema("Tables", new string[] { null, null, null, name });
- foreach (DataRow row in schema.Rows)
- {
- string tableName = row["TABLE_NAME"].ToString();
- string schemaName = row["TABLE_SCHEMA"].ToString();
- if (String.IsNullOrEmpty(schemaName))
- list.Add(tableName);
- else
- list.Add(schemaName + "." + builder.QuoteIdentifier(tableName, conn as OleDbConnection));
- }
- }
- }
- finally
- {
- DisposeConnection(conn);
- }
- }
- /// <inheritdoc/>
- public override int GetDefaultParameterType()
- {
- return (int)OleDbType.VarChar;
- }
- /// <inheritdoc/>
- public override ConnectionEditorBase GetEditor()
- {
- return new OleDbConnectionEditor();
- }
- /// <inheritdoc/>
- public override string GetConnectionId()
- {
- return "OleDb: " + ConnectionString;
- }
- }
- }
|