1.获取表结构
//access里的方式
OleDbConnection connection = new OleDbConnection(accessConnection);
connection.Open();
//获取表结构
DataTable schemaColumns = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new string[] { null, null, tableName, null });
//获取主键
DataTable primaryKeys = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Primary_Keys, new string[] { null, null, tableName });
connection.Close();
//SQL语句新的方式
string sql = string.Format("select {0} from TD_ZSJH_2017", sf);
//SQLserver里的方式
"if exists(select " + sf + " from syscolumns where id=object_id('TD_ZSJH_2017') and name='"+sf+"')"