Hey
Refer below sample.
HTML
<asp:ScriptManager runat="server" />
<div class=" input-group date form_date">
<asp:TextBox ID="txt_todate" class="form-control years hasDatepicker" placeholder="Enter Date"
runat="server"></asp:TextBox>
<span class="input-group-addon"><a href="#"><i id="Image2" class="fa fa-calendar"></i>
</a>
<cc1:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txt_todate"
CssClass="" Format="MM/dd/yyyy" Enabled="True" PopupButtonID="txt_todate" />
</span>
</div>
<asp:Button Text="Insert" runat="server" OnClick="Insert" />
Namespaces
C#
using System.Data.SqlClient;
using System.Configuration;
VB.Net
Imports System.Data.SqlClient
Code
C#
protected void Insert(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO TestDate VALUES(@Date)", con))
{
cmd.Parameters.AddWithValue("@Date", txt_todate.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
VB.Net
Protected Sub Insert(ByVal sender As Object, ByVal e As EventArgs)
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As SqlConnection = New SqlConnection(constr)
Using cmd As SqlCommand = New SqlCommand("INSERT INTO TestDate VALUES(@Date)", con)
cmd.Parameters.AddWithValue("@Date", txt_todate.Text)
con.Open()
cmd.ExecuteNonQuery()
con.Close()
End Using
End Using
End Sub