Adding An Int To A SQL Database Using C#

Hi Guys,

I know this is a little off the subject of ASP.net but I am using some code behind in C#.  I am a real novice at this and so it may appear to be a simple question but Im trying to add a number to the database from a textbox but it is having issues as the Storenum is an int and it wants a string.  Can anyone help?  I know I need to write .tostring somewhere but can't work out where.  My code is below.

Thanks in advance. =)

public partial class _addstore : System.Web.UI.Page

{protected string Location;

protected string Telephone;protected string Prefix;

protected int StoreNum;protected string myConnectionString;protected void Page_Load(object sender, EventArgs e)

{

Location = "default";Telephone = "default";

Prefix = "default";StoreNum = "0";myConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\inetpub\wwwroot\HOF\App_Data\HOF.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;";

 

}protected void Button1_Click(object sender, EventArgs e)

{int sa;

SqlConnection myConnection = new SqlConnection(myConnectionString);

try

{

Location = TextBox2.Text;

Telephone = TextBox3.Text;

Prefix = TextBox4.Text;

StoreNum = TextBox5.Text;SqlCommand myCommand = new SqlCommand("INSERT INTO StoreInfo (StoreID, Location, Telephone, Prefix) Values (" + StoreNum + ", '" + Location + "', '" + Telephone + "', '" + Prefix + "')", myConnection);SqlDataAdapter myDataAdapter = new SqlDataAdapter(myCommand);

myConnection.Open();

sa = myCommand.ExecuteNonQuery();

myConnection.Close();

}catch (Exception ex)

{

TextBox2.Text = ex.Message;

myConnection.Close();

}

}

}