SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

Question

1.00/5 (1 vote)

See more:

Hi There,
Iam facing this above problem.I really dont know how to solve this problem.Please help me....................

Here is my code:

XML

<%@ Page Title="" Language="C#" MasterPageFile="~/Backend/Backend.Master" AutoEventWireup="true" CodeBehind="CalendarDevexpress.aspx.cs" Inherits="Buckshaw.Backend.WebForm7" %>

<%@ Register Assembly="DevExpress.Web.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>

<%@ Register Assembly="DevExpress.Web.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView.Export" TagPrefix="dx" %>
<%@ Register assembly="DevExpress.Web.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v13.1, Version=13.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<asp:Content ID="Content1" ContentPlaceHolderID="cphContent" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <p style="color: #C0C0C0">&nbsp;</p>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">

 <ContentTemplate>
    <dx:ASPxCalendar ID="ASPxCalendar1" runat="server" Theme="Default"
         AutoPostBack="False">
    </dx:ASPxCalendar>
    <br />
               <br />
          </ContentTemplate>
   </asp:UpdatePanel>


     <h1 style="color: #C0C0C0">Monthly Booking Details</h1>

    <p style="color: #C0C0C0">
        <asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="PDF" />


&nbsp;&nbsp;
        <asp:Button ID="Button4" runat="server" onclick="Button4_Click" Text="XLSX" />
            </p>
         <table class="BottomMargin">
        <tr>
            <td style="padding-right: 4px">
                <dx:ASPxButton ID="btnPdfExport" runat="server" Text="Export to PDF" UseSubmitBehavior="False"
                    OnClick="btnPdfExport_Click" />
            </td>
            <td style="padding-right: 4px">
                <dx:ASPxButton ID="btnXlsExport" runat="server" Text="Export to XLS" UseSubmitBehavior="False"
                    OnClick="btnXlsExport_Click" />
            </td>
            <td style="padding-right: 4px">
                <dx:ASPxButton ID="btnXlsxExport" runat="server" Text="Export to XLSX" UseSubmitBehavior="False"
                    OnClick="btnXlsxExport_Click" />
            </td>
            <td style="padding-right: 4px">
                <dx:ASPxButton ID="btnRtfExport" runat="server" Text="Export to RTF" UseSubmitBehavior="False"
                    OnClick="btnRtfExport_Click"/>
            </td>
            <td>
                <dx:ASPxButton ID="btnCsvExport" runat="server" Text="Export to CSV" UseSubmitBehavior="False"
                    OnClick="btnCsvExport_Click" />
            </td>
        </tr>
    </table>
<dx:ASPxGridViewExporter ID="gridExport0" runat="server" GridViewID="grid" PaperKind="A4" Landscape="True">
<Styles>
<Cell Font-Size="Medium"></Cell>
</Styles>
</dx:ASPxGridViewExporter>

    <p style="color: #C0C0C0">
        &nbsp;<asp:UpdatePanel ID="UpdatePanel2" runat="server">
      <Triggers>
        <asp:AsyncPostBackTrigger ControlID="ASPxCalendar1"  />
      </Triggers>
         <ContentTemplate>
          <asp:UpdateProgress ID="UpdateProgress1" runat="server" DisplayAfter="1" >
                <ProgressTemplate>
                    <div style="margin-top: 20px; font-size: larger; color: Green">
                        Processing, please wait ...
                    </div>
                </ProgressTemplate>
            </asp:UpdateProgress>

            <dx:ASPxGridView ID="grid" runat="server" AutoGenerateColumns="false"
                  SettingsPager-Mode="ShowAllRecords">
             <Columns>
                <dx:GridViewDataTextColumn FieldName="HouseID" VisibleIndex="0"   >
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="BookingID" ReadOnly="True"
                    VisibleIndex="1">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="PersonTitle" VisibleIndex="2">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="fName" VisibleIndex="3">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="sName" VisibleIndex="4">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Address1" VisibleIndex="5">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Address2" VisibleIndex="6">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Address3" VisibleIndex="7">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="City" VisibleIndex="8">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Postcode" VisibleIndex="9">
                </dx:GridViewDataTextColumn>

                <dx:GridViewDataTextColumn FieldName="Country" VisibleIndex="11">
                </dx:GridViewDataTextColumn>

                <dx:GridViewDataTextColumn FieldName="Mobile" VisibleIndex="13">
                </dx:GridViewDataTextColumn>

                <dx:GridViewDataTextColumn FieldName="SpecialRequirements" VisibleIndex="15">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataDateColumn FieldName="CheckinDate" VisibleIndex="16">
                </dx:GridViewDataDateColumn>
                <dx:GridViewDataDateColumn FieldName="CheckoutDate" VisibleIndex="17">
                </dx:GridViewDataDateColumn>
                <dx:GridViewDataTextColumn FieldName="Price" VisibleIndex="18">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="AmountPaid" VisibleIndex="19">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataCheckColumn FieldName="ReviewRequested" VisibleIndex="20">
                </dx:GridViewDataCheckColumn>

                <dx:GridViewDataCheckColumn FieldName="IsPending" VisibleIndex="22">
                </dx:GridViewDataCheckColumn>
                <dx:GridViewDataTextColumn FieldName="County" VisibleIndex="23">
                </dx:GridViewDataTextColumn>
            </Columns>
    </dx:ASPxGridView>



        </ContentTemplate>
        </asp:UpdatePanel>

    </p>









    <h1 style="color: #C0C0C0">
        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="PDF" />
