Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Alternative to SQL to Create MS Access Table?
Robert W. - 22 Jul 2006 7:11 PM - 4 messages
I'm new to ADO.net so forgive me if this question seems obvious . . . I want to programmatically create a table in an MS Access database.  To do this, I've implemented this code:               conn.Open(); ...
Score Example of handling TableCleared in typed DataTable partial class?
Martin - 22 Jul 2006 9:51 AM - 2 messages
Hi, I tried to handle the TableCleared event in a typed version of a DataTable partial class, similar to the example for handling RowChanging at [link] (TableInitialized handling worked).  I tried setting up my event handlers ...
Score Bugs in Data Source Configuration Wizard ?
peter - 22 Jul 2006 7:02 AM - 2 messages
I have use the Data Source Configuration Wizard to genernate the Form's code, but i want to change the default "Add" button action, how can i do that ? also a bugs found that with the following table A --- B   (key) ...
Score Change Data Source dialog
Oldman - 21 Jul 2006 8:35 PM - 1 message
If you wrote your own data adapter is there a way to get it to show up in the list in the Change Data Source dialog of the TableAdapter Configuration Wizard. Thanks Oldman ...
Score EntLib and Oracle
Steve K - 21 Jul 2006 7:33 PM - 4 messages
First let me say I know little or nothing about Oracle. I want to configure the EntLib June 2005 to read from an oracle database. I added a new database type and selected the Oracle assembly I added a new database instance using that type then... ...
Score SQL Server 2005 throught OLEDB : Named parameter problem ?
Sylvain Devidal - 21 Jul 2006 7:31 PM - 4 messages
Hello, I'm designing a web application that must be able to connect different databases. So I decided to use OleDb connector instead of SqlClient. While with SqlClient, I can run queries like "select * from mytable where col = @param" then giving a value to the parameter, I get an error when ...
Score DataColumn.DefaultValue Property in VS2005 / .NET 2.0
jason - 21 Jul 2006 6:51 PM - 1 message
hello, i'm curious how to set the default value of a DataColumn to the return value of a function call. for example, the DataColumn is a datatype System.Guid, and i would like to set the DefaultValue to Guid.NewGuid(); ...
Score could using ADO.NET to access database in different VLAN??
ngoctt_hut@yahoo.com - 21 Jul 2006 5:04 PM - 6 messages
I want built my project using C# Application. and using ADO.NET 2.0 to access database. My Database was be in VLAN and my Application was be in Another VLAN// for exam : My DataBase in : 192.168.2.XXX ...
Score how can i fix this ?
calvin - 21 Jul 2006 4:38 PM - 14 messages
sorry for posting with attachment, but for better illusation, i attached my problem here. I have been building the forms using " Data Source Configuration Wizard ".. while i run the project, with that form, then it was report as the error ...
Score VB 2005 trying to use TransactionScope with DB2 backend
Memphis - 21 Jul 2006 3:45 PM - 2 messages
***Environment*** Visual Basic 2005 ..Net Framework 2.0 DB2 Direct Connect Client info as follows DB2Level -> "DB2 v7.1.0.40"  (This is the Client level driver) Running on XP Pro, SP2 ***Problem*** Trying to wrap an Update Statement in a Transaction and get the following ...
Score DataSet into XML
Al - 21 Jul 2006 2:29 PM - 2 messages
1. I need to create a DataSet, containing several DataTables (let's call them as  Workorder, Parts, Labor). 2. Save it as XML file. 3. Send that XML to another Workstation. 4. Open XML on another Workstation into DataSet ...
Score How to get @Return_Value parameter? It is not generated in TableAdapter.Fill
Karel Kral - 21 Jul 2006 1:54 PM - 2 messages
Hello, I am using strongly typed dataset. I am calling stored proc and I want to get return value from SP. So I have  created SP Test (see bellow). I have added TableAdapter for this procedure. But how to get @Return_Value from this procedure? I have seen generated ...
Score .NET Data Provider for Oracle 10g
otto - 21 Jul 2006 11:36 AM - 3 messages
Hi, all: I want to know if .NET Data Provider for Oracle supports Oracle 10g databases. I think .NET Framework 2.0 supports Oracle 10 but I want to be absolutely sure. Can anyone help me? thanks a lot! ...
Score New Record
entrodus - 21 Jul 2006 7:18 AM - 4 messages
I know this must be an easy question to answer but i cant seem to find out how to do it. I am an experienced programmer in delphi but just started to learn ..NET. What i am trying to do is: ...
Score Typed DataSet with TableAdapter Always Error
Saroeurn Long - 21 Jul 2006 5:14 AM - 3 messages
My DataSet always error after I modifer Query in my TableAdapter and all my forms used that DataSet. And the whole project do not know my DataSet name. Thanks, ...
Score Specifying Parameter Direction in SqlParameter.
amitmnagarwal - 21 Jul 2006 4:23 AM - 1 message
A doubt, when writing sqlparams sqlparams(0) = New SqlParameter( sqlparams(1) = New SqlParameter( sqlparams(2) = New SqlParameter( sqlparams(3) = New SqlParameter( Above is a code snippet of dataaccess, All are simple input type of variables to the Stored Proc. I know it is not necessary to specify the param direction for the ...
Score QUERYING THE DATASET
sharmaajay - 20 Jul 2006 11:57 PM - 1 message
hi all, i want to know whether we can make a dataextract function in global page(global.asax) though a query and.. then for each individual .aspx page can we query tht dataset instead of creating dataset for each page ...
Score QUERYING THE DATASET
sharmaajay - 20 Jul 2006 11:57 PM - 1 message
hi all, i want to know whether we can make a dataextract function in global page(global.asax) though a query and.. then for each individual .aspx page can we query tht dataset instead of creating dataset for each page ...
Score DataGrid Row Searching
Keith - 20 Jul 2006 8:46 PM - 7 messages
Background: I have a parent table (Employee) with two child tables (Phone and Email) I have a datagrid bound to the dataset, with datamember = Employee for the employee table I have two other datagrids for the Phone and Email bound to the same ...
Score Commit following use of Oracle Stored Procedure
v.maggs - 20 Jul 2006 8:41 PM - 1 message
Assuming the code below executes successfully, what should the value of ReturnValue be? It is returning a 1 but I am not sure how to interpret that. The stored procedure does not perform a commit and I must do it but I ...
Score How to receive a record type return value from an Oracle function?
Michael Skelton - 20 Jul 2006 8:07 PM - 1 message
Hello all, I have written an Oracle package that contains several Record types, as well as some functions that return the Record types. I am attempting to invoke these Oracle functions from a C# application, and I am using the Oracle Data ...
Score NullException on Exit app when performing updates on the dataset
kuhrty - 20 Jul 2006 7:48 PM - 1 message
Hi, I posted this issue a few weeks ago and the responses helped, I am still receiving the same error. The error is "An unhandled exception of type 'System.NullReferenceException' occurred in system.management.dll Additional information: Object reference not set to an instance of an ...
Score Transactions and foreign keys
ScottW - 20 Jul 2006 7:35 PM - 4 messages
Hi All,   I've seen a similar post regarding this, with no suggestions other than a third party tool.   What I am using is an OleDbConnection / Transaction, because it has to be SQL Server and MS Access compatible.  The code inserts a record in the parent ...
Score Adding rows of data to Untyped DataSet
Deecrypt - 20 Jul 2006 6:01 PM - 3 messages
Hi, I am receiving an untyped DataSet from an Access database as a result of an sql query on my website.  It only contains one table at index [0].  I then extract the values I need from the dataset and populate ...
Score Oracle Stored Procedure
v.maggs - 20 Jul 2006 5:57 PM - 4 messages
Folks, I have tried every way I can think of to get this to work, without success. We have a COTS application and I am tyring to execute a stored procedure, Enter_Result. I can connect fine, etc. I can run the SP fine ...
Score system.Transcation versus ADO transaction
Marc R. - 20 Jul 2006 2:45 PM - 2 messages
I code this to show to my boss that it is possible to rollback some parts of an ADO transaction.         Dim strCon As String = "Data Source=Q09073\SQLEXPRESS;Initial Catalog=Bank;Integrated Security=True;" ...
Score passa dataset through class
Gian Paolo - 20 Jul 2006 2:40 PM - 2 messages
hi all     i have 2 C# 2.0 classes the result i want is that i pass a value( txt) from the class1 to the class2 the class2 build the dataset with this parameter and return to class1 the dataset. ...
Score dataTable select method - complexity
lior - 20 Jul 2006 2:27 PM - 1 message
Hi, I'm using the dataTable select method in order to sort my dataTable. I need to know what is the complexity of this method. is it O(nlogn) or O(n^2) (or even worse? :) ) 10x Lior ...
Score ADODB vs ADO.Net or protocol difference.
Giedrius - 20 Jul 2006 8:17 AM - 5 messages
Hi, I have 2 apps doing the same job, one is older and using adodb to query sql server 2005, another is using ado.net. Something has happened and now app using ado.net execution time of some stored procedures has increased about ...
Score Export asp.net page to pdf
sonali_aurangabadkar - 20 Jul 2006 5:18 AM - 2 messages
how to export asp.net page to pdf ...
Score Like('*') won't work in Access qry
msch-prv - 19 Jul 2006 7:45 PM - 6 messages
I am trying to pull out data from an Access mdb via the Like() operator. The code works fine for specific values ie 3, 4 but fails for the '*' value. TIA for any hints. Mark Code excerpt: (ddnEmp.SelectedValue is a dropdown box, with values: 0, ...
Score DAAB + Master/Detail Tables with SQL Identity field on master
PGC - 19 Jul 2006 3:45 PM - 1 message
Hi, Assume the following two tables ... Order_Header OH_ID    Numeric Identity OH_Cust varchar(20) not null Order_Lines OH_ID    Numeric (FK on Order_Header) OL_Line int not null (incremental) OL_Qty decimal(9,2) not null These tables are mapped to a typed dataset where the properties for ...
Score Inserting Datarow into a named excel range.
Tim - 19 Jul 2006 3:10 PM - 1 message
My code is starting to stadle a few diffrent groups, so I am not sure if my problem is with the ADO.NET or the interop methods I am using to define the Named range. When I used this sample code below in an Excel file i created by hand ...
Score Leer Varchar con DataReader
Alfonso - 19 Jul 2006 2:57 PM - 1 message
Hola, he usado los DataReaders para bajar informacion de la base de datos y me ha funcionado muy bien pero con los campos de tipo Varchar no he podido, puedo bajar string, enteros, DateTime pero como se puede hacer con ...
Score Connection Pooling randomly throwing exceptions
jshepler - 19 Jul 2006 2:47 PM - 1 message
We randomly get the following exceptions: [COMException (0x80070006): The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE))]    System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) +0    System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode) +34    System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection ...
Score Object Oriented Databases
Jeremy - 19 Jul 2006 1:42 PM - 1 message
Just in the past few weeks, I have been looking at a OODBMS called Cache from [link] . At first glance ,this looks like a promising technology since it allows one to design tables in an object oriented manner and has automatic class generation ...
Score AllowDBNull & Performance?
Geert-Jan - 19 Jul 2006 10:35 AM - 4 messages
Hi, We have a C# programm running on .NET 1.1 I have found that on some PC's the performance decreases when  using AllowDBNull=false on a DataColumn. By looping extensively through many DataRows in the DataTables, this becomes evident: the application is ...
Score Reading xml containing datetime attributes in dataset
florin - 19 Jul 2006 9:28 AM - 1 message
I need to to the fallowing: get the data from a dataset as an xml (using GetXml() ) and the load it latr in another dataset (using LoadXml) My problem it that the datetime columns throw an exception when the xml ...
Score ORA-01036 Error from GridView
Monther Al Zamil - 19 Jul 2006 8:29 AM - 1 message
Hi, I have Oracle 8i database and i am trying to connect to it through .Net framework Data Provider for Oracle in visual studio 2005 GridView every thing goes well until I try to update or insert a record i get error ...
Score HELP! Why is SqlException being caught in this code if it can't connect to SQL Server?
Marcus - 19 Jul 2006 12:46 AM - 15 messages
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that sql server resides on is not reachable. The error is different depending on the ...
Score ADO.NET in VB6
vul - 19 Jul 2006 12:30 AM - 7 messages
May ADO.NET be used in VB6 ? I'm not asking about using it in DLL created in VB.NET or C# and then DLL is used in VB6. I'm asking about direct using. I need some of ADO.NET features, which are not available in a traditional ...
Score Concurrency Violation w/ Access Database during Update()
Steve Hiemstra - 18 Jul 2006 8:27 PM - 2 messages
Hi All, I have a DataTable that needs an Update, but I am relying on the CommandBuilder to create my Insert, Update, and Delete statements for me.  I have to - since my DataTable is free-formed (realtime), and I therefore need ...
Score Invalid cast on SqlConnection.open
jsamples@greenwaymedical.com - 18 Jul 2006 7:39 PM - 1 message
I am seeing this on some of my Windows 2000 servers.  This is a web application and I have to restart IIS admin to allow the user to get connections again.  I am assuming this is clearing up the connection ...
Score tell VB when new row inserted in SQL server
JoelH - 18 Jul 2006 3:00 PM - 2 messages
I am running SQL server 2005 and want to be notified in VB when a new row is inserted on a particular table. Can I link to the table in visual express 2005 and have an event fired when there is an insert on a particular table? ...
Score Get related rows for a typed datarow
Henrik Skak Pedersen - 18 Jul 2006 1:25 PM - 4 messages
Hi, How do I get the related datarows for a typed datarow? Thanks Henrik ...
Score converting system.datatype to DbType
Chukkalove - 18 Jul 2006 10:26 AM - 1 message
Is there any dotnet function that will convert an object of type System.DataType to a IDataParameter.DbType enumeration? When I read off a table schema (IDataReader.GetSchemaTable) the data types for each column in the table are returned as System.DataType. ...
Score Connection Pooling
kishor - 18 Jul 2006 7:11 AM - 3 messages
Hi, I have an application, which opens many connection and after completing work never closes connection. This is becoming a problem on sql server side. I am thinking to write a tool which will close all the sleeping connection at one run. ...
Score How to export data from SQL Server to Excel in .net
Neo - 18 Jul 2006 12:04 AM - 6 messages
Hello All, I want to do bulk export using ado.net from SQL Server database to MS Excel document. I would highly appreciate small examle showing how to do this. Best Regards, Neo ...
Score 2 DataGrids with using same SQL Server table
Cousy - 17 Jul 2006 10:09 PM - 2 messages
I have a windows form with two datagrid objects. The goal is to display rows from the same SQL Server table, using different SELECT commands. Here's a sample of the code: Data Grid 1: ---------------------------------------------------------------------------------------------------------------------------------- strCMD =  @"SELECT ID, ClassID, ClassCode, StartDate, EndDate" ...
Score ADO.NET forces unload ODBC Driver
Tony Ser - 17 Jul 2006 9:52 PM - 2 messages
Come across a problem with VB.net application using an ODBC Driver. On application shutdown, it forces unloading the ODBC Driver without giving enough time for the driver to handle DLL_PROCESS_DETACH (or CWinApp::ExitInstance) We have our own ODBC Driver and found a problem with lengthy driver ...
Score Change in Typed Datasets between 1.x and 2.x
jdn - 17 Jul 2006 8:00 PM - 3 messages
I know/gather that the changes between typed datasets between 1.x and 2.x are pretty significant, but there's one specific thing I could do in 1.x and I can't figure out how to do it in 2.x, or if it is still possible. ...
Score how to lock the counter table if using OLE DB database
Rabbit - 17 Jul 2006 2:59 PM - 1 message
Hi, all, I'm having problem on multi user environment, currently I have over 20 concurrent users creating records on Access database table, because my database have a Counter table for generating Record ID. My problem is using ADO.net, i need to generate Record ID in 2 steps: ...
Score SQL Parameter bug
Pradeep - 17 Jul 2006 6:06 AM - 5 messages
I am having a function which accepts Database parameter array, and it inserts to the database inside a loop. Note: inside the loop i am changing the values of the parameter array  . it works fine if the loop executes for only one time, but if the loop ...
Score Oracle behaving strangely with multiple commands executing in a tight loop
Steven Eichert - 16 Jul 2006 10:09 PM - 8 messages
We've run into a very strange issue when running against Oracle using System.Data.OracleClient. As part of an import process that we're running we're doing a number of validations on data that has already been inserted into our database.  For ...
Next »