private static void ExportManufacturers()
{
String ConnStr = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Persist Security Info=True", Settings.GetValue("WebSpiderDB"));
List <InManufacturer> manufacturers = new InManufacturerManager(Constants.ConnectionString).GetData();
foreach (InManufacturer manufacturer in manufacturers)
{
new ManufacturerManager(ConnStr).Save(manufacturer);
}
//OleDbConnection OleConn = new OleDbConnection(ConnStr);
//OleDbDataAdapter OleAdp = new OleDbDataAdapter(SQL, OleConn);
//DataTable dt = new DataTable();
//OleAdp.Fill(dt);
//foreach (DataRow dRow in categories.Rows)
//{
// dt.Rows.Add(dt.NewRow().ItemArray = dRow.ItemArray);
//}
//OleAdp.InsertCommand = new OleDbCommand(INSERT);
//OleAdp.InsertCommand.Parameters.Add("@Value", OleDbType.VarChar, 255, "Value");
//OleAdp.InsertCommand.Parameters.Add("@DisplayName", OleDbType.VarChar, 255, "DisplayName");
//OleAdp.InsertCommand.Parameters.Add("@ParentValue", OleDbType.VarChar, 255, "ParentValue");
//OleAdp.InsertCommand.Parameters.Add("@CategoryUrl", OleDbType.VarChar, 255, "CategoryUrl");
//OleAdp.InsertCommand.Parameters.Add("@ClearanceZone", OleDbType.Boolean, 8, "ClearanceZone");
//OleAdp.InsertCommand.Parameters.Add("@SaleCenter", OleDbType.Boolean, 8, "SaleCenter");
//OleAdp.InsertCommand.Parameters.Add("@OnlineSpecials", OleDbType.Boolean, 8, "OnlineSpecials");
//OleAdp.InsertCommand.Parameters.Add("@HotDeals", OleDbType.Boolean, 8, "HotDeals");
//OleAdp.InsertCommand.Connection = OleConn;
//OleAdp.InsertCommand.Connection.Open();
//OleAdp.Update(dt);
//OleAdp.InsertCommand.Connection.Close();
}
private static void ExportManufacturers()
{
String ConnStr = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Persist Security Info=True", Settings.GetValue("WebSpiderDB"));
List<InManufacturer> manufacturers = new InManufacturerManager(Constants.ConnectionString).GetData();
foreach (InManufacturer manufacturer in manufacturers)
new ManufacturerManager(ConnStr).Save(manufacturer);
//OleDbConnection OleConn = new OleDbConnection(ConnStr);
//OleDbDataAdapter OleAdp = new OleDbDataAdapter(SQL, OleConn);
//DataTable dt = new DataTable();
//OleAdp.Fill(dt);
//foreach (DataRow dRow in categories.Rows)
//{
// dt.Rows.Add(dt.NewRow().ItemArray = dRow.ItemArray);
//}
//OleAdp.InsertCommand = new OleDbCommand(INSERT);
//OleAdp.InsertCommand.Parameters.Add("@Value", OleDbType.VarChar, 255, "Value");
//OleAdp.InsertCommand.Parameters.Add("@DisplayName", OleDbType.VarChar, 255, "DisplayName");
//OleAdp.InsertCommand.Parameters.Add("@ParentValue", OleDbType.VarChar, 255, "ParentValue");
//OleAdp.InsertCommand.Parameters.Add("@CategoryUrl", OleDbType.VarChar, 255, "CategoryUrl");
//OleAdp.InsertCommand.Parameters.Add("@ClearanceZone", OleDbType.Boolean, 8, "ClearanceZone");
//OleAdp.InsertCommand.Parameters.Add("@SaleCenter", OleDbType.Boolean, 8, "SaleCenter");
//OleAdp.InsertCommand.Parameters.Add("@OnlineSpecials", OleDbType.Boolean, 8, "OnlineSpecials");
//OleAdp.InsertCommand.Parameters.Add("@HotDeals", OleDbType.Boolean, 8, "HotDeals");
//OleAdp.InsertCommand.Connection = OleConn;
//OleAdp.InsertCommand.Connection.Open();
//OleAdp.Update(dt);
//OleAdp.InsertCommand.Connection.Close();
}
