I am now thinking a method to handle the concurrency issue in my program. In .Net, the Command Builder Class will generate SQL automatically in which it compares all the fields' original version with the version in database as the update criteria and thus avoid overwriting others' data. In m...more >>

I'm struggling with relationship constraints, when adding new rows. If I want to add a single row in a single-table scenario and let the user enter values on a fom, it's easy. I just call the TA.Add{tablename}Row() method. In the edit form I bind and do an Update() when done. Problem? Say I...more >>

I'm trying to create an edit form to schedule two teams to play on a given scheduled date. I have a Schedule Table and a TeamMatch Table. The TeamMatch Table has a ScheduleID Column (FK) and two TeamID Columns (FK). I'm in 2005 with a DataSet. I added the three TableAdapters and established ...more >>

Hi We're currently upgrading to Oracle 10g client and we've hit an issue with ..NET 1.0 and 1.1 applications that use OracleClient to connect to Oracle. Basically any .NET 1.0 or 1.1 application that tried to open a connection to Oracle would get a "System.Data.OracleClient requires Orac...more >>

The book I'm learning VB .NET from barely scratches the surface of ADO.NET. I have a working application that has a database connection (to Access), a data connection OlDbConnection1, a data adapter OlDbDataAdpater1, and my text boxes are working as expected when bound to the Access fields. The ...more >>

Hi! Is there anyone who has the practice files of "Microsoft ADO.NET 2.0 Step by Step" book by Rebecca M. Riordan? I' ll be really grateful if someone emails the files to me... ...more >>

Hi, Is there any reason to wrap a TableAdapter with a using statement? I don't think there is any reason to but I found example code that did. Thanks in advance!!! using (TransactionScope updateTransaction = new TransactionScope()) { using (MyTableAdapter adapter = new MyTableAdapter()...more >>

Greetings, I'm interesting in hearing about certain techniques that might enable me to execute nonqueries in bulk much faster than one-by-one. Currently, we have areas on the system that'll execute anywhere from 25 to 1000's in bulk but it does so by sending the command each time. One t...more >>

I am using VS 2005 and created a dataset using the designer. I have two different data sources although both have the same schema. One is a SQL Server 2005 database while the other is a SQL Server 2005 Mobile. In the designer a connection is automatically setup when I drag a table to the designe...more >>

Hi, I have a problem where an insert stored procedure does not commit to the database from a vb.net program. I can run the stored procedure fine through the IDE, but when I use the following vb code the message box shows the next ID number but when I check the database no new row has been ad...more >>

I have generated a typed dataset in Visual Studio 2005 by dragging tables from Server Explorer onto the Designer surface. I then configured adapters and added some methods based on stored procedures. Now the underlying tables in the database were changed and I added and remove some columns. ...more >>

Hello. I realize my other post was a bit lengthy, so i'd like to repost this question. Developing VS2005, SP1, .NET 2.0, VB Windows form program on WIN XP Pro, SP2. It has a Dataset with two tables using an SQL 9.0 Server Express. After creating a new database from the VS server explore...more >>

Hi I have a multithreaded application that uses a typed dataset to held configuration data. The configuration data is also stored in at database. The dateset is send to the different threads using the byref keyword From time to time i need to update the dataset in the application. Using t...more >>

Hi, If this isn't the correct forum please let me know where I should post. I'm developing in VS2005 and have a data source based upon a parameterised stored procedure. I click to preview my data and I'm presented with a very nice UI that lists all my parameters however, it is the nature...more >>

Hey, this code seems to work fine, since there is no rows in the DB, it does the INSERT statement. then it proceeds to the second update statement and works great. but nothing is actually inserted into the database. its sql 2005, and this is .net 2.0 in C#. any ideas? P.S. I have wi...more >>

The problem is simple: Astonishingly, it seems that in an ADO.NET 2.0 dataset, adding new rows to a child table does not seem to immediately reflect in any aggregate filter placed upon the parent table. For simplicity I have written some code below for a simple .NET 2.0 winforms app and a very...more >>

Dim com As New SqlClient.SqlCommand("OurRoutine") com.CommandTimeout = 1200 'let it run forever, well 20 minutes anyway When I set the timeout to 1200 for 20 minutes, I still get timeouts in 30 seconds... Our routine runs in just about 30 seconds, so sometimes it times out and others it d...more >>

