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 , but have been unable to find info on the web as to how to do it - th...more >>

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 Access) that can be understood easily by a novice like me. If any...more >>

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 any plan to place the resultset in ADO.NET? It just seems FAR easi...more >>

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, and then use that number as the new "row ID" (the base table then gets...more >>

In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff, and execute it to create my schema for MS-SQL2000? Jack ...more >>

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 the DB on the fly. Actuall I'm tryi...more >>

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. I used to build quick and dirty config files -- ...more >>

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 come off of the record. For other desktop apps, it's not quite so obviou...more >>

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. For the DataTable's Lo...more >>

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 remoting from my c...more >>

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 transfer the new information that is on my website database to my...more >>

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 ...more >>

(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 A...more >>

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. Hasta el dia de hoy estado utilizando el componente DOA para Oracle, y estoy permanentemen...more >>

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 However, I am looking to learn about the "new" way of working w/ data... TableAdapte...more >>

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 gets the data the last columns are system.dbnull, an...more >>

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 the schema and genetated a program, I put a simple grid view in the form...more >>

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. Can I do the same in VisualStudio 2005? When I look fo...more >>

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 tables. As an aside; I started playing with Visual Studio 2003, and now...more >>

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 table. I would like to load "objects" from table, and I would like to modify or delete objects, without dealing with datab...more >>

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...more >>

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 remember its name. I know there are various ORM tools out there, and I ...more >>

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 1 1234 bla8 092705 ...more >>

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 are having ...more >>

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 provider for oracle (system.data.oracleclient.dll version 1.1.4322.2032), the f...more >>

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 long as we do not execute two Updates in the same row,...more >>

hello all, Created procedure in sqlserver accepting id as parameter to delet record. initialized statements Dim DeleteCommand As New SqlCommand("DeleteProc", conn) DeleteCommand.CommandType = CommandType.StoredProcedure dataAdapter.DeleteCommand = DeleteCommand AddParams(dataAdapter...more >>

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...more >>

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 to avoid this? ...more >>

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 from conflict resolution point of view. Thanks Regards ...more >>

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 easy, but maybe it's the...more >>

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 send update to remote service. But, when i need to make standart oper...more >>

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 datatable... i've tried it.. i...more >>

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? ...more >>

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 last 1 year suddently start giving timeout error when query...more >>

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? ...more >>

Hi How can I insert a dataset into an sql table? Thanks Regards ...more >>

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" /> Thanks ...more >>

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 a property (i.e., serialized to app.config). This is ok for design...more >>

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 i...more >>

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 appears that my currentdatetime parameter is going to the next line and I a...more >>

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. With the 1.1 Framework on a machine (that...more >>

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...more >>

... ...more >>

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?) SELECT 'Inpatient' AS Type, [IN-BNFT] AS Benefit, [IN-BFC...more >>

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. I know how to accomplish a connectionstring ...more >>

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 & how do you iterate through the 'record set'? (I'm using c#) ...more >>

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 procedure in t...more >>

Hi All, I want to update the values into database.And i get these values from a xml file.I have done the coding for that but its not getting updated.Plz tell me whats wrong in my program.if possible provide me some code for this...... DataSet XMLDataSet = new DataSet(); DataSet Sq...more >>

How do most people support multiple database types such as SQLServer, Oracle, Access, etc.? Mainly I am wanting to just support MS (SQLServer and Access) but may need others in the future. I am currently looking at creating a simple class that has a few methods for creating and accessing an...more >>