Create a Table in SQL Server database using C# .Net

Please refer this code

HTML

<asp:TextBox ID="txtTableName" runat="server" />
<asp:RequiredFieldValidator ErrorMessage="Required" ControlToValidate="txtTableName"
Display="Dynamic" runat="server" />
<asp:Button Text="Create Table" OnClick="CreateTable" runat="server" />

Namespaces

using System.Data.SqlClient;
using System.Configuration;

C#

protected void CreateTable(object sender, EventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    string sqlStatment = string.Format("CREATE TABLE {0}([Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NULL)", txtTableName.Text.Trim());
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand(sqlStatment, con))
        {
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
}