&nbsp;
        <asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="XLSX" />
    </h1>
     <table class="BottomMargin">
        <tr>
            <td style="padding-right: 4px">
                <dx:ASPxButton ID="ASPxButton1" runat="server" Text="Export to PDF" UseSubmitBehavior="False"
                    OnClick="btn1PdfExport_Click" />
            </td>
            <td style="padding-right: 4px">
                <dx:ASPxButton ID="ASPxButton2" runat="server" Text="Export to XLS" UseSubmitBehavior="False"
                    OnClick="btn1XlsExport_Click" />
            </td>
            <td style="padding-right: 4px">
                <dx:ASPxButton ID="ASPxButton3" runat="server" Text="Export to XLSX" UseSubmitBehavior="False"
                    OnClick="btn1XlsxExport_Click" />
            </td>
            <td style="padding-right: 4px">
                <dx:ASPxButton ID="ASPxButton4" runat="server" Text="Export to RTF" UseSubmitBehavior="False"
                    OnClick="btn1RtfExport_Click"/>
            </td>
            <td>
                <dx:ASPxButton ID="ASPxButton5" runat="server" Text="Export to CSV" UseSubmitBehavior="False"
                    OnClick="btn1CsvExport_Click" />
            </td>
        </tr>
    </table>
     <asp:UpdatePanel ID="UpdatePanel3" runat="server">
    <Triggers>
        <asp:AsyncPostBackTrigger ControlID="ASPxCalendar1"  />
      </Triggers>
    <ContentTemplate>
        <h1 style="color: #C0C0C0">Booking Details of
      <asp:Label ID="Label1" runat="server" Text="Selected Date"></asp:Label>
    </h1>


    <p style="color: #C0C0C0; width: auto; height: auto;">
        &nbsp;</p>

        <dx:ASPxGridView ID="grid1" runat="server" AutoGenerateColumns="False"
            DataSourceID="SqlDataSourceBook" EnableTheming="True" KeyFieldName="BookingID"
            ClientInstanceName="grid">
            <Columns>
                <dx:GridViewDataTextColumn FieldName="HouseID" VisibleIndex="0"   >
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="BookingID" ReadOnly="True"
                    VisibleIndex="1">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="PersonTitle" VisibleIndex="2">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="fName" VisibleIndex="3">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="sName" VisibleIndex="4">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Address1" VisibleIndex="5">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Address2" VisibleIndex="6">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Address3" VisibleIndex="7">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="City" VisibleIndex="8">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Postcode" VisibleIndex="9">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="State" VisibleIndex="10">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Country" VisibleIndex="11">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Telephone" VisibleIndex="12">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Mobile" VisibleIndex="13">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Email" VisibleIndex="14">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="SpecialRequirements" VisibleIndex="15">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataDateColumn FieldName="CheckinDate" VisibleIndex="16">
                </dx:GridViewDataDateColumn>
                <dx:GridViewDataDateColumn FieldName="CheckoutDate" VisibleIndex="17">
                </dx:GridViewDataDateColumn>
                <dx:GridViewDataTextColumn FieldName="Price" VisibleIndex="18">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="AmountPaid" VisibleIndex="19">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataCheckColumn FieldName="ReviewRequested" VisibleIndex="20">
                </dx:GridViewDataCheckColumn>
                <dx:GridViewDataDateColumn FieldName="timeoutDate" VisibleIndex="21">
                </dx:GridViewDataDateColumn>
                <dx:GridViewDataCheckColumn FieldName="IsPending" VisibleIndex="22">
                </dx:GridViewDataCheckColumn>
                <dx:GridViewDataTextColumn FieldName="County" VisibleIndex="23">
                </dx:GridViewDataTextColumn>
            </Columns>
        </dx:ASPxGridView>


    <p style="color: #C0C0C0">&nbsp;&nbsp;&nbsp;<asp:SqlDataSource ID="SqlDataSourceGrid"
            runat="server"></asp:SqlDataSource>

    </p>

    <p style="color: #C0C0C0">
        <asp:SqlDataSource ID="SqlDataSourceBook" runat="server"
            ConnectionString="<%$ ConnectionStrings:BuckshawHomesConnectionString %>"

            SelectCommand="SELECT * FROM [tblBooking] WHERE ([CheckinDate] = @CheckinDate)"
          >
            <SelectParameters>
                <asp:ControlParameter ControlID="ASPxCalendar1" Name="CheckinDate"
                    PropertyName="SelectedDate" Type="DateTime" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p style="color: #C0C0C0">
        <asp:SqlDataSource ID="SqlDataSourceCalendar" runat="server"
            ConnectionString="<%$ ConnectionStrings:BuckshawHomesConnectionString %>"
            SelectCommand="SELECT [CheckinDate] FROM [tblBooking]"></asp:SqlDataSource>
    </p>
    <p style="color: #C0C0C0">&nbsp;</p>
    <p style="color: #C0C0C0">&nbsp;</p>
        <dx:ASPxGridViewExporter ID="gridExport" runat="server" GridViewID="grid1" Landscape="True">
        </dx:ASPxGridViewExporter>


    <br />
    </ContentTemplate>
    </asp:UpdatePanel>
    </asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="cphHeader" runat="server">
