Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score bindingsource addingnew
Rick - 14 Apr 2007 6:08 PM - 6 messages
I have a bindingsource filled by a strongly-typed table via a tableadapter. I have connected the binding source to the AddingNew event where I want to supply some values for the new row. The problem is that this event is triggered when the TableAdapter fills the ...
Score Writing a Decimal to SqlServer loses the fraction
David Thielen - 14 Apr 2007 6:24 AM - 12 messages
Hi; I have a Decimal type in SqlServer and I write a new Decimal (1.23) setting a parameter of type DbDecimal to it and all it writes is a 1. The decimal is gone. What am I missing? ...
Score What SqlDbType is Numeric?
David Thielen - 14 Apr 2007 5:44 AM - 4 messages
Numeric is a type in Sql Server - but not in SqlDbType. ...
Score How do I enum all system tables in a database - and more???
David Thielen - 14 Apr 2007 5:18 AM - 8 messages
This is for Sql Server. "SELECT table_name FROM information_schema.tables WHERE (table_type = 'BASE TABLE') ORDER BY table_name"; gives me all user tables plus the system dtproperties. 1) How can I get just user tables (ie no dtproperties also)? 2) How can I get just system tables? ...
Score Max length of a query string
Lubomir - 13 Apr 2007 6:26 PM - 8 messages
Hi, I am wondering, is there any limitation for the length of a query string? Thanks, Lubomir ...
Score Advantage of Parameters
Norbert_Pürringer - 13 Apr 2007 4:01 PM - 9 messages
Hello! Is there an advantage of using parameter objects instead of using concatenated command strings? Example 1) use of parameter object: OracleCommand cmd = new OracleCommand("SELECT PROJECT FROM USERS.LOGIN WHERE UPPER(SESSIONID)=:SESSIONID", _con); cmd .Parameters.Add(new OracleParameter("SESSIONID", OracleType.VarChar, ...
Score Unlimited NVarChar datasize in params
Earl - 13 Apr 2007 3:02 PM - 1 message
It's been obvious to me since VS2005 came out that the new param generator for the SqlDataAdapter spits out NVarChar character lengths as 0, with no apparent problems passing those values to the database (SQL2005). I've been using the auto-generated params as-is for quite a long time with no apparent ...
Score Copy and Modify a Row (used as a template)
Mike Robertson - 13 Apr 2007 2:01 PM - 1 message
Hi, I use a row in my applications user table as a template for each new user that is added to the table to enable all the default settings that I want a new user to get. In VB6 all I did was a .Clone of my "user" named Default, a modify of that ...
Score ig
Markus Hopfenspirger - 13 Apr 2007 10:38 AM - 9 messages
In english it would we something like: The supplied assemblyname or the codebase is invalid. HRESULT: 0x80131047 The error is displayed right after the application is starting and wants to load the first Class Library. To redroduce the error I need to Start a WebApplication (everything runs ...
Score invalid character or 'sql command not properly ended'
fredd00 - 12 Apr 2007 4:22 PM - 1 message
Hi I'm trying to run multiple inserts in oracle 9i my statement is like this insert into y (col1, col2 , col3) values (1,2,3); insert into y (col1, col2 , col3) values (2,3,4); insert into y (col1, col2 , col3) values (3,4,5); ...
Score invalid character or 'sql command not properly ended'
fredd00 - 12 Apr 2007 4:07 PM - 1 message
Hi, I'm trying to run multiple insert statements in Oracle 9i using microsoft data application block for .net 2.0 the problem is that I either get the error message , invalid character because of the semicolon in the statement ...
Score Item with same key has already been added
JimHeavey - 12 Apr 2007 2:24 PM - 1 message
I am attempting to utilize the Server Explorer to create a new connection to a IMB DB2 database.  When I right click on Database Connections/Add Connection, I get the dialog box for constructing a connection.  I press the ...
Score Drivers Not Registered
JimHeavey - 12 Apr 2007 1:14 PM - 2 messages
I need to register the IBM drivers for connecting to DB2, as I get this message indicating the drivers are not registered.  I can connect to the database just fine using any number of ways outside of my program, so I know ...
Score Transactions in ADO.NET typed datasets -TransactionScope or DbTransaction
micklang - 12 Apr 2007 11:52 AM - 2 messages
Hi there, I'm currently trying to come up with a solution for incorporating transactions into ADO.NET typed datasets. I was all set to simply use implicit transactions using TransactionScope as discussed on this page... [link] ...
Score Dataset displays in datagrid at runtime but designer doesn't see any datasources
jollygreenguy - 12 Apr 2007 5:48 AM - 1 message
Hello, I am having a problem that I can't figure out.  I have a stored procedure that gets a catalog of data from the server. This is the code I have typed: SqlConnection conn = new SqlConnection(); conn.ConnectionString = ...
Score System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
Juan Okeeffe - 11 Apr 2007 10:38 PM - 2 messages
Hi, I'm getting the following error when connecting to Oracle database through ..NET ===================================================================================================== System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information ...
Score [MSSQL] [WebService] Last inserted ID in transaction
Robert Wachtel - 11 Apr 2007 8:37 PM - 6 messages
Hi! I'm in desperate need for help. ;) Given is a table on SQL Server 2005 (T_IDTest with two columns: ID autoid and Text varchar). I implemented a webservice with two methods. The first method gives an empty dataset, so the client can append a row to this dataset. ...
Score Dataset modifid DateTime rows
Assaf - 11 Apr 2007 6:03 PM - 2 messages
Hello all. Here is my architecutre: I have a sql server data table feeding a dataset/datatable displayed in a datagrid. Today I had a very strange error, something like: 'Sql Exception - Date Overflow'. Which is strange in of its own. ...
Score OleDBConnection Closes executes but leaves the Access database locked
doni - 11 Apr 2007 5:29 PM - 2 messages
Hi, I have a .NET DLL with a COM callable wrapper.    The main entry point establishes a connection to an Access 2000 database.   The connection is used as the active connection to different SQL commands. ...
Score Executing a query and reading the column sizes
Oenone - 11 Apr 2007 3:54 PM - 4 messages
I have a project that creates a SqlDataAdapter and uses its Fill method to fill a DataTable with data from a user-provided query. From there I can obviously access details about the rows and columns returned by the query. ...
Score Cascading Delete
Jason Weier - 11 Apr 2007 3:26 PM - 3 messages
I am having a strange issue with cascading deletes in that it simply isn't cascading. Heres what I'm using: VB .NET 2005 sp1 SQL Express 2005 For simplicity, I will give 2 of the many table adapters in the app and ...
Score queries regarding connecting to oracle
craigc - 11 Apr 2007 3:25 PM - 4 messages
do i need to install the oracle client to connect to an oracle database ? i'm doing fairly basic queries to an oracle (9.2) database and will be rolling the app out to multiple windows desktops. will i need to install the oracle client on each windows desktop ? is ...
Score concurrency in ado.net
Archana - 11 Apr 2007 7:09 AM - 6 messages
Hi all, I want to handle concurrency issue when 2 user try to update same record. What i want is if user1 and user2 are accessing same record and user2 has updated same record then when user1 tries to update that record he ...
Score changing 1 value in an xml file
jonefer - 11 Apr 2007 2:00 AM - 1 message
I have a dropdown box in an aspx page -- the two values in the dropdown are: 0 production 1 backup when the user selects a value in the dropdown, I would like it to change the xml file (CurrentDB.xml) which looks like this ...
Score Typed DataSet from existing DataSet
Robert - 10 Apr 2007 3:38 PM - 6 messages
I am working in C# creating a Windows Forms application.  I have a dataset from an Oracle database that I want to change to a typed dataset.  Can this be done once a dataset that is not typed has been returned from the database? ...
Score OrderID or DataTable
Tim - 10 Apr 2007 1:46 PM - 8 messages
Hi Gurus, I need advice from you. We are going through an arguement. I am working on a [ORDERS] project, and another person is working on [REPORTING]. What he want me to pass is a OrderID, then he will do a query, create a ...
Score Getchanges problem on expression column
Bart - 10 Apr 2007 1:22 PM - 5 messages
Hi, I have a problem with the GetChanges() method when I use an expression column. The expression is using data from a child relation. When I call Getchanges I got an evaluation expression that the column from my child relation doens't exist. ...
Score DateTime column.
Lithian - 10 Apr 2007 10:32 AM - 3 messages
Hi all, I need to read and write to a DateTime column. The column is binded to a TextBox. The problem is that I don't know how to display only the "hour part" of the DateTime in the TextBox, now if I write 12.30, when the ...
Score SqlCommandBuilder.DeriveParameters not working for CLR Stored Procedure.
Vimal - 10 Apr 2007 9:33 AM - 3 messages
Hi, I have created a CLR stored procedure and want to call it using Data Access Application block provided by Microsoft. But in this application block when method tried to derive SP's paramter using SqlCommandBuilder.DeriveParameters, it throws InvalidOperationException and give error message "The stored procedure ...
Score using an xml file to store a pre-connection value---
jonefer - 9 Apr 2007 9:58 PM - 3 messages
I'd like the administrator for my web site to be able to select between a 'Production' back-end or a 'Backup' backend. There are 2 values in the Web.Config file, but I know that the point that it ...
Score Drivers are not registered
JimHeavey - 9 Apr 2007 6:34 PM - 2 messages
I have a "UDL" file on my desktop that I used to test my OLEDB connection to my database.  When I invoke this and supply my User ID and Password, it connects to the database just fine. Now when I go over to VS2005 and supply the same connection in my UDL, I get ...
Score client-server app where data is disconnected, but stays fresh
Jesse Aufiero - 9 Apr 2007 5:58 PM - 4 messages
I'd like to develop a client-server application where the users (.Net 2003 application) can modify data in the database (sql server 2005), and all other users will see those changes in near real time.  This kind of ...
Score Add query with parameter to tableadapter ?
TonyB - 9 Apr 2007 2:09 PM - 2 messages
I'm trying out the tableadapter in vb.net V2 framework. I have added a tableadapter which successfully returns all records in a dataset table. If I preview data by right clicking the dafault Fill,GetData() methods shown under the TableAdapter this lists all my ...
Score ConnectionString problems
TonyB - 9 Apr 2007 1:05 PM - 2 messages
I'm connecting to a access database which is in the \bin\debug folder in my project directory. So if I set myproject/settings/myDatabaseConnectionString to "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb" and configure a dataset to use this ...
Score Transactionscope ? - "Unable to get error message (6107) {0}"
L. Scott M. - 9 Apr 2007 11:46 AM - 2 messages
Oracle 9i Windows 2000  SP4 Visual Studio 2005 NET Framework 2.0 Configuration (version 2.0.50727.42) We are getting: "Unable to get error message (6107) System.Runtime.InteropServices.ExternalException {System.Data.OracleClient.OracleException}" - after processing around 10000  +- 500 out of 39000 text inserts to ...
Score Currency Manager
Hemang Shah - 8 Apr 2007 4:55 PM - 10 messages
Currencymanger is a boon, but making it work in out of the box situation could be challenging. Is there any sample or article, which describes, how to synchronize two dataviews bound to the same data table? This is the scenario: ...
Next »