Hi Vikas0001,
Refer below sample.
HTML
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<link rel="stylesheet" href="https://code.jquery.com/ui/1.12.1/themes/pepper-grinder/jquery-ui.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript" src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
<script type="text/javascript" src="https://cdn.rawgit.com/dubrox/Multiple-Dates-Picker-for-jQuery-UI/master/jquery-ui.multidatespicker.js"></script>
<script type="text/javascript">
$(function () {
$('[id*=txtStartName]').multiDatesPicker({
dateFormat: 'mm/dd/yy',
minDate: 0
});
$('[id*=txtEndDate]').multiDatesPicker({
dateFormat: 'mm/dd/yy',
minDate: 0
});
});
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
StartName :
<asp:TextBox ID="txtStartName" runat="server"></asp:TextBox>
<br />
EndDate :
<asp:TextBox ID="txtEndDate" runat="server"></asp:TextBox>
<br />
<asp:Button Text="Insert" runat="server" OnClick="Insert" />
<br />
<asp:GridView ID="gvDates" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Date" HeaderText="Date" DataFormatString="{0:MM/dd/yyyy}" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
Namespaces
C#
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
VB.Net
Imports System.Data
Imports System.Data.SqlClient
Code
C#
protected void Insert(object sender, EventArgs e)
{
SqlConnection con = null;
SqlCommand cmd = null;
for (DateTime date = Convert.ToDateTime(txtStartName.Text); date <= Convert.ToDateTime(txtEndDate.Text); date = date.AddDays(1))
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
cmd = new SqlCommand("INSERT INTO TestDemo VALUES(@Date)", con);
cmd.Parameters.AddWithValue("@Date", date);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
cmd = new SqlCommand("SELECT * FROM TestDemo", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
gvDates.DataSource = dt;
gvDates.DataBind();
}
VB.Net
Protected Sub Insert(ByVal sender As Object, ByVal e As EventArgs)
Dim con As SqlConnection = Nothing
Dim cmd As SqlCommand = Nothing
Dim date1 As DateTime = Convert.ToDateTime(txtStartName.Text)
While date1 <= Convert.ToDateTime(txtEndDate.Text)
con = New SqlConnection(ConfigurationManager.ConnectionStrings("constr").ConnectionString)
cmd = New SqlCommand("INSERT INTO TestDemo VALUES(@Date)", con)
cmd.Parameters.AddWithValue("@Date", date1)
con.Open()
cmd.ExecuteNonQuery()
con.Close()
date1 = date1.AddDays(1)
End While
cmd = New SqlCommand("SELECT * FROM TestDemo", con)
Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
Dim dt As DataTable = New DataTable()
da.Fill(dt)
gvDates.DataSource = dt
gvDates.DataBind()
End Sub
Screenshot
