Insert multiple numbers between two ASP.Net TextBoxes in database using C#

Hi micah,

Pls refer below code.

HTML

<div class="form-group data-custon-pick data-custom-mg" id="data_5">
<label>Range Insert</label>
<div class="input-daterange input-group">
    <asp:TextBox ID="txtfrom" runat="server" CssClass="form-control" name="start" value="" type="text" Placeholder="From"></asp:TextBox>
    <span class="input-group-addon">to</span>
    <asp:TextBox ID="txtTo" runat="server" CssClass="form-control" name="end" value="" type="text" Placeholder="To"></asp:TextBox>
</div>
<asp:LinkButton ID="btnInsert" runat="server" CssClass="btn btn-md btn-primary login-submit-cs" OnClick="btnInsert_Click" > <i class="fa fa-search adminpro-informatio" aria-hidden="true" ></i>Insert Numbers </asp:LinkButton>
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
</div>

Namespaces

C#

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

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        BindGrid();
    }
}

protected void btnInsert_Click(object sender, EventArgs e)
{
    if (!string.IsNullOrEmpty(txtfrom.Text) && !string.IsNullOrEmpty(txtTo.Text))
    {
        for (int i = Convert.ToInt32(txtfrom.Text); i <= Convert.ToInt32(txtTo.Text); i++)
        {
            using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand("INSERT INTO Teller VALUES (@Numbers)", con))
                {
                    cmd.CommandType = CommandType.Text;
                    cmd.Parameters.AddWithValue("@Numbers", i);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }
        }
        this.BindGrid();
    }
}

private void BindGrid()
{
    using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT * FROM Teller", con))
        {
            cmd.CommandType = CommandType.Text;
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);
                    GridView1.DataSource = dt;
                    GridView1.DataBind();
                }
            }
        }
    }
}

Screenshot