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