Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score I'd like to programatically move through a table
barret bonden - 31 Dec 2005 11:58 PM - 6 messages
I'd like to programatically move through a table (call it a recordset in ADO ) and disply fields  in a textbox. I've gotten as far as the code below (which just loads a listbox)  I assume I need to work with the dataadaptor , ...
Score Problem using diffgram
Shtirlits - 31 Dec 2005 8:50 PM - 1 message
I'm use diffgarm xml (for update)  which is sent with a schema with sqlxmlcommand whith sqlxml version 3 sp3. This mechanizem used ALL the parameters in the before xml as the parameters used in the where clause used ...
Score Managing "Row ID" for Table Inserts
Joe Reggae - 31 Dec 2005 5:16 PM - 7 messages
Using c# and Visual Studio 2003, I've begun to wonder whether I'm adding rows to Oracle tables correctly. The tables often have "row ID" columns and, before adding a row, I pull the "max" ID value from a table, add 1 to it, ...
Score SqlCeResultSet, why not in ADO.NET?
Rick Lederman - 31 Dec 2005 3:56 PM - 4 messages
I just discovered the SqlCeResultSet in the compact framework.  It is more like ADO or DAO than anything else that I have seen as far as coding in a VB application goes.  It appears to be very fast and efficient too!  Is there ...
Score History of Data Access
SwatSoftwareDev - 31 Dec 2005 6:28 AM - 8 messages
Hi, I'm a novice programmer. When reading stuff on ADO.Net I often face terms like OLE DB, ODBC. Is there anyone who knows the web links that can provide me the concepts like these (ODBC,OLE DB and other concepts related to Data ...
Score Generate DataSet in 2.0?
Mark Olbert - 31 Dec 2005 5:12 AM - 10 messages
I'm beginning to think Microsoft has spent the last few years revising .NET so as to break every single programming construct I've developed. Sheesh! Today, I'm trying to figure out where the Generate Dataset context menu option went in VS2005. ...
Score Philosophical question: how often to submit updates to database
Earl - 31 Dec 2005 12:19 AM - 3 messages
A concept I've waffled on from time-to-time with ADO.Net: how often to submit updates back to the database. For example, I have some CF apps where it's quite obvious the *when* part of submitting the update -- soon as you ...
Score Jet vs. Sql Server Express
kcamhi - 30 Dec 2005 11:04 PM - 28 messages
Greetings - I'm working on a new application and need to select a database for it.  I was wondering if anyone had any views on tradeoffs between going with Jet/Access vs. SQL Server 2005 Express. The database is going to sit on a server.  I'm planning to implement .net ...
Score how do i connect to a remote database
Gerlop - 30 Dec 2005 10:51 PM - 4 messages
i have a website that i use to file all my clients information, the go online and they type the information.  i'm using an microsoft access database.  Now, i want to create a windows application that i can run whenever a want to ...
Score exception on : ra = myCommand.ExecuteNonQuery()
barret bonden - 30 Dec 2005 6:32 PM - 4 messages
(VB Exoress 20005) I get an exception on this line :  ra = myCommand.ExecuteNonQuery() {"ExecuteNonQuery requires an open and available Connection. The connection's current state is closed."} in this code: Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand Dim ra As Integer ...
Score Books on ADO.NET 2.0?
johnb41 - 30 Dec 2005 5:48 PM - 29 messages
I would like to get a good book on ADO.NET 2.0.  I searched Amazon and found 2 books that are rated well: - Pro ADO.NET 2.0 (Expert's Voice) - Programming Microsoft ADO.NET 2.0 Applications: Advanced Topics ...
Score dataset columns with system.dbnull
Buho - 30 Dec 2005 4:42 PM - 4 messages
Hi everyone(happy new year!!), Well, here we go... I have a problem with datsets, ado.net as i understand ..I have a sp that in query analizer retrieve 13 columns and the last 3 like the others have data, but when i see the dataset which ...
Score Creating Schema
Jack - 30 Dec 2005 4:30 PM - 4 messages
In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff, and execute it to create my schema for MS-SQL2000? Jack ...
Score How to use backgroupworker to load dataset?
abc - 30 Dec 2005 4:15 PM - 1 message
As the existing application is running very slow when start application, How to use backgroupworker to load dataset? ...
Score SqlExpress & C# problem in an ASP.NET web site
Lloyd Dupont - 30 Dec 2005 11:28 AM - 3 messages
I'm trying to create a SqlServer express database file on the fly in a web application.. (mhh.... maybe I should try to get something running in a desktop application first?) Anyway I want to connect to a database file and, if it doesn't exist, create ...
Score Conectar BD
EWAT - 30 Dec 2005 11:10 AM - 3 messages
Hola a todos y Feliz año 2006: Tengo que crear una aplicación que accede a una Base de datos, y los datos cambian constantemente en las tablas de la Base de datos, esos cambio son nuevos registros. ...
Score About datatables
Ravindra - 30 Dec 2005 9:02 AM - 7 messages
Hi How to pass the content of one data table to another data table.I simply tried using assignment operator...Example: datatable1=datatable2...But,its not working.. ravindra ...
Score TableAdapter Performance
Programatix - 30 Dec 2005 8:41 AM - 6 messages
Hi, Have anyone ever benchmark the TableAdapter performance compared to DataTable's Load method? I found out that the DataTable's Load method is about 10x faster than TableAdapter's Fill method. I used the same SELECT query and DataSet (predefined), for both test. ...
Score How to bind an object to a table
bumperman_jc - 30 Dec 2005 3:36 AM - 5 messages
Hi,        I am new to .net. I think .NET provides what I need, but I don't know how to implement it.        What I need is simply associating an object with a database ...
Score How to connect a DataView to an access database?
Brad Rogers - 30 Dec 2005 3:11 AM - 8 messages
Im trying to understand DataView, to make a couple of lists of sorted data. The 3 textbooks I have on .net dont have dataview in the index even. Ive started by doing a database wizard.  it finds the .mdb file and formats ...
Score newbie in search of ADO.NET code samples
barret bonden - 30 Dec 2005 2:31 AM - 2 messages
Can anyone point me to step by step walk-throughs of ADO.NET code - I'd like to get to the point of being able to programmatically work with assigning field data to text boxes and then write back changes to the ...
Score .NET 1.1 "System.Data.VersionNotFoundException" - I need a workaro
David W. Rogers - 30 Dec 2005 1:33 AM - 6 messages
I have three related tables, and I am getting an exception when : **************** Dim dataRows As DataRow() = ds.Tables(MappingName).Select_("", "",DataViewRowState.Added) dataAdapter.Update(dataRows) ****************** The exception is: {System.Data.VersionNotFoundException}     [System.Data.VersionNotFoundException]: {System.Data.VersionNotFoundException} ...
Score OracleClient in VS2005 ???
Dino Buljubasic - 29 Dec 2005 9:57 PM - 2 messages
Hi, I am using VisualStudio 2005 (C#) and have to write a code to access Oracle Database.  I know that in .NET Framework 1.1, I could download OracleClient namespace (System.Data.OracleClient.dll) and add referenct to it in my project. ...
Score SQL Querry
Charles A. Lackman - 29 Dec 2005 7:11 PM - 3 messages
Hello, I trying to produce a querry that will accomplish the following and am not sure how to write the statement. I am currently using Jet 4.0 but will be using SQL Server soon. Example Records ID      CustID     Data      Date           Balance ...
Score Unexpected Timeout
Scott S. - 29 Dec 2005 5:35 PM - 7 messages
I have an application that connects to sql server.  Two installs of the application are frequently experiencing the following error: "System.InvalidOperationException: Timeout expired."  We've checked and confirmed that all connections are closed and disposed.  The two sites that ...
Score Oracle Ref Cursor Issue in ADO.NET
Ram - 29 Dec 2005 4:22 PM - 11 messages
Hello, I ran into a performance issue with Oracle Ref Cursor in ADO.NET (with VS 2003). The SQL itself runs in less than 5 seconds in SQL*Plus. (Oracle 9i). When the same is called from ADO.NET using the microsoft ...
Score Whatever happened to ...
Martin Robins - 29 Dec 2005 2:48 PM - 9 messages
I seem to recall, back in the early promise days of Whidbey, that there was talk (and even an early version) of a set of classes for mapping data between objects and a database being a part of the release; alas I cannot ...
Score Quirky response to Update command using datagrid
Earl - 29 Dec 2005 1:15 PM - 4 messages
Using VS2003 and SQL2k. I've noticed that if I have an expression column (or relation column) added to the main table, I cannot do an Update without setting the UpdatedRowSource to either OutputParameters or None. This works fine ... so ...
Score ado.net deleting record sql server
karunam - 29 Dec 2005 5:54 AM - 2 messages
hello all, Created procedure in sqlserver accepting id  as parameter to delete record. initialized statements Dim DeleteCommand As New SqlCommand("DeleteProc", conn) DeleteCommand.CommandType = CommandType.StoredProcedure dataAdapter.DeleteCommand = DeleteCommand AddParams(dataAdapter.DeleteCommand, "testId") At this following line i receive error ...
Score Problem with adding new rows to dataset
Kobus - 29 Dec 2005 5:32 AM - 1 message
Hi I am busy with a C# Windows application. I load data from a MS Access database into a DataSet. In my database the primary key is an AutoNumber field. When I load the data into the Dataset I add the following event handler to ...
Score TableAdapter Fill Code
AaronMoore - 29 Dec 2005 3:08 AM - 3 messages
Hello, I just purchased Visual Studios 2005.  I noticed that when I drag a control from the DataSources toolbar, or set the datasource property of a datagridview, that code is automatically generated in the forms load event to fill the dataset.  How can I disable this feature?  I normally fill my ...
Score dataset.merge not working correctly
Chris - 29 Dec 2005 1:56 AM - 4 messages
Hi, I am trying to merge two datasets into one, each dataset has one table when I merge the two datasets I get a dataset with two tables? I need the merged dataset to only contain one table with the merged data.  Does anyone know how ...
Score Combining fields from different tables into 1 dataset
jonefer - 28 Dec 2005 9:09 PM - 6 messages
So far the dataset just shows Type, Benefit, Change I want it to show Type, Benefit, Change, Description This should be a pretty elementary question - and I've spent 2 days on it already. I just want to add one field from another table into my dataset, should be ...
Score .Net 2.0 DataTable have a lot of lacks?
mtczx232 - 28 Dec 2005 9:02 PM - 11 messages
it seem that data table and Expression field have a lot of Laks, it is true? the DataTable is powerfull of Memory relation data that bind to controls. so i can load data from remote service and manipulate it  and after i ...
Score datarow duplication and unique key conflicts
claudio.benghi - 28 Dec 2005 7:24 PM - 2 messages
Hi all, I need a quick way to create a new datarow based on an existing one change a few values and update them to the database (the duplication should be made in the same db table). I've seen previous posts suggesting to use the ImportRow method for the ...
Score ADO.NET on x64 error: Unable to find the requested .Net Framework Data Provider. It may not be inst
John Yung - 28 Dec 2005 6:47 PM - 7 messages
All, I am running a middle tier component (MarshalByRefObject) as a Windows Service (the Windows Service starts a Console Application which hosts the Middle Tier component). When the services is running under a non-64bit machine, it runs without any problems (accepts client connections and API calls). ...
Score vb.net generated ado.net code - wherefore art thou, insert statement ?
Chris Smith - 28 Dec 2005 6:14 PM - 2 messages
I have a simple little application to maintain books. The books contain a type field that is foreign-keyed to an edit table that contains only a primary key and the description. I have a menu item on the main form that goes to a table maintenance screen ...
Score Dataset to table
John - 28 Dec 2005 4:40 PM - 9 messages
Hi I have a sub method that has been passed a dataset as parameter. I need to insert this dataset into a table. What is the code that I need to do this? The dataset does not have any conflicting keys so it is a very easy scenario ...
Score Brush up my ADO.NET skills
review - 28 Dec 2005 4:13 PM - 1 message
Hi, I am trying to review by ADO.NET skills so what will be the best online site to review the topics in ADO.NET and if possible that should be a future reference to solve some of ADO.NET problems ...
Score sql local database files, need install SQL server on target machine?
mtczx232 - 28 Dec 2005 4:10 PM - 2 messages
New feature come in VS 2005, ability to ADD local database files (.mdf) into project. When i install my EXE on client PC, I need install SQL server? ...
Score Replacement for Com object connect string builder
_DG - 28 Dec 2005 12:49 PM - 1 message
It used to be that you could add references to the same Com object used by VS2003 by: Add ref to [.NET] adodb Add ref to [COM] Microsoft OLE DB Service Component 1.0 Type Library Then using ADODB.Connection and MSDASC.DataLinks to access the ...
Score Query on SqlConnection of ADO.NET
Suhas Vengilat - 28 Dec 2005 6:16 AM - 3 messages
Hi, I have an sql server on seperate system and my application runs on another dedicated server - both the machines works on Windows 2003 server OS. From last 2-3 days one of the .net application which has been working fine for the ...
Score Set connection string at run time for typed DataSet (Framework 2.0
Thomas Taylor - 28 Dec 2005 2:25 AM - 7 messages
I have typed DataSets in a data access tier and want to pass a connection string from the client at run time (for use by the TableAdapters created using VS2005).  However, at design time, VS2005 sets the connection string as ...
Score dataprovider
Kim(Kman) - 28 Dec 2005 12:14 AM - 2 messages
If I only have ASP.Net 1.1 installed on a server what would I replace this with? <dataProvider name="SqlClient"       connectionType="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" ...
Score quick question: how datareader stores data
Vadim - 28 Dec 2005 12:01 AM - 10 messages
Hi, Where does the datareader store it's data in this scenario: Create sqlconnection, Create sqlCommand - query specified here could return 1000 rows SqlCommand.ExecuteDataReader, returns datareader use DataReader.read to iterate through the rows. As far as I understand all the 1000 rows in this case will be initially ...
Score ADO.NET paremeters
WXMCDBA - 27 Dec 2005 9:04 PM - 8 messages
Hi everyone. I have a small problem that I can not seem to resolve. I am executing a stored procedure using the ExecuteReader method. However it is failing. Here is my code in short. I debugged it using Sql profiler it ...
Score Inserting a dataset
John - 27 Dec 2005 8:39 PM - 4 messages
Hi How can I insert a dataset into an sql table? Thanks Regards ...
Score Using Leave event to trigger an Update in Datagrid
Earl - 27 Dec 2005 5:29 PM - 2 messages
I've often used the datagrid CurrentCellChanged event to trigger my Update code. However, I've noticed with checkbox columns, this event is not triggered in the same fashion as with textboxcolumns. So I've been playing around with the datagrid Leave event to trigger an Update and am curious if ...
Score Framework 2.0 Changes ADONET 1.1 SqlCommandBuilder Commands
PaulJB PHD - 27 Dec 2005 4:24 PM - 2 messages
I'm using the SqlCommandBuilder to help construct the update commands to a SQL Server 2000 database. I have the SqlCommandBuilder generate the initial command text and then modify the CommandText to use primary keys to specify the row to be updated. ...
Score loading parent row after child row
Bart - 27 Dec 2005 2:29 PM - 7 messages
Hi, when you load a child row when the parent row doesn't exist in a relational dataset an execption is thrown. Is there an event to capture this occurence before the exeption is thrown? Thanks Bart ...
Score How to generate a dataset from stored procedure which have many resultsets?
abc my vclass - 27 Dec 2005 12:52 PM - 2 messages
How to generate a dataset from stored procedure which have many resultsets? I try Dataset designer from VS2005, it only generate first table from stored procedure on server explorer.  Another table cannot to generate.  How should I do? ...
Score Recursive Parent keywords in Column Expression
Ted - 27 Dec 2005 6:59 AM - 1 message
If I have three DataTables, let's call them "MyParentTable", "MyChildTable" & "MySubChildTable", with a relation between "MyParentTable" and "MyChildTable" that we'll call "FK_PARENT_CHILD", and a relation between "MyChildTable" and "MySubChildTable" that we'll call "FK_CHILD_SUB". If I have an expresion column in the "MySubChildTable" that should access a ...
Score ..
Gary Miller - 26 Dec 2005 11:48 PM - 3 messages
... ...
Score paramaterized Union query?
jonefer - 26 Dec 2005 9:34 PM - 8 messages
This is a union query from an Access Database But I will also be using SQL server For the meantime in Access, I want parameters MRN, [GROUP] and SGR For the following UNION query - (how should I go about this using ADO.NET?) ...
Score Application settings
Dirk Schelfaut - 26 Dec 2005 8:39 AM - 2 messages
Hello I use the data source window to connect to a database. Because the location of the database might vary, I want to change the connectionstring at runtime via my.settings.... but this is an application setting which can't be changed at runtime. ...
Score Equivelsnt to old recordset & movenext
Ant - 26 Dec 2005 6:27 AM - 3 messages
Hi, Is there an equivelant to the old ado recordset which you could use the movenext/moveprevious methdods with? If not, what do you use to do this in ADO.NET? What would be the steps invloved in creating the equivelant object & ...
Score Need some guidance on .NET connection pooling
JL - 25 Dec 2005 5:31 AM - 3 messages
Hi all, Merry Christmas! I have an application that reads records off an Excel spreadsheet and imports them into an Oracle database. What I have in my application is a subroutine that opens a database connection, sets up the command and parameters, and executes a stored ...
Score Earn money Online - without risk!
Earn money Online - without risk! - 25 Dec 2005 1:53 AM - 1 message
Earn money Online - without risk! For all people, who can utilize money. Are you on the search for a lucrative source of income?  Would you like to work of at home out of, without yourself you someone makes directions?  Would you yourself like to ...
Next »