I am trying to convert the vb code in the book to c#, and am trying to import the onlinediary with a using statement. Is there an alternate method? I have tried instantiating the class and referencing the object in the calls to the methods defined in the class. Same problem applies to the diaryentry and diaryevent classes.

Thanks for any help with this.


Tom

__________________
Thomas G Magaro

what exactly is d error msg?

__________________
busteronline

I'm not really sure.

I've tried running the debugger on it, but it the code executes fine, but I am getting the stack trace screen saying that a field count is being accessed after the reader is closed. Like I said, it is executing all the code fine.

By the way, this is happening right after I complete the login process.

Here is the code:

<code>
publicstaticSqlDataReader GetDiaryEventsByDate(
int diaryId, DateTime fromDate, DateTime toDate)
{
SqlConnection conn = newSqlConnection(
"data source=tommagaro-pc; initial catalog=diarydb; integrated security=true");
SqlCommand cmd = newSqlCommand("GetDaysWithEvents", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DiaryId", diaryId);
cmd.Parameters.AddWithValue("@EventFromDate", fromDate);
cmd.Parameters.AddWithValue("@EventToDate", toDate);
//cmd.Parameters.AddWithValue("@MaxRows", 0);
conn.Open();
SqlDataReader eventSQLDR = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Dispose();
conn.Close();
conn.Dispose();
return eventSQLDR;
}
</code>

It's when it finishes this code that it just jumps to the stack trace page.

Tom

__________________
Thomas G Magaro

Hi there,

A SqlDataReader needs an open connection in order to work successfully. In your code, you're closing the connection in the function that gets the reader. By the time the reader returns at the calling code the underlying connection is closed and the reader will fail. To fix this, don't close and dispose the connection object. The enum CommandBehavior.CloseConnection will automatically close the connection when it's done reading.

If you look at the original VB code you see it follows the same pattern in this function.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Hey Imar,

Once again, thanks. However, I am still getting the error, and I think it is because of the temporary files that VWD produces during the compile process were still coming up in a find of the entire solution on the term dispose. Is there any way of deleting these files so that I can get a whole new build.

Tom

__________________
Thomas G Magaro

They should be recreated whenever you compile. You could try renaming the project and then opening it in VS; this should give you a clean folder. Alternatively, just delete the files from the folder that contains your temporary file.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!