I wrote a stored procedure in sql 2005 that returns 14 rows when I run it directly from management studio. When I call the same stored procedure from .net with the same parameter, it returns 13 rows. I'm using SqlDataAdapter and have never had a problem like this with it before. Any suggestions? Nothing stands out with the one missing row. It's pretty much in the middle of the dataset with simliar data as the rest of the rows (but different enough to not be excluded in a SELECT DISTINCT).
sqlConnection = new SqlConnection(SQLCONNECTIONSTR);
DataTable dtOrderData = new DataTable();
SqlCommand cmd = new SqlCommand("TestingSTP", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Parameter1", SqlDbType.Int).Value = cartData.ClientID;
SqlDataAdapter da = new SqlDataAdapter(cmd);