</asp:Content>

and C# Code is:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.html.simpleparser;
using System.IO;
using System.Drawing;
using DevExpress.Web.ASPxGridView;
using DevExpress.Web.ASPxGridView.Export;

namespace Buckshaw.Backend
{
public partial class WebForm7 : System.Web.UI.Page
{

SqlConnection conn = new SqlConnection("Data Source=Dcil-226;Initial Catalog=BuckshawHomes;");
protected DataSet dsBooking;
DataView todo = new DataView();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ASPxCalendar1.VisibleDate = DateTime.Today;
FillBookingDataset();

}

}
protected void FillBookingDataset()
{

DateTime firstDate = new DateTime(ASPxCalendar1.VisibleDate.Year,
ASPxCalendar1.VisibleDate.Month, 1);
DateTime lastDate = GetFirstDayOfNextMonth();
dsBooking = GetCurrentMonthData(firstDate, lastDate);

}

protected DateTime GetFirstDayOfNextMonth()
{
int monthNumber, yearNumber;
if (ASPxCalendar1.VisibleDate.Month == 12)
{
monthNumber = 1;
yearNumber = ASPxCalendar1.VisibleDate.Year + 1;
}
else
{
monthNumber = ASPxCalendar1.VisibleDate.Month + 1;
yearNumber = ASPxCalendar1.VisibleDate.Year;
}
DateTime lastDate = new DateTime(yearNumber, monthNumber, 1);
return lastDate;
}
public override void VerifyRenderingInServerForm(Control control)
{
/* Verifies that the control is rendered */
}

protected DataSet GetCurrentMonthData(DateTime firstDate,
DateTime lastDate)
{
DataSet dsMonth = new DataSet();
ConnectionStringSettings cs;
cs = ConfigurationManager.ConnectionStrings["BuckshawHomesConnectionString"];
String connString = cs.ConnectionString;
SqlConnection dbConnection = new SqlConnection(connString);
dbConnection.Open();

String query;
query = "SELECT HouseID,BookingID,PersonTitle,fName,sName,Address1,Address2,Address3,City,Postcode,Country,Mobile,SpecialRequirements, CheckinDate,CheckoutDate,Price,AmountPaid,ReviewRequested,IsPending,County FROM tblBooking " +
" WHERE CheckinDate >= @firstDate AND CheckinDate < @lastDate";
SqlCommand dbCommand = new SqlCommand(query, dbConnection);
dbCommand.Parameters.Add(new SqlParameter("@firstDate", firstDate));

dbCommand.Parameters.Add(new SqlParameter("@lastDate", lastDate));

SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(dbCommand);
sqlDataAdapter.Fill(dsMonth);

//ASPxGridView1.DataSourceID = "SqlDataSourceBook";

grid.DataSource = dsMonth;
grid.DataBind();

dbConnection.Close();
try
{
sqlDataAdapter.Fill(dsMonth);
}
catch { }
return dsMonth;

}

