Archived Months
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
all groups > dotnet ado.net > april 2008 > threads for april 1 - 7, 2008

Filter by week: 1 2 3 4 5

Call Dispose on OleDbCommand?
Posted by JohnMSyrasoft at 4/7/2008 12:49:02 PM
1. Should you explicitly call Dispose on OleDb objects like OleDbCommand or OleDbConnection? 2. In VB.NET for the keyword USING (as in "Using cn As New OleDbConnection(...)...") Should you explicitly call the Close method on the OleDbConnection object or will the object be closed and d...more >>


OutOfMemoryException using .NewRow
Posted by TexasAggie96 at 4/7/2008 7:09:46 AM
I am dealing with a very large amount of data add it to a dataset using DataTable.Rows.Add. When creating the new row using .NewRow I get an OutOfMemoryException at around row 4 million plus. I know that this is a very large number of rows, but I have 4 GB of Ram and the Task Manager shows th...more >>

How to fill a listview from LINQ query
Posted by Dean Slindee at 4/6/2008 8:28:25 PM
Currently using a legacy Winform listview, that is filled by a function from datatable(0) in a dataset. This works fine as the datatable has column headers and data rows that correspond to listview headers and listview rows. Would like to use Linq to SQL to populate the same legacy WinForm l...more >>

Add column using Dataset Designer => hosed project
Posted by Molon Labe at 4/5/2008 12:36:01 PM
Context: VS2008 SQL Server Compact 3.5 database Problem: I used the Dataset Designer to add a column to a table (right click on table in designer, Add->Column). How do I update the database to correspond with this change? I tried locating the database in my Server Explorer and addin...more >>

How to Update an existing schema on a typed dataset
Posted by socamb at 4/4/2008 6:11:00 AM
I need to do what seemes a simple task, but i am stuck. I have a column in my database i need to change from 7 chars to 10 chars. I have a number of strongly typed datasets in my system that use this table. I attempted to edit the xsd file in the designer and changed the 7 to a 10. But...more >>

Replacement for dataadapter
Posted by Harsha at 4/4/2008 5:22:36 AM
Hi Experts, I am having new problem again. This is regarding SqlDataAdapter fill method performance. Even though its discussed several times my problem is little different. I had migrated one VB6 application to .Net 2.0. In VB6 application they were using RecordSet. Like, --------------...more >>

Databinding to a listview
Posted by Ant at 4/4/2008 5:11:00 AM
Hi, I'm trying to populate a list box using a dataset. The data set is tested fine to have data in it but when I run the app, the listbox does not get populated. Below is what I'm doing: Class1 myclass = new Class1(); myclass.Server = "LAPTOP"; myclass.DB = "Northwind"; ...more >>

Where to: Questions About EDM and CSDL
Posted by CharlesRCaplan@gmail.com at 4/3/2008 2:21:56 PM
We are about to start serious design on a new app here. I would like to use the Entity Framework stuff that's new in Framework 3.5 and since it's not even officially released yet, I'm sure to have some questions. So my question is "microsoft.public.dotnet.framework.adonet" the best group to ask ...more >>



How to read sequentially from a random point in a large Xml File. (200 - 2000 MB)
Posted by Schwartzberg at 4/3/2008 1:02:00 PM
Hello Have a huge XML file with multitudes of "LogEntry" nodes / text lines. A small sample of this xml/text content is below. The file could be anywhere between 200 to 2000 MB. My questions comes in two parts. (A) I would like a solution (or ideas for it), in C#, -- to randomly access ...more >>

Question to the generals in this newsgroup including MSFT's
Posted by Cor Ligthert[MVP] at 4/3/2008 7:15:57 AM
Is this a FrameWork.ADONET or a LINQ newsgroup? As I see so many non LINQ to ADONET questions answered at the moment. Cor...more >>

Reading a text field
Posted by Josh at 4/2/2008 4:58:02 PM
How do I get the data out of an MS-SQL Text field efficiently A simple "SELECT [FieldName] FROM [Table]" unfortunately returns a truncated version of the fields contents ( which actually contains an entire book ). I know that your not supposed to do a simple select, but my Google-Fu is wea...more >>

SQL 2005 Error connecting to SQL2000
Posted by Ant at 4/2/2008 3:20:00 AM
Hi, I'm connecting to an SQL2000 Server, it runs a very slow SP that takes around two minutes. I've set the command & connection timeout to handle this. It used to work fine but now I get a seemingly unrelated error. I can connect remotely to do simple queries & LINQ queries but the SP doesn'...more >>

Linq SubmitChanges and DataLoadOptions
Posted by Chuck P at 4/1/2008 1:34:01 PM
I have some code that has a DataLoadOption to load Master/Detail records. When I update the Master table, the object gets returned but the Details records are not loaded. Is their a work around for this? using (MyDataContext dc = new MyDataContext()) { ...more >>

linq combined query
Posted by Chuck P at 4/1/2008 10:05:01 AM
I tried to make some complex linq queries easier to read by pulling some of the queries out. This works fine: var qAllJobDescriptions = from j in dc.Jobs select j; var qAllOracleJobCodes = from o in dc.OracleJobCodes ...more >>


DevelopmentNow Blog