<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	>

<channel>
	<title>The Life of Tyler</title>
	<atom:link href="http://www.teamclanmatch.com/blog/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://www.teamclanmatch.com/blog</link>
	<description>Hold on tightly let go lightly...</description>
	<pubDate>Fri, 14 Nov 2008 15:19:02 +0000</pubDate>
	<generator>http://wordpress.org/?v=2.5</generator>
	<language>en</language>
			<item>
		<title>VB.net check if CAPS LOCK is on</title>
		<link>http://www.teamclanmatch.com/blog/?p=51</link>
		<comments>http://www.teamclanmatch.com/blog/?p=51#comments</comments>
		<pubDate>Fri, 14 Nov 2008 15:18:28 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=51</guid>
		<description><![CDATA[Place this code Within your public class, if you have a password box then it will let the user know if CAPS is in the on or off state:
Private Declare Sub keybd_event Lib &#8220;user32&#8243; (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Integer, ByVal dwExtraInfo As Integer)
Code to toggle CAPS LOCK state
&#8216;Turn [...]]]></description>
			<content:encoded><![CDATA[<p>Place this code Within your public class, if you have a password box then it will let the user know if CAPS is in the on or off state:</p>
<p>Private Declare Sub keybd_event Lib &#8220;user32&#8243; (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Integer, ByVal dwExtraInfo As Integer)</p>
<p><strong>Code to toggle CAPS LOCK state</strong></p>
<p>&#8216;Turn on CAPS<br />
Call keybd_event(System.Windows.Forms.Keys.CapsLock, &amp;H14, 1, 0)</p>
<p>&#8216;Turn Off CAPS<br />
Call keybd_event(System.Windows.Forms.Keys.CapsLock, &amp;H14, 3, 0)</p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=51</wfw:commentRss>
		</item>
		<item>
		<title>VB.NET My.Settings</title>
		<link>http://www.teamclanmatch.com/blog/?p=50</link>
		<comments>http://www.teamclanmatch.com/blog/?p=50#comments</comments>
		<pubDate>Wed, 08 Oct 2008 10:56:33 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[VB.Net]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=50</guid>
		<description><![CDATA[Want to store some user settings in vb.net?This could be used for any number of things, I used this to store the length of a barcode that was being read from a text file, the user could change the default of 12 to any custom value:
 
Open My Project / Settings
Name = message
Type = integer
Scope = [...]]]></description>
			<content:encoded><![CDATA[<p><strong>Want to store some user settings in vb.net?</strong>This could be used for any number of things, I used this to store the length of a barcode that was being read from a text file, the user could change the default of 12 to any custom value:</p>
<p> </p>
<p>Open My Project / Settings<br />
<strong>Name = </strong>message<br />
<strong>Type</strong> = integer<br />
<strong>Scope</strong> = user<br />
<strong>Value = </strong>10</p>
<p><strong>Add this code below our Public Class:</strong></p>
<p>Public Sub New()<br />
&#8216; This call is required by the Windows Form Designer.<br />
InitializeComponent()</p>
<p>End Sub<br />
<strong>On you form load add (to display the value):</strong><br />
Try</p>
<p>txtbox1.text = My.Settings.message</p>
<p>Catch ex AsException</p>
<p>MsgBox(ex.Message)</p>
<p>End Try<br />
 </p>
<p><strong>To Update the setting(put this on a button, reads new value from textbox):</strong></p>
<p>Try<br />
My.Settings.message = CInt(txtNewValue.Text)<br />
My.Settings.Save()<br />
My.Settings.Reload()<br />
Msgbox(&#8221;New Setting Saved.&#8221;)</p>
<p>Catch ex As Exception</p>
<p>MsgBox(ex.Message)</p>
<p>End Try</p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=50</wfw:commentRss>
		</item>
		<item>
		<title>VB.net Create file name from date</title>
		<link>http://www.teamclanmatch.com/blog/?p=49</link>
		<comments>http://www.teamclanmatch.com/blog/?p=49#comments</comments>
		<pubDate>Wed, 08 Oct 2008 10:39:11 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[VB.Net]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=49</guid>
		<description><![CDATA[The following code will produce a unique text file name:
 _____________________________________________________________
 Dim FileTime As Long = DateTime.Now.ToFileTime() 
 Dim FILENAME = &#8220;Log-&#8221; &#38; FileTime &#38; &#8220;.txt&#8221;
 ___________________________________________________________
Usefule for creating a uniqye file name for a program log
]]></description>
			<content:encoded><![CDATA[<p>The following code will produce a unique text file name:</p>
<div><span style="font-size: x-small;"><span style="font-size: x-small;"> _____________________________________________________________</span></span></div>
<div><span style="font-size: x-small;"><span style="font-size: x-small;"> D</span></span><span style="font-size: x-small; color: #0000ff;">im</span><span style="font-size: x-small;"> FileTime </span><span style="font-size: x-small; color: #0000ff;">As</span><span style="font-size: x-small;"> </span><span style="font-size: x-small; color: #0000ff;">Long </span><span style="font-size: x-small;">= DateTime.Now.ToFileTime()<span style="font-size: x-small;"> </span></span></div>
<p> <span style="font-size: x-small; color: #0000ff;">Dim</span><span style="font-size: x-small;"> FILENAME = </span><span style="font-size: x-small; color: #a31515;">&#8220;Log-&#8221;</span><span style="font-size: x-small;"> &amp; FileTime &amp; </span><span style="font-size: x-small; color: #a31515;">&#8220;.txt&#8221;</span></p>
<p> ___________________________________________________________<br />
Usefule for creating a uniqye file name for a program log</p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=49</wfw:commentRss>
		</item>
		<item>
		<title>JavaScript Hack/view Autocomplete Password</title>
		<link>http://www.teamclanmatch.com/blog/?p=48</link>
		<comments>http://www.teamclanmatch.com/blog/?p=48#comments</comments>
		<pubDate>Tue, 19 Aug 2008 12:43:28 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=48</guid>
		<description><![CDATA[Myspace: javascript:alert(document.forms(1).elements(3).value)
https://login.facebook.com/login.php: javascript:alert(document.forms(0).elements(1).value)
Have you clicked to remember a password into a website like myspace and forgotten what it actually is?
Go to the website:
www.myspace.com
copy and paste this into the address bar:
javascript:alert(document.forms.length)

This will tell you how many forms are on the page:
The popup alert will tell you there are 5 forms.
javascript:alert(document.forms(0).name)
Now we find there names of the [...]]]></description>
			<content:encoded><![CDATA[<p><strong>Myspace: javascript:alert(document.forms(1).elements(3).value)<br />
<a href="https://login.facebook.com/login.php">https://login.facebook.com/login.php</a>: </strong>javascript:alert(document.forms(0).elements(1).value)</p>
<p>Have you clicked to remember a password into a website like myspace and forgotten what it actually is?</p>
<p>Go to the website:<br />
<a href="http://www.myspace.com">www.myspace.com</a></p>
<p>copy and paste this into the address bar:<br />
<strong>javascript:alert(document.forms.length)<br />
</strong><br />
This will tell you how many forms are on the page:</p>
<p>The popup alert will tell you there are 5 forms.</p>
<p><strong>javascript:alert(document.forms(0).name)<br />
</strong>Now we find there names of the forms&#8230;</p>
<p>0 = srch<br />
1 = aspnetForm (we are interested in this one)<br />
2 =<br />
3 = SearchFormTop<br />
4 = srch</p>
<p>I then ran:</p>
<p>javascript:alert(document.forms(1).elements(1).name) = nextpage<br />
javascript:alert(document.forms(1).elements(2).name) = Email<br />
<strong>javascript:alert(document.forms(1).elements(3).name)</strong> = Password</p>
<p>Enter some info into the log in:</p>
<p>Email: billy<br />
Password: Bob</p>
<p>Now run this:</p>
<p><strong>javascript:alert(document.forms(1).elements(3).value)<br />
</strong><br />
the alert box will show Bob, so its read what is stored behind the dots!!!</p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=48</wfw:commentRss>
		</item>
		<item>
		<title>ASP.net RadioButtons Text Align</title>
		<link>http://www.teamclanmatch.com/blog/?p=47</link>
		<comments>http://www.teamclanmatch.com/blog/?p=47#comments</comments>
		<pubDate>Wed, 06 Aug 2008 15:36:07 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[ASP.NET]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=47</guid>
		<description><![CDATA[Want to know how to Align you RadioButton List text so that it is in line with the button image?
Create a css file and reference it in the head:
 
 



&#60; link rel=&#8221;stylesheet&#8221; type=&#8221;text/css&#8221; href=&#8221;media/css/reset-fonts-grids.css&#8221;&#62;

 
 
 

Put this in a css file:
/* &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-
* Flow Layout List
* RadioButtonList RepeatLayout=&#8221;Flow&#8221;
  &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- */
.flowLayoutList
{
display: block;
height: 25px;
}
.flowLayoutList INPUT,
.flowLayoutList LABEL
{
line-height: 20px;
vertical-align: middle;
}
.flowLayoutList INPUT[type=&#8221;radio&#8221;]
{
float: left;
    width: [...]]]></description>
			<content:encoded><![CDATA[<p>Want to know how to Align you RadioButton List text so that it is in line with the button image?</p>
<p>Create a css file and reference it in the head:</p>
<p> </p>
<p> </p>
<div></div>
<p><span style="font-size: x-small; color: #0000ff;"></p>
<blockquote>
<div><span style="font-size: x-small; color: #0000ff;"><span style="font-size: x-small; color: #0000ff;">&lt; </span></span><span style="font-size: x-small; color: #0000ff;"><span style="font-size: x-small; color: #0000ff;"><span style="font-size: x-small; color: #a31515;">link</span><span style="font-size: x-small;"> </span><span style="font-size: x-small; color: #ff0000;">rel</span><span style="font-size: x-small; color: #0000ff;">=&#8221;stylesheet&#8221;</span><span style="font-size: x-small;"> </span><span style="font-size: x-small; color: #ff0000;">type</span><span style="font-size: x-small; color: #0000ff;">=&#8221;text/css&#8221;</span><span style="font-size: x-small;"> </span><span style="font-size: x-small; color: #ff0000;">href</span><span style="font-size: x-small; color: #0000ff;">=&#8221;media/css/reset-fonts-grids.css&#8221;&gt;</span></span></span></div>
</blockquote>
<p> </p>
<p> </p>
<p> </p>
<p></span></p>
<p>Put this in a css file:</p>
<p>/* &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<br />
* Flow Layout List<br />
* RadioButtonList RepeatLayout=&#8221;Flow&#8221;<br />
  &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- */<br />
.flowLayoutList<br />
{<br />
display: block;<br />
height: 25px;<br />
}<br />
.flowLayoutList INPUT,<br />
.flowLayoutList LABEL<br />
{<br />
line-height: 20px;<br />
vertical-align: middle;<br />
}<br />
.flowLayoutList INPUT[type=&#8221;radio&#8221;]<br />
{<br />
float: left;<br />
    width: 20px;<br />
    padding: 0;<br />
    vertical-align: middle;     }</p>
<p>.flowLayoutList LABEL<br />
{<br />
clear: right;<br />
margin-right: 4px;   white-space: nowrap;<br />
}</p>
<p> </p>
<p>Set CSSClass on the Radiobutton list to: flowLayoutList</p>
<p>And you text will vertically align!</p>
<p>JD</p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=47</wfw:commentRss>
		</item>
		<item>
		<title>Topgun according to Tarantino</title>
		<link>http://www.teamclanmatch.com/blog/?p=46</link>
		<comments>http://www.teamclanmatch.com/blog/?p=46#comments</comments>
		<pubDate>Wed, 06 Aug 2008 08:13:08 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[You Tube]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=46</guid>
		<description><![CDATA[http://www.youtube.com/watch?v=vyN8VN4BSzM&#38;feature=related
This is worth a watch!
]]></description>
			<content:encoded><![CDATA[<p><a href="http://www.youtube.com/watch?v=vyN8VN4BSzM&amp;feature=related">http://www.youtube.com/watch?v=vyN8VN4BSzM&amp;feature=related</a></p>
<p>This is worth a watch!</p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=46</wfw:commentRss>
		</item>
		<item>
		<title>vb.net  Check for valid UK postcode</title>
		<link>http://www.teamclanmatch.com/blog/?p=40</link>
		<comments>http://www.teamclanmatch.com/blog/?p=40#comments</comments>
		<pubDate>Tue, 29 Jul 2008 15:09:17 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[ASP.NET]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=40</guid>
		<description><![CDATA[Who said you cant validate a UK postcode? Ill tell you who
http://en.wikipedia.org/wiki/UK_postcodes
Automatic validation of postcodes on the basis of pattern feasibility is therefore almost impossible to design, and the system contains no self-validating feature such as a check digit. Completely accurate validation is only possible by attempting to deliver mail to the address, and verifying [...]]]></description>
			<content:encoded><![CDATA[<p>Who said you cant validate a UK postcode? Ill tell you who</p>
<p><a>http://en.wikipedia.org/wiki/UK_postcodes</a></p>
<p>Automatic validation of postcodes on the basis of pattern feasibility is therefore almost impossible to design, and the system contains no self-validating feature such as a check digit. Completely accurate validation is only possible by attempting to deliver mail to the address, and verifying with the recipient.</p>
<p>The function will return True of False</p>
<p><span style="font-size: x-small; color: #0000ff;"><a href="http://www.teamclanmatch.com/blog/media/Check Postcode.txt" target="_blank">Download Source code here</a></span></p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=40</wfw:commentRss>
		</item>
		<item>
		<title>Play.com Security Policy</title>
		<link>http://www.teamclanmatch.com/blog/?p=39</link>
		<comments>http://www.teamclanmatch.com/blog/?p=39#comments</comments>
		<pubDate>Mon, 28 Jul 2008 11:44:33 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[Uncategorized]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=39</guid>
		<description><![CDATA[I am curious to whether Play will make any changes to their site after my email.
Email Sent to Paypal regarding password reminders being sent in plain text:

Hello,
 
A friend has had his account hacked / logged into by an unauthorised user and items ordered off their cash card, this prompted me to log in and change [...]]]></description>
			<content:encoded><![CDATA[<div><span class="609543409-28072008"><span style="font-size: x-small; font-family: Arial;">I am curious to whether Play will make any changes to their site after my email.</p>
<p>Email Sent to Paypal regarding password reminders being sent in plain text:</span></span></div>
<div><span class="609543409-28072008"></span></div>
<div><span class="609543409-28072008"><span style="font-size: x-small; font-family: Arial;">Hello,</span></span></div>
<div><span class="609543409-28072008"></span> </div>
<div><span class="609543409-28072008"><span style="font-size: x-small; font-family: Arial;">A friend has had his account hacked / logged into by an unauthorised user and items ordered off their cash card, this prompted me to log in and change my password. I thought I would check my history of purchases to ensure this had not happened to my account and only saw one item ordered. I realised I had an old account and needed the password to log in, so I had the password emailed to me which to my suprise was in PLAIN TEXT!</span></span></div>
<div><span class="609543409-28072008"></span> </div>
<div><span class="609543409-28072008"><span style="font-size: x-small; font-family: Arial;">Most online shops / secured sites would email a reset link so that the password never exists in plain text format. I have logged in and changed the password so that is not really an issue but many users would retrieve the password and not change it, I feel this is a big hole in your security policy and should be addressed. My debit card on your system is out of date, I wont be updating it until I feel that your system is more secure.</span></span></div>
<div><span class="609543409-28072008"></span> </div>
<div><span class="609543409-28072008"><span style="font-size: x-small; font-family: Arial;">This is not a complaint just thought I would give my view.</span></span></div>
<div><span class="609543409-28072008"></span> </div>
<div><span class="609543409-28072008"><span style="font-size: x-small; font-family: Arial;">Thank You</span></span></div>
<p>Their response:</p>
<p><span style="font-size: x-small;">Dear Ryan Tyler</p>
<p>Thank you for your email.</p>
<p>We are grateful for your suggestions and will forward your request onto the relevant department for their investigation. If we feel that our customers will benefit from your suggestion, we will update our website so it is worth periodically checking it for any further information.</p>
<p>If you have any further queries please check the FAQ section on our Helpdesk</p>
<p><font size="2"> </p>
<p></font></span></p>
<p><a href="http://www.teamclanmatch.com/blog/wp-admin/www.play.com/helpdesk"><span style="text-decoration: underline;"><span style="font-size: x-small; color: #0000ff;">www.play.com/helpdesk</span></span></a></p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=39</wfw:commentRss>
		</item>
		<item>
		<title>Susan Balaka goes full length</title>
		<link>http://www.teamclanmatch.com/blog/?p=38</link>
		<comments>http://www.teamclanmatch.com/blog/?p=38#comments</comments>
		<pubDate>Wed, 25 Jun 2008 10:40:45 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[Uncategorized]]></category>

		<category><![CDATA[film]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=38</guid>
		<description><![CDATA[Susan Balaka: Bound to the Reload

Taken from URL: http://www.bbc.co.uk/wales/southeast/sites/blaenaugwent/pages/susanbalaka.shtml

 
Packino Productions have found internet fame with their Wing Wing Shoot Bag series of short comedy films. Angus Rogers tells how they made the leap to making a full-length community movie in Blaina&#8230;
In January 2008, the weather forecast predicted snow in our area of the South Wales [...]]]></description>
			<content:encoded><![CDATA[<h2>Susan Balaka: Bound to the Reload</h2>
<p><object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="425" height="344" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"><param name="src" value="http://www.youtube.com/v/HL5SqOIWPXE&amp;hl=en" /><embed type="application/x-shockwave-flash" width="425" height="344" src="http://www.youtube.com/v/HL5SqOIWPXE&amp;hl=en"></embed></object></p>
<p><span style="font-size: xx-small;">Taken from URL: http://www.bbc.co.uk/wales/southeast/sites/blaenaugwent/pages/susanbalaka.shtml<br />
</span></p>
<p> </p>
<div class="Textblock"><strong>Packino Productions have found internet fame with their Wing Wing Shoot Bag series of short comedy films. Angus Rogers tells how they made the leap to making a full-length community movie in Blaina&#8230;</strong></div>
<p>In January 2008, the weather forecast predicted snow in our area of the South Wales valleys. We wrote a short film to film in the snow, featuring our most beloved character, Susan Balaka - the transgender Russian super spy.</p>
<p>However, the forecast snow never arrived, and we were left feeling robbed of our creativity. As a way of making ourselves feel better, we decided to write a bigger, better sketch for our character. It was about time for Susan&#8217;s legs to stretch anyway.</p>
<p><img src="http://www.bbc.co.uk/wales/southeast/sites/blaenaugwent/images/susanbalaka_poster200.jpg" border="0" alt="Susan Balaka poster" hspace="6" vspace="6" width="200" height="135" align="left" />Like the back-catalogue of Susan Balaka shorts, this new sketch was originally only meant to last a few minutes. Our intention was to increase the production qualities to make our new work excel from our previous shorts.<br />
But during the writing process we decided to fuse several ideas together, boosting the project up to something which would last around twenty minutes.</p>
<p>Over the next few months and after several scenes were filmed, our friends started to take an active interest in the project, pitching in with aesthetic and practical help. As our friends involvement grew, so did interest from the community and then the media. As a result of this, the film too grew, until it became a feature length production.</p>
<p><img src="http://www.bbc.co.uk/wales/southeast/sites/blaenaugwent/images/susanbalaka_filming200.jpg" border="0" alt="Filming of Susan Balaka" hspace="6" vspace="6" width="200" height="135" align="left" />Being no-budget film-makers, we would use anything we could our hands on. Equipment, props and costumes were borrowed and we would gain permission to film in locations for free.<br />
People who had no experience or even thoughts of acting before would step forward and help us. Everyone did everything they could in order to better the film, and we&#8217;re proud to say that we think the final product is a testament to the hidden talent and beauty of the South Wales valleys.</p>
<p>On July 25th we hope that the audience will see something very new and very, very funny. If you want to find out more join the Susan Balaka Film group on Facebook.</p>
<p><strong>Susan Balaka: Bound to the Reload</strong> is being shown at the Beaufort Theatre, Ebbw Vale, on Friday 25th July. Doors 7pm, admission free.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=38</wfw:commentRss>
		</item>
		<item>
		<title>ASP.net mySQL Insert function</title>
		<link>http://www.teamclanmatch.com/blog/?p=36</link>
		<comments>http://www.teamclanmatch.com/blog/?p=36#comments</comments>
		<pubDate>Fri, 04 Apr 2008 09:05:29 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		
		<category><![CDATA[ASP.NET]]></category>

		<category><![CDATA[mySQL]]></category>

		<guid isPermaLink="false">http://www.teamclanmatch.com/blog/?p=36</guid>
		<description><![CDATA[This code is from a football website off a Add_Player page. The code will add a new football player to the database.
The table the code is added to contains:
ID,Name, Team, DOB, Bio, Position, SquadNo, Birthplace
As ID is set to auto increment within the database then it is not required in the insert.
I have placed some [...]]]></description>
			<content:encoded><![CDATA[<p>This code is from a football website off a Add_Player page. The code will add a new football player to the database.</p>
<p>The table the code is added to contains:</p>
<p>ID,Name, Team, DOB, Bio, Position, SquadNo, Birthplace</p>
<p>As ID is set to auto increment within the database then it is not required in the insert.</p>
<p>I have placed some very basic error checking, the TRY CATCH will attempt to insert the data, outputing to a label if it is successful or not.</p>
<p>code:</p>
<p>Sub Submit_Click(ByVal sender As Object, ByVal e As EventArgs)<br />
        Dim myConnection As MySqlConnection<br />
        Dim myDataAdapter As MySqlDataAdapter<br />
        Dim myDataSet As DataSet</p>
<p>        myConnection = New MySqlConnection(&#8221;server=mysql.server.com; user id=Admin; password=xxx; database=data1; pooling=false;&#8221;)<br />
        Dim myExecuteQuery = &#8220;INSERT INTO Players (Name, Team, DOB, Bio, Position, SquadNo, Birthplace) VALUES ( &#8216;&#8221; &amp; txtname.Text &amp; &#8220;&#8216; , &#8216;&#8221; &amp; listTeam.selecteditem.value &amp; &#8220;&#8216;, &#8216;&#8221; &amp; txtDOB.text &amp; &#8220;&#8216;  , &#8216;&#8221; &amp; txtbio.text &amp; &#8220;&#8216; ,&#8217;&#8221; &amp; listPos.selecteditem.value &amp; &#8220;&#8216; ,&#8217;&#8221; &amp; txtsquadno.text &amp; &#8220;&#8216;,&#8217;&#8221; &amp; txtbirth.text &amp; &#8220;&#8216; )&#8221;</p>
<p>        Dim myCommand As New MySqlCommand(myExecuteQuery, myConnection)<br />
        myCommand.Connection.Open()</p>
<p>        Try<br />
            myCommand.ExecuteNonQuery()<br />
            myConnection.Close()<br />
            lblmsg.text = &#8220;Player has been added &#8221;</p>
<p>        Catch<br />
            lblmsg.text = &#8220;Could not insert please resubmit&#8221;<br />
        End Try<br />
    End Sub</p>
]]></content:encoded>
			<wfw:commentRss>http://www.teamclanmatch.com/blog/?feed=rss2&amp;p=36</wfw:commentRss>
		</item>
	</channel>
</rss>