protected void ASPxCalendar1_DayRender(object sender, DayRenderEventArgs e)
{
DateTime nextDate;
if (dsBooking != null)
{
foreach (DataRow dr in dsBooking.Tables[0].Rows)
{
nextDate = (DateTime)dr["CheckinDate"];
if (nextDate == e.Day.Date)
{
e.Cell.BackColor = System.Drawing.Color.CadetBlue;
}
}
}
else
if (todo.FindRows(e.Day.Date).Length > 0)
{
e.Cell.BackColor = System.Drawing.Color.Indigo;
}
}

protected void ASPxCalendar1_VisibleMonthChanged(object sender, MonthChangedEventArgs e)
{
FillBookingDataset();

}
void Page_PreRender()
{
FillBookingDataset();
todo = (DataView)SqlDataSourceCalendar.Select(DataSourceSelectArguments.Empty);
todo.Sort = "CheckinDate";

}

protected void ASPxCalendar1_SelectionChanged(object sender, EventArgs e)
{
FillBookingDataset();
Label1.Text = ASPxCalendar1.SelectedDate.ToShortDateString();

}

//protected void btnPdfExport_Click(object sender, EventArgs e)
//{
// // //gridExport.WritePdfToResponse();
// iTextSharp.text.Table table = new iTextSharp.text.Table(ASPxGridView1.Columns.Count);
// table.Cellpadding = 2;
// table.Width = 100;
// FillBookingDataset();
// //Transfer rows from GridView to table
// for (int i = 0; i < ASPxGridView1.Columns.Count; i++)
// {
// string cellText = Server.HtmlDecode
// (ASPxGridView1.Columns[i].HeaderText);

// iTextSharp.text.Cell cell = new iTextSharp.text.Cell(cellText);
// cell.BackgroundColor = new iTextSharp.text.Color(System.Drawing
// .ColorTranslator.FromHtml("#93a31d"));
// table.AddCell(cell);
// }

// for (int i = 0; i < ASPxGridView1.Rows.Count; i++)
// {
// if (ASPxGridView1.Rows[i].RowType == DataControlRowType.DataRow)
// {
// for (int j = 0; j < ASPxGridView1.Columns.Count; j++)
// {
// string cellText = Server.HtmlDecode
// (ASPxGridView1.Rows[i].Cells[j].Text);
// iTextSharp.text.Cell cell = new iTextSharp.text.Cell(cellText);

// //Set Color of Alternating row
// if (i % 2 != 0)
// {
// cell.BackgroundColor = new iTextSharp.text.Color(System.Drawing.ColorTranslator.FromHtml("#dce0bc"));
// }
// table.AddCell(cell);
// }
// }
// }

// Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
// PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
// pdfDoc.Open();
// pdfDoc.Add(table);
// pdfDoc.Close();
// Response.ContentType = "application/pdf";
// Response.AddHeader("content-disposition", "attachment;" +
// "filename=DynamicReport.pdf");
// Response.Cache.SetCacheability(HttpCacheability.NoCache);
// Response.Write(pdfDoc);
// Response.End();
//}

protected void Button2_Click(object sender, EventArgs e)
{

gridExport.WriteXlsxToResponse();
}

protected void Button1_Click(object sender, EventArgs e)
{
gridExport0.WritePdfToResponse();
}

protected void Button4_Click(object sender, EventArgs e)
{
FillBookingDataset();
gridExport0.WriteXlsToResponse();
}

