| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 December 2007 January 2008 February 2008 March 2008 April 2008 |
Filter by week: 1 2 3 4 5 Connection works but returns no records Posted by auntiejack56 at 4/20/2008 4:04:41 AM Hi, I have been studying the books (2 ADO.NET and 1 VB.NET) and still
can't work out why the records in the database aren't being read.
>>>>
Dim sConString As String = "Data Source=.
\SQLEXPRESS;AttachDbFilename=""C:\Active Access Library\FigaroNET
\Figaro\Figaro\FigaroData.mdf"";Inte...more >>
Saving Data with DataAdapter to Jet DB Posted by NYWGUY54 at 4/18/2008 5:20:00 PM I am trying to save changes to a dataset using the dataAdapters update method
to an Access 2003 DB, therefore I'm using an OleDbDataAdapter to accomplish
this.
I am using a For/Next loop to change a single column of data in the
dataTable, & I know this works. The problem arises when I try to ...more >>
SqlCommandBuilder DeriveParameters Ouput Arg gets wrong direction Posted by JM at 4/18/2008 9:17:01 AM First, I am using the Enterprise Library DatabaseFactory to get a Database
object. I have traced the issue down to the SqlCommandBuilder
DeriveParameters method.
Given a stored procedure args:
CREATE PROCEDURE UpdDept
( @KeyDepartmentIdentifier UNIQUEIDENTIFIER,
@KEYTimestamp BINARY(8)...more >>
how to extract value from LINQ query? Posted by SftwDude at 4/18/2008 5:53:02 AM Is it possible to extract a single value from the results of a LINQ query
with out iterating over the results.
For example I have a table in SQL Server:
tblExample
Type int <--this is a key field
Descr nvarchar(5)
I would like to get the description (Descr) fi...more >>
Problems with LINQ and CLR Stored Procedure Posted by Jules140 at 4/17/2008 11:04:52 AM Hi all,
I'm having a bit of a problem with Linq and a CLR Stored Procedure.
I'm just trying to fill a gridview with a simple query that depends on multiple
(one to n) search terms.
The sproc is as follows:
ALTER PROCEDURE [dbo].[CMS_Pages_Search]
@searchString varchar(500)
AS
BEG...more >>
error that occur in StoredProcedure it's throw exception to Ado.net? Posted by mttc at 4/16/2008 6:12:51 AM I ask it before and I got this answer:
======================================================
yes errors with a certain severity level will throw exceptions in your
code
try this in your stored proc
RAISEERROR(N'This is a message %s %d', -- message text
16, --severity
1, --state
...more >>
SqlCommand.ExecuteReader takes too much time Posted by Achim Domma at 4/16/2008 1:04:21 AM Hi,
I have a table containing about 14,5 million records and I want to
iterate over the complete data. If I execute a "select * from
mytable", the call to ExecuteReader takes some hours to return. In T-
SQL I can open a cursor and start reading immediately. As far as I
understand, ExecuteRead...more >>
Querying a Runtime Dataset with LINQ Posted by Ant at 4/15/2008 9:23:01 PM Hi,
Can you query a run time Dataset with LINQ or must the Dataset be strongly
typed?
If not, how can this be simply accomplished?
Many thanks for any ideas on this
Ant...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
GC.Collect() not cleaning memory, how to find out what references to lots of memory still exist? Posted by DR at 4/15/2008 2:03:04 PM GC.Collect() not cleaning memory, how to find out what references to lots of
memory still exist?
When all my processign is done i set everything to null and then:
GC.Collect();
and then
GC.WaitForPendingFinalizers();
but it still shows that my process takes 400 MB of memory. Is there any ea...more >>
slowing/halting stored procedure from ado.net Posted by MarcelG at 4/15/2008 4:41:01 AM Hi,
I've strange problem with an application developed with VB.NET 2008/ADO.NET
framework target 2.0 and SQL Server 2005.
Sometimes a certain stored procedure wich normally executes in seconds,
suddenly takes forever (15minutes plus).
When I execute the stored procedure from within SQL Server...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |