How to format DateTime in GridView with LINQ to SQL data source?

Question

I have a GridView with LinqtoSQL data source.I am binding it in code.Here is the code

 DataClassesDataContext dContext = new DataClassesDataContext();
            var userId = (Guid)(Membership.GetUser(Membership.GetUser().UserName, false).ProviderUserKey);
            var Query = from d in dContext.table1
                              where d.UserId == userId
                              select new { d.date, d.weight, d.height, d.BMI };


            gv.DataSource = Query;
            gv.DataBind();

the d.date is DateTime column I like to show only the date how to format it? Thanks

Lion · Accepted Answer · 2015-03-01 11:55:57Z

1

code in aspx page

<asp:GridView ID="gridView1" runat="server" AutoGenerateColumns="false">
                <Columns>
                    <asp:BoundField DataField="Login_USER" HeaderText="Login User" />
                    <asp:BoundField DataField="Login_DATE" HeaderText="Login Date"
                        DataFormatString="{0:MM/dd/yyyy}" />
                </Columns>
            </asp:GridView>

======================================

code

Entities db = new Entities();

var users = from user in db.Logged_user select new {user.Login_USER, user.Login_DATE };

if(users != null)
{
     gridView1.DataSource = branches.ToList();
     gridView1.DataBind();
}

answered Mar 1, 2015 at 11:55

Lion

111 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Lea Cohen Over a year ago

Welcome to Stack Overflow! If you could please edit your answer and explain what the code you're showing does, and why/how that code answers the question, it would make your answer even more helpful.

vikifor · Accepted Answer · 2012-07-21 23:07:54Z

0

One of the ways to convert DateTime to show only date is this one

DateTime today=DateTime.Now;
string todayString=today.ToString();
string dateOnly=todayString.Split(' ')[0];

answered Jul 21, 2012 at 23:07

vikifor

3,4664 gold badges51 silver badges76 bronze badges

Comments

Kishor · Accepted Answer · 2012-08-08 12:14:04Z

0

var Query = from d in dContext.table1 
            where d.UserId == userId 
            select new { date = String.Format("{0:MM/dd/yyyy}", d.date), d.weight, d.height, d.BMI };

answered Aug 8, 2012 at 12:14

Kishor

2012 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to format DateTime in GridView with LINQ to SQL data source?

3 Answers 3

code in aspx page

code

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

code in aspx page

code

1 Comment

Comments

Comments

Related