protected void Button3_Click(object sender, EventArgs e)
{
FillBookingDataset();

gridExport0.WritePdfToResponse();
}
protected void btnPdfExport_Click(object sender, EventArgs e)
{
FillBookingDataset();
gridExport0.WritePdfToResponse();
}
protected void btnXlsExport_Click(object sender, EventArgs e)
{
FillBookingDataset();
gridExport0.WriteXlsToResponse();
}
protected void btnXlsxExport_Click(object sender, EventArgs e)
{
FillBookingDataset();
gridExport0.WriteXlsxToResponse();
}
protected void btnRtfExport_Click(object sender, EventArgs e)
{
FillBookingDataset();
gridExport0.WriteRtfToResponse();
}
protected void btnCsvExport_Click(object sender, EventArgs e)
{

gridExport.WriteCsvToResponse();
}
protected void btn1PdfExport_Click(object sender, EventArgs e)
{

gridExport.WritePdfToResponse();
}
protected void btn1XlsExport_Click(object sender, EventArgs e)
{

gridExport.WriteXlsToResponse();
}
protected void btn1XlsxExport_Click(object sender, EventArgs e)
{

gridExport.WriteXlsxToResponse();
}
protected void btn1RtfExport_Click(object sender, EventArgs e)
{

gridExport.WriteRtfToResponse();
}
protected void btn1CsvExport_Click(object sender, EventArgs e)
{

gridExport0.WriteCsvToResponse();
}
//protected void ASPxGridView1_DataBinding(object sender, EventArgs e)
//{
// FillBookingDataset();
//}

//protected void btnXlsxExport_Click(object sender, EventArgs e)
//{
// gridExport.WriteXlsxToResponse();
//}
//protected void btnRtfExport_Click(object sender, EventArgs e)
//{
// gridExport.WriteRtfToResponse();
//}
//protected void btnCsvExport_Click(object sender, EventArgs e)
//{
// gridExport.WriteCsvToResponse();
//}
//private void BindData()
//{

// DataSet ds = new DataSet();
// conn.Open();
// string cmdstr = "Select Top 10 HouseID,BookingID,fName,City,Country from tblBooking";

// SqlDataAdapter adp = new SqlDataAdapter(cmdstr, conn);
// adp.Fill(ds);
// ASPxGridView1.DataSource = ds;
// ASPxGridView1.DataBind();
// conn.Close();
//}

// protected void btnPDF_Click(object sender, ImageClickEventArgs e)
// {
// int columns = ASPxGridView1.Columns.Count;
// int rows = ASPxGridView1.Rows.Count;
// int tableRows = rows + 3;
// iTextSharp.text.Table gvTable = new iTextSharp.text.Table(columns, tableRows);
// gvTable.BorderWidth = 1;
// gvTable.BorderColor = new iTextSharp.text.Color(0, 0, 255);
// gvTable.Cellpadding = 5;
// gvTable.Cellspacing = 5;
// Cell c1 = new Cell("Create PDF From GridView Example In Asp.Net");
// c1.Header = true;
// c1.Colspan = 2;
// gvTable.AddCell(c1);
// Cell c2 = new Cell("By www.CsharpAspNetArticles.com");
// c2.Colspan = 2;
// gvTable.AddCell(c2);
// gvTable.AddCell("Name"); gvTable.AddCell("Location");

// for (int rowCounter = 0; rowCounter < rows; rowCounter++)
// {
// for (int columnCounter = 0; columnCounter < columns; columnCounter++)
// {
// string strValue = ASPxGridView1.Rows[rowCounter].Cells[columnCounter].Text;
// gvTable.AddCell(strValue);
// }
// }
// Document Doc = new Document();
// PdfWriter.GetInstance(Doc, Response.OutputStream);
// Doc.Open();
// Doc.Add(gvTable);
// Doc.Close();
// Response.ContentType = "application/pdf";
// Response.AddHeader("content-disposition", "attachment; filename=GridView.pdf");
// Response.End();

//}

}
}

Posted 17-Mar-14 4:06am

dps2305

Updated 17-Mar-14 4:08am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vedat Ozan Oner · Answer 1 · 2014-03-17T04:18:00

Solution 1

I haven't read all of your code (and I can't) but the problem is invalid mssql datetime value. you have to validate user input (check if it is between that range) before sending it to the database. if it is not in range, you should warn user, or if that date field is not compulsory, you can send a null value (in case of your db design supports null for the field).
the same question:
how to solve the sqldatetime overflow error[^]

Posted 17-Mar-14 4:18am

Vedat Ozan Oner

Updated 17-Mar-14 4:20am

v2

Comments

Rob Philpott 17-Mar-14 13:48pm

Sounds likely. I have no intention of reading all that, but this is a common error with a DateTime whose value has not been set, it defaults to DateTime.MinValue which is far too long ago for SQL Server!

Vedat Ozan Oner 18-Mar-14 3:33am

Possibly.