asked on
<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>
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";