Using ASP.NET and C# (Visual Studio 2005). I generated a Typed DataSet. I run the following code, but don't get any errors, but it doesn't appear to be updating the database. (I've stepped through the code to ensure it is hitting the code): // Begin Code DirectoryListingTableAdapters.DIREC...more >>

Hi, is it possible to set different filters for two binding sources with the same data source? If so, how? I tried to use this code: BindingSource bindingSource1 = new BindingSource(); BindingSource bindingSource2 = new BindingSource(); bindingSource1.DataSource = myDataSet.Tables["tblname"...more >>

I have a program using OleDbCommand to insert some chinese character information into Oracle Database. It runs normal except when data contains a particular chinese character "=A6=E2" and the exception message is ORA-00917 missing comma. This is so strange for me since this is a very simple ch...more >>

I'm fairly new to VB.Net 2005 development and I am in need of updating MS Access 2000 data via code. This was easy to do in my prior programming language, but I am stuck here. :( I am using the following test code that when a button is pushed, the contents of the Customer_ID field is chang...more >>

I have Form1 that has two OleDBconnections to an Access database. I have Form2 that has a function that requires the Access db be disconnected from my application. My Form2 knows nothing about the db connections in Form1 obviously. How do I close the open dbconnections from Form2 when they a...more >>

Hello group: Given a data table in a typed dataset with a composite key made up of 2 integer fields, what approaches have people taken with regard to editing them? The following might help describe the situation better. Situation: I have a grid view displaying some customer configura...more >>

Hi all, I have a huge memory leak problem in what is really very simple data insert code. In my app I'm trying to use a typed dataset to insert into a database. It adds quite a few rows (say hundreds). Unfortunately it has a big ass memory leak and I dont understand why. The code belo...more >>

All, I am using SQL Server Manager Objects (SMO) Restore to restore an SQL Database. All works well however when I set the PercentCompleteNotification = 1 I would of expected the PercentCompleteEventHandler to trigger every one percent, instead it triggers a total 23 times not 100. Ye...more >>

Hello. Working on a VS2005 SP1 Windows form program in .NET 2.0, on XP Pro, SP2. I must be pretty stupid. I can't figure out how use decimal data in a table where there is no decimal point. I populated the table with data from a flat file that has a number like this "000001645000". With...more >>

Hello. Working on a VS2005 SP1 Windows form program in .NET 2.0, on XP Pro, SP2. I have a datatable with no keys and just three columns. How do you clear a datatable to no rows ? I tried : itemsDataTable.Clear() itemsDataTable.AcceptChanges() itemsDataTable.Rows.Clear() itemsDa...more >>

I have been going through some tutorials on using the new dataset designer in Visual Studio 2005 to build dataadapters which include inserts, updates, and deletes...so I don't have to code it all by hand. This tutorial is tutorial #1 located here http://www.asp.net/learn/dataaccess/default.a...more >>

Hello Everyone, We have a .net application (1.1 Framework) that uses a strongly typed dataset. The application is in production for over 2 years. One of the users recently reported that when he tried starting the app. in the morning it failed and the logs showed the following error detail...more >>

Hi all I am inserting data into an ntext column in SqlServer 2000 but it is being truncated. In every StackTrace and Steps column (the only 2 ntext columns) I am seeing the text truncated to about 255 chars. Can anyone tell me why this is, and maybe how to solve the problem? Thanks ...more >>

How to find out or catch compiler error during scripting stored procedure via OracleCommand class? E.g. OracleCommand _oracleCommand = new OracleCommand(); ....... StringBuilder sb = new StringBuilder(); sb.AppendLine("create or replace procedure test_proc(var_number in ...more >>

Hi, We would like to use MS SQL Server Express database for out data. The data can be updated by many clients. There will be an application that will show these data. This application can work with the disconnected recordest. My question is, how to notify this application, about the dat...more >>

Hi all, I have a data access library project within which I have created a number of datasets. In one of the datasets I've added a number of strongly typed datatable/tableadapters and configured them to use a connection string that has been stored in a settings file. The problem I'm h...more >>

Hello ng I edit the field expression with '\n' or '\r\n' in the property-designer of the dataset/datacolumn. At runtime in the datagrid I miss the linebreak. The charaters '\n' or '\r\n' were shown in the datagrid. How can I include a linebreak in the Datacolumn.Expression from a typed d...more >>

Okay, so I've read various articles on setting up a TableAdapter to retrieve a newly generated identity column value back into the dataset after an insert. However, I'm having issues with the dataset actually getting updated. I swear this was working Monday, but once I thought it was working, I...more >>