While click the link button will automatically insert the current date.

Question

While click the link button will automatically insert the current date in my table how to do that? Thanks&Regs Magesh.A

Senthilkumar · Answer

Hi Create the table. CREATE TABLE Views ( SNO INT IDENTITY(11) PRIMARY KEY UserID INT ViewedDate DATETIME DEFAULT GETDATE() ) Design page: Untitled Page onclick=lbtnInsert_Click> Code File: using System; using System.Collections; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; public partial class ViewInsert : System.Web.UI.Page { protected void Page_Load(object sender EventArgs e) { } protected void lbtnInsert_Click(object sender EventArgs e) { try { SqlConnection sqlConnection = new SqlConnection(); sqlConnection.ConnectionString = @Data Source=SS438\SQLEXPRESS;Initial Catalog=Examples;Integrated Security=true;; sqlConnection.Open(); string sqlQuery = INSERT INTO Views(UserID) VALUES (@UserID); SqlCommand sqlCommand = new SqlCommand(sqlQuery sqlConnection); sqlCommand.CommandType = CommandType.Text; Random random = new Random(1); sqlCommand.Parameters.Add(UserID SqlDbType.VarChar).Value = random.Next(10000); sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); lblMessage.Text = Inserted successfully...; } catch (Exception ex) { Response.Write(ex.Message); } } } Hope this will help you...