Groups | Blog | Home


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 > june 2007 > threads for june 15 - 21, 2007

Filter by week: 1 2 3 4 5

ApplicationException: Error in the application in SqlConnection.Open()
Posted by Jan Obrestad at 6/21/2007 3:40:55 PM
Hello. I'm developing an application where suddenly I get this rather generic error, it is an ApplicationException with the message: "Error in the application". The problem is that it originates deep inside the .NET Framework. Here is (part of) the stack trace: System.ApplicationException:...more >>


Type is invalid error
Posted by william at 6/21/2007 1:05:01 PM
Hi, I have a tableadapter which is used to access Oracle database using OLEDB for Oracle. I have a query on this adapter which consumes a procedure, this procedure has output parameter as Char(1) or Int. From my business layer, I call the adapter query by passing parameter of out string. It...more >>

Error while connecting remote SQL server
Posted by at 6/21/2007 4:52:55 AM
hi all, I trying to connect remote sql server from my machine. but it giving me some errors Here are few errors listed, =EF=82=A7An error has occurred while establishing a connection to the serve= r=2E When connecting to SQL Server 2005, this failure may be caused by the fact that under the...more >>

Error in DSN
Posted by Simi at 6/21/2007 2:17:02 AM
I have Error:Could Not Install ISAM.When i use System DSN. my code is in app.config <add key="dsn1" value="Provider=Microsoft.Jet.OLEDB. 4.0;DSN=EduLiteDSN"/> and i create system DSN =EduLiteDSN and database is Ms-Access 2000 ...more >>

how to save a piocture n a table
Posted by Mero at 6/20/2007 11:09:47 PM
hi to all; i want to save a picture in column image in a database for example,in the table "users" i want to save the user image as when i want to select the user data from the database to show it in my site, the image selected from the table "users" thanks you ...more >>

How To Save A Picture In a table
Posted by Mero at 6/20/2007 4:40:23 PM
hi to all; i want to save a picture in column image in a database for example,in the table "users" i want to save the user image as when i want to select the user data from the database to show it in my site, the image selected from the table "users" thanks you ...more >>

commit transaction closes connection ?
Posted by John Grandy at 6/20/2007 4:30:55 PM
Does committing a transaction close it's underlying connection ? Or must you explicitly close the connection ? Also, is there any reason to dispose a connection ? My goal is to force the underlying connection to return to the connection pool. Thanks. ...more >>

SqlConnection.Open() Which ErrorCodes
Posted by Henrik Skak Pedersen at 6/20/2007 4:03:36 PM
Hi, I am trying to discover which SQLException.ErrorCode SqlConnection.Open() can throw. I have until now discovered these: // 53 : {"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under...more >>



Concurrency violation problem.
Posted by pachuts at 6/20/2007 2:18:36 PM
Hi, Using ADO.NET Table adapter in C# , am updating a record using VS2005 generated update command by passing dataset and the assocaited table like; this.CustomerDataSet.CustomerTable. while updating am getting "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records...more >>

DAO/VB6 Outperforms ADO.NET in VB 2005
Posted by Paul Engel at 6/20/2007 1:24:04 PM
I have an application that reads through a delimited file, breaks the values into an array and then checks to see if the record already exists in the database. If it does, the record is updated. If not, the record is added. Both of these actions are based on the values of the associated array ...more >>

Error with report viewer and Oracle database access
Posted by Rusty Owens at 6/20/2007 11:41:50 AM
I am trying to connect dot net report viewer control to an Oracle database. When I try to run it, I get the following error message: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I have installed Oracle Client 9.2 on that server and have tried the fix a...more >>

Behavior of close application during dataGrid modification
Posted by schaf NO[at]SPAM 2wire.ch at 6/20/2007 11:10:43 AM
Hi NG! I have recognized a strange behavior of the DataGrid control. If I'm editing the value of a cell in the DataGrid and press the close button (of the ControlBox of the application 'X') then the application closes but the DataGrid does not loose the Focus. I would like to save the changes d...more >>

