我的代码有问题.. [英] my code have a problem..

问题描述

我的数据库表用户

id int
电子邮件varchar(5000)
名称varchar(500)
ImageName varchar(500)


mydatabase表Scrap

id int
ToId int
FromId int
消息varchar(5000)
SendDate datetime



在我的代码中，我将消息发送给了我的朋友

这是代码

my database table User

Id int
Email varchar(5000)
Name varchar(500)
ImageName varchar(500)


mydatabase table Scrap

Id int
ToId int
FromId int
Message varchar(5000)
SendDate datetime



in my code i send the message to my friend

this is code

<pre lang="midl">string postScrap = "Insert INTO Scrap (FromId,ToId,Message) VALUES(''" + Session["Id"].ToString() + "'',''" + Request.QueryString["Id"].ToString() + "'',''" + TextBoxScrap.Text + "'')";
           dbClass.ConnectDataBaseToInsert(postScrap);
           Response.Redirect("UserDetails.aspx?Id=" + Request.QueryString["Id"].ToString());

<pre lang="xml"><div align="justify">
                               <%#DataBinder .Eval(Container.DataItem,"Message")%>
                                <br />
                                <br />
                            </div>
                            <span>Posted On: &nbsp;</span>
                            <asp:Label ID="lblSendDate" runat="server" Text=''<%# DataBinder.Eval(Container.DataItem,"SendDate") %>''></asp:Label>

这是在Gridview中显示消息的代码

Here is the code to display message in Gridview

 DataBaseClass dbClass = new DataBaseClass();
    public DataTable dt;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            GetUserScrap(int.Parse(Request.QueryString["Id"].ToString()));
        }
    }
    public void GetUserScrap(int Id)
    {
        string getUserScraps = "SELECT u.Id as UserId,u.Name,u.ImageName,s.FromId,s.ToId,s.Message,s.SendDate,s.ID as ScrapId FROM [User] as u, Scrap as s WHERE u.Id=s.FromId AND s.ToId=''" + Request.QueryString["Id"].ToString() + "''";
        dt = dbClass.ConnectDataBaseReturnDT(getUserScraps);
        if (dt.Rows.Count > 0)
        {
            GridViewUserScraps.DataSource = dt;
            GridViewUserScraps.DataBind();
        }
    }


Now Problem is that is sendDate is not displayed how to i enter sendDate on which I SendMessage and display that data on Gridview

推荐答案

IN C#

id int
ToId int
FromId int
消息varchar(5000)
SendDate VARCHAR(50)

现在，您可以在接口代码中使用

STRING DATE = DateTime.now.tostring();

使用DATE变量传入参数

IN C#

Id int
ToId int
FromId int
Message varchar(5000)
SendDate VARCHAR(50)

NOW U USE IN INTERFACE CODE

STRING DATE=DateTime.now.tostring();

use DATE variable pass in parameter

有两种方法:
1.将前端接口中的日期时间值插入数据库表.
发送DateTime.Now()
2.您可以在数据库表中定义日期时间字段，并使用函数getDate().

There are two ways:
1. Insert the date time value from front end interface into data base table.
send DateTime.Now()
2. You can define a date time field in database table and use function getDate().

这篇关于我的代码有问题..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！