I have an ASP.NET application that uses MS Access. In my PC works fine. If I put the application in my notebook he can't connect with Access DataBase. There is any differences about connection DB in normal PC's and notebooks? What do I have to do? Note that my BD is local (is in C:\) -- ...more >>

Hey, all! I have an asp.net page, uses ADO.NET connection to create a DB and insert a UID/Password into one of the tables inside the new DB. Here's what I'm seeing: 1) If I ONLY create the DB("Create database abc"), I can delete the DB right away. 2) If I create the DB and simply OPEN a c...more >>

Hey Group, I`ve got this Anoying problem, and was wondering if somebody would be so kind as to help me? I keep getting "Failed to Enable Constraints. One or more rows contain values wiolating non-null, unique, or foreign-key contraints". When I click ok, my Datatable has a Red Exlimation ma...more >>

Hi all I have a datatable returned from an Oracle Stored Proc containing look up data. This is used by my application and shared between multiple threads. The problem is the underlying data for the lookup table gets updated on irregular intervals externally. What is the best way to refresh t...more >>

Hello I need some hints and recommandations about accesing data, and instantiating business-objects with this data we want to use untyped datasets to retrive data from db and hold this datasets in our business-entities a small scenario we have a business-object "purchaseorder" which aggregates...more >>

I am trying to remove a set of tables, relations and constraints from a dataset, however I get an error: "Collection was modified, enumeration operation may not execute". I create the dataset with three tables. The tables are created in VB .Net code by sending an SQL criteria string to SQL Server to...more >>

Hey Group, I`ve build a VB.Net App which has a Access Database. This will be used by 4 people. Do i need to worry about putting Locks and things on it? If so anybody suggest what i need to do, any links? Ta MCN ...more >>

Okay, what gives. The SQL database has rights for this Windows account. What could be the problem? This is very important....more >>

* i posted this in the SQLserver group, but it has some ado.net issues, so maybe here is good too * I have a schema in place and I'm starting to think that it must be a bad design because I'm having the hardest time organized my results so that I can present them the way I want. Here is the s...more >>

Howdy, I have a table with 5 fields. User1 connects to the db and is editing his dataset - say record 3. User2 connects to the same db and wants to delete record 3 from his dataset while user1 is editing the same record in his dataset. How can I prevent User2 from updating the table ...more >>

I've got a Windows Forms application that I'm using to create a typed dataset (C#) and a corresponding XML file (with data) that I'm encrypting. This Windows Forms application is only to be used by me to create the typed-dataset and XML file. I want to use the typed dataset in some assemblies t...more >>

I have a table in the database called Users and it has typical fields (UserId, UserName, etc.). I created a User class with properties that match the fields in the table. What I want to do is read a row from the table and create an instance of the User class, populated with the data from t...more >>

For all those that have suffered trying to figure this out! I hope this helps! John RETURN VALUES AND OUTPUT PARAMETERS USING THE DATA ACCESS APPLICATION BLOCK The overloaded method that takes an array of objects cannot return an output parameter or a return value. You must pass in a paramet...more >>

Is there alway to check the data set agains a database to see if there have been and changes made in the database since the last fill on the dataset then get the changes? thanks.. I don't want to have to fill thousands of rows each time... seems a waste... ...more >>

Hello! I think this must be simple newbie question. I'm using VB.NET 2003, and making WinForm application. I need only insert row into database table, which is some kind of log table, and not need to retrieve any data of it in this part of my application. It is easy to make using sql like 'INS...more >>

Here's my problem (been reading the book Microsoft ADO.NET Core Reference), I must of skipped this in the book or haven't goten to it yet, but... How do you work with referential data in ADO.NET? Here's what I am trying to do, I have two tables... one is basicly a person table, and another is a...more >>

Hello I have a store procedure that has 2 parameters declared datatype Numeric as per the SQL table. When i try to use the following: Me.SqlCommand1.CommandType = CommandType.StoredProcedure Me.SqlCommand1.Parameters.Clear() Me.SqlCommand1.CommandText = "altera_linha_encomenda" With ...more >>

Hi, is it better or more efficient or somehow "different" to make an ad hoc query using the Parameters collection of a Command object, than constructing a sql string for the CommandText property? Example: //assumes a LastName parameter str Cmd = "SELECT FirstName FROM Employees WHERE (LastN...more >>

What is the best way to find the Max of a particular column in a DataSet? ...more >>

Hello friends, I need to read/access unicode data saved in text/csv file through ADO.Net but I'm not able toget success. Is there any support provided in ado.net to access unicode data ?? Anticipating a Quick reply... thanks in advance Ritu ___ Newsgroups brought to you courtesy of www.d...more >>