SQL Server 2005 installation
Posted by Steve Bugden at 6/20/2007 9:56:01 AM
Hi, Could someone please tell me what I would need to install if anything on a client machine to access an SQL Server 2005 database from a .Net component? Is it sufficient just to have the database files (.mdf and .ldf) and access them via ADO.NET? I only have a development machine and ...more >>

Working With Tables, Please Help!
Posted by Nando_uy at 6/19/2007 4:19:01 AM
I'm a Vb.net 2005 newbie, but an Older VB6 programmer. With a ADO I work very comfortably (many years!), with ADO Is possible to work DIRECTLY with all the records in a Table WITHOUT the need to write ANY sql command. I try to make the same with ADO.NET (.Net 2.0) using sqlserver express, but ...more >>

need a reply of this question
Posted by Mero at 6/19/2007 12:27:34 AM
i use visual studio 2003 amd c#.net to make my web application my site is about e-learning in my site i want to set some setting in "create new lesson page" such as name, description , startdate, end date,... i used textboxes,dropdownlist, radiobutton in the design of this page the probl...more >>

ObjectDataSource with list of others object in an object
Posted by Ghistos at 6/18/2007 11:05:00 AM
i all, I have a class with properties returning int, string, date... and generic Lists of other classes. private static string zipcode; private static string city; private static double? x; private static double? y; private static List<Proprio> pro...more >>

Contecting transactions between two stored procs
Posted by Jerry J at 6/18/2007 8:55:02 AM
I have two sql server stored procedures that use transactions. Both stored procedures have there own begin transaction , commit and rollback. Currently I have C# .Net code that executes both of these stored procedures consecutively. Everything works fine unless the second stored procedure ...more >>

SQL Server 2005/.NET 2.0 - Application performance deteriorates!
Posted by Steve Barker at 6/18/2007 8:46:00 AM
Hi guys, I’m getting a really weird problem when accessing a SQL Server 2005 database from .NET 2.0 code. I was wondering if anyone could make any suggestions as to what is going wrong?! Here is the problem (names and real world equivalents have been altered!): I have a database that ...more >>

Need help with this Error
Posted by news.microsoft.com at 6/16/2007 12:27:49 PM
I have a SQL Server database. I am using a OleDB Provider. I am getting the following error An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.dll Additional information: Command parameter[2] '' is invalid. Command parameter[3] '' is invalid. He...more >>

Delete the data from tabel in the database
Posted by Husam at 6/16/2007 4:48:00 AM
Hi EveryBody: I made project by using Asp.Net 2.0 and the code behind is written by vb.net I want to delete the old password from the database tabel and insert the new password insted ? My queruy for retriveing information from the data base is : Dim cmd As SqlCommand Dim ...more >>

ADO.Net
Posted by Steve at 6/15/2007 3:49:27 PM
Does any body have sample code to create a dbf from ado.net recordset in C# From http://www.developmentnow.com/g/7_2004_3_0_1_0/dotnet-framework-adonet.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Updating a P.SQL DataSet
Posted by mitzoe NO[at]SPAM yahoo.com at 6/15/2007 1:55:04 PM
I apologize for any inappropriate cross-posting, but wasn't sure where whether this is a Pervasive or ADO.NET issue. I'm trying to migrate data from a propietary system that's based on btrieve into Pervasive SQL 9.5 using a .NET application written in C#. The main problem is that the existing...more >>

Oracle DB, Remoting and .NET
Posted by ashehu NO[at]SPAM gmail.com at 6/15/2007 4:40:24 AM
Hi all, I am workibng on an application that will interact with an Oracle database and this is the first time I am doin sthg with oracle. From what I read in other posts, I will have to install the oracle Client before I can use any of the providers (MS or Oracle) to interact with the database....more >>


DevelopmentNow Blog