Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Datagrid calculated column not updating
David Kirkman - 28 Jan 2006 10:34 PM - 7 messages
I have a datagrid (C# Windows Forms App) bound to a dataset. One column in the dataset is a calculated column based on an expression that simply subtracts the value in one column from the value in another column. I created the dataset using a dataset control and the ...
Score Q: Updating the correct keys
Geoff - 28 Jan 2006 10:12 PM - 9 messages
Hi I'm hoping somebody can help me with the following problem that has occurred to me. Suppose I have two tables in an SQL Server database. Let's call these tables A and B. Assume that A has two fields: a primary key and another holding a ...
Score ODBCDataReader NO_DATA error when reading from CSV file
simon - 28 Jan 2006 6:01 PM - 4 messages
This is a strange one. In ASP.Net v1.1 using VB, I'm using an ODBCDataReader to read from a CSV file. Most of the time it works, but if the "description" field contains more than 2046 chars, I get a NO_DATA error (see below for full error) when ...
Score "EOF" in Data table
Ant - 28 Jan 2006 5:53 AM - 8 messages
Hi, I'm just coming from classic ADO (& still thinking that way) & I'm wondering how you can determine when you get to the EOF in a data table. This is what I've done below. It works, but I don't think it's the most elegant way of ...
Score Adding commands at runtime to generated adapters
Scott Bruno - 28 Jan 2006 1:01 AM - 3 messages
So I’ve got this dataset that was built with the designer. All is well except that the Select command needs to be generated at runtime for app-specific reasons. I thought I would do something clever, which was add a version of Fill() to ...
Score Database with diverse data
Amil - 27 Jan 2006 8:12 PM - 1 message
Can anyone recommend a good whitepaper, strategy, or book on this... I am going to implement a project where I will be getting several very different types of data from third-party vendors; the data will often be in a format only understood by the third-party (encoded).  I would like to be ...
Score Where to use connection, dataset, datareader ?
Doru Roman - 27 Jan 2006 7:01 PM - 11 messages
Hi, I have some difficulties in understanding how to use the connection, dataset, datareader in a form. Let's suppose I want to create a datareader and when I push a button to bring another row from the dataset. Supposedly I create under MyForm_Load event the connection, then a command ...
Score EndCurrentEdit does not push changes into the dataset
susan - 27 Jan 2006 5:28 PM - 2 messages
I have a Windows Form written in C# with a non-edit DataGrid showing a list of records. When the user selects a row in the grid, the full details of the record display in a panel which contains textboxes and ...
Score Middle tier Data access object in .net assembly or COM?
david - 27 Jan 2006 3:29 PM - 3 messages
Hi, I am new in VS.net. We try to migrate our VB6 application to .net. In our VB6 application, we have a middle tier data access object to handle the connection and stored procedures' calls. Do we still do middle tier DO in ...
Score Manipulating data on input w/ TableAdapter & Dataset.
Mike Edgewood - 27 Jan 2006 2:21 PM - 7 messages
I know this is easier to do with a datareader and a listview, but can it be done with a tableadapter and a dataset? I want to manipulate the data prior to it reaching the dataset,   For instance, data is stored as Firstname and Lastname and sometimes there ...
Score [.NET 2.0]Problem with DataTable.Load (dt,LoadOptions.Upsert)
Oriane - 27 Jan 2006 2:14 PM - 2 messages
Hi, I would like to update an Sql Server database with Excel data. For this, I use2 identical typed datatables: dtSql, and dtXls. Here's my code simplified: TypedDataTable dtXls = new TypedDataTable; TypedDataTable dtSql = new TypedDataTable; dataAdapterXls.Fill (dtXls); dataAdapterSql.Fill (dtSql); ...
Score TransactionManagerCommunicationException using TransactionScope
Christopher Kimbell - 27 Jan 2006 12:11 PM - 3 messages
I'm writing a Windows service that uses the new TableAdapter in .NET 2.0. I have several adapters that must be updated as an atomic operation, so I have wrapped them using the TransactionScope. When I run my code I get a TransactionManagerCommunicationException with the ...
Score SQL Table to DataSet to Dataview, to DataSet to XML!
matteo - 27 Jan 2006 10:20 AM - 5 messages
Hi everybody, i've a question for this group: i've  developed a windows service that every x minutes count records present in a sql table and if those records are bigger than a fixed threshold start with clean operations. ...
Score DataSet to Dataview to Dataset to XML!
matteoalessio - 27 Jan 2006 10:12 AM - 3 messages
Hi everybody, i've a question for this group: i've  developed a windows service that every x minutes count records present in a sql table and if those records are bigger than a fixed threshold start with clean operations. ...
Score DataAdapter error
Ant - 27 Jan 2006 8:55 AM - 2 messages
Hi, I've created a relational group of tables using the designer for the Data Adapter. It decided to cross join all the tables, so I manually did it using Inner joins, nothing special just PK to FK. When I click preview data, then try to fill a dataset created by the ...
Score Fitting TableAdapter into Remoting Infrastructure
CMM - 27 Jan 2006 8:46 AM - 3 messages
Short question: how to fit TableAdapters into (true) n-tier development. More Info: In VS2003 in terms of *physical* n-tier development, I had a fairly nice pattern going. My DAL exists on a separate server and accessed via remoting. ...
Score Table name in Dataset
Ant - 27 Jan 2006 2:57 AM - 4 messages
Hi, When I create a typed dataset containing multiple relational tables using Generate dataset, it creates a single set of records based on what was chosen when setting up the data adapter. If I have an orders table, an orderItems ...
Score General network error
Valerie Hough - 27 Jan 2006 2:24 AM - 4 messages
Hi I am supporting a client that gets 5-10 of the following errors each day: General network error.  Check your network documentation. ----------------------------- Stack trace:     at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)    at ...
Score building a web site
admin - 27 Jan 2006 1:25 AM - 1 message
I just got back working on my website.  Its taken a long time to finish but I am getting there. I got great web hosting at [link] where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. ...
Score GetChanges question
WineNCheese - 26 Jan 2006 9:51 PM - 3 messages
Can someone please tell me how the following is possible?  When I do this:    System.Data.DataSet addedAndModified =  myDataset.GetChanges( DataRowState.Added | DataRowState.Modified ); some of the rows in the resulting dataset have a RowState of ...
Score DBAccess in WinForms
Vedanshu Mandvikar - 26 Jan 2006 9:30 PM - 2 messages
Hi EveryOne, What is the best approach for data access while developing applications using Windows Forms ? Is it opening, working with and closing a new SQLconnection and SQLcommand object everytime a DB access is needed , or maintaining a single open connection/command object at the application level ...
Score Error saving typed dataset (.NET 2.0) - Object not set to referenc
tgb - 26 Jan 2006 6:44 PM - 2 messages
I have an ASP.NET project with a typed dataset (with table adapters).  The table adapters' connection string property was set to get the connection strings out of the web.config file.  I was able to add new table adapters, ...
Score SqlTransaction problems
Michael - 26 Jan 2006 6:27 PM - 6 messages
Hi Everyone, I'm currently working on a form that requires 3 stored procs to run (one of them several times), but these stored procs are in different functions (see below). The problem is that after the commit, the database doesn't reflect ...
Score cannot connect to an oracle
Julia - 26 Jan 2006 4:42 PM - 5 messages
Hi I have problems when I try to connect to my Oracle db from VS 2003. I get this error: ORA-12154: TNS:could not resolve the connect identifier specified My tnsnames.ora-file I have this text: MALL =   (DESCRIPTION = ...
Score DataReader Limits data returned!
TY - 26 Jan 2006 1:55 PM - 3 messages
I have a stored procedure that returns xml data (using For XML), it returns about 9000 records. I use a datareader to write the data to a XML file. For some reason, the datareader doesn't write all data, it seems like the ...
Score click event handler executed twice
dsvick - 26 Jan 2006 1:15 PM - 8 messages
Hi everyone: I got simple aspx with a user control in it that posts some entered data to a database. The problem I'm seeing is that when the submit button is clicked the code is executed twice and I get duplicate rows ...
Score Document locking concept ?
Marek - 26 Jan 2006 10:56 AM - 1 message
Hi ! I have problem with locking concept in my application (ADO.NET , C#). Application has several documents which looks like Order.My question is what and how should I lock those documents. 1.Lock document as a whole (Order + OrderLines) so another user can't work ...
Score copy selected row from a datagridview to another
Federico Caselli - 26 Jan 2006 9:36 AM - 1 message
I'm trying to copy seleced rows from dgv1 datagridview, bound to dsOrders1 dataset to dgb2 datagridview, bound to dsOrders2 dataset both dsOrders1 and dsOrders2 are instance of dsOrders dataset schema. Can you help me? Thanks. ...
Score question on sql
ken - 26 Jan 2006 9:29 AM - 3 messages
Dear all 1.)How can i save the stored procedure in sql 2005 server, into server and NOT in file location 2.)How can create folder in stored procedure to separate categories? 3.)How can view the created date and modify date of stored pro ...
Score TransactionScope and DataSets
Kirk Jackson - 26 Jan 2006 2:19 AM - 4 messages
Hi, I'm wondering what the official Microsoft recommendation is for handling TransactionScope transactions when using TableAdapters within a DataSet. I have a dataset that various areas of my business logic uses, and at a higher level I'd like to wrap several business functions in a ...
Score What causes SqlCommandBuilder to not build commands?
Scott Bruno - 26 Jan 2006 12:59 AM - 9 messages
Language is C++ and my code is pretty much right out of the documentation example, yet I'm not ending up with any generated commands. In the following, assume the relevant objects are members of a form class and this is happening ...
Score OLEDB Exception: The search key was not found in any record
temp - 25 Jan 2006 9:43 PM - 3 messages
Greetings! I've written a console application to perform some trivial database routines.  When I run the application, it catches the an OleDbException that states "The search key was not found in any record."  My C# code follows: ...
Score "Specified cast is not valid" when generating dataset
pldurrer - 25 Jan 2006 8:42 PM - 2 messages
I have a dataset defined as follows: <?xml version="1.0" standalone="yes" ?> <xs:schema id="dsEscheatment" targetNamespace="http://www.tempuri.org/dsEscheatment.xsd" xmlns:mstns="http://www.tempuri.org/dsEscheatment.xsd"     xmlns="http://www.tempuri.org/dsEscheatment.xsd" ...
Score JOIN on 2 datasets?
mirax_00 - 25 Jan 2006 8:08 PM - 4 messages
Can I code a JOIN on 2 datasets the same as 2 tables in a database or do I have to retrieve the table by index or something of the table and JOIN those?  There's only 1 table in each ds... ...
Score Default DateTime Value in a column
Josh - 25 Jan 2006 4:37 PM - 4 messages
Hi, Im creating an in memory DataTable.   I have a "dtCreated" column that I want to be populated with the current date and time when a record is added. I dont want to code this every time I add a record. ...
Score Intermediate Table / DataView / Strongly Typed Dataset
Jay Pondy - 25 Jan 2006 4:03 PM - 1 message
Given the following Tables and Relationships in a Strongly Typed Dataset: Employees <-->> EmployeeGroup <<--> Groups   PKID            GroupPKID           PKID ...
Score Oracle Developer Tools for Visual Studio .NET 10.1.0.4.0
Julia - 25 Jan 2006 2:58 PM - 1 message
Hi I have tried to install the plug-in tool for Oracle. I just ran the ODT10104.exe file. But when I open Visual Studio .NET 2003 I cant se the Oracle-window in the View menu... what can be wrong? ...
Score ADO.NET 2.0 TableAdapter Configuration Wizard
Mike - 25 Jan 2006 2:47 PM - 4 messages
Dear Group, When I add a DataTable to a Typed Dataset, and a TableAdapter to the DataTable, I am able to create methods to send updates directly to the database (GenerateDBDirectMethods), however when my TableAdapter Fill SQL contains a WHERE clause which looks up a field from another joined table, ...
Score XML to RTF parsing
Ilya Dyoshin - 25 Jan 2006 1:49 PM - 3 messages
Hi all There is an XML file, formed from dataset. I want to see this in the RTF-document like a set of tables. something like: Table1 name +------------------------+------------------------+--------------------+ Table2 name +------------------------+------------------------+ and so on. Can someone give me code samples how to do it? ...
Score VS2005 Strongly Typed DS and Mutliple Result Set
Jay Pondy - 25 Jan 2006 1:13 PM - 2 messages
Using a Stored Procedure that returns mutliple result sets how do I populate a strongly typed dataset? I've tried using a command object to call the SP and then using the DataAdapters TableMappings collection as follows: oAdp.TableMappings.Add("Table", DS.Junk.TableName) ...
Score date/time fields
Jerome - 25 Jan 2006 12:52 PM - 8 messages
Hallo, I know a lot has already been told about date/time fields in a database but still confuses me, specif when dealing with SQLserver(Express). It seems that sqlserver only accepts the date in a "yyyyMMdd" format? (difference between Express and MSDE2000A ?) ...
Score ZombieCheck
Eyal S - 25 Jan 2006 10:13 AM - 3 messages
We develop using .net 2.0 with SQL 2000 DB. We randomly receive an error: System.Data.SqlClient.SqlTransaction.ZombieCheck(). Does anybody have any idea ot why this happens? Thanks ...
Score How to retrieve all sql server errors on ADO.NET?
ABC - 25 Jan 2006 8:19 AM - 5 messages
How to retrieve all sql server errors on ADO.NET? I have a stored procedure which will validate data and raiserrors when any error value inputted? Example from my stored procedure when running sample data. Server: Msg 50000, Level 16, State 1, Procedure proc_Validation, Line 52 ...
Score How do you pass NULLs to SQL via an Insert Statment
Phil Williams - 25 Jan 2006 2:53 AM - 5 messages
Hello all, I have a SQL Insert statement like the following: INSERT INTO tblQuestions                       (SurveyID, Inactive, Description, Datatype, Question, ...
Score VB.NET - How do I return an AutoNumber from an Insert Statement using the DataGridView
Phil Williams - 24 Jan 2006 9:46 PM - 8 messages
Hello, I have a Grid in a VB.Net application which I want to return the Primary Key which is an AutoNumber after I insert a record. The Primary Key Number that I get back is not from SQL Express but from VB and it can be wrong. ...
Score Updating Database where Field Column Name has a space in it
richy_latham - 24 Jan 2006 7:01 PM - 4 messages
Hi I'm hoping this has a nice easy solution. I have a small C# app that adds some rows to an Access database. Only problem is one of the columns was originally named "Parent Alias". When I went to update it I get the following error message "An ...
Score SQL syntax to increment field value by 1?
VB Programmer - 24 Jan 2006 5:58 PM - 5 messages
What is the SQL Express SQL syntax to increment a field by 1? The stored proc doesn't like this: CREATE PROCEDURE dbo.VideoViewIncrement @VideoId nchar(40), AS UPDATE Videos SET TimesViewed = TimesViewed + 1 WHERE (VideoId = @VideoId) RETURN Any ideas? ...
Score date type conversion error ignored
Richard Chandler - 24 Jan 2006 4:15 PM - 3 messages
Win2003 Server sp1, SQLServer2000 sp4, .Net 1.1 The code below executes fine without throwing an exception. Unfortunately, in my real problem the command executes a stored proc, which completes happily despite this error. The error results in NULL values in ...
Score Combobox Lookup
Kenneth Hutson - 24 Jan 2006 3:40 PM - 4 messages
Hi, I am pretty much a novice at this, but this must be a simple thing to do. I have an Access database with tables offices and states. Offices has a stateid (long integer) column. States table has a stateid (long integer) and ...
Score Incremental search
Zoltan Hubai - 24 Jan 2006 11:12 AM - 1 message
Hi I'm trying to do incremental search in my DataTable with TextBox and DataGridView. I did it but like to know if it's there a simple method to do the same. I have a DataSource with more DataTables. Depending wich TextBox has the ...
Score TableAdapter and CommandTimeout
Jurica Smircic - 24 Jan 2006 10:31 AM - 5 messages
Is there any way to change CommandTimeout on commands that are generated using TableAdapter wizard? ...
Score Unbound Data Access
harry.verstandig - 24 Jan 2006 1:59 AM - 2 messages
I am having a problem with asp.net 2.0 that I did not have with 1.1. In C# code behind, I want to read data via a GetData(int productID) class to obtain several columns of data from one row of one table in a Sql ...
Score passing parameters to filter using "IN" keyword
Andre Ranieri - 23 Jan 2006 11:33 PM - 7 messages
Hi, I'm trying to build a stored procedure to run in a SQL 2000 environment. I'd like to search for invoices by invoice type.  The user interface for invoice type has a checked listbox where multiple selections are allowed.  ...
Score BEGIN TRANSACTION problem
JimM - 23 Jan 2006 9:50 PM - 8 messages
I have the following code and the rollback is giving me an exception that there was no BEGIN TRANSACTION.  I have stepped through the code and the BeginTransaction is created. Now I am running a set of unit test forcing both failure and success ...
Score expects parameter ??? , which was not supplied."
Michael - 23 Jan 2006 8:13 PM - 3 messages
Hi Everyone, I'm getting the above error when I try to execute a stored proc. I've been trhough the SP and the vb function and can't find anything missing or incorrect, unless I missed something. Here is a list of things I've tried: ...
Score Problem opening oledb connection to excel file
Bill Youngman - 23 Jan 2006 6:03 PM - 2 messages
I am trying to open an excel file on my local machine and read it's contents using the OleDbConnection class in C#. Here is what I am doing-- string csv_store_read = "import/" + filename;    --> points to excel file ...
Score new to .net and I want to throw it back
Gonzosez - 23 Jan 2006 5:22 PM - 10 messages
I have the followinf statement TextBox1.Text = rsVMFG("id") I get the following message Unable to cast object of type 'ADODB.InternalField' to type 'System.String'. Huh???? ...
Score GridView DeleteCommand Erroring on StoredProcedure?
David R. Longnecker - 23 Jan 2006 5:08 PM - 8 messages
I'm attempting to call a stored procedure to delete a grouping of records based on the GridView's DeleteCommand; however, I constantly receive an error message from Oracle that, after searching through Google and Meta, does not provide much insight: ...
Score asp:AccessDataSource, update command does nothing.
Arne - 23 Jan 2006 4:46 PM - 1 message
All my sql commands against Access works fine except my update command. I had my update command working fine against SQLExpress., but SQLExpress has other problems. What am I doing wrong? Is there another public domain database that I should be using? ...
Score Using correctly SqlDataReader
Javier Martínez - 23 Jan 2006 3:27 PM - 4 messages
Hi When I using a SqlDataReader returned by a ExecuteReader command is all data results loaded in memory or the database is accessed in each Read method of SqldataReader? Thanks in advance Javier ...
Score MDAC Install Problem
Wayne Wengert - 23 Jan 2006 11:26 AM - 4 messages
I have a system running XPPro/SP2 which, when we run the install for MDAC 2.8 (the mdac_type.exe file) gives an error: "This setup does not support installing on this operating system."  The install is set for installing on ...
Score how can I do a databind to arraylist?
amos hchmon - 23 Jan 2006 8:46 AM - 2 messages
I have a arraylist I want to bind him to datagrid how can I do this? could I get a reference about this or example. thanks. ...
Score How-to? Handling exception with DatasetTableAdapter in ADO.NET 2
Michael Wong - 23 Jan 2006 7:23 AM - 1 message
Hi, I'm currently trying to code with the new C# ADO.NET 2 (I'm still new and haven't done much coding in ADO.NET 1 yet) I'm stuck trying out to figure how the exception handling works. ...
Score Tablename.Fieldname in DataSet
AJ - 23 Jan 2006 5:01 AM - 2 messages
I have a sql query with a join, for example something like this SELECT  Customers.CompanyName, Customers.ContactName , Orders.OrderDate, Customers.CustomerID, Orders.CustomerID FROM  Customers INNER JOIN Orders ON                 Customers.CustomerID = Orders.CustomerID ...
Score ObjectDataSource and ColumnChanges.
Wayne Brantley - 22 Jan 2006 7:45 PM - 4 messages
I have a grid connected to an ObjectDataSource and everything works and updates fine.  I am using VS2005's dataset designer to create the dataset/tableadapters and developing in ASP.NET. What I am now trying to do is to update column A when column B changes. ...
Score Relative path to Access database in .net 2
Thomas M - 22 Jan 2006 1:54 PM - 4 messages
I'm trying to read from an Access database using an SqlDataSource and displaying the retrieved data with a DataList, in asp.net 2. I want to use a relative path to the .MDB file. However, I get this error: ...
Score dataset changes not reflectin in database
divya jain - 22 Jan 2006 10:06 AM - 2 messages
Hi, i have a data adapter(da) with ther query "select product, qty form order" and a dataset with the name (ds) da.fill(ds,"aa") //i want to update only this particular column of this dataset, so i m ...
Score dataset changes not reflectin in database
divya jain - 22 Jan 2006 10:03 AM - 1 message
*** Sent via Developersdex [link] *** ...
Score ObjectDataSource Example for Bill Vaughn (1/1)
Otis Mukinfus - 22 Jan 2006 12:46 AM - 1 message
[attached file: Author.cs] [attached file: AuthorDB.cs] ...
Score ObjectDataSource Example for Bill Vaughn (0/1)
Otis Mukinfus - 22 Jan 2006 12:46 AM - 1 message
This post is to show an example of how to design Classes for use with the ObjectdataSource in ASP.NET.  Since it uses ADO.NET to access the database layer I'm posting it here. Bill if you see this, you may recall I told you if I learned more ...
Next »