the code below keeps throwing an exception throw new NotImplementedException() and I m am not sure how to fix it. I am trying to capture the datetime returned by the stored procedure below.
public void FormCarry_Load(object sender, EventArgs e)
{
System.DateTime? test;
test = new System.DateTime(2013, 04, 22);
// spMaxDateinGreeks test2 = new spMaxDateinGreeks();
test = (DateTime)spMaxDateinGreeks(ref test);
monthCalendarAdv1.Value = test.Value;
monthCalendarAdv1.Value = new System.DateTime(2013, 04, 22);
}
private DateTime spMaxDateinGreeks(ref DateTime? test)
{
throw new NotImplementedException();
}
ALTER PROCEDURE [dbo].[spMaxDateinGreeks] (@returneddate datetime OUTPUT)
--spMaxDateinGreeks null
AS
SET NOCOUNT ON;
--if @InqDate is null
Select @returneddate= max(valuationdate)
from Greeks
RETURN
EDIT: @Sam This is what's implemented by the designer
public virtual int spMaxDateinGreeks(ref global::System.Nullable<global::System.DateTime> returneddate) {
global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));
if ((returneddate.HasValue == true)) {
command.Parameters[1].Value = ((System.DateTime)(returneddate.Value));
}
else {
command.Parameters[1].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = command.Connection.State;
if (((command.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
command.Connection.Open();
}
int returnValue;
try {
returnValue = command.ExecuteNonQuery();
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
command.Connection.Close();
}
}
if (((command.Parameters[1].Value == null)
|| (command.Parameters[1].Value.GetType() == typeof(global::System.DBNull)))) {
returneddate = new global::System.Nullable<global::System.DateTime>();
}
else {
returneddate = new global::System.Nullable<global::System.DateTime>(((global::System.DateTime)(command.Parameters[1].Value)));
}
return returnValue;
}
It's right there in your code
private DateTime spMaxDateinGreeks(ref DateTime? test)
{
throw new NotImplementedException();
}
It means exactly what it says, Your method is not implemented yet. It doesn't do anything. It's only there as a placeholder.
You should either implement spMaxDateinGreeks
, or stop calling it.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With