Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score help with currencymanager position
rossu - 3 Dec 2005 11:35 PM - 3 messages
I want to access hidden columns in a datagrid as soon as the row is changed so that I can alter some aspects of my form.  To do this I need to access the approriate row in the underlying datatable so I can "see" the hidden data. To ...
Score Problem with .NET 2.0, DataViews, and Relational RowFilters
David W. Rogers - 3 Dec 2005 10:52 PM - 3 messages
I am having a problem with advanced databinding. I think it is a problem with RowFilters. Here is an example program: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; ...
Score ExecuteReader - CommandBehavior.CloseConnection
matt - 2 Dec 2005 11:47 PM - 3 messages
hello, when coding a datareader, i often use the following in my code:     conn.Open();     SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection);     ...[do stuff w/ dr]...     dr.Close() ....with the understanding that, when the reader is closed so will the ...
Score Synchronising SQL Server 2005 mobile with SQL Server 2005 Express.
Paul Aspinall - 2 Dec 2005 11:47 PM - 1 message
Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express). I believe that I will need to write my own synchronization application, in ...
Score Sudden error on connection, conflict sql 2000-2005? desperated!
Pieter - 2 Dec 2005 5:50 PM - 9 messages
Hi, I have some nasty error when deploying my application (VB.NET 20002) on the users-computers. I'm using an SQL 2000 database. The problem I guess is the fact that I had a local SQL 2000 and a local SQL ...
Score How to export DataTable to VFP table?
Gordon Lau - 2 Dec 2005 3:57 PM - 2 messages
Hope someone can help me on this.  How do I export a DataTable to a VFP table?  My app creates a new DataTable with many rows (could be a half a million rows).  I want to save/export the DataTable to a new VFP table.  Tried creating a new VFP table and using the insert/update commands (used the OleDbCommandBuilder to automatically generate them for me) to add rows to it but it is WAAY too slow (took over 7 minutes just for 150,000 rows).  I'm not updating an existing table.  I want to export the results my app produced to a new table.   Any ideas? ...
Score Oracle vs MSSQL Parameters
Adam Clauss - 2 Dec 2005 3:32 PM - 7 messages
So, we originally wrote our application to use Oracle.  As such, we used specifically declared OracleConnection and use ":" for naming parameters. Ex: SELECT * FROM sometable where somefield = :fieldValue Now, we have a need to port the code to SQL server for another client.  I'm ...
Score VS 2005
JDF - 2 Dec 2005 3:16 PM - 5 messages
Has anyone heard of an actual ship date. I know the subscriptions are available but I am looking for the boxed version. Does anyone find it strange that MS anounced the release date of 11/7/05 months ago and they ...
Score Update one table from another with DataAdapter
Yex - 2 Dec 2005 3:11 PM - 3 messages
I've got a scenario that I can't seem to figure out how to handle appropriately. First of all, I've got two tables in a database that both contain roughly 90% of the same data...meaning, most fields in each table are ...
Score Multiple dataTables in dataset, insert problem
SimonV - 2 Dec 2005 12:16 PM - 7 messages
Hy, I have a dataset with 2 tables in: Stuff and Price in the Stuff table are the collumns: Id, Name, PriceID in the Price table there are: Id, Price This is excatly the same as in my database. I'm using SqlDataAdapter, SqlCommand and so. ...
Score parameter max count of ole db for Oracle?
Napo - 2 Dec 2005 7:54 AM - 1 message
Hi:    I am building an application based on sqlserver and oracle 9i. So I use ole db to do DB access. There is a stored proc with many parameters.If the count of parameters is less 512, the code which called sp worked well on both ...
Score DAO to ADO.NET
news.demon.co.uk - 2 Dec 2005 5:21 AM - 4 messages
I have been using vb6 and DAO up to now, i did not like ADO so i never used it. i now want to start programming in dotnet, but i see that DAO will not be good, so i need to learn ADO.NET fast i am a quick lerner, where can i get detail ...
Score Help with creating recordset from XML
intrader - 2 Dec 2005 1:39 AM - 2 messages
I need help with the code to create a recordset from a string containing XML. The XML represents one or more history records. The history records have the representation: <Filters> <filter> <actionType></actionType> ...
Score How to export DataTable to VFP table?
Gordon Lau - 2 Dec 2005 1:22 AM - 1 message
Hope someone can help me on this.  How do I export a DataTable to a VFP table?  My app creates a new DataTable with many rows (could be a half a million rows).  I want to save/export the DataTable to a new VFP table.  Tried creating a new VFP table and using the insert/update commands (used the OleDbCommandBuilder to automatically generate them for me) to add rows to it but it is WAAY too slow (took over 7 minutes just for 150,000 rows).  I'm not updating an existing table.  I want to export the results my app produced to a new table.   Any ideas? ...
Score How to export DataTable to VFP table?
Gordon Lau - 2 Dec 2005 1:09 AM - 1 message
Hope someone can help me on this.  How do I export a DataTable to a VFP table?  My app creates a new DataTable with many rows (could be a half a million rows).  I want to save/export the DataTable to a new VFP table.  Tried creating a new VFP table and using the insert/update commands to add rows to it but it is WAAY too slow (took over 7 minutes just for 150,000 rows).  Any ideas? ...
Score Automated Table Updates - Strategy Assistance Requested
Jeff - 1 Dec 2005 11:26 PM - 2 messages
I'm actually stuck! Can't believe it... so I'd appreciate some help. What I'm doing is enabling users of an ASP.NET 1.1 Web application to update a table in a SQL Server 2000 database. To make their life easier and to ...
Score Where is the Designer Code in WebApp
ad - 1 Dec 2005 9:01 PM - 1 message
I study the new feature of dataset in VS2005. When in a WinForm application, After I create a new DataSet with the IDE of VS2005, it will generate a Desginer file with the .xsd file. For example, if the DataSet file if dsZip.xsd, it will generate ...
Score Are there any benefits in specifying full details in SQL Parameter?
James - 1 Dec 2005 7:40 PM - 5 messages
I had asked this question before (long ago) but not sure if the answer still stands. When I create a SqlParameter object I can one of the many overloaded constructors. SqlParameter param = new SqlParameter("@customerid", 1001); SqlParameter param = new SqlParameter("@customerid", SqlDbType.Int, 4, ParameterDirection.Input, ..., 1001); ...
Score enumerate odbc data sources
Stuart - 1 Dec 2005 2:58 PM - 5 messages
Hi, Using Framework 2.0 how can I get a list of odbc datasources on the local machine? Using the DbProviderFactory.CanCreateDataSourceEnumerator returns false. This is the same with oledb providers which I also need to enumerate. Any suggestions appreciated. ...
Score OracleDataAdapter fill method - Refill problem
mspzzz - 1 Dec 2005 2:15 PM - 4 messages
I am using a DataGrid with a dataset and the OracleDataAdapter.Fill(dataset,"Tablename") method. All is fine: a table is created and mapped to the dataset and data is shown in the datagrid. When I clear the table, dispose it and remove it from the dataset, and then ...
Score Problems with a SP with a Temporary Table in .NET
Bruno Renato - 1 Dec 2005 1:51 PM - 1 message
Hy people, i hava a problem with add a SP with a tempory table inside in a SQLDataAdapter in VS .NET 2003. Is this the point of sintax that occur the error: (...) if object_id('tempdb.dbo.#tempprod') is not null drop table #tempprod ...
Score Insert Unicode string
ThorstenJ - 1 Dec 2005 11:48 AM - 2 messages
This has probably been addressed before, but I couldn't find it in the archives.   I try to store unicode data with ado.net. I'm using VS2005 and C++. In order to find Unicode data I have copied some text from [link] ...
Score Finding NULLs in untyped DataSet
Jeff - 1 Dec 2005 8:22 AM - 3 messages
I'm importing data from an Excel file into an untyped DataSet. I need to find any rows in the DataSet that have a NULL value in a specific column (say, the "FirstName" column). These would result from any any ...
Score joinview in 2005
Rick Elbers - 30 Nov 2005 10:59 PM - 4 messages
How abou joinview in 2005 ? Its needed ...
Score Synchronising SQL Server 2005 mobile with SQL Server 2005 Express
Paul Aspinall - 30 Nov 2005 10:23 PM - 8 messages
Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express). I believe that I will need to write my own synchronization application, in ...
Score Retrieve varbinary from SqlServer using OUTPUT params in StoredPro
Alvin - 30 Nov 2005 8:58 PM - 4 messages
Hi I have a stored proc with a varbinary OUTPUT param and I am trying to retrieve the value of this variable in the C# using SqlCommand and setting its parameters. However, I am not able to retrieve the value of varbinary ...
Score CurrencyManager
Joe - 30 Nov 2005 7:50 PM - 2 messages
I have a control which binds to a DataSource (DataView) but doesn't have a BindingContext. Is there anyway to attach a CurrencyManager to this DataView? Thanks, Joe ...
Score Foreign key error, adding in liked tables
Sam - 30 Nov 2005 7:01 PM - 1 message
Hi I am using VS2005 VB, SQLexpress. I did some tests in a simple 2 table test application where a parent table is linked to a child table. The data base is designed with VS and the data access is made by a typed data set and ...
Score Call SP with application block (daab) & multiple out REF CURSOR parameters
Stef - 30 Nov 2005 6:58 PM - 3 messages
Hi, I'm using Microsoft's data application blocks to execute a stroed procedure that look like this: (Note that I have not included the package declaration nor the T_CURSOR type declaration since it's working fine when I execute this procedure in a tool like TOAD or else) ...
Score Problem connecting to SQL Server 2000
John Yung - 30 Nov 2005 5:18 PM - 10 messages
Hi, I installed SQL Server 2005 Express on one of my development machine, I had since then having problem connecting to a SQL Server 2000 (On a cluster) database. The problem persist even after I remove SQL Sever 2005 Express. ...
Score ASP Scripts permissions error after install 2003 Server
JR - 30 Nov 2005 4:36 PM - 4 messages
Here's the scenerio: HAD:  Entire Windows 2000 domain multiple servers Internal Web Server - Windows 2000 NAS Server - Windows 2000 Internal Web Application (On Web server) utilizing .ASP scripts to access shared directories through mapped drives on NAS Server. (And ...
Score GridView Dynamic creation problem
Larry F. Burge - 30 Nov 2005 3:23 PM - 1 message
I have migrated my ASP.NET 1.1 implementation of a dynamic DataGrid to ASP.NET 2.0 GridView.  I make use of TemplateColumn, now TemplateField, etc. The problem is that I handle my own paging in a toolbar type control at the ...
Score error- System.Exception: Could not create an environment: OCIEnvCreate returned -1
scott - 30 Nov 2005 3:21 PM - 1 message
Hi, I encounter the following error System.Exception: Could not create an environment: OCIEnvCreate returned -1. when i try to run a simple program of ASP.Net (databinding example) that connects to an oracle database. I have included the program: ...
Score error- System.Exception: Could not create an environment: OCIEnvCreate returned -1
scott - 30 Nov 2005 3:20 PM - 5 messages
Hi, I encounter the following error System.Exception: Could not create an environment: OCIEnvCreate returned -1. when i try to run a simple program of ASP.Net (databinding example) that connects to an oracle database. I have included the program: ...
Score First chance exception?
Brian Henry - 30 Nov 2005 3:10 PM - 2 messages
I keep getting the following exception... A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Error: EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'. why would i be getting that? I have SQL debugging disabled in VS 2005. I and ...
Score Navigation using linked combo box and syncronization with a list box
George Gîta - 30 Nov 2005 12:46 PM - 2 messages
I want to do the following: - have a combo box linked to the Customers table - have a list box linked to the Orders table When I select a Customer from the combo, the list box will display all the Orders from that Customer. ...
Score DataList Creates Tables That Are Not Well-Formed
Nathan Sokalski - 30 Nov 2005 6:08 AM - 1 message
I have a DataList control that has 3 columns (RepeatColumns property = 3). However, because the number of Items in the DataSource is not always equally divisible by 3, the last 1 or 2 cells in the generated Table is sometimes ...
Score Insert columns into existing excel + OLEDB
rcm29 - 30 Nov 2005 5:20 AM - 3 messages
MyCase: I have an excel file Example1.xls which has file columns say A,B,C,D,E. Now when some error occurs i have to retrieve data from the input row index (this im doing by retrieving from the dataset) and insert the same data along ...
Score TARFU: Data Controls
clintonG - 30 Nov 2005 5:09 AM - 1 message
The Website Administration Tool  and the CreateUserWizard -- and presumably other controls -- do not record data to the database using system time. They record data using Greenwich time. Thus, if your web server's system is configured for GMT (-06:00) Central ...
Score sqlDataSource and textboxes, database, etc
ineedyourluvin1 - 30 Nov 2005 1:56 AM - 2 messages
Ok, let's say I have a web form with two textboxes.     Let's also say I want to enter my first and last name into them.     How would I bind these textboxes in a Visual Studio 2005 ...
Score Link between 2 databases
Peter Alt - 29 Nov 2005 10:44 PM - 2 messages
Hi, I have to do queries between 2 databases and with dao/vb6 I've linked all tables of database 1 into database2 as followed and can than do the queries in database 2. Now I'm beginning to transfer the project in vb.net and I ...
Score VS2005, ADO.NET 2.0 How to build a typed data set based on and oracle stord procedure?
A.M-SG - 29 Nov 2005 9:39 PM - 10 messages
Hi, Using VS2005 and ADO.NET 2.0, How can I build a typed dataset based on an Oracle stored procedure? Thank you, Alan ...
Score Parameterized queries to different data providers
Dino Buljubasic - 29 Nov 2005 8:35 PM - 5 messages
Hi, I would like to build my app so it can connect to SQL Server, Oracle or mySQL and query data. Data queries should be parameterized to reduce impact of SQL Injection. SQLServer Dataprovider uses named parameters (i.e. @name) ...
Score Data Access and Middle-Tier... Control Library or Web Services
Dollar - 29 Nov 2005 6:47 PM - 3 messages
Does anybody have strategies on when to through your Data Access and Middle-Tier into a Web Service opposed to a Control Library? I mostly deal with intranet ASP.NET web applications, and occasionally create web services that access my Data Access (which is in a control ...
Score How to use DataSet.xsd with ADO.NET DataSet??
Rob R. Ainscough - 29 Nov 2005 6:24 PM - 3 messages
In VS 2005 I've used the Data Source Configuration Wizard to create a MyDataSet.xsd, but I'm lost on how to get anything out of the .xsd into a workable ADO.NET dataset??  Any suggestions? Thanks, Rob. ...
Score Insert ForeignKey of parent DataGrid in child
Sebastian-Hiller - 29 Nov 2005 4:41 PM - 2 messages
Hi, I have two dataGrids bound to two different datasets, which relate to each other as parent/child. The primary key/foreign key columns are hidden in the DataGrid. If I select a Parent the corresponding child's are displayed. ...
Score DataSets designed in wizard
rogersmail - 29 Nov 2005 4:33 PM - 11 messages
Greetings, I am new to this and have some problems. I created a dataset using the vs2005 GUI and want to load the dataset using code in the back end I have:             XmlDocument xmlDoc = new XmlDocument(); ...
Score HELP on New request is not allowed to start because it should come
Geraldo Thomaz Jr. - 29 Nov 2005 3:55 PM - 9 messages
I am getting the following error in my application: New request is not allowed to start because it should come with valid transaction descriptor. This is happening under a very singular circustance: I have just migrated to SQL server 2005 and ASP.NET 2.0. ...
Score Problem with deleting a DataRow in a DataTable
Gus Gustafson - 29 Nov 2005 3:46 PM - 1 message
Hi all: I am allowing a user to delete (indirectly) a row (representing a floor in a building) from a data table (representing the floors in a building). To delete the floor, the user displays the appropriate floor data and clicks the ...
Score VS2005 / Stored Procedure
BJF - 29 Nov 2005 2:49 PM - 2 messages
First time through on this, so I could use some help. I'm having difficulty getting data from a stored procedure into a DataGridView control in a Windows form.  I'm using VS2005 and C#. My test program has two DataGridView controls.  One is populated via SQL ...
Score Absolute Beginner Question
Chris Strug - 29 Nov 2005 2:22 PM - 4 messages
Hi, My apologies if this is a simple question but I'm having a hard time making any progress so... I'm looking at VB ADO.net, moving from ADO / Access development. I've created a bog standard windows app in VB2005 Express and having read ...
Score DataGridView reordering in design view
Simon - 29 Nov 2005 12:41 PM - 1 message
Hi folks, I'm developing an desktop app that uses a DataGridView. This is bound to a BindingSource derived from an object. I have just added a couple of public properties to the class and added these columns to the DGV. They ...
Score DataAdapter Mapping only works for the first two tables.
vrjaya - 29 Nov 2005 9:53 AM - 4 messages
Hi, I am writing an application where the select command returns multiple record sets and write the infomation to a xml file. I used typed dataset to store the returned info and use the dataset.writexml command to save the data to a xml file. Oh one more thing I am used the DAB ...
Score Problem with strongly typed data sets
Carl - 29 Nov 2005 7:16 AM - 3 messages
Hi! Does anyone know of a way to tweak the code generator for the strongly typed data sets to allow nullable types? For example, the datatype "decimal" should be generated as "decimal?" instead. regards Carl ...
Score Concurrency Violations in SqlCeDataAdapter
Raja - 28 Nov 2005 11:48 PM - 4 messages
Hi all, I am having a problem with using SqlCeDataAdapter to update the database. I am working with the dataset and the data adapter to do  my Select,Insert,Update,Delete . The Dataset holds the results of the select commmand and I store the adapter in a Hashtable .When the user ...
Score define dataset column for timestamp data type in MS SQL server
John Yung - 28 Nov 2005 11:25 PM - 3 messages
All, What kind of data type should I use to definde a timestamp (row version) data-type in MS SQL Server for a column in a dataset? I tried to define it as byte[], but MSDataSetGenerator is giving me the ...
Score Problem Connecting To Access Database
Cathleen C via DotNetMonster.com - 28 Nov 2005 10:36 PM - 10 messages
I created some very simple ASP.NET  applications - form data is entered into an Access database.  There are 4 of these apps - all similar in nature and even connect to the same database just different tables via stored queries. ...
Score ADO.net is giving me the WRONG date here...
0to60 - 28 Nov 2005 9:59 PM - 8 messages
I have a table with a datetime column.  Then, in my C# program I open a datatable with that column in it and access it with the following syntax: dt.rows[i]["datefield"] Now, when I look at the data in the table from say Enterprise Manager, the ...
Score Nasty DataView bug
Bob L. - 28 Nov 2005 9:24 PM - 8 messages
Hi, everyone, I ran into a serious bug upgrading to VS2005, and very easy to reproduce. It goes like this: 1. Filter a DataView 2. Get a reference to a DataRowView 3. Clear the filter - the reference to the DataRowView has changed to a ...
Score Serviced Component, Excel and OleDbConnection.Open
josef - 28 Nov 2005 7:34 PM - 2 messages
I'm using the OleDbConnection object to retrieve the contents of an Excel Worksheet as a DataSet. This works fine when testing the MyExcel.GetMonthly() method call. When I call MyExcel.GetMonthly() from a Serviced Component, it bombs. Code snippet: ...
Score DataTable.Load() fills in schema!!
Benton - 28 Nov 2005 6:48 PM - 2 messages
Hi there, I was loading a datatable with Dataadapter's Fill() method. Then, I could add a new record to the datatable and it won't complain about not null columns until I called the Dataadapter's Update() method. That's OK for me. ...
Score WITH NOWAIT And SqlConnection's InfoMessage
Patrick - 28 Nov 2005 6:42 PM - 2 messages
Is there any possible way to get messages asynchronously sent from a stored procedure running on SQL Server 2000, back to ADO.Net, in realtime (or at least somewhat close to it)? After much experimenting, I am left to say "no"... it is not possible. ...
Score Why am I getting ForeignKeyConstraint requires child key value error?
dbuchanan - 28 Nov 2005 6:14 PM - 15 messages
Hello, Here is the error message; ---------------------------- Exception Message: ForeignKeyConstraint Lkp_tbl040Cmpt_lkp302SensorType requires the child key values (5) to exist in the parent table. ---------------------------- I am encountering this error when I try to insert records into table 'tbl040Cmpt' using the DataSet1.Tables("Table").Rows.Add(row) ...
Score Dtabinding and Update issues
Vincent Dalton - 28 Nov 2005 4:30 PM - 1 message
Hi All, I have a typed dataset which contains several tables. The 3 that I am experiencing difficulty with are "CONTACTS", "ALL_ZIP_CODES" and "E_ZIP_CODES." The "CONTACTS" table is selfexplantory. The table "E_ZIP_CODES" is a subset of all ZIP codes that are in the "CONTACTS" table. The table "ALL_ZIP_CODES" consists of a complete listing of ZIP codes. ...
Score ANN: OleDBProNet for .NET version 2 is released at www.udaparts.com
Yuancai (Charlie) Ye - 28 Nov 2005 3:49 PM - 1 message
Hi, All:      OleDBProNet is a .NET class library which is a complete, feature-rich, and extremely powerful data access solution for .NET programmers through MS OLEDB technology. It offers the following key benefits over ADO.NET: ...
Score Comparing two datasets
Ali - 28 Nov 2005 10:01 AM - 10 messages
I need to compare the values of two datasets and retrieve the differences into a third dataset. I need to retrieve Employees  names and numbers from Excel sheet into ds1 and retrieve Employees names and numbers from SQL Employees Table into ds2.  ...
Score best practice for transactions
Julia - 28 Nov 2005 9:38 AM - 5 messages
Hi, I'am developing an asp.net app that is using an sql server. How should I deal with transactions? Should I do the transactions in my stored procedures or should I use Serviced Components or... Thanks ...
Score That pesky timestamp thing
Earl - 28 Nov 2005 5:27 AM - 7 messages
Creating a datatable from scratch and then I'm inserting with a select in the sproc to return the current values after the insert. Now I realize the timestamp column is a datatype of byte, and I'm not trying to insert the ...
Score Getting the value of an identity column after an insert
UncleJoe - 27 Nov 2005 11:24 PM - 4 messages
Hi all. I am trying to resolve this seemingly very simple and not to mention well documented problem but just couldn't seem to get it to work. I have a datatable that uses an identity column as the primary ...
Score Visual design tools and DAL in VS 2005 / .NET 2.0
Paul Aspinall - 27 Nov 2005 10:48 PM - 3 messages
Hi I wrote quite a few apps with .NET 1.0 and 1.1, which made use of a Data Access Layer, and also used the Microsoft Application Blocks for Data Access (v2). In VS 2005, there is a huge improvement in 'visually' designing the data ...
Score Conditions of DataBinding
Martin - 27 Nov 2005 4:36 PM - 2 messages
what are the conditions in order to bind to an object? i have an object, which implements the IList interface. Now I'am able to bind the objects, which are hold by the collection. now i implemented two properties in my collection. but i'm not able to bind ...
Score Paging Problem
Kim - 27 Nov 2005 6:26 AM - 1 message
I've got a PageIndexChanged event handler as follows: Private Sub dg_PageIndexChanged (ByVal s as System.Object, ByVal e As System.DataGridPageIndexChangedEventArgs) Handles dg.PageIndexChanged      dg.CurrentPageIndex = e.NewPageIndex      dg.DataSource = ds.Tables("ABC") ...
Score Losing Dataset icon/instance from project
Jeff - 27 Nov 2005 5:03 AM - 1 message
I've got a project with a Typed Dataset. The dataset consists of several tables. Every time I attempt to go into the dataset to adjust a table, like adding a new column that was added to the DB, I lose the ...
Next »