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(); } } }