我想只在gridview中的linkbutton中获取日期。 [英] I want to get only the date in the linkbutton in gridview.

问题描述

嘿大家。



到目前为止，我试过这个： -

Hey Everybody.

So far I've tried this:-

<pre lang="xml"><asp:DataList runat="server" ID="dataimg" RepeatColumns="4" RepeatDirection="Horizontal" CssClass="separator">
                       <ItemTemplate>
                           <li class="list-group-item list-group" style="max-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" style="max-width:200px" Width="200px" Text='<%#Eval("detail") %>'></asp:Label>
                               <%--<label id="label">
                                   <a href="<%#"design.aspx?pid="+Eval("ID") %>">View Details</a></label>--%>
                           </li>
                       </ItemTemplate>
                   </asp:DataList>

和onclick我的代码是： -

and onclick my code is this:-

protected void Unnamed1_Click(object sender, EventArgs e)
    {
        LinkButton lnk = sender as LinkButton;
        TextBox1.Text =  lnk.Text;
        SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["str"]);
        SqlDataAdapter da1 = new SqlDataAdapter("Select * from date1 where ddate='" + TextBox1.Text + "'", con1);
        con1.Open();
        DataSet ds1 = new DataSet();
        da1.Fill(ds1, "date1");
        dataimg.DataSource = ds1;
        dataimg.DataBind();

        con1.Close();

    }

我的数据表日期1如下： -

My Datatable date1 is as under:-

<br />
RefrenceNo       bigint	<br />
ddate	         date	<br />
image	         varchar(MAX)	<br />
detail	         varchar(MAX)	<br />
groups	         varchar(15)	

我的问题是我只想显示日期，但我在文本框中同时获得日期和时间。



请帮助。

My problem is I want to only show the date but I'm getting both date and time in textbox.

Please Help.

推荐答案

尝试这样的事情：

Try something like this:

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.
    if (!DateTime.TryParse(lnk.Text, out theDate))
    {
        // The text is not a valid date:
        throw new FormatException(string.Format("The value '{0}' is not a valid date.", 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.DataSource = ds1;
        dataimg.DataBind();
    }
}

这篇关于我想只在gridview中的linkbutton中获取日期。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！