insert-data.sql

ASP.NET Web Forms Techniques

GO

/****** tblNews ******/
SET IDENTITY_INSERT tblNews ON
GO
INSERT INTO tblNews (NewsID, NewsTitle, NewsPrecis, NewsText) VALUES (1, 'New Model Entering Production', 'Production starts on the new <b>Xrox Wresplendant</b> luxury sedan in September! The latest developments in automotive design give high quality travel, combined with responsiveness and great performance', '
<img src="images/newmodel.gif" align="right" width="254" height="245" alt="picture of new car" />
<p>Xrox Cars are proud to announce the exciting new addition to their range, the <b>Xrox Wresplendant</b>.
This fabulous new design goes into production in September, and the first ones are expected to be rolling off
the production line at the start of the following year. Obviously, numbers will be limited at first, and so you
probably should be placing an advance order now to make sure you don''t miss out!</p>
<p>The Wresplendant will be the ultimate combination of luxury and performance for the person who has already got
the best of everything. We''ve combined brand new ideas in design and concept with an underlying technical specification
that is even better than that you are already used to seeing in Xrox Cars.</p>
<p>In fact, its fair to say that this exciting new car will put all our competitors in the shade - for some time to come.
There is, and will be in the foreseeable future, nothing quite like it. So there is already huge speculation surrounding
the development and announcement, but <b>you</b> can be one of the first to see the finished thing.</p>
<p>We''re holding a special press release celebration party in November, and all you have to do to get an invitation is
buy one of our other cars online before then. Don''t miss out, get your order in today and be part of the chosen few...!</p>')
GO
INSERT INTO tblNews (NewsID, NewsTitle, NewsPrecis, NewsText) VALUES (2, 'Xrox Wroadster wins El Mans', 'Great news for Xrox Cars, and for owners of the fantastic <b>Wroadster</b>. After a grueling 72 hours, a win in Spain for our most popular road-legal racing model!', '
<img src="images/elmans.gif" align="right" width="200" height="193" alt="cup and chequered flag" />
<p><b>We''ve done it again!</b> Another win for the amazing <b>Xrox Wroadster</b>. This is turning out to be the best
year yet for Xrox Wracing, our affiliated racing team. And, of course, for the Wroadster itself. Now at seven wins,
five "other places", and only one non-finish, the Wroadster is proving to be a triumph of great design, expert engineering,
and sheer power</p>
<p>Despite poor visibility during the second day, and a minor brush with James Fastly''s Merdubleyew Coupe, Dave Andal
kept the Wroadster running almost flat out for the full 72 hour race. Afterwards, talking to him in the pits, he admitted
that he was "completely exhausted, just like the pipes underneath the car". It''s a well-known fact in racing circles that
Dave''s driving is a far better than his jokes.</p>
<p>One thing you can be sure of is that the work we do in conjunction with Xrox Wracing to prepare these cars, feeds back
into the production models we build. If you want the ultimate in road-legal racing then the Wroadster is the car for you.</p>
<p>Next up is the even more demanding Japanese 5-day all-comer''s event at the tight and twisting Toymitzahonda circuit
high in the mountains above Tokyo. If you can''t be there in person, be sure to set your VCR. We might not have anything
to prove, but we''ve got a growing reputation to protect. See you there...!</p>')
GO
INSERT INTO tblNews (NewsID, NewsTitle, NewsPrecis, NewsText) VALUES (3, 'Great Dheels on Wheels', 'Equip your Xrox car with a set of the <b>fabulous new alloys</b> just arrived in stock. All the colors, all the sizes, and all at <b>great prices</b>!', '
<p><b>What some wheels? We''ve got some wheely good dheels!</b></p>
<p>OK, we''ll give the bad puns a miss from here on in, and concentrate on the great value instead. Just arrived
from Birmingham, England, are hundreds of alloy wheels in all different shapes, designs, sizes and colors. But
they''re going fast, so call us now and get your order in while stocks last.</p>
<img src="images/rainbows.gif" align="right" width="200" height="193" alt="cup and chequered flag" />
<p>Those of you who know the little old town of Birmingham, located roughly in the middle of England, will probably
already be aware that it is the place where colored aluminium and alloys really started. Long a center for heavy
engineering, Birmingham also became one of the pioneering centers for the processing
and use of the new lighter metals and alloys that became available in the engineering world early in the last
century. In particular, aluminium found use in places like window frames and commercial glazing, where its non-rusting
properties combined with lightness and strength for over-head glazing made it an ideal choice.</p>
<p>But while it doesn''t go rusty, it does (as all car owners with alloy wheels can attest) go white and discolor.
To prevent this, heat-treatment and coating processes were continuously developed in Birmingham until they reached
the current state where almost any alloy can be permanently coated in almost any color. So, it''s time to get rid of
your boring old silver or gold wheels, and go co-ordinated. Call our sales desk now and our experienced color consultants
(equipped with modern color-wheel technology) will be able to tell you exactly what color wheels you need for your Xrox car.</p>')
GO
INSERT INTO tblNews (NewsID, NewsTitle, NewsPrecis, NewsText) VALUES (4, 'New Interior Leather Colors', 'It looks like the scientists have figured out how to breed cows in <b>even more exciting colors</b>! We''ve taken advantage by widening our range of leather upholstery colors on all our models! Now you <b>can</b> have an all green leather interior!', '
<p>The combination of advances in genetic engineering and cloning has provided a breakthrough in many areas of science, medicine and
agriculture. While we all fear the long-term effects of the science community "playing God", the good news is that it has had a real benefit for
motor car enthusiasts.</p><img src="images/cows.gif" align="right" width="300" height="227" alt="cows in three colors" /><p>One of the big problems with leather upholstery is the nature of the process of getting it just the right color, and making sure it stays
that way without wearing and gradually fading. The solution has long thought to revolve around finding a way to get the color to go right
through the leather, rather than being just a thin coating on the surface.</p><p>While attempting to breed pigs that would not show the dirt, agricultural researchers in a remote university in Kansas found that they could
achieve a nice browny-gray color that was a good approximation to mud. The only problem then was that farmers kept loosing their pigs. One
farmer is reported to have complained: "It''s just like looking for a black cat in the dark."</p><p>In response, the researchers soon had a range of brightly colored pigs available to the local farming community, and they proved to be such
as hit that they decided to try their hand at cows. And the rest, as they say, is history. Now specialist breeding stations have been
established that produce cows in a range of over 350 standard automotive paint colors, allowing you to have a perfect match and long-lasting
colorfast performance from your new leather upholstery.</p><p>Here at Xrox Cars, we''re on the case. We can now offer leather upholstery on any model in the following colors:</p>
<table border="0" width="95%"><tr><td><table border="3" cellpadding="2" cellspacing="4" width="80%">
<tr><td bgcolor="#FFFFFF">&nbsp;</td><td align="center">White</td></tr>
<tr><td bgcolor="#FF0000">&nbsp;</td><td align="center">Red</td></tr>
<tr><td bgcolor="#FFA500">&nbsp;</td><td align="center">Orange</td></tr>
<tr><td bgcolor="#FFFF00">&nbsp;</td><td align="center">Yellow</td></tr>
<tr><td bgcolor="#008000">&nbsp;</td><td align="center">Green</td></tr>
<tr><td bgcolor="#0000FF">&nbsp;</td><td align="center">Blue</td></tr>
<tr><td bgcolor="#800080">&nbsp;</td><td align="center">Purple</td></tr>
<tr><td bgcolor="#000000">&nbsp;</td><td align="center">Black</td></tr>
<tr><td bgcolor="#A0CE00">&nbsp;</td><td align="center">Alice Blue</td></tr>
<tr><td bgcolor="#FAEBD7">&nbsp;</td><td align="center">Antique White</td></tr>
<tr><td bgcolor="#00FFFF">&nbsp;</td><td align="center">Aqua</td></tr>
<tr><td bgcolor="#7FFFD4">&nbsp;</td><td align="center">Aquamarine</td></tr>
<tr><td bgcolor="#F0FFFF">&nbsp;</td><td align="center">Azure</td></tr>
<tr><td bgcolor="#F5F5DC">&nbsp;</td><td align="center">Beige</td></tr>
<tr><td bgcolor="#FFE4C4">&nbsp;</td><td align="center">Bisque</td></tr>
<tr><td bgcolor="#FFEBCD">&nbsp;</td><td align="center">Blanched Almond</td></tr>
<tr><td bgcolor="#8A2BE2">&nbsp;</td><td align="center">Blue Violet</td></tr>
<tr><td bgcolor="#A52A2A">&nbsp;</td><td align="center">Brown</td></tr>
<tr><td bgcolor="#DEB887">&nbsp;</td><td align="center">Burly Wood</td></tr>
<tr><td bgcolor="#5F9EA0">&nbsp;</td><td align="center">Cadet Blue</td></tr>
<tr><td bgcolor="#7FFF00">&nbsp;</td><td align="center">Chartreuse</td></tr>
<tr><td bgcolor="#D2691E">&nbsp;</td><td align="center">Chocolate</td></tr>
<tr><td bgcolor="#FF7F50">&nbsp;</td><td align="center">Coral</td></tr>
<tr><td bgcolor="#6495ED">&nbsp;</td><td align="center">Corn Flower Blue</td></tr>
<tr><td bgcolor="#FFF8DC">&nbsp;</td><td align="center">Corn Silk</td></tr>
<tr><td bgcolor="#DC143C">&nbsp;</td><td align="center">Crimson</td></tr>
<tr><td bgcolor="#00FFFF">&nbsp;</td><td align="center">Cyan</td></tr>
<tr><td bgcolor="#00008B">&nbsp;</td><td align="center">Dark Blue</td></tr>
</table></td><td><table border="3" cellpadding="2" cellspacing="4" width="95%">
<tr><td bgcolor="#008B8B">&nbsp;</td><td align="center">Dark Cyan</td></tr>
<tr><td bgcolor="#B8860B">&nbsp;</td><td align="center">Dark Goldenrod</td></tr>
<tr><td bgcolor="#A9A9A9">&nbsp;</td><td align="center">Dark Gray</td></tr>
<tr><td bgcolor="#006400">&nbsp;</td><td align="center">Dark Green</td></tr>
<tr><td bgcolor="#2F4F4F">&nbsp;</td><td align="center">Dark Slate Gray</td></tr>
<tr><td bgcolor="#00CED1">&nbsp;</td><td align="center">Dark Turquoise</td></tr>
<tr><td bgcolor="#B22222">&nbsp;</td><td align="center">Fire Brick</td></tr>
<tr><td bgcolor="#FFFAF0">&nbsp;</td><td align="center">Floral White</td></tr>
<tr><td bgcolor="#228B22">&nbsp;</td><td align="center">Forest Green</td></tr>
<tr><td bgcolor="#DAA520">&nbsp;</td><td align="center">Goldenrod</td></tr>
<tr><td bgcolor="#808080">&nbsp;</td><td align="center">Gray</td></tr>
<tr><td bgcolor="#F0E68C">&nbsp;</td><td align="center">Khaki</td></tr>
<tr><td bgcolor="#E6E6FA">&nbsp;</td><td align="center">Lavender</td></tr>
<tr><td bgcolor="#90EE90">&nbsp;</td><td align="center">Light Green</td></tr>
<tr><td bgcolor="#D3D3D3">&nbsp;</td><td align="center">Light Gray</td></tr>
<tr><td bgcolor="#778899">&nbsp;</td><td align="center">Light Slate Gray</td></tr>
<tr><td bgcolor="#FF00FF">&nbsp;</td><td align="center">Magenta</td></tr>
<tr><td bgcolor="#800000">&nbsp;</td><td align="center">Maroon</td></tr>
<tr><td bgcolor="#C71585">&nbsp;</td><td align="center">Medium Violet Red</td></tr>
<tr><td bgcolor="#FF4500">&nbsp;</td><td align="center">Orange Red</td></tr>
<tr><td bgcolor="#DDA0DD">&nbsp;</td><td align="center">Plum</td></tr>
<tr><td bgcolor="#87CEEB">&nbsp;</td><td align="center">Sky Blue</td></tr>
<tr><td bgcolor="#4682B4">&nbsp;</td><td align="center">Steel Blue</td></tr>
<tr><td bgcolor="#D2B486">&nbsp;</td><td align="center">Tan</td></tr>
<tr><td bgcolor="#EE82EE">&nbsp;</td><td align="center">Violet</td></tr>
<tr><td bgcolor="#F5DEB3">&nbsp;</td><td align="center">Wheat</td></tr>
<tr><td bgcolor="#F5F5F5">&nbsp;</td><td align="center">White Smoke</td></tr>
<tr><td bgcolor="#9ACD32">&nbsp;</td><td align="center">Yellow Green</td></tr></table></td></tr></table>
<p>Simply specify a color from the list above, or even your own custom color (using the standard Pantone color code) when you place your order.
Custom colors are charged at an extra $200.00, and there is a manufacturing delay of between three and five years until the cows have grown
large enough.</p>')
GO
SET IDENTITY_INSERT tblNews OFF
GO