自动获取表结构及Relation

string myConnString = "Provider=SQLOLEDB;Data Source=server;Initial Catalog=Duwamish7;Integrated Security=SSPI;Connect Timeout=30";

OleDbConnectionconn = new OleDbConnection(myConnString);

DataSetds = new DataSet();

using (conn)

{

conn.Open();

//取表

DataTable dataTalbeschema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,

new Object[]{ null, null, null,"TABLE" } );

//取表结构

foreach (DataRow tableRow in dataTalbeschema.Rows)

{

String tableName = tableRow["Table_Name"].ToString();

string sql = "select * from " + tableName ;

OleDbDataAdapter oda= new OleDbDataAdapter(sql,conn);

oda.MissingSchemaAction = MissingSchemaAction.AddWithKey;

oda.FillSchema(ds,SchemaType.Mapped,tableName);

}

//添加Relation

DataTable dtfk = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_Keys,null );

foreach (DataRow fkRow in dtfk.Rows)

{

String fkName = fkRow["Fk_Name"].ToString();

DataColumn parentColumn = ds.Tables[fkRow["Pk_Table_Name"].ToString()].Columns[fkRow["Pk_Column_Name"].ToString()];

DataColumn childColumn = ds.Tables[fkRow["Fk_Table_Name"].ToString()].Columns[fkRow["Fk_Column_Name"].ToString()];

ds.Relations.Add(fkName,parentColumn,childColumn);

}

conn.Close();

}

详细了解请参看MSDN "GetOleDbSchemaTable"帮助