Avatar of JacksonJoe
JacksonJoe

asked on 

DATE TIME PICKER THROWING NULL REFERENCE ERROR

I am receiving the following error with my DateTime control.   This is a JQuery Plugin from http://xdsoft.net/jqplugins/datetimepicker/ (see attachment)

System.NullReferenceException: Object reference not set to an instance of an object.

Markup Code:
<input type="text" placeholder="Select Date & Time" value="" id="datetimepicker"/></p>
    <p>
    </p>
    <p>
                    <asp:Button ID="button1" runat="server" Text="Submit" 
                        onclick="btnSubmit_Click" CssClass="button1"/>
                </p>
    <p>
    </p>
    <p>
                <asp:Label ID="Label1" runat="server" EnableViewState="False" 
                    ForeColor="#009900" Text="Label" Visible="False"></asp:Label>

Open in new window


Code Behind:
SqlCommand cmd = new SqlCommand("Insert into AOS(EventDateTime1) VALUES (@EventDateTime1)", con);

        // cmd.Parameters.Add("@Ship", System.Data.SqlDbType.NVarChar, 50).Value = Ship.SelectedValue;
        // cmd.Parameters.Add("@Station", System.Data.SqlDbType.NVarChar, 50).Value = Station.SelectedValue;

        var dt = DateTime.ParseExact(Request["datetimepicker"].Trim(), "MM/dd/yyyy g:i A", CultureInfo.InvariantCulture);
        cmd.Parameters.Add("@EventDateTime1", System.Data.SqlDbType.DateTime, 8).Value = dt;

        //cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar, 50).Value = UpdatedBy.SelectedValue;
        //cmd.Parameters.Add("@EventCode", SqlDbType.NVarChar, 100).Value = EventCode.SelectedValue;
        //cmd.Parameters.Add("@ReasonCode", System.Data.SqlDbType.NVarChar, 50).Value = ReasonCode.SelectedValue;
        //cmd.Parameters.Add("@StatusCode", System.Data.SqlDbType.NVarChar, 50).Value = StatusCode.SelectedValue;
        //cmd.Parameters.Add("@ShortDesc", System.Data.SqlDbType.NVarChar, 4000).Value = ShortDesc.Text;
        //cmd.Parameters.Add("@EntryTime", System.Data.SqlDbType.DateTime, 8).Value = DateTime.Now;    // --------Entry Time
        cmd.ExecuteNonQuery();
        con.Close();
        Label1.Visible = true;
        Label1.Text = "Data Stored Successfully";

Open in new window

C#Visual Basic.NETASP.NET

Avatar of undefined
Last Comment
JacksonJoe

8/22/2022 - Mon