how to insert current date into database

Its always better to Tag a Question with all possible related technologies(including RDBMS) you are using.

I do not recommend you to use .Net/C# syntax/code to save Current Date. Because on Production, Time-Zone of your Web-Server and Database-Server may not be same.

Use below syntax to get Current DateTime of your DB-Server.

1) SQL Server
http://www.w3schools.com/sql/func_getdate.asp

2) Oracle
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions172.htm

3) MySQL
http://www.w3schools.com/sql/func_now.asp

4) DB2
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0005870.html

For SQL : getdate();

For C# : DateTime.Now; or DateTime.ToDay;

If the field is varchar then,

DateTime.Now.ToString("dd/MM/yyyy");
or
DateTime.ToDay.ToString("dd/MM/yyyy");

if the datatype of your date column in your database is datetime then in button click you can use directly

DateTime.Now

or if it is varchar type you can pass like this

DateTime.Now.ToString()

or if you write stored procedure for inserting the record in stored procedure you can write like
getdate() function in sqlserver returns the current date and time

getdate()

You can do it byusing Codebehind or SQL

using SQL

SELECT GETDATE()

using code behind

DateTime.Now.Date.ToString("MM/dd/yyyy") ;

I cannot provide whole code. Use Getdate() function to get Current datetime function.

Like

Insert Into Abc(FieldName) Values (getdate())

DateTime.ParseExact(yourControlId,"dd/MM/yyyy",null);

hi,

use

select GetDate() function

DateTime.Now.Tostring("mm/dd/yyyy");