注册日期代码......... [英] register date code .........

问题描述

如何获取注册日期

how to get register date

tablename User

ID            int
Email         varchar(500)
Password       varchar(500)
Name            varchar(500)
Country        varchar(500)
LastLogin            datetime
RegisterDate         datetime
Description          Varchar(500)
ImageName           varchar(500)

string chkUser = "Select * FROM [User] where Email='" + UserName + "' AND Password='" + Password + "'";
dt = dbClass.ConnectDataBaseReturnDT(chkUser);
if (dt.Rows.Count > 0)
{
    boolReturnValue = true;
    Session["UserId"] = dt.Rows[0]["Id"].ToString();
    string que = "UPDATE [User] SET LastLogin = GETDATE() where Id=" + Session["UserId"].ToString();

what logic i use



    dbClass.ConnectDataBaseToInsert(que);

推荐答案

尝试dis

Try dis

Session["UserId"] = dt.Rows[0].ItemArray[1].ToString();
Session["RegDate"] = dt.Rows[0].ItemArray[6].ToString();

要获取RegisterDate类型

To get RegisterDate type

// Get RegisterDate from row 0, column: RegisterDate
DateTime registerDate = (DateTime)dt.Rows[0]["RegisterDate"];

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