一、读取时间
分别获得年-月-日和时:分:秒
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;
string crdate = DateTime.Now.ToString("yyyy-MM-dd");
string crtime = DateTime.Now.ToString("HH:mm:ss");
二、写到数据库
数据库有2个字段,crdate为DATE型字段,crtime为TIME型字段
编写C#后台代码
Connection.Open();//打开数据库
MySqlCommand cmd = new MySqlCommand("insert into table1 set username=@username , psw=@psw , userrights=@userrights , crdate=@crdate , crtime=@crtime", Connection);
cmd.Parameters.AddWithValue("@username", username);
cmd.Parameters.AddWithValue("@psw", psw);
cmd.Parameters.AddWithValue("@userrights", userrights);
cmd.Parameters.AddWithValue("@crdate", crdate);
cmd.Parameters.AddWithValue("@crtime", crtime);
if (cmd.ExecuteNonQuery() > 0)
{
Response.Write("<script>alert('成功')</script>");
}
else
{
Response.Write("<script>alert('失败')</script>");
}
写入结果