Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score INSERT before checking duplicate values
Sagaar - 15 Apr 2006 9:22 AM - 5 messages
Hi I am inserting 2 text values from user input. I wanted ot check if there is any duplicate text value before I insert into columns...which is best way to avoid duplicate valies....constraints or check in INSERT statement.....any ...
Score Inserting info in a table
John - 15 Apr 2006 3:13 AM - 6 messages
Hi I have a set of values that I need to insert and sql server table. My question is, out of all the methods what is the best (in terms of being simplest/most straightforward) method to do that? Thanks ...
Score Connection.GetSchema
Jiho Han - 14 Apr 2006 7:44 PM - 3 messages
I am trying to test for the existence of a particular table in all databases on a server. I found some samples and looking at the SDK doc as well, I found the following use of GetSchema method on Connection class: ...
Score Oracle....
Lowry Smith - 14 Apr 2006 6:48 PM - 2 messages
Which is the preferred name space to use for interaction with Oracle database? ..Net Framework 1.1. Thank you, Lowry ...
Score Two phase commit
Lowry Smith - 14 Apr 2006 6:42 PM - 2 messages
Does anyone show me the resource to implement two phase commit using SQL Server 2000 and Oracle 9x using ADO.Net technology? Is there any additional settings are required in these two databases two implement the same? Is there any configuration on the system where the application (ASP.Net) is ...
Score Inserting clob data to Oracle
rh.krish - 14 Apr 2006 6:40 PM - 1 message
Hi,    I'm trying to insert clob data which is around 250K through stored procedure in oracle. But I'm getting 'ORA-1460: unimplemented or unreasonable conversion'. Here is my oracle stored procedure: PROCEDURE saveResponseClob                 (IDNum IN RPT.ID#%TYPE, ...
Score Caches, Datasets, and Relations
apandapion - 14 Apr 2006 6:38 PM - 2 messages
I'm starting on my fourth database/web service/web client, using C# as the language.  On my last project, I had two datasets.  One lived in the Cache object, was very large, rarely changed, and was shared across ...
Score Google to Microsoft as Be to MCB
MSDN - 14 Apr 2006 4:11 PM - 2 messages
Hi Be, How are ya? For some reason my phone does not ring and at times I get my voice message few days late. I just got your voice..   so I thought I drop you this email before ...
Score VS 2003 and VS 2005 differences in implementation
peeyush - 14 Apr 2006 1:04 PM - 1 message
I m developing an outlook customization programme, I was saving data in outlook's contact folder using VS 2003 like this oCt.CustomerID = stroutlook where oCt is a variable of type outlook contacts and cutomerid is the field of outlook and stroutlook is a variable containing the value to ...
Score current member of bindingsource
fanor - 14 Apr 2006 3:09 AM - 1 message
Hi all, how can i load the current item in bindingsource to a datarow?? I try this DataRow   dr;     dr=this.dsCM1.upholstery.NewRow();   // this one work to create a new row   dr= ( ????)bindingsource1.Current ; ...
Score DataGrid Delete Problem
thebison - 13 Apr 2006 9:30 PM - 4 messages
Hi all, I hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my database has been made in MSDE. ...
Score ADO.Net to ADOBD
Arne Garvander - 13 Apr 2006 9:15 PM - 3 messages
How do I serialise a ADO.Net dataset into a ADODB recordset using XML? ...
Score anyone have product key for dataobject.net
umair118 - 13 Apr 2006 8:19 PM - 3 messages
dataobject.net is very good product for making persistent data object. Anyone have product key for it which is required to run it. [link] ...
Score Serialize a dataset
Arne Garvander - 13 Apr 2006 7:54 PM - 2 messages
How do a serialize a dataset? I tried string buf; buf = mydataset.GetXml(); I got the data but no Schema. There is a GetXmlSchema, but I want everything together. Can I append the dataset string to the schema string and get a complete ...
Score Timeout error with Transactions
Harry Keck - 13 Apr 2006 6:01 PM - 2 messages
If I open a transaction, peform a select from the database using the transaction, and then try to perform another select from the database with a separate connection that does not use the transaction, I get a timeout error. Also, this is only with a piece of code written in .Net 1.1 Framework.  When ...
Score GetSchemaTable and Friendly Column Name
Michael Jackson - 13 Apr 2006 4:50 PM - 3 messages
Looking for a suggestion. Using .NET 2003 and SQL Server 2000, I'm using GetSchemaTable to get the schema of mutiple tables. I populate a listbox with the column names and allow the user to multi-select the column names, then using the selected ...
Score is a datarelation the way to go?
Duncan A. McRae - 13 Apr 2006 8:50 AM - 3 messages
Greetings: I am working on a small application to learn the .NET 2.0 framework better (ASP.NET and C# against SQL Server 2005).  I have chosen as my project a web-based expense-tracking tool.  When a person logs in their ...
Score DbType vs. OleDbType vs. SqlDbType
Tom Winter - 12 Apr 2006 10:13 PM - 3 messages
I'm trying to put together a generic Command object that my business objects can use to access my applications database. We're starting with an MDB and then maybe moving to SQL Server and then maybe SQL Mobile. So my code in the business objects is working with the "generic" ...
Score try/catch error
tshad - 12 Apr 2006 7:45 PM - 2 messages
Why am I getting this error: ************************************************************* Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30616: Variable 'exc' hides a variable in an ...
Score How to test if an ado field is null
moondaddy - 12 Apr 2006 7:32 PM - 3 messages
Need help converting vb.net 1.1 code snippet to c# 2.0. The code below tests to see if field in a strongly typed data row is null. This works in vb.net 1.1, but I'm having trouble converting it to c# 2.0 ...
Score DataView ListChanged Event machine gun !!
Ray Holiday - 12 Apr 2006 7:31 PM - 1 message
Hi, I'm using the DataView.ListChanged event to catch modifications to my table. But every time I update a row in my table the event fires has many time has I have columns.  Since I have 55 columns and sometimes can be sending 3 ...
Score DataSet Row Locking
Randy L. - 12 Apr 2006 7:24 PM - 2 messages
We are using a typed dataset in a singleton type scenario that is not bound to a database. With multiple clients modifying the dataset we have implemented a simple DataRow locking approach. The goal here is to insure thread safety on tranactions in the dataset. ...
Score RowNotInTableException - Help
Stan - 12 Apr 2006 5:15 PM - 2 messages
I've written code that uses a DataGrid to display the data in a table.  When I am adding a new row to the table I've hooked into the ColumnChanged event to verify that the data entered is correct.  With a detached(new) row I get ...
Score database connection loss
Martin B - 12 Apr 2006 2:44 PM - 4 messages
Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database I use System.Data.Common.DBConnection and .DBCommand. How can I keep aware from connection losses (network not availeable, ...
Score Naming data access components
Chris Fulstow - 12 Apr 2006 1:17 PM - 6 messages
Hi, What are people's thoughts on naming convention for data access components? I'm building two classes that will be used by an ObjectDataSource for data binding: 1. Data entity (encapsulates a single record, e.g. Employee) 2. Utility class (performs employee ADO.NET database operations) ...
Score Retrieving Foreign key schema with da.FillSchema. Is it possible?
A.Neves - 12 Apr 2006 12:11 PM - 2 messages
Hi, I'd like to retrieve database schema using OleDbDataadapter.FillSchema, but I couldn't find how to retrieve foreign Keys. Is It Possible? How? Any help would be very much apreciated. Thanks. ...
Score DBConcurrencyException on dataset update (because of datetime primary key ?)
rc - 12 Apr 2006 8:12 AM - 12 messages
Hello, I'm writing a VB .NET application that manipulates data in an Access database. I fill a Dataset with data extracted from a table of my database, modifiy one field and try to update with an OleDbCommandBuilder which throws a DBConcurrencyException. ...
Score DataGridViewComboBoxColumn, Guid and DBNull problem
danikenan - 12 Apr 2006 7:54 AM - 1 message
Hi, I have a datagridview bound to a datatable with two columns: "x" and "y". "x" is of type Guid, it can accept DBNull and is a foreign key to another table. In my datagridview I would like to let the user edit the value of "x" ...
Score Selecting Data from one Datatable and Copying to another
Stuart - 12 Apr 2006 7:16 AM - 4 messages
Hi there (code below !) I have 2 datatables in a Dataset Table 1 contains unique reference numbers - the contents of this table are dynamic and may change from minute to minute Table 2 contains records that have a field (Category) which may or may not ...
Score Restricting cols with a data view
Ant - 12 Apr 2006 3:11 AM - 2 messages
Hi, I've always used Database views to restrict columns from the user. Is this what ADO Dataviews are also meant for? I see how you can filter rows with a data view, but how about columns? Can this be done with a dataview? Is there ...
Score Re: ContextSwitchDeadlock was detected
hayworth - 11 Apr 2006 8:47 PM - 1 message
This was talked about a little in microsoft.public.dotnet.languages.vb. QUOTE FROM Brian Gideon ContextSwitchDeadlock is one of several new Managed Debugging Assistants (MDA).  It is not compiled into release builds so that's probably why you don't see them outside of the debugger.  It can be ...
Score DataViewRow and subtables
objwiz - 11 Apr 2006 8:25 PM - 3 messages
I'm new to some of this so please pardon me if this is easy question. I have some xml like this:   <logentry>     <id>f26915a6-33ec-475e-bb98-58224f16a0e1</id> ...
Score XML to Table inference
Raj Wall - 11 Apr 2006 7:25 PM - 2 messages
Hi, I have a simple config.ini to be read into a simple table with three columns: accountID, port, base_path. Reading this page: [link] ...
Score escaping special operators, ', etc.
David Thielen - 11 Apr 2006 5:39 PM - 9 messages
Hi; In a select for Sql Server, the characters '_%[ are all special and have to be escaped to be used as that character. A couple of questions: 1) Are there any others? 2) Is doubling ' to '' (that is two ' chars, not a single ") standard for ...
Score Is dispose necessary in this scenario with datasets and adapters?
pkellnernews - 11 Apr 2006 5:29 PM - 2 messages
I typically make calls like this: UsersTableAdapter usersTableAdapter = new UsersTableAdapter();                             DataSetUsers.UsersDataTable usersDataTable ...
Score DataTable.Select DateTime problem
/dev/null - 11 Apr 2006 5:15 PM - 1 message
DataTable.Select DateTime problem Hello, i am using the select method on a datatable to obtain rows that correspond to a range of dates. The application works fine under some regional settings in windows xp: English(USA) and French(Canada) but fails to work the i select French(France) ...
Score Oracle - works with Framework 1.1, not with 2.0
Chris Botha - 11 Apr 2006 4:13 PM - 4 messages
Hi, I have a web site on a 2003 server. The web site runs under Framework 1.1 and works with oracle, no problem. On the same server I have another web site that runs under Framework 2.0 and ...
Score BindingSource with Controls + DataGridView problem
Pieter Coucke - 11 Apr 2006 12:37 PM - 1 message
Hi, I have a DataGridView, that contains a list of Articles, which can be added (automaticly via the AllowUserToAddRows) and changed by the user. The current item is also displayed in textboxes under the datagridview, to give more space for the user to change the item. ...
Score Using Typed Datasets in asp.net 2.0
amit - 11 Apr 2006 12:30 PM - 1 message
I am having a play with typed datasets in ASP.Net 2.0 I am using the builder to create my data layer. I have the following tables. [EmployeeType], [Departments], [Location], and [Groups] The first three tables above have a one to many relation ship to ...
Score OracleDataReader field type?
n4ixt - 11 Apr 2006 11:47 AM - 3 messages
I've hunted for what should be a fairly simple answer but can't find what should be an answer to a simple question. I have a data reader, let's say it's declared in C# as OracleDataReader dr = ...
Score ForeignKeyConstraint Problem (Creating Child Record)
Aziz - 11 Apr 2006 10:40 AM - 2 messages
Hello, my main VB .NET 2003 + Access program wasn't working so I created two small sample applications to test why I get the following error: ForeignKeyConstraint ProductOrder_Product requires the child key values (AAA-BBB-1) to exist in the parent table. ...
Score Connecting web sql server with my local Sql Server
Alok yadav - 11 Apr 2006 10:06 AM - 6 messages
Sir,    i have two phase of my application one is website which saves data in sql database and other application is on the intra net i have to update the intranet database with the database which is on web server. ...
Score Help with Cascading SELECT in asp.net application
Stuart - 11 Apr 2006 5:42 AM - 3 messages
Hello I have the following scenario that I need to address with which I would appreciate some help if anyone has the time: (Simply) I have an asp.net application: I have 2 tables: Table 1 is called Categories and is used to hold hierarchical data (Tiers) - ...
Score ORM (Object-Relational Mapping) tools
Kenny M. - 11 Apr 2006 12:11 AM - 4 messages
Hi peers I want to know yours opinions about those ORM (Object-Relational Mapping)  tools , my company is going to start using it. What are the good and bad things about? ...
Score possible bug in oracleclient
jamesd - 10 Apr 2006 8:15 PM - 2 messages
I believe I may be encountering a bug in the way System.Data.OracleClient is issuing commands: The following code you will see that the CommandText is different.             OracleConnection con = new OracleConnection(); ...
Score The DeleteCommand affected 0 records
s.bussing - 10 Apr 2006 7:20 PM - 3 messages
Hi, as many before me, and probably after me, I recieved the following error when I try to update my table using a typed dataset which contains serveral tables. The Delete/UpdateCommand affected 0 records All my tables are related and all relationships are configured. For ...
Score Transactions and TableAdapters on Win98
Tom Bianchi - 10 Apr 2006 3:40 PM - 1 message
Hi, I am using VS2005 Pro and SQL2005 Express. I have two tables that I want to update under the same transaction. I don't understand how to do this using TableAdapters. MSDN says to use System.Transaction, but it reports that this works only on Win2000 and above ...
Score HOWTO: List SQL Servers on Local Machine
Scott - 10 Apr 2006 2:37 PM - 9 messages
Hi All, I need to retrieve a list of SQL servers that are running on a local machine. I have tried using:    SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;    System.Data.DataTable table = instance.GetDataSources(); but have found that it returns servers on the entire network not on the ...
Score Re: Efficient data retrieval techniques
Eniac - 10 Apr 2006 1:24 PM - 4 messages
Thanks guys, I'm relieved to realize I'm not the only one viewing things like this. I find it hard to back up my claims tho, because all articles that explains how to handle a database are example usings the ...
Score Data layers in n-tier ASP.NET 2.0 applications
mark.norgate - 10 Apr 2006 1:17 PM - 4 messages
Hello I'm looking for resources and advice on how best to implement a scalable data layer in an n-tier ASP.NET 2.0 application. I understand the ADO.NET classes, and I'm a reasonably competent programmer but I've never really tried to implement an enterprise scale ...
Score AcceptRejectRule question
olrt - 10 Apr 2006 12:46 PM - 1 message
Hello, In the documentation it says : ---------------------------------------------------------------- AcceptRejectRule Changes to rows can be accepted using the AcceptChanges method or canceled using the RejectChanges method of the DataSet, DataTable, or DataRow. When a DataSet contains ForeignKeyConstraints, invoking the AcceptChanges or RejectChanges methods enforces the AcceptRejectRule. ...
Score Does one know how to bind a BindingDataSource with designer ?
olrt - 10 Apr 2006 11:59 AM - 4 messages
Hello, Here's the case I want to address with the help of the designers (I'm using Visual Studio C# Express). Let's say I designed a typed DataSet (named BidonDataSet). Let's say I designed a Windows Form (named Form1). ...
Score could not determine which columns uniquely identify the rows for ...
somersbar - 10 Apr 2006 11:02 AM - 2 messages
im trying to access a microsoft access database from an asp.net webform. but when i use the OdbcDataAdapter config wizard i get the folowing errors: *Generated UPDATE statement -could not determine which columns uniquely identify the rows for "Customers" ...
Score Parent-Child Relationship Headaches (add new records) (VB 2003)
Aziz - 10 Apr 2006 9:28 AM - 6 messages
Right...I have an access Database with around 10 tables. I have modelled only a few of these in the XML Schema (enough to get my program working) and assigned the relevant DataRelations. Anyway I'm having problems with a three table ...
Score Updating a Table
Roshawn Dawson - 10 Apr 2006 3:41 AM - 6 messages
Hi, I have three datatables, the last of which represents a many-to-many relationship.  Here's how it looks: Table #1 attID (autoincrement) Attribute Name ProdNumber Table #2 valID (autoincrement) Text Number Department Table #3 attID valID Here's the scenario.  I have an empty database that I'm using.  I'm retrieving data from a web ...
Score typed dataset and untyped dataset, which one is faster?
Napo - 10 Apr 2006 3:27 AM - 5 messages
typed dataset and untyped dataset, which one is faster? I think the answer is typed, but some one told me is untyped. Who can tell me the answer and the reason? thanks ...
Score DataGrid Sort Problem
thebison - 9 Apr 2006 11:08 PM - 3 messages
Hi all, I hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my database has been made in MSDE. ...
Score VS2003 transfer data between two data sources
AbeR - 9 Apr 2006 8:23 PM - 10 messages
I am loading a DataSet from an access file (exported from another app that a vendor provided) and want to appendthe data into an SQL Table that has the same structure. I can easily append rows to the SQL table, but that can't be a best ...
Score DSN, Check if exists
Bernie Hunt - 9 Apr 2006 2:26 PM - 3 messages
My application needs to run at many different sites and I need to depend on a DSN set up by another application, so I want to check for the DSN's existance right up front before bothering to do anything else. ...
Score VS2005 using Access 2000 database with database password
Dave Flowers - 9 Apr 2006 1:27 AM - 5 messages
Hi all, I hope I'm in the right place. I have an existing Access database that has a Jet OLEDB:Database Password and I'm having trouble connecting to it with 2005 ASP.NET. If I clear the password I don't have a problem but this is not ...
Next »