7,713
社区成员
发帖
与我相关
我的任务
分享
["+ row[2]+"] where ["+ row[3]+"]
呢using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\access\xx.mdb;User Id=admin;Password=;";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
DataTable schemaTable = connection.GetOleDbSchemaTable(
OleDbSchemaGuid.Columns,
new object[] { null, null, null, null });
foreach (DataRow row in schemaTable.Rows)
{
string queryString = "select top 1 1 from [" + row[2] + "] where [" + row[3] + "] like '%abc%'";
using (OleDbCommand command = new OleDbCommand(queryString, connection))
{
if(command.ExecuteScalar() != null)
Console.WriteLine("{0} - {1}", row[2], row[3]);
}
}
}
Console.Read();
}
}
}