Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score merge problem
observer - 16 Sep 2006 6:21 PM - 1 message
Hi, I have a dataset that contains two tables, one holds parent entities and the other contains the Childs, there is a relation made into the dataset between the two tables to tie the primary key of the parent with the foreign in the ...
Score merge problem
observer - 16 Sep 2006 6:19 PM - 1 message
Hi, I have a dataset that contains two tables, one holds parent entities and the other contains the Childs, there is a relation made into the dataset between the two tables to tie the primary key of the parent with the foreign in the ...
Score Merge problem
Observer - 16 Sep 2006 5:19 PM - 1 message
Hi, I have a dataset that contains two tables, one holds parent entities and the other contains the Childs, there is a relation made into the dataset between the two tables to tie the primary key of the parent with the foreign in the ...
Score Problem: Master / Detail + DataRelation + DataView
Arif - 16 Sep 2006 9:52 AM - 1 message
Hi all, Testing with Database       :   Nortwind Master Table  :  Customers Detail Table    :  Orders DataRelation : relCustomersOrders On Form_Load, DataAdapter fills the dataset with above two table and creates ...
Score Internal .Net Framework Data Provider error 12.
Anant Kulkarni - 16 Sep 2006 7:57 AM - 9 messages
Hi, I am using .Net Framework 2.0. And for accessing data Oledb data provider. This is used in a multi-threaded windows service. I am getting the following error on a select query. The stack trace is as follows. ...
Score ORA-00020: maximum number of processes (%s) exceeded
John G - 15 Sep 2006 8:21 PM - 3 messages
I have been using the OleBDhelper ([link]) with oracle.  With a small group of people we recieved the following message: ORA-00020: maximum number of processes (%s) exceeded ...
Score chunking in binary (BLOB) data for generic providers
Michael Burstin - 15 Sep 2006 6:24 PM - 11 messages
I think that the answer is no, but is there a generic way to insert BLOB data into a table in a generic method via ADO.Net in blocks/chunks? From reading all examples, questions, and other information I can find ...
Score Testing for SQL2000 server availability?
ARTMIC - 15 Sep 2006 6:24 PM - 4 messages
how can i test in my C# code that the sql2000 server is available or can be seen on the network? Right now when i connect to it it gives me an exception, and it takes a while to spit out the exception, i mean i can hide the ...
Score Where to put the Connection String
tshad - 15 Sep 2006 4:31 PM - 3 messages
I am trying to find the best place to put my connection string. For my websites, I put it in the web.config file.  But since I have multiple web sites, I have multiple strings to handle whenever I make a change to the ...
Score Location of file written by WriteXML
glenn - 15 Sep 2006 3:15 PM - 3 messages
Hello, I am using the following code in an attempt to write my dataset to XML. Function GetRecordCount() as integer Dim strConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=c:\path\fmdb.mdb" ...
Score DataRow 'saved' in a Queue (C#)
Bishman - 15 Sep 2006 2:16 PM - 2 messages
Hi, I am using a Queue object to save the contents of a DataSet within a 'foreach' loop. I use the .Enqueue method to add the Row to the Queue, but when the .Delete method is called on the original row each 'field' value has the exception ...
Score Storing BLOB when you don't know the length
Andrew - 15 Sep 2006 8:53 AM - 2 messages
I am currently using the following code to store a stream into a binary database field.  This works but I want to start reading from a compressed stream where I will not know the length. Is there any way to add the bytes chunk by chunk until there is none left to ...
Score Impersonation and Jet 4.0 OleDB Error
mdhaman - 15 Sep 2006 6:42 AM - 7 messages
Hi I have a ASP.Net 2.0 web site which dowloads the "#" delimited  file from FTP server and drop it onto a UNC share. This file is then loaded into a dataset using Microsoft Jet 4.0 OleDB provider. ...
Score Unable to connect to MDB in shared folder
syvman - 14 Sep 2006 10:51 PM - 7 messages
Hello everyone... I have run across a very strange problem, and I'm at my wits end, hehe.  It seems that I'm unable to connect to an access ..mdb database file via Jet OLE DB Provider when I use a network shared ...
Score Adding variable to SQL Server query VB.NET
T McDonald - 14 Sep 2006 7:21 PM - 2 messages
I'm attempting to add a variable to a WHERE clause in a SQL query datasource. I want to add the variable in my page_load statement. The datasource looks like this: <asp:SqlDataSource                 ID="SqlDataSource1" runat="server" ConnectionString="<%$ ...
Score lost with SQL 2005
Phil Townsend - 14 Sep 2006 6:09 PM - 4 messages
I have installed SQL 2005 on a new machine and cannot find any of the client tools I am used to having: query analyzer, enterprise mgr., profiler. Shouldn't they be included in a default installation if I chose to install client tools? Where do I go to find them? ...
Score Sybase ASE client to connect to Sybase System 11
Chris Davoli - 14 Sep 2006 5:56 PM - 2 messages
I'm using .Net framework 2.0, Sybase System 11. I need the Sybase ASE cient to use to get data from a sybase data bse, but I can't find it. Anybody have it? Does anybody know where I can get it? I have ...
Score Create an STD (strongly typed dataset)
Cowboy (Gregory A. Beamer) - 14 Sep 2006 5:15 PM - 1 message
I have been asked this question numerous times, so I wanted to provide a blog link: [link] It shows how to flip from normal DataSets to STDs without much effort. ...
Score This dataAdapter update code keeps timing out...
Bmack500 - 14 Sep 2006 4:11 PM - 1 message
Basically, I'm just iterating a searchresult collection, sticking it into a datatable, and trying to update the source database. However, it seems that no matter what I set the batch size or timeout (on the connection string) to, it keeps timing out about 85% of the time! It's ...
Score Retrieving data directly from a table adapter
Steve Jensen - 14 Sep 2006 3:50 PM - 1 message
In working with ADO.NET in VS2005, I need to find specific rows in the filled adapter and get values from specific columns in those rows.  To do this, I first have to query the table adapter's binding source: ...
Score Cleverjoin?
Edwin Knoppert - 14 Sep 2006 2:01 PM - 4 messages
I have a field in a table (TABLE2) with commaseperated keywordes for example: "AA,BB" Another table (TABLE1) has multiple (user)records field only having "AA" or only having "BB" etc.. I would like to use a join on these fields like: ...
Score Related rows within a typed dataset: How to make them work?
Sean F. Aitken - 14 Sep 2006 1:22 PM - 2 messages
Good morning, I have a typed dataset that is composed of a few tables. I usually just use the typed dataset for loading / updating and working with data at the table level (and not at the DataSet level). In other words, I ...
Score DataSet Question
Weste - 14 Sep 2006 11:15 AM - 3 messages
I have 2 questions regarding designing typed data sets.  Say an application has 20 tables.  Is it better to create a single data set with all 20 tables or should you create several data sets each including only the applicable ...
Score SQL performance anomaly through .NET with parameters
Dave Booker - 14 Sep 2006 3:08 AM - 5 messages
I have three database queries that, as listed here, do the same thing.  #1 uses two parameters, #2 uses one parameter, and #3 uses none. 1) SqlCommand cmd = new SqlCommand("SELECT * FROM DataView WHERE Date>=@Start AND Date<=@End", conn); ...
Score how to connect asp.net with MS-access and also how to pass data t
Jack - 14 Sep 2006 1:03 AM - 1 message
hI, Anyone here know how to connect asp.net with MS-access and also how to pass data to a table? The following is the code which I have but unfortunately its not working..     Public Connectionstring As String = ...
Score how to connect asp.net with MS-access and also how to pass data t
Jack - 14 Sep 2006 1:01 AM - 2 messages
hI, Anyone here know how to connect asp.net with MS-access and also how to pass data to a table? The following is the code which I have but unfortunately its not working..     Public Connectionstring As String = ...
Score SQL Error? Incorrect Syntax near '1'
Greg P. - 14 Sep 2006 12:11 AM - 2 messages
I have created an insert statement by concatenation in VS2005 going to SQLServer 2005.  If i copy the string out of my watch window and run it as a query on my Database it works fine.  If I do an execute non-query on it I the ...
Score Best Practice from Oracle DB to DataGridView
newtonwong - 13 Sep 2006 10:24 PM - 2 messages
Hi, I'm wondering whats the best practice to accomplish the following display in a DataGridView. 1. Perform a Query to an Oracle DB with a multiple join select that returns multiple rows. (Should I use a DB object i.e. Stored Procedure, ...
Score Dataset Update problem
Kevin - 13 Sep 2006 9:55 PM - 4 messages
I'm at my wits end on this. Hopefully it's just something stupid I did. I have a dataset of a that I'm populating by looping through some records in a Btrieve database (Peachtree) and then writing to a SQL table. New records ...
Score Memory Problem doing INSERTs
DonS - 13 Sep 2006 5:04 PM - 3 messages
I am having a problem with massive memory usage when running a series of INSERT statement.  This started in VB6 using ADO and Access, then I moved to VB.NET using ADO, then to ADO.NET and then to SQL instead of Access.  I have ...
Score Severe Problems while conencting to SQL 200 from Ado.net 2.0
FrankTheTank - 13 Sep 2006 9:49 AM - 2 messages
We are having a severe problem with connecting a asp.net 2.0 application to sql server 2000. I have searched the internet for about one day and tried every option there, but there seems no solution. It is realy strange and we don't know anymore what to do. Let me briefly ...
Score Connection string
Stig-Arne Basberg - 13 Sep 2006 7:08 AM - 3 messages
I would like to make it easy for users of my app to change database. Not everyone knows all the necessary settings in a connection string, so is there any way for me launch the database "Connection properties" window (same as when generating a connection string in VS2005) from my application? ...
Score Oracle Stored Procedure Default Parameter problem
dave_93_98 - 13 Sep 2006 12:42 AM - 1 message
Hello, I am receiving the following error when trying to call an Oracle stored procedure inside of a package - PLS-00306 wrong number or types of arguments. This happens for several procedures within the package I am using and by using DeriveParameters I was able to determine that the first ...
Score Yet another issue with DataColumn inhertiance
Joe - 12 Sep 2006 11:49 PM - 7 messages
Since DataColumn is not sealed I would like to inherit from it and create my own. Unfortunately it seems that when serializing a DataTable with these columns, only DataColumn (the base) is serialized and my derived column is not. Is there anyway I can use and serialize a derived DataColumn? ...
Score DataRelations. With or without the constraint?
michael - 12 Sep 2006 8:57 PM - 4 messages
Why would you be able to (or want to), create a DataRelation without a constraint? The DataRelation constructor takes a parent and child column array to create the association, I assume (maybe incorrectly) that the child column array would serve as the Foriegn Key. However, you need to set the ...
Score best practice for inserting rows using a dataAdapter?
Rich - 12 Sep 2006 6:52 PM - 9 messages
Hello, I want to use a dataAdapter to insert rows into a table on a sql server DB.  I understand that the DataAdapter will automatically handle concurrency issues.  So first I have to get a table to insert a row into.  I have been ...
Score Data View Thread Safety Problem
Shaeney - 12 Sep 2006 1:30 PM - 10 messages
I have a multi-threaded application with a static constructor and static DataSet and DataView variables, populated in the constructor. i then create many threads to access the static DataView but some of the threads generate errors while others work. Here is the code for the sample ...
Score Write DataSet as XMLDataDocument without Expression entries?
AxelHecker - 12 Sep 2006 12:09 PM - 1 message
Hi! I use an ADO DataSet with DataTables having lots of columns using expressions (mainly for the purpose of making visible Master entries in Detail tables). The DataSet is linked to an XMLDataDocument in order to write the current data to XML. I observed that entries in columns using expressions are also ...
Score Object ref. not set to an instance of an object
cu.4m.srinivas@gmail.com - 12 Sep 2006 3:53 AM - 2 messages
hi, My pgm flow as like this: parent() {        a();        b();          .          . } a()                               b() ...
Score Have you used Microsoft's ADO.NET DataAdapter Builder?
evint - 11 Sep 2006 7:38 PM - 2 messages
Has anyone tried using Microsoft's ADO.NET DataAdapter Builder? This tool is included on the companion CD to the book Microsoft ADO.NET Core Reference (Microsoft Press, David Sceppa, ISBN 0-7356-1423-7). I used it to generate the DataAdapter code for my app but I am not sure ...
Score Oracle Adapter scale error
Oldman - 11 Sep 2006 7:00 PM - 4 messages
I am using the Oracle Data adapter and calling a stored procedure that does a select of a table and returns it. I get this error: Decimal's scale value must be between 0 and 28, inclusive. Is this a limitation of the adapter? ...
Score Newbie
Austin Phillips - 11 Sep 2006 6:28 PM - 3 messages
Hello; I am *very* new to website programming. I come from a client/server background.(Sybase Powerbuilder). I have been assigned a task of moving our client/server applications to the web. My question is this and please excuse any ignorancy on my part: ...
Score Need to upgrade users from access db to SQL Server db through code...
0to60 - 11 Sep 2006 6:13 PM - 2 messages
I want to roll out an update that will update my users databases from Access to SQL Server.  Now, I have the scripts all written that will create all my tables and relationships and such, but I need to copy the data over.  What ...
Score Is it really wise to use strongly-typed datasets?
Earl - 11 Sep 2006 4:48 PM - 8 messages
I've been mulling this question since I started using .Net in 2003. Seems like a lot of effort to rearrange code to get the data layer out of the UI layer. It seems like a nice quick-and-dirty solution, but long term, is it ...
Score dbType.Binary and limit of 0-8000 bytes
Chukkalove - 11 Sep 2006 4:31 PM - 4 messages
Can someone explain the following to me please, from the help files. I can't understand what it means DbType.Binary Supported by the .NET Compact Framework. A variable-length stream of binary data ranging between 1 and 8,000 bytes. ...
Score OleCMD - dont prompt option ignored
GS - 11 Sep 2006 4:18 PM - 1 message
why am I getting saveas dialog prompt from the following code    Dim doOpt As SHDocVw.OLECMDEXECOPT         doOpt = SHDocVw.OLECMDEXECOPT.OLECMDEXECOPT_DONTPROMPTUSER '<<< is this is the one to suppress prompt? ...
Score Dataset.ReadXml: M/c hangs when trying to read 37mb xml string.
Savvy - 11 Sep 2006 9:46 AM - 6 messages
Hi All, I am trying to read a 37 mb xml from a url into a stream and then store it in a string variable "_xml". When I try to pass this string as a StringReader object to the ReadXml method, my m/c hangs and I have to kill the process. ...
Score OOP - Confusion
PenguinPig - 11 Sep 2006 3:18 AM - 2 messages
Dear Experts I am confused in the OOP design For my concept, I will using 3 class for each business domain 1. DomainClass - Domain information, for example, Exhibitor 2. ControllerClass - Business Logic, for example, Exhibitor.Register(RegistrationForm) However, if I have 20 domains, then I need 20 DomainClass, and 20 ...
Next »