Insert (Save) DateTime from HTML TextBox in database using C# and VB.Net in ASP.Net

Hi marouane,

Refer below code.

HTML

<input type="text" name="txtDateTime" value="2020/06/27 16:15" />
<asp:Button Text="Insert" runat="server" OnClick="OnInsert" />

Namespaces

C#

using System.Configuration;
using System.Data.SqlClient;

VB.Net

Imports System.Configuration
Imports System.Data.SqlClient

Code

C#

protected void OnInsert(object sender, EventArgs e)
{
    DateTime dt = DateTime.Parse(Request.Form["txtDateTime"]);
    string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        string query = "INSERT INTO dateee (date_go) VALUES (@Date)";
        using (SqlCommand cmd = new SqlCommand(query))
        {
            cmd.Connection = con;
            cmd.Parameters.AddWithValue("@Date", dt);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
}

VB.Net

Protected Sub OnInsert(ByVal sender As Object, ByVal e As EventArgs)
    Dim dt As DateTime = DateTime.Parse(Request.Form("txtDateTime"))
    Dim constr As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
    Using con As SqlConnection = New SqlConnection(constr)
        Dim query As String = "INSERT INTO dateee (date_go) VALUES (@Date)"
        Using cmd As SqlCommand = New SqlCommand(query)
            cmd.Connection = con
            cmd.Parameters.AddWithValue("@Date", dt)
            con.Open()
            cmd.ExecuteNonQuery()
            con.Close()
        End Using
    End Using
End Sub