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 > september 2007 > threads for september 8 - 14, 2007

Filter by week: 1 2 3 4 5

Problem with XML vs Dataset
Posted by Ariana at 9/14/2007 9:02:29 PM
Hello, I have a problem and I'm hoping it will ring a bell with someone here. :) In my ASP.NET website, I have a custom calendar control which highlights ranges of dates based on a data source, and also allows a new date range to be selected. To select a new range, the user clicks on the f...more >>

is there some per-process-limit on memory in .net processes? is there any way to increase it? i keep getting System.OutOfMemoryException when my box h
Posted by Daniel at 9/14/2007 8:36:41 PM
is there some per-process-limit on memory in .net processes? is there any way to increase it? i keep getting System.OutOfMemoryException when my box has 8 gigs of unused memory. ...more >>

Large update SQL command works on old slow servers but times out on super fast one!
Posted by steve NO[at]SPAM orchardprofessional.com at 9/14/2007 11:33:59 AM
Hi all, I have a problem in that I have written a .Net 2 application for a customer that performs significant amounts of manipulation - 250,000 records manipulated and updated with combination of update and select into commands. The issue is that it works fine on my old slow development 200...more >>

Newbie Helo - Datarow.EndEdit
Posted by Daniel Jeffrey at 9/14/2007 12:00:00 AM
Can someone please help me. I have created a simple form. 3 Controls - ID, Firstname and Lastname. I have added a SqlDataadapter, Dataset etc etc. When I call Fill(Dataset) it all works fine. I can edit the values on the screen but when I post nothing happens unless I call EndEdit. ...more >>

Autonumber Issue With Access 2007 Database/ADO.NET
Posted by Jeff Gaines at 9/13/2007 6:07:38 AM
I thought this may help other people learning ADO.NET. Having, I thought, got a sufficient grip to 'go live' I set up an app using Access 2007 and ADO.NET. During testing everything worked except my 'AddRecord' function, which kept complaining of a duplicate entry in an indexed field. Aft...more >>

Passing parameter to store SQL procedure ???
Posted by calderara at 9/12/2007 6:20:00 AM
Dear all, I am passing parameters to store procedure without any troubles but parameters list are less than 10 parameters, still manageable. But we have a situation where we do not know for instance the number of variable my final customer would like to monitor and store to database. It c...more >>

dataset help
Posted by AVL at 9/12/2007 5:30:05 AM
hi, i need help on setting datatype of a table's column at runtime.. i'm loading a dataset from an xml file... after loading, i want to set the datatype of one of the column as int32.. how can i acheive it.. is there any way to set the datatypes of the columns before loading the data from x...more >>

Select and update
Posted by Alejandro at 9/12/2007 12:00:00 AM
Hi all, I'd like to do something that was very easy with ADO in VB6. I'd like to do a selection in one table and be able to search on the group of registers, update or even insert one new. This is possible to do in ADO .NET? How? Thank you in advance. Alejandro ...more >>



New columns in database -> added to the DataSet automatically.
Posted by Trygve Lorentzen at 9/12/2007 12:00:00 AM
Hi, I do a "select * from tablename" in my dataadapter. In most cases this is fine because all those columns are also defined in the strongly typed dataset I'm working with. However, if I add a few new columns or want to use the dataadapter to fill a different dataset where not all columns ...more >>

Requirements to Run ADO.NET Application
Posted by Jonathan Wood at 9/11/2007 2:08:46 PM
I'm grappling with understanding some ADO.NET issues. I'd appreciate any help. If I write a .NET Windows application that uses ADO.NET, what needs to be distributed with my application in order for it to run for Customers using Windows Vista? I understood ADO.NET is included with the .NE...more >>

Does the password in the ConnectionString travel encrypted?
Posted by seguso at 9/11/2007 10:28:35 AM
Hello, I have a very simple question I could find nothing about. When, in a .NET application, I connect to a database with a ConnectionString like "database=foo; server=220.40.231.2; uid = root; persist security info= false; pwd=blabla", does my root password travel in clear-text? AFAIU,...more >>

Single Quote In A Text Field
Posted by Jeff Gaines at 9/10/2007 2:51:18 PM
In my efforts at learning ADO.NET I have discovered that it balks at text fields with single quote marks embedded. The field in question comprises notes that can contain anything, it is stored as a memo field in Access. I tried to wrap the whole field in double quotes without success, it st...more >>

SqlException and Violation of PRIMARY KEY constraint
Posted by Max2006 at 9/10/2007 1:06:26 PM
Hi, At this point I check the SqlException.Message to check for the "PRIMARY KEY" errors. Can I use SqlException.ErrorCode to do the job? I have ErrorCode=-2146232060 for primary key errors. Can I assume that the error code -2146232060 and primary key error are always associated togethe...more >>

how to get the id of the inserted datarow?
Posted by Norbert_P=FCrringer at 9/10/2007 5:51:13 AM
Hello there, after inserting a row, I want to return the id of the inserted row. This id could be a number or a string (e.g. GUID values). The database could be SQL Server, Oracle, MySQL or Access. Is there a database independent way to return the ID of the inserted data row? My way does on...more >>

Storing decimals to Pervasive SQL database
Posted by Hans van de Laar at 9/10/2007 2:38:27 AM
Within an VB.net application I'm trying to store decimal values to a Pervasive SQL table. The decimal values comes from a xml file and is looking something like: <Grade1>6.65</Grade1> <Grade2>6.66</Grade2> <Grade3>6.0</Grade3> When I look for the results in the database I find 665, 666 and ...more >>

Enterprise library connection string
Posted by Rick Mavrovik at 9/10/2007 12:00:00 AM
Hi, I need to connect to a database the connection string of which is determined at runtime. I am using Enterprise Library 3.0 for data access. How can I connect to a database at runtime, without hardcoding the connection string in the web.config. Please help!! Thanks. Rick ...more >>

Large MySQL SQL File -> ASP.NET Database
Posted by Jonathan Wood at 9/9/2007 10:12:03 AM
Greetings, I have backed up a MySQL database from a PHP site. This backup is in the form of a large (55MB) SQL file. Can anyone tell me how I can convert it to an ASP.NET database? The file is too large for cut and paste and it appears the SQL content is not fully compatible with Micros...more >>


DevelopmentNow Blog