Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score SQL Select and primary keys
J L - 9 Apr 2005 11:47 PM - 5 messages
I should know this but I dont and cant find an answer via Google... If my table as a primary key bases on multiple fields and I do a select with a Where statement using those fields, will the select be ...
Score Data Access Layer that allows Multiple Data Sources
Scott - 9 Apr 2005 5:02 PM - 4 messages
Has anyone come across any elegant frameworks that allows writing to multiple data sources? I'm looking for something that allows a typical master data source for storing and retrieving data, but I'd also like it to be able send select data to other datasources. IOW, the other ...
Score vb.net
anu jyala via .NET 247 - 9 Apr 2005 6:41 AM - 2 messages
(Type your message here) hello,    i'm using fill method to populate.and fill method implicitly open and close the executereader connection.  and my question is why the error occured"there is already an open datareader associated with this connection which must be closed first"  only inside the  combobox selectedindexevent and textchanged event.? when i call this parameterized querry inside any other event's as keyevent,click event it work's succesfully? how can i correct it?if the existing connection is there how can i close it? ...
Score How can I Return a selected row without the Frist column (ID autonumber column) ??
David Eadie - 9 Apr 2005 2:26 AM - 3 messages
G'Day all, Heres my code: (watch for wrapping) 'MDB Connection and open         Dim MDBConnection         Dim MDBConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=example.mdb" ...
Score Record navigation with Paging
Hari - 9 Apr 2005 2:10 AM - 5 messages
Hi, Iam working with a custom grid control to navigate navigate large number of records from a table. The control need to have row up, row down, page up, page down features. Requirements are :   page size = 30 records   maximum records in database table - 20,000 (each record ...
Score Can't Create SQL Server Stored Proc in VS.NET? Help!
Ken - 8 Apr 2005 8:03 PM - 7 messages
I can create Stored procedures directly in SQL Server using the enterprise manager but can't get VS.NET 2003 to let me. I am logged in as an aministrator on the server, and using .NET on the database server. What ...
Score Null Values
Kevin - 8 Apr 2005 5:48 PM - 4 messages
Am fed up with Null values crashing my applications and screwing up data when it hits a check or combo box, in Visual Studio 2002. Have found numerous fixes on various sites and now feel am going round in circles. ...
Score DataGrid, Relations and Binding
Harry - 8 Apr 2005 4:52 PM - 4 messages
Hello, I have a DataSet built from a .XSD that contains relations. For example consider the XML fragment below: <Apples>   <Orange ID="A"/>   <Orange ID="R"/> </Apples> <Apples> ...
Score Excel Reports in VB.NET
krallabandi - 8 Apr 2005 2:01 PM - 3 messages
Hi, I am trying to generate Excel sheet using Provider=Microsoft.Jet.OLEDB.4.0; I am always getting the error while inserting data into any cell other than A. An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll ...
Score Excel Report in VB.NET
krallabandi - 8 Apr 2005 1:49 PM - 2 messages
Hi, I am trying to generate Excel sheet using Provider=Microsoft.Jet.OLEDB.4.0; I am always getting the error while inserting data into any cell other than A. An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll ...
Score update via component
Kurt Schroeder - 8 Apr 2005 1:33 PM - 4 messages
I followed a walk through and created a record set. The db functionality is being handeled in a component. dataaccess is working fine, but i'm not able to built a sub to handle the updates. the walkthrough. I used studio to create the component and it generated all the edit, update, ...
Score How to compare DataTables?
Mika M - 8 Apr 2005 1:28 PM - 2 messages
Hi! I should retrieve DataTable of the source database and compare that with the target database's DataTable. Only those lines in source database's DataTable which has (new unknown) code that does not already exist in target database's DataTable should add (ie. import) into target ...
Score Re: Oracle Provider 1.1 Error; dbid length too long
mentalmike - 8 Apr 2005 7:59 AM - 2 messages
hi, I've got the above problem with the database name being too long and I was wondering if there is a fix or how I go about with work around? Cheers for any help -- mentalmike ------------------------------------------------------------------------ mentalmike's Profile: [link] View this thread: [link] ...
Score How to merge a subset of rows from one dataset to another
moondaddy - 8 Apr 2005 5:29 AM - 2 messages
I need to merge/copy/import or what ever you want to call it, select rows from a dataset to another.  for example, say ds1 has 10 rows and I want to get only the rows where the column 'category' has a value of 2, and merge ...
Score Error inserting record into SQL Server using ADO .Net
Roopali via DotNetMonster.com - 8 Apr 2005 4:40 AM - 3 messages
Please tell  me what could be the problem with this piece of code Error : Message    "Prepared statement '(@ID int,@fname varchar(50),@lname varchar(50),@mname varchar(50' expects parameter @ID, which was not supplied."    ...
Score Getting a list of Tables from SQL
J L - 8 Apr 2005 3:56 AM - 3 messages
I have used the OleDb connection GetlOleDbSchema & OleDbSchemGuid.Tables to get a list of tables from the Access database. I can not find the equivalent way to get a list of tables from an SQL database. Please advise how to go about this. ...
Score Update Multiple Tables in Database using DataRelations
russzee - 7 Apr 2005 11:02 PM - 9 messages
Hello, I'm working with NorthWind My Customers Form uses Untyped Dataset and Bound Controls (BindingManagerBase). However, deleting a customer and updating the database is throwing an error because of Referential Integrity issues. I'm trying to use DataRelations to resolve this issue. ...
Score ADO.NET or Enterprise Services (ES)
lottoman2000 - 7 Apr 2005 8:51 PM - 10 messages
I am debating which route to take for Declarative Trans Application. ADO.NET or ES (COM+). What do i gain by going the ADO.NET rounte and cetainly at what cost? Thank you ...
Score Interesting DataSet/DataTable question
Sahil Malik [MVP] - 7 Apr 2005 8:38 PM - 4 messages
Friend of mine asked me this, I'll try look at this later in the evening, but hey feel free to take a stab -- lets say I have a table(table1) that looks like Region,State,count -------------------- West,CA,10 ...
Score reference the oledbupdatecommand, how?
Kurt Schroeder - 7 Apr 2005 7:27 PM - 2 messages
I'm getting there! I'm using vs.net and have created a dataadapter and a recordset in a component. i'm able to reference the component to get data .Hey! i even created a dataview! however, i'm not sure how to reference the created oledbupdate command. ...
Score Sybase stored proc column values change when called from ASP.net page
simran2371 - 7 Apr 2005 6:24 PM - 2 messages
When I call a sybase stored proc from RapidSQL, I get back the value -100 for some columns(which is correct). However, when I call the procedure from an ASP or ASP.NET page, I get back -1 instead of -100. ...
Score Calling BeginTrans without Commit / RollBack
akano_at_yahoo.de - 7 Apr 2005 5:27 PM - 3 messages
Hi, Will there be any negative impact (subtle issue) on the database if one calls SqlConnection.BeginTransaction but not SqlTransaction.Commit or SqlTransaction.Rollback afterward? I am talking about the case where it's imposible to issue the commit/rollback commands, e.g. a sudden blackout. ...
Score "No size set for variable length data" Oracle update error with empty string in .NET
arvee - 7 Apr 2005 4:22 PM - 2 messages
Hi - I'm updating an Oracle table with an empty string and getting the error: An unhandled exception of type 'System.Exception' occurred in system.data.dll Additional information: Parameter 'p1': No size set for variable length data type: String. ...
Score Expression columns in strongly typed datasets
Brian Smith - 7 Apr 2005 2:51 PM - 3 messages
I have a typed DataSet populated from a SQL query. To the columns returned by the query I have added a calculated column with an expression of the form Quantity * UnitPrice, but after filling the DataSet with a DataAdapter the expression column remains at the default ...
Score Returning a dataset to bind to a listbox
Jordan - 7 Apr 2005 1:31 PM - 8 messages
I'm trying to incorporate a data tier into my asp.net web application (add, update, delete, etc), as opposed to using spaghetti code. So far my "getter" class, "CabinetSpec.vb", has Update, Add, and Delete methods that work perfectly.  However, I am having problems with my "List" function which ...
Score Querying the version of MDAC
Mark Rae - 7 Apr 2005 7:40 AM - 3 messages
Hi, In ASP classic, I used to do something like this: <% Sub TestMDAC(pstrConnectionString) Dim conn Dim strVersion Set conn = CreateObject("ADODB.Connection") conn.ConnectionString = pstrConnectionString conn.Open strVersion = conn.Version conn.Close End Sub %> Is there a native .NET way to do the same? I'm hoping to run this on my ...
Score Adding constraints
Lubomir - 6 Apr 2005 8:23 PM - 5 messages
Hi, I have an ACCESS database, with 2 tables. The realtionship between tables is set 1:1. I put those tables into dataset and set up the foreign key constraints: DataColumn parent = ds.Tables["Empl].Columns["AdvertisementID"]; DataColumn child = ds.Tables["Pictures"].Columns["AdvertisementID"]; ...
Score running out of memory
Supertree - 6 Apr 2005 8:13 PM - 5 messages
Hi; I have to write custom data integrity utilities comparing files with table data. I've found that looping through an ado recordset will cause memory problems if it's a large recordset. I'm using this sort of syntax: ...
Score DBTimeStamp - Data type mismatch in criteria expression
jimmy - 6 Apr 2005 6:12 PM - 2 messages
Hi, I'm receiving an exception of "Data type mismatch in criteria expression" when trying to store a date and time to a column of Access 2002.  The default parameter constructor puts the DBType as DbDate which stores only the date portion.  It needs to be changed to DbTimeStamp in order to have the time portion stored.  It works for my another program but not this time, unfortunately.  I'd spent the last 3 days trying to solve this problem as the time portion is critical to my application.  What did I do wrong? Thanks. ...
Score SQL Data Written fm ADO.NET read fm ADO
CBKowitz - 6 Apr 2005 5:55 PM - 4 messages
I have two applications one written in Access 2002 using ADO and the other written in VB.NET using ADO.NET.  The Access application looks for files and runs an associated process once the file is found.  The VB.NET application ...
Score Moving info between two tables
Prasun - 6 Apr 2005 4:58 PM - 2 messages
Hello: I have 3 datatables under a dataset .  They have the same columns and were populated from the same excel sheet.  I would like to move the info from one column in a datatable to another column in another datatable.  I have ...
Score Text File
Andy Williams - 6 Apr 2005 3:03 PM - 3 messages
I'm trying to open a comma delimited text file using the following code, but no luck... Dim cn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\monkey.txt;Extended Properties=""text;HDR=no;FMT=Delimited""") ...
Score Data Problems
Kevin - 6 Apr 2005 2:58 PM - 4 messages
Am using the VB.NET (Vis Studio 2002) Data Form Wizard. As soon as I include a checkbox the data form just stops working. Using SQL Server 2000 and the bit field type. Any ideas? as am going round in circles :( ...
Score System.Data.OracleClient exception while using multiple Oracle homes
Michael via DotNetMonster.com - 6 Apr 2005 2:39 PM - 3 messages
Hi, I'am getting "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" in ASP.Net apps while trying to open Oracle connection. I am using Oracle Data Provider to connect to oracle database and have two Oracle clients 8.0 and 9i on my local PC. ...
Score Type Dataset with database
Mark Lyday - 6 Apr 2005 2:16 PM - 3 messages
I am trying to use Crystal reports to create a report for a dotnet app I am writing.  Crystal reports only works with type dataset, which is where I have my problem. I know how to create the typed dataset if my data is comming from a database ...
Score How to use typed datasets in 3-tier environment
Gabriel Lozano-Morán - 6 Apr 2005 1:49 PM - 4 messages
What is the proper way of working with typed datasets in a 3-tier environment? Should I use a common assembly for the typed datasets that can be referenced in the presentation layer, business logic layer and the data access layer? I really don't want to add a reference to my data access layer ...
Score Size of datatable...in bytes?
Jesper - 6 Apr 2005 12:46 PM - 10 messages
Is there any way to get or estimate the memory being used by a dataset or a datatable? I'm writing a caching class and trying to keep track of the size of the data I'm keeping or at least an estimate, to make better decisions on ...
Score COM OBJECT WITH CLSID... IS EITHER NOT VALID OR NOT
NQ - 5 Apr 2005 10:47 PM - 2 messages
I'm developing an application works with SQL Server. I've installed MSDE in my PC. When I run it on my PC everything works fine, but when i try to run the application in another PC (Win XPP) this error ...
Score ConnectionTimeout is always 15 coming back from the DataLinksClass dialog
nuychaco - 5 Apr 2005 10:33 PM - 5 messages
I have an application where we use the OleDb DataLinkClass dialog to retrieve the connection string. In the advanced tab one can set the connection time. I set it to any value but the dialog always returns the default 15. ...
Score Sending XML From .Net To SQLServer
Johny - 5 Apr 2005 8:57 PM - 7 messages
Hi people I have a question about that: Nowadays I'm using the Update Method from DataAdapter but i figure out that it generate multiples roundtrip to my dbserver so i want to use XML to send all my data to SQLServer and process that in just one travel :P ...
Score SQL Server does not exist
rbutch@coair.com - 5 Apr 2005 7:44 PM - 7 messages
guys i need some help here. what was working somehow has has stopped. the drive in the machine i was using died and was replaced, so i had to re-install SQL Server. i was developing on my laptop with an instance of sql server using the conStr of("Data Source=(Local);Initial Catalog=A39;Integrated Security=SSPI;") ...
Score Join two datatables populated from different sources?
Dave - 5 Apr 2005 6:35 PM - 8 messages
Hi, I've managed to populate a dataset with two different datatables from different webservices.  They each contain a different number of columns but both have the Ticker symbol as a common key. Is there a way to "join" or combine these the two tables based on the ticker ...
Score ANN: Microsoft webcast on DataSets
Pablo Castro [MS] - 5 Apr 2005 4:54 PM - 5 messages
Sorry for the spam, but I thought some of you might be interested on this :) Next Thursday we'll be hosting a webcast on DataSets. The speaker will be Kawajit Bedi, the Program Manager that's responsible for DataSet and "the ...
Score DataTable Merge
Prasun - 5 Apr 2005 4:47 PM - 2 messages
Is it possible to be able to merge multiple DataTables in a DataSet? What is the intructions/code for doing so? Thank You Prasun ...
Score DataReader Vs DataSet
mavrick101 - 5 Apr 2005 4:43 PM - 3 messages
At several times in my code I am opening and reading data from data reader. Would using the DataSet instead improve the performance? As few times in my code ,  to get items one by one while the connection is still open, sound ...
Score Binding a DataRelation to a Datagrid??
Dave - 5 Apr 2005 4:11 PM - 2 messages
Hi, I'm trying to bind a datarelation to a datagrid so that I'll show all the columns from the first and second datatables that relate (parent/child). The code below only shows the data from the master table? How do I include ...
Score DataAdapter Configuration Wizzard
Bob Day - 5 Apr 2005 3:43 PM - 3 messages
I am trying to create something like:     DELETE FROM Customers WHERE CustomerID = @CustomerID by using the Build query in the DataAdapter Confirguration Wizzard. However, regardless of what I set the WHERE to, I get an error when clicking ...
Score memory leak in SqlDataAdapter.Fill method?
Ben - 5 Apr 2005 3:29 PM - 7 messages
I have a program that invokes the following block of code every x seconds.  The process private bytes keeps increasing after every call. I've try to dispose the SQlDataAdapter in the finally block, but did not work. If I invoke the garbage collector manually GC.Collect in the ...
Score ADO.Net Connection Pooling Problem with Oracle
Bird - 5 Apr 2005 1:09 PM - 4 messages
Howdy, I recently implemented an ASP.Net application and am having trouble with running out of database connections. I've read many articles on the web concerning pooling, but have yet to find one that really describes in detail how pooling is supposed to behave. My problem is ...
Score DataView.RowFilter issue
Jensen bredal - 5 Apr 2005 7:01 AM - 8 messages
Hello, I use The RowFilter property to select number of row from my dataview. How can i get the number of rows found ? I experience that the number of rows remains the same  as before the filter was applyied if there i no match for the filter. ...
Score Formatting a SQL query
Roshawn Dawson - 5 Apr 2005 1:16 AM - 7 messages
Hi, I have the following query written for MS Access: PARAMETERS [Enter a keyword to search] Text ( 255 ); SELECT TOP 10 ISBN, Title FROM Books WHERE Keywords LIKE "*" & [Enter a keyword to search] & "*" ORDER BY Title; This query works as expected.  Now, how do I write this query in VB.NET ...
Score Cannot Open Any More Tables
Matthew Holton - 4 Apr 2005 10:01 PM - 4 messages
I was working on creating a data library to use throughout my applications, when I came across an odd behavior.  I encounter “Cannot Open Any More Tables.” After using the OleDBCommand.ExecuteNonQuery method.  I have included code that recreates the exception.   I cannot recreate this error ...
Score Editing Info in a DataTable
Prasun - 4 Apr 2005 9:35 PM - 6 messages
Hello: How can you you edit data in a datatable? I already have the datatables created. I want to know how i can refer to the columns in the data table and what commands do i have for editing info in the table. I want to be able to ...
Score shared access folder problem
Stephen - 4 Apr 2005 9:20 PM - 7 messages
Hi guys... I have a web app that works pretty good . It was developed with the access database in the virtual directory....now thats its about done, i would like to reference the database from a shared network directory. I thought all I ...
Score weird ADO issue
Paul Shpilsher - 4 Apr 2005 9:10 PM - 3 messages
Hi all, I apologize for posting in this NG if this post is a better fit for some other group, however I am up against the wall here. My program uses free threaded COM.  Once in a while (depending on routines I ...
Score multiple tables in a flat grid
The Burgess Family - 4 Apr 2005 8:59 PM - 5 messages
What is the best way to create a datasource for a single flat grid that pulls from multiple updateable datatables? I'd like to pull back multiple tables, create relationships between them, then have a grid bind to a 'view' of these tables so that when I ...
Score Rows
Steve Schroeder - 4 Apr 2005 7:55 PM - 3 messages
How might I return a current count of rows in a dataset table? I tried the obvious: DataSet.Tables("TableName").Rows.Count However that returns the original number of rows, and not the number of rows filtered subsequently in my datagrid. How may I return either the number of ...
Score Why can't I find...?
Steve Schroeder - 4 Apr 2005 7:17 PM - 5 messages
Why can't I find a reference page for ADO.Net, you know, objects, properties, methods...? I can find all kinds of feel good stuff like: Best Practices, Migration, ADO.Net & You...but no straight up, no b.s. reference. Kinda sucks :-S ...
Score Schema Collection -> Strongly Typed Dataset
Vicki - 4 Apr 2005 6:01 PM - 7 messages
I have a bunch of .xsd files some of which inherit from others, such that there are elements that have attributes in one file and also inherts other attributes from another file.  These schemas come from an external source (I ...
Score Dataset Merge Question
Jim McFadden - 4 Apr 2005 5:59 PM - 9 messages
Does anyone know exactly how the MERGE method on the dataset functions? The reason that I am asking is that it does not appear to be doing what I expect, and what the documentation claims will happen (if I am understanding it ...
Score ReadXml into a DataTable?
Dave - 4 Apr 2005 5:31 PM - 6 messages
Hi, I've gotten the dataset.ReadXml() method to load XML from a remote source but I was wondering since I plan on having multiple datatables in the dataset, can you specify which table to read XML into?  I'm using ASP.NET 1.1 ...
Score Multiple DataTables in Dataset
Vish - 4 Apr 2005 5:31 PM - 9 messages
Hi, I am returning multiple datatables from a stored procedure into a dataset. It keeps naming the datatables as "Table","Table1","Table2" etc. Is there a way i can change the sproc so that my datatables get created with a name ? ...
Score MS Best Practice - Load subset of a single Row
Jim Brandley - 4 Apr 2005 5:09 PM - 9 messages
Can someone please tell me the recommended best practice for loading a subset of the columns from a single row of a database table? Users can make fields come and go from the form, so a stored procedure is not an option as I see it. ...
Score Reset SQL Server connection pool?
Jon Pope - 4 Apr 2005 5:01 PM - 2 messages
Is there a way to reset the connection pool on a machine so that all cached connections to a database are closed? Cheers, Jon ...
Score Retrieving datarows using DataTable.Select method and adding it to new DataTable
C.Anand via DotNetMonster.com - 4 Apr 2005 4:07 PM - 5 messages
Hi, I have the following fragment of code which retrieves datarows from a data table using the Select method.I want to add these rows into another data table.But I get the Exception: 'Column "ReleaseDate" already belongs to another table' ...
Score Transactions in ADO.Net 2 strongly-typed datsets.
gwolinsky - 4 Apr 2005 3:55 PM - 32 messages
Here's the scenario:  I have a custom object that represents a group in our law firm.  For each group, there are many members of that group. Now, the group object exposes a property that is a strongly-typed ...
Score data access
joe hassan - 4 Apr 2005 3:35 PM - 2 messages
Hi all, I am trying to gather records from different databases into one dataset. I can do the select statements and get the data into the datatables and then into a dataset. The problem is then being able to get the data I need from ...
Score What is "Any instance members are not guaranteed to be thread safe" ?
ks_lon - 4 Apr 2005 3:11 PM - 4 messages
Hello all, I was developing an ASP.NET application using c#, and I was thinking for adding some instance variables for my xyz.aspx like this :- public class SetCustomers : System.Web.UI.Page     {         private string s_workemail = ""; ...
Score problem with nested relations in typed datasets
Elhanan - 4 Apr 2005 2:26 PM - 3 messages
hi.. i have 2 problems if i create a table relationship  between 2 tables and define it as nested in the "is nested" property schema it does not create any DataRelations if i try to define a nested Relation in runtime but with a constructor ...
Score DataColumn.Caption
Nikolay Petrov - 4 Apr 2005 12:49 PM - 3 messages
I've set the Caption property for a table in DataSet, so when hte DataSet is binded to a Datagrid, the caption is displeyd instead of the column name. But it doesn't work. I get the column name instead of caption. ...
Score How to use Like in free text search on Datadview.Rowfilter or DataTable.Select()
Jensen bredal - 4 Apr 2005 12:41 PM - 3 messages
Hello, I need to implement a free text search on an asp.net page. I need to search two columns based on a text entered in a tex box. it should be possible to search any subsrting included in one of the two ...
Score Bug of SqlClient?! Problem with output parameter/SQL Server 2000!
Neo The One - 4 Apr 2005 10:03 AM - 5 messages
Here is the simple test stored procedure: <code> CREATE  PROCEDURE pr_test (     @xParam1 nvarchar(200) = null output ) as --set @xParam1 = newid() select result = @xParam1 set @xParam1 = newid() </code> If I run the following test SQL script in Query Analyzer, I get expected ...
Score Using Transactions in C#
daniel schmied - 4 Apr 2005 10:02 AM - 6 messages
Hi, i have some wired behaviour using c#, ado and sql server. There are two tables on sql server: Order and Orderdetails. (Order_ID is primary key on Table Order and foreign Key on Orderdetails.) I have two c# Classes calles Order and Orderdetails. They contain two ...
Score DeriveParameters and Jet OLEDB Provider
Doug - 4 Apr 2005 8:11 AM - 5 messages
Hi I've just discovered that the Jet OLEDB Provider does not support OleDbCommandBuilder.DeriveParameters, to discover the number and type of parameters expected by a Microsoft Access query. I'm a little surprised, as it was always possible to use the ADO Refresh ...
Score ADO.NET 2.0 - Question for Microsoft Employees
Sahil Malik - 4 Apr 2005 2:55 AM - 10 messages
Okay, so we have a new Isolationlevel for transactions in ADO.NET - the snapshot isolation. That exists at System.Data - which leads me to believe that nothing really stops me from setting that isolation level on Oracle. So my question is - by setting that on Oracle, does it mean the same as ...
Score Datarepeater
pax - 3 Apr 2005 2:28 PM - 5 messages
Hi, NG! Is there any updated version (.Net) of the Datarepeater control or do I have to use the old (VS6.0) version? Thanks. pax ...
Next » 2 3 4 5 6 7 8 9 10