Can we create a Stored Procedure in Sql server Using Asp.net Front End

using System;
using System.Collections.Generic;
using System.Text;

using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            string __conStr = @"Data Source=(local)\S2005;Initial Catalog=Demo;Integrated Security=SSPI";

            using (SqlConnection con = new SqlConnection(__conStr))
            {
                con.Open();

                string __spName = "MyUsp";
                string __tblName = "Customers";
                string __sQuery = "";

                __sQuery += "CREATE PROCEDURE " + __spName + "\r\nAS\r\n";
                __sQuery += "Begin\r\n";
                __sQuery += "SELECT * FROM " + __tblName + "\r\n";
                __sQuery += "End\r\n";

                SqlCommand cmd = con.CreateCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = __sQuery;

                try
                {
                    cmd.ExecuteNonQuery();
                }
                catch { }

                con.Close();
            }
        }
    }
}