public override void ImportDataToDataSet()
{
MyDataSet.WriteXmlSchema(DirPath + "\\" + BaseName + "_sheme.xsd");// запись схемы данных
foreach (DataTable tbl in MyDataSet.Tables)
{
DataTable tblfromfile = GetAllRecords(tbl.TableName);
foreach (DataRow row in tblfromfile.Rows)
{
MyDataSet.Tables[tbl.TableName].Rows.Add(row);
}
;
}
}
public override void Create()
{
MyDataSet.WriteXmlSchema(DirPath + "\\" + BaseName + "_sheme.xsd");// запись схемы данных
try
{
Conn.Open();
if (MyDataSet != null)
{
Cmd.CommandText = string.Format("if (db_id('{0}') is not null) DROP DATABASE [{0}] CREATE DATABASE [{0}] ", BaseName);
Cmd.ExecuteNonQuery();
foreach (DataTable tbl in MyDataSet.Tables)
{
Cmd.CommandText = string.Format("USE [{0}] CREATE TABLE {1} (", BaseName, tbl.TableName);
foreach (DataColumn col in tbl.Columns)
{
Cmd.CommandText += string.Format("[{0}] {1}, ", col.ColumnName, new SqlField(col).GenerateSql());
}
Cmd.CommandText = Cmd.CommandText.Remove(Cmd.CommandText.Length - 2);
Cmd.CommandText += string.Format(@")");
Cmd.ExecuteNonQuery();
}
}
MessageBox.Show("DataBase (sql): " + BaseName + " has created Successfully", "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
// Создание таблицы файла базы данных
public override void Create()//List <DbfField> structure, string nameTbl)
{
DirectoryInfo dir = new DirectoryInfo(DirPath);
dir.Create();
MyDataSet.WriteXmlSchema(DirPath + "\\" + BaseName + "_sheme.xsd");//запись схемы данных в Xml
try
{
Conn.Open();
if (MyDataSet != null)
{
foreach (DataTable tbl in MyDataSet.Tables)
{
Cmd.CommandText = string.Format(@"CREATE TABLE [{0}] (", tbl.TableName);
foreach (DataColumn col in tbl.Columns)
{
DbfField field = new DbfField(col);
Cmd.CommandText += string.Format(@"{0} {1}, ", col.ColumnName, field.GenerateSql());
}
Cmd.CommandText = Cmd.CommandText.Remove(Cmd.CommandText.Length - 2);
Cmd.CommandText += string.Format(@")");
Cmd.ExecuteNonQuery();
MessageBox.Show("DataBase (dbf): " + BaseName + " has created Successfully", "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
