将varchar数据类型转换为日期时间数据类型会导致超出范围的值 [英] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

问题描述

这是我的HTML代码： -

Here's My HTML Code:-

<div class="col-lg-3 col-md-3" style="float: left">
               <asp:DataList runat="server" ID="dataimg" RepeatColumns="4" RepeatDirection="Horizontal" ItemStyle-CssClass="panel panel-default">
                   <ItemTemplate>
                       <li class="list-group-item list-group" style="width: 200px">
                           <asp:HyperLink ID="HyperLink1" NavigateUrl='<%# String.Concat("Img/",Eval("image")) %>'
                               Target="_blank" runat="server">
                               <img src='Img/<%#Eval("image") %>' alt="15aug" width="160px" height="160px" />
                           </asp:HyperLink>
                           <asp:Label ID="Label1" runat="server" CssClass="text text-default" Font-Size="12px" Text='<%#Eval("detail") %>'></asp:Label>
                           <%--<label id="label">
                               <a href="<%#"design.aspx?pid="+Eval("ID") %>">View Details</a></label>--%>
                       </li>
                   </ItemTemplate>
               </asp:DataList>
           </div>

C＃代码： -

C# Code:-

protected void Unnamed1_Click(object sender, EventArgs e)
   {
       // NB: The "as" operator can return null:
       LinkButton lnk = sender as LinkButton;
       if (lnk == null)
       {
           throw new InvalidOperationException("sender is not a LinkButton!");
       }

       DateTime theDate;
       // NB: If your date is in a specific format, use TryParseExact instead.
       string format = "dd-MM-yyyy";
       if (!DateTime.TryParseExact(lnk.Text, format, null, DateTimeStyles.None, out theDate))
       {
           // The text is not a valid date:
           throw new FormatException(string.Format("The value '{0}' is not a valid date.", lnk.Text));
       }

       TextBox1.Text = lnk.Text;

       using (SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["str"]))
       using (SqlCommand cmd = new SqlCommand("SELECT * FROM date1 WHERE ddate = @ddate", con1))
       {
           cmd.Parameters.AddWithValue("@ddate", theDate.Date);

           DataSet ds1 = new DataSet();
           SqlDataAdapter da1 = new SqlDataAdapter(cmd);
           da1.Fill(ds1);

           dataimg.Visible = true;
           dataimg.DataSource = ds1;
           dataimg.DataBind();
       }
   }

推荐答案

上述错误消息的任何可能原因，你会发现此处 [ ^ ]。

Any possible reason of above error message, you'll find here[^].

这篇关于将varchar数据类型转换为日期时间数据类型会导致超出范围的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！