/// <summary>
///
/// </summary>
/// <param name="ds"></param>
/// <param name="conn"></param>
public void CreateTableRelations(DataSet ds, SqlConnection conn)
{
TableCreator STC = new TableCreator(conn);
STC.Connection.Open();
foreach (DataRelation relation in ds.Relations)
{
//STC.Get
//string chTblName = item.ChildTable.TableName;
//string prntTblName = item.ParentTable.TableName;
//List<DataColumn> lchColumns = relation.ChildKeyConstraint.Columns.ToList();
//List<DataColumn> parColumns = relation.ParentKeyConstraint.Columns.ToList();
//string prntTblName = relation.ParentTable.TableName;
try
{
STC.CreateRelationFromDataSet(relation);
}
catch (Exception ex)
{
string msg = ex.Message.ToString();
// throw;
msg += "";
}
}
STC.Connection.Close();
}
public void CreateServerTables(DataSet ds, SqlConnection conn)
{
TableCreator STC = new TableCreator(conn);
STC.Connection.Open();
foreach (DataTable dt in ds.Tables)
{
STC.CreateFromDataTable(dt);
}
STC.Connection.Close();
}
