C# ASP.NET怎样把当前系统时间存入数据库

一、读取时间

分别获得年-月-日和时:分:秒

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>");
                                    }

写入结果