Are begDate and endDate actually strings with the values "2007-11-18", "2007-12-31" respectively?
And what is the type of data in row(1)? Is it also a string, or is it a date?
If it is a date in that column, then it seems possible that taking the ToString() from date values is not using the same format as begDate and endDate are representing the date.
I'd suggest doing the comparison as date (DateTime) values to avoid any issues with cultural-specific date formatting.

In a C# 2010 application that I am working on, I want to use linq to sql to update 2 tables in a sql server 2008 database.

I want to do the following:
create new Table1 object ;
InsertOnSubmit(tbl1)
**Table 1 will contain the primary key.
create new Table2 object;
table2 will contain a foreign key column that refers to primary key in
table1 object.
InsertOnSubmit(tbl2)
SubmitChanges()

Before and/or right after the submitchanges() event occurs, I would like to know what the value is for the primary key in table1 and the foreign key value is in table2. I would like to know what the table key value is so I can display this information on reports that will be generated right after the record(s) have been inserted into the database. Thus can you tell me how to determine what the primary key value is for table1 that also refers to the foreign key value in table 2?

Why is common sense not common?Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazyPlease stand in front of my pistol, smile and wait for the flash - JSOP 2012

The SP isn't returning a value. The 'return value' could be coming from anywhere, even being just what was lying around in some piece of memory from the previous query. If you want to check that the insert statement worked, don't SET NOCOUNT and return the result of it from the SP.