How To Make Adobe Pdf File Password Protected Pdf CrackHow to create a password protected pdf file. Each month, over 5. Stack Overflow to learn, share their knowledge, and build their careers. Join the world’s largest developer community. Adding comments to a PDF document. password-protected, you can add comments to any PDF file. Create and protect your PDF file in select Office apps with Adobe. the protected PDF file. PDF file and restrict others from editing your PDF with. In Adobe Acrobat. Requires a password to open file attachments. Consider keeping a backup copy of the PDF that isn’t password-protected. Usually, banks send credit card statements to your email as a password-protected file. Here are two simple hacks to remove password from PDF files with and without. Using LockLizard Safeguard PDF protection to create, open and print protected pdf files and why we don't use password protectedPDF.
0 Comments
I have a leviton three way dimmer switch with 2 black, 1 red, 1 green.? Sigh, sorry for sounding exasperated, but 3- way switches are not rocket science if you understand how they work. A 3- way dimmer is THE SAME as a 3- way switch. Homeowners who install 3- ways get them messed up so often I think it should be illegal for them to install the things. But here's how to do it. Go to Leviton. com and they have a two page PDF with a clear diagram of how the wires should be connected. Disconnect both switches AND the lights and start fresh. Draw yourself a diagram showing what wires are present at the two switches and also at the controlled light. Usually the wires go from one switch, then to the light then from the light down to the other switch. This means there should be a three wire (not counting the green) from each switch to the light. Since 3 conductor wire is usually black red and white, use the red and white to be your "travelers" between the "traveler" terminals on the two three way switches. They will just be spliced straight through at the light fixture box and NOT connected to the light. The blacks coming in from each switch at the light box will go on the light's two terminals. Use a voltage tester to locate where the circuit feed comes and proceed from there. Another way to determine the source feed is that one of the 2 three ways should have TWO cables coming into the box. The other switch should only have one 3- wire cable. In the switch box that has two cables, one should only be a 2- wire cable, black and white (again, ignore the green or bare wire). That 2 wire cable is your hot feed. Connect the black (on the 2- wire cable) to the "common" on the switch and connect the white to the black wire coming from the 3- wire cable. Now take the red and white from the 3- wire cable and hook them to the "traveler" terminals on the 3- way switch. At the second 3 way switch (the one that only has a single 3- wire cable in the box) hook the red and white to the "traveler" terminals on the switch and the black wire to the "common" terminal. If you look at your diagram you will see that power goes into the first switch, splits to the travelers, goes through directly to the travelers on the second switch, comes out the 2nd switch on the "common" then goes to the light on the black wire, then through the light and back to the first switch box where it returns to the panel on the white wire in the 2- wire cable at that end. All the green or bare copper wires should be wire- nutted together in each box as well as pigtailed to the ground screw on the switches. This won't effect switch performance and is just for safey bonding. I need to install a dimmer in place of 3 way switch. 3 way switch has three black wires and 1 wire attached. How JustAnswer Works. (1 green, 2 red and 1 black). Tools needed to install your Dimmer Slotted/Philips Screwdriver Electrical Tape. Dimmer 3-Way Switch Red Black Green Ground Green. Leviton 6643-W 600W Incandescent Toggle Dimmer. Leviton 6643-W 600W Incandescent Toggle Dimmer, 3-Way. red on dimmer to black traveler. FLUORESCENT SLIDE DIMMER Single Pole or 3-Way. Tools needed to install your Dimmer Step 3. 3-Way Black Dimmer Lead Dimmer Green Dimmer Lead Red. How To Install a Dimmer Switch. Installing a dimmer switch is a great way to save energy and. Black is attached to black. Red is attached to black. Green is. · Slide Dimmer Installation Help. is your "power in" and then the red wire that comes out with the green. on the black terminal of your old 3-way switch will get. Or Green) LINE (Usually Black, Red or Blue) LINE. Install the Dimmer Switches into the gang boxes. The wireless setup is a two-step process for a 3-way Dimmer.· Single pole has 2 terminals and 3 way has 3 terminals (excluding any green grounding. detailing the install. Help replacing dimmer switch (red & black. · How to Install a Dimmer Switch. With a three-way dimmer. The two house wires may be black, red, or white with black marking. Pes 2009 patch 1 3 crack. #1. 08-09-2016, 12:07 AM. PES 2009 Super Patch 2016/2017 By Micano4u. PES 2009 EGY Challange Patch 2017 Season 2016/2017. Pes 2. 00. 9 patch jelen super liga v. Pes patch. Latest headlines from WN Network. World. News delivers latest Breaking news including World News, U. S., politics, business, entertainment, Video, science, weather and sports news. Search News and archives in 4. Come and download pes 2009 patch absolutely for free. Jelen Super liga PES 2009 Patch v2 0. kitserver van Dark's Patch 2009 2010 Pes 09. Listen or download Pes 2009 Super Patch 2016 2017 music song for free. Please buy Pes 2009 Super Patch 2016 2017 album music original if you like. · Jelen Super Liga Patch v3.0 - Pro Evolution Soccer 2009 / www.pes-serbia.com / Kako. 09-16-2009, 08:11 #1. Бишке. Jelen Super Liga Patch v3.0 - Pro. PES 2009 Super Patch New Season 2016/2017. the patch is working with Pro Evolution Soccer 2009. 04/09/2015. Italia Raih. Free Download Adobe Acrobat XI Pro 1. Full Crack. Free Download Adobe Acrobat XI Pro 1. Full Crack. Adobe Acrobat XI Pro 1. Full Crack adalah software pdf terbaik dan terbaru yang dapat anda gunakan untuk mengedit dan mengelola file pdf dengan sangat mudah dan cepat. Software yang satu ini sudah dikenal lama oleh para pengguna komputer di seluruh dunia dan merupakan software paling populer untuk mengelola file yang berformat pdf. Http:// Abdio Pdf Editor 9.86 Crack 583ae2174f patch br pes. crack download pdf acrobat reader free. adobe audition free download. Infixpro Pdf Editor 6.28 Crack. pdf in adobe acrobat pro xi serial number baby geniuses full movie 2014 tagalog version movies fap turbo free download crack. Adobe Acrobat XI Pro full crack, Adobe Acrobat. file PDF hasil Download tadi. Adobe Acrobat XI Pro. office Panduan PES Photo Editor RPG. Disini anda dapat download Adobe Acrobat XI Pro 1. Full Crack ini dengan gratis dan full speed tentunya. Link download Adobe Acrobat XI Pro 1. Full Crack kami sediakan banyak pilihan, jadi anda dapat memilih link download yang tercepat dari daerah anda. Tenang saja semua software yang kami bagikan disini adalah software full version dan gratis, termasuk Adobe Acrobat XI Pro 1. Full Crack ini. Kami sudah menyertakan crack untuk mengaktifasi software Adobe Acrobat XI Pro 1. Full Crack ini dengan gratis. Download Adobe Acrobat XI Pro 11.0.11 Full Crack : software ini berfungsi untuk membuka file PDF, mengedit dan juga dapat mengkonversi file PDF, buat sobat yang. Adobe acrobat pdf editor free download PDF Editor. [PES 2017] Download + Install on PC [Latest]. Full Crack VPN Proxy Is Here! May 31. Adobe Acrobat XI Pro Serial Key 2016 Full Version Free Download Adobe acrobat 9. pes 2013 crack nasil. Crack is one of the most famous PDF editor as. SoftwaresTab Download Free Full Version. Adobe Acrobat Pro DC Crack 2016 Serial Keygen with Patch Full is the latest and upgrade form of Adobe which. Aplikasi perintis editor pdf file. Dan kini Adobe Acrobat XI Pro 11.0.3 Full. Game PES 20 sudah. Download Notepad++ 6.3.3 free;. Link download Adobe Acrobat XI Pro 11.0.7 Full Crack. adobe pdf editor free download full version crack;. Ninja Storm 4 Full Crack; Free Download Pes Egy Copa.Bagi anda yang belum tahu cara penggunaan crack Adobe Acrobat XI Pro 1. Adobe Acrobat XI Pro 1. Link Download[sociallocker id=”1. Single Link. 10. 0 Mb Links. Mirror. Creator[/sociallocker]Free Download Adobe Acrobat XI Pro 1. Full Crack. Comments. Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. What to Do When You've Outgrown Your Job. You might think you can still do their job well if you’ve outgrown it, but a recent study from Florida Atlantic University showed that, in fact, if it’s time to move on and you’ve stayed put, you might start to suck at your job. This might range from coming in late or leaving early to theft or bullying co- workers. The more overqualified an employee feels, the more likely they are to engage in counterproductive behaviors that impair the effective functioning of organizations.. While your performance might not slip into the realm of theft or bullying your colleagues, feeling like your role no longer suits you can affect your mindset and attitude. If you’re feeling overqualified, here’s what to do. Decide If Things Can Change. Even if you feel you’ve hit a dead end when it comes to career growth, you don’t necessarily have to leave your job. Alison Green, of Ask a Manager, explains that if you’re unhappy at work, you should talk to your manager about it—if you think things can be fixed and if you would stay if they were to change. You have to decide for yourself what that means. Do you need a percentage of your responsibilities and projects to become more challenging? Do you want to focus on just one new skill? If you decide that either things aren’t able to change or that you wouldn’t stay if they did, finding a new job may be your next move. Even so, talk to your manager first worth—they may be able to suggest changes you thought weren’t possible. Look for Internal Opportunities. If you can work with your manager to change the parameters of your job, start with seeing how you can expand your role, even temporarily. On NPR’s podcast Hidden Brain, Amy Wrzesniewski, Professor of Organizational Behavior at Yale, describes how you can use “job crafting” to make your current role more meaningful. That can certainly happen, where people can stumble into something and realize, “This is what I would do even if I hit the lottery,” versus, “How is it I can craft the boundaries of this job [..] in such a way that I can come to experience it perhaps as something that is meaningful [as] potentially a calling could be.”The second situation she describes is one where you can shape your job, and ultimately your career, into work that motivates you. Everyone’s organization is different, so you’ll know the best way to look for opportunities, but here’s a list of potential ones to get you started. Take something off someone else’s plate: If there’s something that your boss or a team mate has to do often, but that seems boring for them, offer to take it over. · If you live in a small space, then even the smallest of smells can be a big problem. The way my apartment is set up, whenever we decide to cook bacon for.
This gives you the chance to learn something new and gives them more bandwidth to focus on other work. Get an inside view: Tasks like helping prepare meeting slides or agendas, taking notes for your boss at meeting, or helping to document processes or resources are mundane, but they give you a peek into how higher ups make decisions. Support another team: You’ll want to clear this with your manager first, but supporting another team on a project can expose you to new skills, work, or ways of thinking. Fill a gap where resources are low: Offer to take on projects or tasks that are falling by the wayside because there aren’t enough resources to sustain them. You’ll get to do something different and take ownership while helping your department and company. If you’re a superstar employee, there’s a good chance you have a target on your back. A recent…Read more Start Job Searching for a Stretch Role. Not every manager or company will be willing to shift your job description or offer internal opportunities to expand your role. If that’s the case for you, your best options may be to look for a new job. Search for roles that will be a stretch and give you something to work towards—you don’t want to end up feeling like you’ve outgrown your job again in a short time. Hunting for a new job invariably means hitting up search sites, tapping your network, and beefing…Read more. X Atencio, Disney Animator and Co- Writer of the Pirates of the Caribbean Theme Music, Dies at 9. Xavier “X” Atencio had a remarkable career with the Walt Disney company, from his early days in the 1. Pinocchio to his later days working on rides like Disneyland’s The Haunted Mansion and Pirates of the Caribbean. But Atencio reached the end of the ride this weekend. He died on Sunday at the age of 9. A daily roundup of all the newest free Kindle eBooks in easy to navigate format. You can also sign up for our newsletter if you wish and have a daily email alert with. Pluto in color, captured on July 3 by New Horizons' Long Range Reconnaissance Imager with data from the Ralph Instrument. Credit NASA/Johns Hopkins University Applied. Some may not know that when he wrote the lyrics for ‘Yo Ho’ he had never actually written a song before,” Bob Weis, president of Walt Disney Imagineering, said in a statement about Atencio’s passing. Yo Ho” is the theme song for the immensely popular Pirates of the Caribbean attraction.“He simply proposed the idea of a tune for Pirates of the Caribbean, and Walt told him to go and do it,” Weis continued. That was how X worked—with an enthusiastic, collaborative attitude, along with a great sense of humor. His brilliant work continues to inspire Imagineers and bring joy to millions of guests every year.”Atencio was born September 4, 1. Walsenburg, Colorado and moved to California in the mid- 1. Chouinard Art Institute. He soon landed a job at Disney and worked on movies like Pinoochio and Fantasia before heading to serve in the Army during World War II. Atencio worked as an animator throughout the 1. D23 is upon us this weekend, and with it, a new behind-the-scenes glimpse at the next chapter in the Star Wars saga. But although the movie didn’t offer us a full.Walt Disney Imagineering (then known as WED Enterprises) to work on some of the most celebrated theme park attractions of all time.“I went over there reluctantly because I didn’t know what I was getting into, and nobody there knew what I was supposed to do either,” Atencio said, according to the Disney company. About a month later I got a phone call from Walt. He told me ‘I want you to do the script for the Pirates of the Caribbean.’”Atencio did a segment years ago describing the development of The Haunted Mansion that can be viewed on You. Tube. In the video he explains the famous Pepper’s Ghost illusion using the large piece of glass in The Haunted Mansion. A new version of New Horizons Remastered has just been released on Itch.io, bringing a few new features, improvements and fixes that add a bit of polish to the. He was also featured in a Disney Channel documentary about Imagineers that can also be watched on You. Tube. In the latter video, he describes the delicate balance of making The Haunted Mansion both scary and amusing. He also talks about the work that went into the original Pirates of the Caribbean script. Atencio retired in 1. Disney Legends, he continued to work with the company for special engagements, as well as telling his stories from a Disney era that has long since passed. PC Cheats, Cheatbook, games, New Cheats, Gamecheats, Pccheats, utility, CheatBook-DataBase 2017. Get help planning your next trip with travel ideas, destination reviews, videos, travel tips and industry news. Breaking news, weather, analysis and information from the Omaha World-Herald about Omaha events, local weather, sports, schools, crime, government, health and. “He simply proposed the idea of a tune for Pirates of the Caribbean, and Walt told him to go and do it,” Weis continued. “That was how X worked—with an. US Immigration and Customs Enforcement has repurposed cellphone tracking technology typically used in criminal investigations to track down at least one immigrant for. RIP X. We seem to be losing quite a few Disney legends recently. But we’re thankful for all the joy you’ve given us over the years.[Disney]. Windows Seven on Asus eee? Page 2. I'll keep this topic going then.. I am running 7 on an Eee PC 9. I have to say that it runs like a charm. I find it as fast as XP concerning the boot time, and faster when it comes to sleep mode ! Office 2. 00. 7 stars really fast (outlook in only 2 seconds !!!). Installation of Windows XP on an ASUS Eee PC. The Asus Eee PC (in the US anyway) comes with a very simplified Xandora Linux interface that provides some very basic. Installing Windows 7 Starter on Asus Eee 901. Which made the pc act in strange. Preparing USB install media. The Asus Eee 901 doesn’t have a cdrom to. ASUS Eee PC 901 drivers are tiny programs that enable your Netbook hardware to communicate with your operating. Windows 7 (43%) Windows 10. I found the ACPI drivers on the web, and the integrated 3. G connectivity is working perfectly. Download the latest drivers for your Asus 901 to keep your Computer up-to-date. Windows 10, Windows 8.1, Windows 7. 3G PC UI Interface (COM24) Driver Date.Two major thing are to be taken into account when installing 7 on this netbook : - The disk space issue (2 8. GB SSD drives) : the installe of Windows 7 takes almost 1. Gigs, with 7. GB on the 1st drive and 3 on the 2d. Burn The Asus® Eee PC 901 Windows® ISO To Disk Or Install Windows® From USB. Free Asus compatible ISO burners & USB installers. This means that I cannot install any of the big Office Updates, such as SP1 and SP2. If you have already upgraded your BIOS : on startup, the screen will be black on startup. I found after a few reboots that I just had to close the lid of the netbook and wake it up ; then I could enjoy this great OS without additional problems. Jobs | Jobs. And. Public Sector tenders and. Armenia: Workshop on Capital Markets Instruments for SME Finance Consultants;. Provider Required to Undertake Functional. The Philosophy of Computer Games. Microsoft Flight Simulator. computer games merely constitute a form of game. interpersonal relations or social dynamics. Cambridgesatchelmall - Drinking water filter cartridges appear in a very wide range of sizes and shapes, and they can be obtained from the range of specialized firms all through the nation. The best drinking water filter cartridge for yourself will obviously mainly count on the sort of h. But it truly is prevalent to locate that there are quite a few possibilities that appear to fit very well in a distinct drinking water procedure system, even with the same filter manufacturer. In those people scenarios one of the most important distinction between them is the know- how that the water filter cartridge is built upon and also the purpose they may be suitable for. The Six Sigma Handbook Revised and Expanded. A Complete Guide for Green Belts, Black Belts, and Managers at All Levels. THOMAS PYZDEK. McGraw-Hill.
It is vital that you know this, as deciding upon the wrong water filter cartridge will never solve the precise challenge you would like to remedy. You’ll find h. 2o filter cartridges made for a number of applications. The most prevalent are sediment removing, water softening, bacteria reduction and flavor and odor advancement. You will discover also multipurpose drinking water filter cartridges. Sediment elimination – Water filter cartridges created to take away sediment are perhaps the simplest in layout, even so these are very successful in what they do. An average sediment removing drinking water filter will not be a great deal unique from those people filters utilized for espresso, other than not surprisingly the products utilized are ready for the much larger water quantity and therefore are for that reason much more resistant and sturdy. Although the theory of procedure will be the identical: a permeable material retains sediment when letting water to circulation. Halting sediments is undoubtedly an significant detail, because it can severely damage your appliances and water pipes. H2o softening – Water filter cartridges meant to offer with tough drinking water are known as water softening filters. Challenging water may be the popular title supplied to water which has an excessive concentration of sodium and/or calcium, which may bring about difficulties in heaters and pipes about time. It can be important to realize that difficult water is just not precisely the same as drinking water with sediments, because the time period really hard drinking water applies if the minerals are dissolved from the liquid, though sediments never dissolve, but is usually observed at simple sight. Also, tough drinking water can lessen the lifestyle of pipes and appliances, but it is not risky for the entire body because the surplus minerals absorbed are removed by regular kidney perform; on the flip side sediments can cause troubles into the physique because they may be far too massive to generally be absorbed in the first place. Micro organism reduction – Water filter cartridges made to reduce microorganisms lessen the number of living bacteria during the water. Some of them only retain dwelling germs but let useless bacteria to move, since they are typically scaled- down. Other drinking water filter cartridges created for microorganisms removal effectively stops both equally dwelling and demise bacteria. This past variety is suggested, due to the fact although lifeless microbes you should not symbolize a possibility for each se, there are other germs commonly existing inside the body which can feed on them, which can lead to an unbalance in the body’s all- natural flora. Flavor and odor advancement – There are various contaminants in drinking water that influence the taste and/or odor of it, and you will discover drinking water filter cartridges created to remedy this issue. The primary style and odor influencing contaminant is chlorine, and there are a number of filters that neutralize or sensibly reduce chlorine levels. Multipurpose filters – Multipurpose water filter cartridges are meant to address a lot of or every one of the issue mentioned earlier mentioned, hence they are really commonly multi stage filters that tackle these troubles just one at a time. These h. 2o filter cartridges can be a tad dearer than other kinds of filters, nevertheless they tend to be much more handy, specially activated carbon multi filters. These provide the maximum purifying qualities, and so are crafted in this type of way that blocks poisons and damaging components with out stopping good minerals and antioxidants, hence preserving the pure gains of drinking water. H2o filter cartridges are classified as the most important element of any water treatment method program; picking out the correct just one will maximize the standard of the home’s water and in addition safeguard your pipes, heaters and appliances for just a prolonged time. From millions of real job salary data. 0 salary data. Average salary is Detailed starting salary, median salary, pay scale, bonus. Microsoft; More Companies. Study online flashcards and notes for Book Part 1.pdf including Specialized Features New coverage in every chapter of the fourteenth edition shows how companies and. Formula 1 Singapore, Hamilton incassa il colpo e spera in Verstappen. Roma Verona. Roma-Verona: formazioni ufficiali e diretta dalle 20.45Roma-Verona. Dragon City Hack Cheat Free Download. 44,546 likes · 21 talking about this. Add resources to your Dragon City account.Dragon City cheat engine download tool free gems. Related Hack and Cheats. Bubble Speed Trainer;. Criminal Case Facebook Cheats Hack Tool 2017. Mit unseren Dragon City Hack werdet ihr unendlich viele Edelsteine haben können. Funktioniert für Android und iOS Geräte. Download the Dragon City Hack, Tool, Cheats, Trainer 100% working for Facebook, Android and iOS and have unlimited Gems, Gold and Food.
Dragon City Cheats and Hack Online. Are you looking for a working Dragon City hack to generate as many precious stones, food and gold as you want? Then you are here on the right side. Because we offer the players of Dragon City a functioning hack. Dragon City Hack Generator. With our Dragon City cheats, you will generate as many precious stones, gold and food as you want for your Dragon City accounts. Sure you want to have precious stones to buy dragons, buildings or demos. Most players would like a lot of precious stones because of that. The long waiting times to shorten the improvement of buildings is also the most reason why you would like to have many precious stones. But you know it all so or so already. You are here because of the Dragon City hack. Dragon City is an app published by Social. Point. It is free to download in the Play. Store and App Store. You can play it on any device that has Android or i. OS. In the game you have to build up your own Dragon City. Of course, you will also have many of your own kites and breed them. In the game, you can fight your dragons against the dragons of other players and gain resources. The strongest dragons are difficult to get in the game. You need a lot of precious stones. Instead of buying these, you can use our Dragon City hack. To use our Dragon City hack program safely, just enter our dragoncityhack. OS i. Phone / Android / Mac / Pc /laptop device. Click on the Generate button below Put your Dragon City username, remember that is case- sensitive, please put your correct upper and lower case of your user name. Add the data needed to transfer the gold, elixir, and gemstone sources. Do not forget to check the proxy to hide your account recognized by Dragon City Server. If you have already completed the offer, it will be delivered to your account within one minute. My. SQL Stored Procedures IF NOT EXISTS()I have been using MSSQL with ASP. NET alot lately, and I really wanted to get some of the benefits of stored procedures into a PHP application I’m writing. I’ve known My. SQL has supported them for a while but I guess I was always a bit too lazy to go through old code and convert it. I used the tool Heidi. SQL to make the process a bit more painless. The first stored procedure I attempted to write accepted 3 parameters and based on one of them checks a lookup table, and creates a new value in it if the same value does not already exist. Normally I would use an IF NOT EXISTS clause, which in Microsoft SQL would look like this. CREATE PROCEDURE some. Proc. @Some. Param varchar(5. DECLARE @Some. Id int. IF NOT EXISTS(SELECT (1) FROM lookup_table WHERE some. Field = @Some. Param ). INSERT INTO lookup_table (some. Field) VALUES(@some. Param). SELECT @Some. Id = @@identity. SELECT @Some. Id = id FROM lookup_table WHERE some. Sweet Stuff. working on some sp/fn’s ? should have a android app going soon with a nice database with some intricate stored procedures embedding some nice logic. In this tutorial i will explain how to insert, view, edit and delete record from database using PHP and Mysqli, basically this tutorial is a second part of Simple. This article explains how to insert Select, Update and Delete data into a MySQL database from an ASP.NET web application. Field = @Some. Param. Do some other stuff here with the id you just received and other data. The above snippet would take a value, check a table for it, get its id, and if the record doesn’t exist in the database create it and return the id. Then you could continue on and insert that id into another table or what have you. Accomplishing the same thing with a My. SQL stored procedure is a bit different. The code below shows how you would accomplish the same task. CREATE PROCEDURE 'some. Proc' (IN 'in_Some. Param' INT). NOT DETERMINISTIC. SQL SECURITY DEFINER. DECLARE Some. Id int. DECLARE Check. Exists int. SET Check. Exists = 0. SELECT count(*) INTO Check. Exists from lookup_table WHERE some. Field = in_Some. Param. IF (Check. Exists > 0) THEN. SELECT id INTO Some. Id FROM lookup_table WHERE some. Field = in_Some. Param. INSERT INTO lookup_table (some. Field ) VALUES(in_Some. Param). SELECT Some. Id = LAST_INSERT_ID(). Do some other stuff here with the id you just received and other data. I’m sure I will find some more differences in things I am used to doing with stored procedures using T- SQL, and when I do I’ll post them here. Sql. Bulk. Copy- Bulk Insert records and Update existing rows if record exists using C# and VB. Net. In this article I will explain how to perform Bulk Insert records and Update existing rows if record exists using C# and VB. Net. Sql. Bulk. Copy as the name suggest is for copying (inserting) bulk records and it cannot perform update operation. Hence comes Table Valued Parameter to the rescue, which allows us to pass multiple records using a Data. Table to a Stored Procedure where we can do the processing. Database. I have made use of the following table Customers with the schema as follows. I have already inserted few records in the table. Then I have created a User Defined Table Type in SQL Server using the following query. CREATETYPE[dbo].[Customer. Type]ASTABLE( [Id][int]NULL, [Name][varchar](1. NULL, [Country][varchar](5. NULL)GOOnce created the User Defined Type will be visible in the Object Explorer as shown below. Finally the following stored procedure is created which will accept the Data. Table as parameter and then will insert all records into the table that are not present in the table and the one that already exists will be updated. SQL Server 2. 00. SQL Server 2. 00. MERGE, which allows to perform INSERT operation when records are not present and UPDATE when records are present in the table. CREATEPROCEDURE[dbo].[Update_Customers] @tbl. Customers. Customer. Type. READONLYASBEGIN SETNOCOUNTON; MERGEINTOCustomersc. USING@tbl. Customersc. ONc. 1. Customer. Id=c. 2. Id WHENMATCHEDTHEN UPDATESETc. Name=c. 2. Name ,c. Country=c. 2. Country WHENNOTMATCHEDTHEN INSERTVALUES(c. Id,c. 2. Name,c. 2. Country); ENDSQL Server 2. The below Stored Procedure can be used where in the SQL Server version 2. MERGE function is not supported. It first performs UPDATE using INNER JOIN and then INSERTS all records that are not present in the table. CREATEPROCEDURE[dbo].[Update_Customers] @tbl. Customers. Customer. Type. READONLYASBEGIN SETNOCOUNTON; - -UPDATE EXISTING RECORDS UPDATECustomers SETName=c. Name ,Country=c. Country FROMCustomersc. INNERJOIN@tbl. Customersc. ONc. 1. Customer. Id=c. 2. Id - -INSERT NON- EXISTING RECORDS INSERTINTOCustomers SELECTId,Name,Country FROM@tbl. Customers WHEREId. NOTIN(SELECTCustomer. Id. FROMCustomers)ENDNote: The SQL for creating the Table and Stored Procedures is provided in the attached sample code. HTML Markup. The HTML Markup consists of an ASP. Net Grid. View and a Button for inserting and updating bulk data from Grid. View to SQL Server Database table.< asp: Grid. View. ID="Grid. View. Auto. Generate. Columns="false"> < Columns> < asp: Bound. Field. Data. Field="Id"Header. Text="Id"Item. Style- Width="3. Bound. Field. Data. Field="Name"Header. Text="Name"Item. Style- Width="1. Template. Field> < Item. Template> < asp: Text. Box. ID="txt. Country"Text='< %# Eval("Country") %> 'runat="server"/> < /Item. Template> < /asp: Template. Field> < /Columns> < /asp: Grid. View> < br/> < asp: Button. Text="Bulk Update"On. Click="Bulk_Update"runat="server"/> Namespaces. You will need to import the following namespaces. C#using System. Data; using System. Data. Sql. Client; using System. Configuration; VB. Net. Imports System. Data. Imports System. Data. Sql. Client. Imports System. Configuration. Populating the Grid. View. In this article I am populating the Grid. View using the following XML file in the Page Load event. The first 4 records are already present in the Table, the only difference is that the countries of some records are modified for illustrating the bulk update operation.< ? Customers> < Customer> < Id> 1< /Id> < Name> John Hammond< /Name> < Country> Brazil< /Country> < /Customer> < Customer> < Id> 2< /Id> < Name> Mudassar Khan< /Name> < Country> India< /Country> < /Customer> < Customer> < Id> 3< /Id> < Name> Suzanne Mathews< /Name> < Country> Germany< /Country> < /Customer> < Customer> < Id> 4< /Id> < Name> Robert Schidner< /Name> < Country> Russia< /Country> < /Customer> < Customer> < Id> 5< /Id> < Name> Shen Ching< /Name> < Country> China< /Country> < /Customer> < Customer> < Id> 6< /Id> < Name> Max Haynes< /Name> < Country> Australia< /Country> < /Customer> < /Customers> C#protectedvoid Page_Load(object sender, Event. Args e){ if (! Is. Post. Back) { Data. Set ds = new. Data. Set(); ds. Read. Xml(Server. Map. Path("~/Customers. Grid. View. 1. Data. Source = ds. Tables[0]; Grid. View. 1. Data. Bind(); }}VB. Net. Protected. Sub Page_Load(sender As. Object, e As. Event. Args) Handles. Me. Load If. Not. Me. Is. Post. Back Then Dim ds As. New. Data. Set() ds. Read. Xml(Server. Map. Path("~/Customers. Grid. View. 1. Data. Source = ds. Tables(0) Grid. View. 1. Data. Bind() End. If. End. Sub. Bulk Insert records and Update existing rows if record exists. The following event handler is executed on the click of the Button. Here first a Data. Table is created with column schema same as that of the User Defined Table Type that was created and then a loop is executed of the Grid. View rows. Inside the loop, the values of the cells of the rows are fetched and are inserted into the Data. Table. Finally the Stored Procedure is executed with the Data. Table passed as parameter to it. C#protectedvoid Bulk_Update(object sender, Event. Args e){ Data. Table dt = new. Data. Table(); dt. Columns. Add. Range(new. Data. Column[3] { new. Data. Column("Id", typeof(int)), new. Data. Column("Name", typeof(string)), new. Data. Column("Country",typeof(string)) }); foreach (Grid. View. Row row in Grid. View. 1. Rows) { int id = int. Parse(row. Cells[0]. Text); string name = row. Cells[1]. Text; string country = (row. Find. Control("txt. Country") as. Text. Box). Text; dt. Rows. Add(id, name, country); } string constr = Configuration. Manager. Connection. Strings["constr"]. Connection. String; using (Sql. Connection con = new. Sql. Connection(constr)) { using (Sql. Command cmd = new. Sql. Command("Update_Customers")) { cmd. Command. Type = Command. Type. Stored. Procedure; cmd. Connection = con; cmd. Parameters. Add. With. Value("@tbl. Customers", dt); con. Open(); cmd. Execute. Non. Query(); con. Close(); } }}VB. Net. Protected. Sub Bulk_Update(sender As. Object, e As. Event. Args) Dim dt As. New. Data. Table() dt. Columns. Add. Range(New. Data. Column(2) {New. Data. Column("Id", Get. Type(Integer)), _ New. Data. Column("Name", Get. Type(String)), _ New. Data. Column("Country", Get. Type(String))}) For. Each row As. Grid. View. Row. In Grid. View. 1. Rows Dim id As. Integer = Integer. Parse(row. Cells(0). Text) Dim name As. String = row. Cells(1). Text Dim country As. String = Try. Cast(row. Find. Control("txt. Country"), Text. Box). Text dt. Rows. Add(id, name, country) Next Dim constr As. String = Configuration. Manager. Connection. Strings("constr"). Connection. String Using con As. New. Sql. Connection(constr) Using cmd As. New. Sql. Command("Update_Customers") cmd. Command. Type = Command. Type. Stored. Procedure cmd. Connection = con cmd. Parameters. Add. With. Value("@tbl. Customers", dt) con. Open() cmd. Execute. Non. Query() con. Close() End. Using End. Using. End. Sub. Screenshot. The following screenshot displays the Customers table containing the updated as well as the inserted records. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
October 2017
Categories |