Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score SqlDataAdapter Bug??
Jav - 21 Oct 2006 7:04 PM - 2 messages
When using VS2005 SqlDataAdapter to generate StoredProcs for SQL Server 2000, I have noticed a problem that can only be a bug. I would not be surprised to know that it is already known. In a nutshell, if the underlying table has any uniqueidentifier columns that ...
Score Provider-independent data access, again
Massimo - 21 Oct 2006 5:12 PM - 3 messages
I'm still trying to provide my application (ADO.NET 2.0) with a generic data access layer, independent of the specific provider used. Now, my main concern is about connection strings, which can be quite different amongst various providers. ...
Score Search box to pull data from SQL db
JerHiggs - 20 Oct 2006 9:01 PM - 2 messages
I apologize... I am completely new to SQL and to ADO so this may seen very easy to some but I am at a complete loss here. I have been searching the entire day so far for some sort of lead on how to ...
Score Child DataView is not updating automatically
jmagaram - 20 Oct 2006 8:40 PM - 1 message
I am trying to display list of people and for each person a list of their corresponding phone numbers. I am doing this with databinding in outline form with WPF with all nodes expanded. If the user inserts a new Person and types ...
Score OracleClient - OracleOraHome817Agent services
Chandra - 20 Oct 2006 6:58 PM - 2 messages
Hi, What is the use of OracleOraHome817Agent services? And when i try to start the same, it provides me a services error as "Could not start the OracleOraHome817Agent service on Local Computer. Error 0xc002000f: 0xc002000f". What is this problem? Can any of you provide me the ...
Score High volume data access architecture
Jasen - 20 Oct 2006 5:46 PM - 3 messages
Hi, We currently have a very high volume ASP.NET application.  The web server is processing anywhere between 500-750 web hits per second.  These hits include webservices and .aspx pages.  For performance reasons, we cache most ...
Score New to ADO.NET
Shooter4Life8 - 20 Oct 2006 4:32 PM - 3 messages
Hi, I am currently using Visual Basic from Microsoft Visual Studio 2003 ..NET. I would like to create an ADO.NET connection to a local Access database.  Any pointers or helpful informational sites would be much appreciated :) My main questions are: ...
Score Cannot create DataRelation 2005
moWhite - 20 Oct 2006 3:17 PM - 3 messages
I have some code in a VB.NET 2003 assembly that creates two DataTables and a DataRelation between them.  Neither table is specifically added to a DataSet. This runs fine in other VB.NET 2003 projects. When I add this assembly to a VB.NET 2005 project, it dies when this code is ...
Score How to use String Array as SqlParameter in VS 2005
Marcus Kraus - 20 Oct 2006 2:53 PM - 4 messages
Hi there, I can't figure it out. I have following SQL Statement: Select xx from yy where yy in ( 'value1', 'value2') That one is running fine. Now I want to use that SQL Statement in VStudio 2005 DataDesigner... so I would have a string array or else ( maybe Object ) for the values. ...
Score Can you add custom attributes to an Xsd table header file
j2associates - 19 Oct 2006 10:14 PM - 1 message
Hello all, Is there a way to store a custom attribute in the file header of an Xsd file? I would like to store the original loading stored proc name. I would like to be able to do something like the following where SelectCommand is my ...
Score Blobs in a DataTable
Rex the Strange - 19 Oct 2006 6:58 PM - 2 messages
Does anyone know, offhand, how to distinguish between a "blob" type field and a "long raw" type field from an Oracle database?  The DataTable reports them both as being type Byte[] (Byte Array). tia, rts ...
Score Oracle connection pooling problem (Framework 2.0)
Abelardo Vacca - 19 Oct 2006 6:20 PM - 2 messages
Hello, I am experiecing the known problem related to the Oracle provider connection pooling ([link]) However I am having this problem for the Framework 2.0. Was this bug not corrected in the version 2.0? Is it possible I am having ...
Score Cancel Fill Operation
Rex the Strange - 19 Oct 2006 4:53 PM - 3 messages
Hi All, Help please. How can I cancel the Fill operation of an OracleDataAdapter? I have the fill running in a different thread so I can invoke an event while it is running, but nothing seems to actually stop it. I've tried killing the thread, destroying the object, closing ...
Score TransactionScope with SQL Server 2000
Néstor Sánchez A. - 19 Oct 2006 4:36 PM - 2 messages
Hi, Can I use TransactionScope with SQL Server 2000 without DTC? If no.... what is the simplest way (example please) to manage transactions with 2000? Thanks in advance. Néstor. ...
Score Where Can I found the SQLException list ?
Angeljo - 19 Oct 2006 2:59 PM - 3 messages
So, I know that a Violation of Primary Key constraint is the number 2627 but I would see the complete list. Thank You, AngelJo ...
Score Changed Rows with SqlDependency
Midi - 19 Oct 2006 10:11 AM - 2 messages
Hi, I'm using SqlDependency to get changes from a Sql 2005 Server. Every time there are changes on the Recordset i get the whole one - but I need and want only the changed Rows! Does anyobdy knows a way? ...
Score Using a Timestamp field to implement optimistic concurrency
BBM - 18 Oct 2006 9:46 PM - 3 messages
Hi, I'm using ADO.Net SqlCommand objects to do Database reads/updates in an application.  I'd like to use optimistic concurrency, so each of my tables has a Column of type TimeStamp in it. Right now I am NOT using stored procedures.  I am updating the CommandText ...
Score table with automaticily refreshtable with automatically refresh
Tobias Wobben - 18 Oct 2006 9:31 PM - 4 messages
Hi, short description of my problem: I wanna open a dataset round about 30000 records on a SQL 2005. This is not the problem ;-) 30 users are updating the data on the server. I need an idea, if the data on the server is changed, that I'll get the ...
Score OleDbDataAdapter.Update for DB2
igitur - 18 Oct 2006 8:16 PM - 4 messages
I have a populated DataSet that I want to upload to a DB2 table.  There isn't a stored procedure, so I'll have to do it with a direct INSERT statement. The OleDbCommandBuilder doesn't work to generate an INSERT statement ...
Score comparison reporting -- technique suggestions?
matt - 18 Oct 2006 8:15 PM - 9 messages
hello, i have been given a challenging project at my org. i work on an inventory management web application -- keeping tracking of parts assigned to projects. in the past, i built an in-house ASP.NET reporting system. just your standard stuff -- user clicks on a report, ...
Score .NET 2 DataTable SLOW
James - 18 Oct 2006 7:10 PM - 4 messages
I recently attempted to convert an application from .NET 1.1 to .NET 2.0.  I discovered that the performance of filling the DataTable objects was ridiculously slower than in the .NET 1.1 incarnation.  So I wrote a little ...
Score What type of transactions do you use now?
Smokey Grindel - 18 Oct 2006 3:19 PM - 2 messages
We use to use the classic sqltransaction, but now with transaction scope's, the question is which one do you perfer? and why? thanks! ...
Score VB2005 : Create table in Access - copy of another table but without the data
Screaming Eagles 101 - 18 Oct 2006 11:04 AM - 3 messages
Hi, I'dd like to create a table in an Access MDB, which is a copy of an existing table, but without the data, only the structure. ...
Score SqlTransaction
Neven Klofutar - 18 Oct 2006 10:53 AM - 6 messages
hi, I would like to learn some details about how SqlTransaction really works. Can you please recomend some posts, sites, forums about the subject ? thanx, Neven ...
Score SQLDataReader not working
Yash - 18 Oct 2006 9:09 AM - 3 messages
Hi, I am trying to read data from a stored procedure(SP) using the SQLDataReader. Inside SP, i populate a temp table (created using SQL Table variable) with some records based upon some logic. Last statement in the SP, selects few records from the temp table. ...
Score How to add a column to the first position
ad - 17 Oct 2006 9:24 PM - 5 messages
I use the code below to add a columns to the columns of a table.     Table1.Columns.Add("NewField", typeof(string)); But it always add the clolumn to the last position. How can I add a column to the first position. ...
Score Leaking ADO.NET Connections from ASP.NET 2 Web App
Sierra - 17 Oct 2006 6:46 PM - 2 messages
Problem: Database connections are not being reused properly. SP_WHO2  shows upwards of 200 connections being created per page request. Most connections exist for 60 seconds then close without being reused. A few connections are reused. SQL System Profiler shows many “Audit Login” and many “RPC: Completed” records ...
Score how to handle connections on heavely used app
Smokey Grindel - 17 Oct 2006 5:32 PM - 6 messages
I have a web app which could get 10,000 hits per minute, and relies heavely on database interaction... we've always been told open and close connections only when needed... but what happens if two people hit a page at the same ...
Score Best way to create a database
David Thielen - 17 Oct 2006 5:02 PM - 12 messages
Hi; We have an ASP.NET portal product we are about to start shipping. It needs a database to run. To create the database which approach do you recomend (and why): 1) Provide Erwin generated scripts for each vendor that will create the ...
Score Problems connecting to Oracle 9i database with Oracle 10g Client and Win XP x64
Sacha Korell - 17 Oct 2006 2:11 PM - 3 messages
Hardware/Software: Dell Precision 490 with Intel Xeon 64 bit processor running MS Windows XP Professional x64 Edition Version 2003 Service pack 1. Visual Studio .NET 2005 Oracle 10g Client I am trying to run my ASP.NET application from the above mentioned computer ...
Score Addign a row to a dataset
Ant - 17 Oct 2006 2:11 PM - 9 messages
VS2003 C# Hi, My dataset is ordered. When I add another row to it by creating a new row then using AddNew(), & then persisting it to the underlying table, thencaccepting changes to the dataset, the new row is appended to the ...
Score Dynamic Column names
coolCoder - 17 Oct 2006 6:54 AM - 3 messages
Hi All,           I have a tricky situation here. I want that the column headers of a query result should contain some dynamic information ( ex, date ).         If my query output is something like this -- ...
Score Filtering Parent table on child records
Helen Warn - 17 Oct 2006 1:32 AM - 9 messages
Good day, I have a DataSet with 2 tables, Parent & Child, that are connected by a DataRelation. I would like to filter the Parent table to display only those records which have a record in the Child table that satisfies a certain ...
Score ComboBox databinding - complex
Mike - 16 Oct 2006 11:28 PM - 2 messages
I have three tables. TableA and TableB contain data related via TableC (a many to many relationship). I would like to use a ComboBox to allow a user to choose the TableB entry for TableA. Ideally, the data in TableB would appear in a sorted fashion in ...
Score How to get the index selected in the datagrid table
anant - 16 Oct 2006 6:44 PM - 2 messages
How to get the index selected in the datagrid table which contains the employees table information ,on getting the index who to update the record at that index in to other table --- Posted via DotNetSlackers.com ...
Score Checking for db connectivity
Bluemel - 16 Oct 2006 3:45 PM - 3 messages
I am trying to check for db connectivity during the onload event.  To do this I use the connection time setting from the connection string.  It allows me to set it higher than the default of 15, however if I set it to 5 for example ...
Score how to quickly check for database connectivity quickly
Bluemel - 16 Oct 2006 3:38 PM - 2 messages
I want to check for db connectivity from the onload event.  If there is connectivity I will update and xml file.  I am trying to use the connection string Connection Timeout setting, however the Conneciton Timeout setting will not  go below the default of 15 seconds.  I can set it to 20 or over and ...
Score Transport level error with .NET 2.0
aliostad - 16 Oct 2006 9:29 AM - 7 messages
Has connection pooling implementation changed in .NET 2.0?! I was happily running a code in 1.1 and now it seems that I have a problem and receive this error: System.Data.SqlClient.SqlException : A transport-level error has ...
Score Strange SqlConnection problem
Steve Price - 16 Oct 2006 8:30 AM - 2 messages
Hi, We've got a program thats been happily in production for the past few months, but we'ev come accross a problem, for one users profile, we are unable to create a SqlConnection object, getting the exceptions below related ...
Score bind data to gridview using custom data class?
vineetbatta - 16 Oct 2006 6:07 AM - 6 messages
I have Custom Data class which stores data about single customer and then i store that customer objects in arraylist as shown below. Customer custdata = null; // Custom Data class for 1 customer data.         ArrayList ar = new ArrayList(); // To store more than one customer ...
Score how to bind Data to Grid view with custom data class.
vineetbatta - 16 Oct 2006 6:06 AM - 1 message
I have Custom Data class which stores data about single customer and then i store that customer objects in arraylist as shown below. Customer custdata = null; // Custom Data class for 1 customer data.         ArrayList ar = new ArrayList(); // To store more than one customer ...
Score xml into collections
dnvhari - 16 Oct 2006 4:36 AM - 1 message
Hi all, we have an xml file. Based on this file we have to generate menu. This xml file changes every day. We are loading the xml file into the application memory and transforming the data of xml file into collections (using classes). ...
Score indexing problem when adding row
Ant - 16 Oct 2006 3:51 AM - 2 messages
VS2003 C# Hi, I have a form with all txtboxes databound. A list box shows a list of names which can be used to pick a record (using the find method to return the index of the row. This index is then used to set the binding context position) ...
Score null date
JB - 16 Oct 2006 1:03 AM - 1 message
I have a form with a number of textboxs bound to a datatable which is populated by a query on SQL server.  Some of the datatable columns are of type dateTime.  When the user enters a normal date in one of the textboxs ...
Score Datagrid inside a Panel doesn't load records
Lambuz - 15 Oct 2006 9:22 PM - 5 messages
hi all, I'm using .NET Framework 2.0 and I've created a Panel with a DataGrid inside. This datagrid was created automatically by dragging & dropping into it a datasource. The problem is that if I put this panel into a Form I can't load any ...
Score Why no good resources on junction table scenarios?
Earl - 15 Oct 2006 6:48 PM - 3 messages
Over the years I've read a lot of good books, articles, even posts on ADO.Net. But when it comes to anything more complex than single or multiple single table updating scenarios, there seems to be a dearth of good ...
Score C# / ADO.NET Questons
DaBrain - 15 Oct 2006 7:59 AM - 3 messages
I can use some help here. I have been moving from Delphi/C++ Win32 Database Development (ADO) to C#.Net /ADO.NET  the language is not the problem ADO.NET is however kicking my butt. I finally get the true power and purpose of a Dataset, wow, that was a ...
Next »