My web form is not saving to database successfully
<p>My form doesn't save the text in the Texbox to the database. I've probably something wrong in my .cs CodeFile, but I can't work it out.</p>

<p>It could well be my connection string.</p>

<p><strong>My web form:</strong></p>

<pre><code>&lt;form id="form1" runat="server"&gt;
    &lt;div&gt;
        &lt;table&gt;
            &lt;tr&gt;
                &lt;td&gt;
                    Enter selection text:
                &lt;/td&gt;
                &lt;td&gt;
                    &lt;asp:TextBox ID="TextBox1" runat="server"&gt;&lt;/asp:TextBox&gt;
                &lt;/td&gt;
            &lt;/tr&gt;
                &lt;td colspan="2" align="center"&gt;
                    &lt;asp:Button ID="Button1" runat="server" Text="Submit" /&gt;
                &lt;/td&gt;
            &lt;/tr&gt;
        &lt;/table&gt;
    &lt;/div&gt;
&lt;/form&gt;
</code></pre>

<p><strong>Here is my code behind:</strong></p>

<pre><code>using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    SqlConnection con = new SqlConnection(@"Data Source=db65225900.db.1and1.com; Initial Catalog=db211255182; User ID=dbo652259000; Password=Password");

    protected void Page_Load(object sender, EventArgs e)
    {
    }

    protected void Button1_Click1(object sender, EventArgs e)
    {
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "insert into homepageSelection values('"+TextBox1.Text+"')";
        cmd.ExecuteNonQuery();
        con.Close();    
    }
}
</code></pre>

<p>My MsSQL is setup like the following:</p>

<p>1 column: selectionText nvarchar(3000)</p>