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"帮助
