Click here to Skip to main content
16,014,613 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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>









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


Posted
Updated 2-Jun-11 0:48am
v2
Comments
gowthammanju 2-Jun-11 6:47am    
u can use following to retrive dates such as

gettype(),DateTime.Now.ToShortDateString()


just assign that to label
[no name] 2-Jun-11 16:11pm    
how to assign to label plz give me code

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
 
Share this answer
 
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().
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900