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

Hi,

Create the table.

CREATE TABLE Views

(

SNO INT IDENTITY(1,1) PRIMARY KEY

,UserID INT

,ViewedDate DATETIME DEFAULT GETDATE()

)

Design page:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ViewInsert.aspx.cs" Inherits="ViewInsert" %>

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...

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Hi,

Create the table.

CREATE TABLE Views
(
SNO INT IDENTITY(1,1) PRIMARY KEY
,UserID INT
,ViewedDate DATETIME DEFAULT GETDATE()
)

Design page:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ViewInsert.aspx.cs" Inherits="ViewInsert" %>

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...

0