Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign
paul tomlinson - 2 Apr 2005 7:55 PM - 2 messages
We've moved a database from one SQL server to another using a backup and restore, we had some problems because the location was slightly different when we moved the database, then we had to create all the users again. ...
Score ExecuteNonQuery returns ORA-01036 illegal variable name/number
Jim Brandley - 2 Apr 2005 5:43 PM - 7 messages
I have used ExecuteNonQuery with no trouble for inserts, updates and deletes. The best practices book I have says this is also the most efficient way to return multiple column values from a single row. The requested fields can be changed by users adding/removing fields from the form, so a stored ...
Score how to connect Access database
AbdSol - 2 Apr 2005 5:33 PM - 6 messages
I was using the following classes to get data from. Now I would like to know which class shall I use from  Windows Forms VC++ 2005. CDaoDatabase m_Dao;              // Variables in  String Table ...
Score Case-sensitivity in a stored procedure
Matthias S. - 2 Apr 2005 4:10 PM - 7 messages
Hi there! How can I toggle case-sensitivity within a stored procedure? I'd like to compare 2 passed in parameters against fields in a table. The first comparison is case-sensitive, the second is not. How can I do that? By default it seems they're not case-sensitive. ...
Score To Insert Multiple Rows in Oracle using oledbCommand
Mose Joseph via .NET 247 - 2 Apr 2005 5:36 AM - 1 message
I need to know how to Insert Multiple Rows in Oracle using oledbCommand -------------------------------- From: Mose Joseph ----------------------- Posted by a user from .NET 247 ([link]) <Id>wLuDr7c3DU+/lMo6w74RrQ==</Id> ...
Score (Q for David Sceppa!) Problems submitting hierarchical changes to DB
Eric - 2 Apr 2005 4:09 AM - 4 messages
Hello, On page 786 of the ADO.NET Core Reference (chapter 11 - Advanced Updating Scenarios),  David Sceppa gives the basic steps for submitting hierarchical changes (paraphrased): 1. Submit new master rows 2. Submit new detail rows 3. Submit modified master rows ...
Score Get the name of the primary key
Patrick B - 2 Apr 2005 4:03 AM - 3 messages
Working with a Microsoft Access database, what is the best way to get the name of the primary key field? I know the table name. ...
Score Parameter expected?
andrewbb - 1 Apr 2005 11:07 PM - 5 messages
It keeps saying the stored procedure expects the parameter '@entity' which was not suppplied, but I'm supplying it: OdbcConnection cn = new OdbcConnection(CNSTR); OdbcCommand cmd = new OdbcCommand("GetMyList", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@entity", OdbcType.VarChar, 4); ...
Score Generic error in GDI+
HarlanM - 1 Apr 2005 7:13 PM - 3 messages
I'm loading thousands of images into a SQL Server 2000 database. I have a ..NET windows application that I'm working on written in C# that retrieves the fileinfo of the directory and then loads all of the images into an image ...
Score Errors connecting with Microsoft.Jet.OLEDB.4.0
Javier Villarreal via .NET 247 - 1 Apr 2005 6:49 PM - 2 messages
Hi, I install Crystal Reports 8, and some  permissions for the registry subkeys and their lower-level subkeys are modified. I used a Crystal restoration utility, and everything come back fine again, all except for the OLEDB connections using Microsoft.Jet.OLEDB.4.0 ...
Score VB.Net Joining Paradox and SQL Server Table?
Roger - 1 Apr 2005 5:44 PM - 9 messages
Has anyone done this yet?  I know it is easily done in Paradox, but I would like to do it in VB.Net. Can anyone point me in the right direction? Thanks, Rog ...
Score dataadapter and component
Kurt Schroeder - 1 Apr 2005 5:33 PM - 4 messages
I'm creating a component that contains a function. This function is to return a data set of state values (AL,IL,TN,CA,...). I'm new to dataadapters this is my first, but something just doesn't seem right. ...
Score Filter Dataset
Steve Schroeder - 1 Apr 2005 4:48 PM - 5 messages
Correct me if I'm wrong, but once I have my data returned from a stored procedure, in a dataset and displayed in a DataGrid (ASP.Net)...I can filter the data correct, without making a return trip to the server? ...
Score No cursor when compared with ADO
Samuel1234 - 1 Apr 2005 4:33 PM - 3 messages
After a dataset has been populated, it no longer reflects changes in database. It is the shortcoming I found in ADO.NET. In ADO, we have dynamic recordset, keyset recordset which can reflect the changes to database done by other users immediately. Why can't I find these useful stuff in ADO.NET? ...
Score Memory leak in OleDbCommand.ExecuteNonQuery()?
Colin Sewell - 1 Apr 2005 3:55 PM - 11 messages
Maybe there's something I'm doing wrong here. I'm open to any suggestions. I'll see if I can explain this clearly... I have a C# application that runs 24x7 collecting data from some source and storing the data in a Microsoft Access database. The ...
Score SQLConnection connection pool issue
Rory Smith via .NET 247 - 1 Apr 2005 3:53 PM - 4 messages
I have a similar problem to several other people who have posted here - I can only open up to <Max Pool Size> connections.  After that I get a timeout expired exception. Looking at the open / pooled connections in perfmon (in both SQL Server stats, and the CLR runtime), there are never more than 5 / 6 connections open, but without fail, I cannot open more than <Max Pool Size> connections, even when I change this value or don't specify it. ...
Score XML Schema (XSD) and ADO.net DataSet - limitations mapping between them
David Laub - 1 Apr 2005 2:53 PM - 2 messages
The following valid XSD schema can NOT be successfully read by the ReadXMLSchema method of the DataSet object - it errors out with a "NonEmptyString not defined" error.  This schema is more complex than a plain vanilla schema, but doesn't strike me as obscenely complex. ...
Score Extracting enum from table
Morten Skov via .NET 247 - 1 Apr 2005 2:32 PM - 1 message
Hi, I'm reading the result of a query using MySqlDataReader. I'd like to extract information about the row datatypes that are returned. For example, myDataReader.GetFieldType(1).TosTring() will easily return values such as "System.UInt32" or "System.Byte". ...
Score Broken Web Links Within Microsoft Access
Corey Vlasak via DotNetMonster.com - 1 Apr 2005 1:14 PM - 2 messages
I have built a database in Microsoft Access 2003 that has a number of links that go out to the web. Does anyone know of a way I could set up my database to check which links are active and which ones are inactive? ...
Score Dataset: expression columns recalculation
Hugo Batista - 1 Apr 2005 9:58 AM - 3 messages
Hi there I'm having a typed dataset, where a datatable has some columns which are expressions. After doing a Merge, i was expected that my expression columns were calculated, but they were not. Although, if i do this foreach(System.Data.DataColumn column in dataset.myDataTable.Columns) ...
Score C# and ADO.Net - Cheap Question!
Matthias S. - 31 Mar 2005 11:25 PM - 9 messages
Hi, I'd like to INSERT a string into a database using C#. The way I've tried it is the following: sQuery = string.Format("INSERT INTO myTable (Header, Body) VALUES ('{0}','{1}')", sHeader, sBody); It works fine until I have an occurence of ' (an apostrophy) in either ...
Score Problem with RowChanged event and bindingcontext
Elias Fernandez - 31 Mar 2005 8:59 PM - 1 message
Hello all, I´m experiencing a problem ( maybe a bug ...), with the rowchanged event. When i change the position in a table after alter a field the datarowchanged event starts only if the navigation path of the databinding is not a ...
Score sqlcommand parameters with null
gv - 31 Mar 2005 8:36 PM - 3 messages
Is there an easier \ shorter way of doing this?         If txtreason.Text = "" Then             NoteCmd.Parameters.Add("@reason", SqlDbType.VarChar, 100).Value = vbNull ...
Score Strange slow down with imbricated DataReader (Oracle, c#)
Guy - 31 Mar 2005 8:20 PM - 3 messages
This is my first c# windows app. I create a data reader on an Oracle table. Returns 552 rows. I iterate thru them, goes like light speed. Next, for each row returned, I need to fetch from another table to get ...
Score first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
gv - 31 Mar 2005 8:11 PM - 1 message
Hi all, I thought I would help out on a Error that comes up for a lot of people when calling a stored procedure from your application using sqlcommand object and passing parameters. this error comes up in VB.NET ...
Score Architecture: One Producer, Many Consumers
Neil B - 31 Mar 2005 6:13 PM - 3 messages
Hi all, This sounded like a really easy R&D challenge but .NET is leaving me with too many options and I don't have six months to experiment and find the best one. Hence I would like to lean on this board's expertise. ...
Score Trouble with creating DataRelations - Need Help
Prasun - 31 Mar 2005 5:25 PM - 2 messages
I am building an App that takes an Excel file and populates 3 DataTable's in a Dataset.  I then was to create a relationship between these 3 DataTables. After dong so I want to run some code to process / modify the data in the ...
Score DataTable.Row[i].EndEdit()
Antonio Budano - 31 Mar 2005 5:24 PM - 2 messages
Hi, How can I know which row is currently being editing when I have some controls bound to a DataSet.DataTable in order to call the EndEdit method prior to update data to the database? Is there any CurrentRecord indexer? ...
Score Decimals truncated in dataset
robot7 - 31 Mar 2005 5:23 PM - 2 messages
I'm airly new to .net and I can't seem to figure out this problem, I hope you can help... I'm filling a dataset from an Access database with columns of type = Decimal. When I load a datagrid with the dataset, the numbers are truncated, ...
Score closing connection not by design
JiangZemin - 31 Mar 2005 2:26 PM - 4 messages
Hi, i wanted to get this groups opinions on a design issue ive run into: a programmer has coded a common data access class which is supposed to be inherited by all data access layers at my firm.  This class instantiates a ...
Score Vb.net ADO connecting SQL Server and Paradox table to create a query.
Roger - 31 Mar 2005 2:22 PM - 1 message
All, I want to run a query in my vb.net application that will join a table in Paradox and a SQL Server table? The paradox table will be dynamic, meaning based on user input I may point to different folders but same file to get data. ...
Score How does ADO.NET handle transactions when the connection is broken
Rob Thompson - 31 Mar 2005 9:36 AM - 2 messages
Hi, We are thinking of using ADO.NET to implement transactions on our SqlConnections, but would like to know how ADO.NET and SqlServer handle the situation when the connection gets broken. We have a client application in one location and a SqlServer DB in another ...
Score REGISTERED AND CRACKED CAD/CAM/CAE SOFTWARES 2005!
cadsoftwares@europe.com - 31 Mar 2005 7:55 AM - 1 message
Hello architectural, engineer and technical users! We can offer you new regi stered CAD/CAM/CAE softwares: Survey , GIS , Rock , Soil and Water, Industri al and Control Project, Mathematics , Statistics and Accounting, Engineering and Technical Standards and Databank Such as ISO , DIN , BSI ,ASME , ASTM a ...
Score Datatable.Select method - Difference Between %AE% and *AE*
Palani - 31 Mar 2005 7:12 AM - 2 messages
Hi, Keyvalue :AETHAE Keyvalue : AETH   The problem is that I am using the Datatable .select method and Filter expression is %AE%.This Pattern is searchs only mid string not with starting point. Output: AETHAE IF i use the *AE* , then searches from the starting point ...
Score How to synchronize Dataset to database
Arnab - 31 Mar 2005 6:59 AM - 3 messages
In our project we fetched data into dataset from the database. Now we are storing the data in a XML File from the dataset. The modified DataSet is kept in the XML File And dataset is closed. Later at the time of  saving we are building the dataset from the XML file ...
Score DataSet and Table join
dmsy - 30 Mar 2005 11:59 PM - 5 messages
Is there a way to join DataTables, kind of like how you do join in SQL? ...
Score Having problem with SQLConnection.ChangeDatabase() method.
Ken Varn - 30 Mar 2005 10:43 PM - 1 message
I have multiple databases in which I want to traverse.  Each database is secured using Applicaiton Roles.  I use the SQLConnection object to connect to the first database.  I run the sp_setapprole procedure and I can access ...
Score DataTable Select method
Mandar Patankar via .NET 247 - 30 Mar 2005 10:34 PM - 2 messages
I want to know what kind of queries can i execute on datatable select method. The one i am interested in is between query for eg:- this is my sample query Select max(resultan) from TblseasResult Where SeasId='15.3.13.3302005' And Countno between 4801 and 4806 ...
Score Problems inserting data into Access database
Roshawn Dawson - 30 Mar 2005 10:04 PM - 3 messages
Hi, I'm trying to insert new rows into a table in an Access database. Here's my code: Dim cn As OleDbConnection Private Sub Page_Load(ByVal sender As System.Object, ByVal e As   System.EventArgs) Handles MyBase.Load ...
Score Can't find stored procedure
tshad - 30 Mar 2005 9:46 PM - 10 messages
On Sql Server 2000, my program can't seem to find the Stored Procedure: AddNewResumeTemplate. The error it shows is: Could not find stored procedure 'AddNewResumeTemplate '1234',1001,'This is a test','This is our resume',5'. The problem is that it is there.  I even have Sql Profiler running which ...
Score using ReadXML with disparate XML data
Joe - 30 Mar 2005 7:13 PM - 3 messages
I want to load data from two related but different XML files into a two different DataTables in a single DataSet, then create relations, and finally filter and select specific data. I can't figure out how to load the two ...
Score A question about closing the SqlDataReader
M - 30 Mar 2005 6:54 PM - 7 messages
Hi all, I have code like: SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) {     // do something here } else {     reader.Close();        // this is the line I'm not sure about ...
Score List SQL Servers instaled on the system and the ODBC drivers
irimiabc - 30 Mar 2005 4:53 PM - 3 messages
Hi! I am trying to find a way for listing the SQL servers installed on a machine, for example MS SQL, Oracle, My SQL, Transact SQL. And also the ODBC drivers that exists on a system, including ODBC drivers for sql servers previosly listed,  and the ODBC drivers for flat files (for ...
Score Can I execute sql drop database cmd w/a SqlParameter
John Aldrin <> - 30 Mar 2005 4:36 PM - 3 messages
Hi, I'm wondering if it is possible to execute a sql command to drop a database with a SqlParameter containing the name of the db to drop. I've tried the following and I get an error SqlCommand dropDbSqlCmd = _masterDbConn.CreateCommand (); ...
Score Connecting to non SQL database
Jake - 30 Mar 2005 4:29 PM - 3 messages
When i try to connect to an old UniVerse database (using their ODBC drivers) visual studio (vc# standard) gives me an error saying something to the effect that this version can only connect to Access/SQL databases.  What version of ...
Score DataReader problem
David Young - 30 Mar 2005 2:38 PM - 5 messages
I hope someone can help.  I'm using a SqlDataReader to pull some data from a Sql 2000 database.  Most of the columns are varchar's of varing lengths and one of the columns is defined as a char(2).  Using the datareader I can get ...
Score Altering Access Database Using ADO.NET
Lee - 30 Mar 2005 2:33 PM - 3 messages
Hi Since the last version of my released software I've had to make some modifications to the back end Access database such as adding an extra field to a table and adding new queries. Does anyone know the easiest way to modify a tables structure and add ...
Score DataAdapter Query Access
Johny - 30 Mar 2005 2:15 PM - 4 messages
Hi people, i have a question about this: I need to know how can i obtain the sql queries (Insert, Update, Delete) that are executed by DataAdapter.Update on a DataSet. I know that i can see that queries on SQLProfiler but i want to obtain that sentences on my ...
Score how store the images in ORACLE database using asp.net
viji g via .NET 247 - 30 Mar 2005 9:51 AM - 1 message
(Type your message here) -------------------------------- From: viji g hi i need help .... how store the images in ORACLE database using asp.net pls give me resulet i m wating pls help me urgent ----------------------- Posted by a user from .NET 247 ([link]) ...
Score Replacing MSDE
Michael - 30 Mar 2005 8:34 AM - 4 messages
Hello, I have made a Windows Application in C#, with a database running under MSDE. The application is quite simple, and there is only 3 tables, and only one has maybe 200-250 records maximum (the 2 others have only 10-20 records). ...
Score Excel file permissions problem
Nikolay Petrov - 30 Mar 2005 7:09 AM - 2 messages
I have an Excel file, which I use to store some data. When reading from file, everiting is ok. When i try to insert some row, an OleDbExcetpion is thrown. I'va tracked it to a permission problem. The sheats of my Excel file as protected with password. ...
Score A simple insert problem
Dave Cooke via .NET 247 - 30 Mar 2005 6:52 AM - 3 messages
Hi all, I know I am going to kick myself but I have run into a bit of a brick wall and I need some help before I loose the rest of my hair. All I want to do is insert a new row of data into a access database from a vb.net app I'm writing. ...
Score Using Enterprise Library caching in Data Layer
Shaun - 30 Mar 2005 4:49 AM - 1 message
Can anyone point me in the direction of, or provide, some best practice (and poss examples) for using the Enterprise Library caching block within a COM+ Data Access Layer (which also uses the DA block)? I would like to cache data for a set period of time.  The data is returned ...
Score Simply adding a table
Thomas Krause - 30 Mar 2005 1:32 AM - 4 messages
What is the best way to add a new table to a database? If possible I don't want to use SQL, but ADO.Net directly. I'm a Ado-Newbie and tried the following: dataSet.Tables.Add("xyz"); adapter.Update(dataSet); ...
Score Handling paging in the UI without using datagrid/dataview
Hari - 30 Mar 2005 12:29 AM - 2 messages
Hi Please give me some inputs on the following : Iam planning to use a custom control to list a large number of records from sql database through ado.net.   so in the following code, if i give a select ...
Score Excel and ADO.NET
Prasun - 29 Mar 2005 11:52 PM - 6 messages
Hello: I am building an App that takes an Excel file and populates 3 DataTable's in a Dataset.  I then was to create a relationship between these 3 DataTables. After doing so I want to run some code to process / modify the data in the ...
Score Datagrid Navigate question
Chris Eisensmith - 29 Mar 2005 9:16 PM - 1 message
If a datatable, bound to a datagrid, has multiple child tables, is there any way to determine which relationship is being used to generate the child rows when the user navigates using one of the relationship links? Thanks. ...
Score ADO.Net DataSet to ADO Recordset
Ganesh - 29 Mar 2005 9:13 PM - 4 messages
I have two applications, one on ASP.Net and the other on ASP (both have different explicit databases). It so happens that the ASP application now wants to use the dataset created in ASP.Net for further information processing. How do i make this happen? ...
Score Messages in ADO.NET
Mike Caputo - 29 Mar 2005 9:03 PM - 4 messages
I would like to be able to execute a long-running stored procedure from a Windows Forms application.  The procedure loops through about 7,000 items, calling various other procedures along the way, and progress is displayed in SQL Query Analyzer using the Print command.  It appears that Print events are ...
Score return OleDbDataReader from static function
Sharon - 29 Mar 2005 8:28 PM - 18 messages
Hi all I want to return OleDbDataReader from a static function, So I will have DB interface for my Entire project, Is it possible? How do I close the connection ?????? Thank you Sharon ///////////////////////////////////////////////////////////// //Example of use  : ///////////////////////////////////////////////////////////// OleDbDataReader reader  = myDbObj.Select("SELECT CustomerID, ContactName, ...
Score How to override (null)?
Cezar - 29 Mar 2005 8:11 PM - 4 messages
Sorry, this can be trivial question, but somehow I cannot find the answer to it. When I bind a data grid to a table, then some cells show a text value "(null)". This is happening for fields that have a database null value. ...
Score ado.net create a table
viki - 29 Mar 2005 7:05 PM - 24 messages
Hi , I want to copy a dbf file to the the access database.I thought of two solutions 1. Copy the dbf to the access db by the query SELECT * into dest_table from [source.dbf] in 'source folder' this  does not work out, it gave me the error that u have no ...
Score LABEL ON not part of sql server?
Steve Richter - 29 Mar 2005 6:11 PM - 4 messages
in sql server, how do I specify the column heading of a column?  That is a column heading other than the column name. in the little sql I know, in the SQL on the IBM AS400, the following is ...
Score DataReader works even if the SQLServer is shutdown.
Nimmagadda Ramakrishna via .NET 247 - 29 Mar 2005 6:01 PM - 2 messages
Hi, I was thinking that the SQLDataReader should not work if there is no connection to the SQLServer. We experimented the scenario but looks like after we execute the ExecuteReader method, in the debub mode on VS.NET , we then shutdown the SQLServer 2000. Then we tried to iterate through the DataReader and what I expected was an exception. But what actually happened was that it gave me the results one after the other. Ideally the DataReader should read one row at a time from the stream that gets connected to the DB server and which should throw an exception if we shutdown the DB server right ? ...
Score Patterns and Practices - SQL Database Question
Mythran - 29 Mar 2005 4:53 PM - 5 messages
One of the major pitfalls of the new Patterns and Practices Enterprise Library, compared to the old version of the SQL Helper libraries, is that the code gets blown up.  Before, using the SQLHelper library, I could write code as follows, while the new library I must do stuff following the first ...
Score DataAdapter Update
J L - 29 Mar 2005 4:39 PM - 4 messages
If a DataAdapter.Update fails mid-way through the dataset, are earlier updates rolled back or how is this handled? For example, let's say I am a dummy and I create a dataset without setting a unique key constraint. Then I try to do an update on the ...
Score Filtering Dataviews
wjousts - 29 Mar 2005 4:21 PM - 5 messages
The DataView RowFilter property rather annoyingly doesn't allow for wildcards in the middle of strings. So, for example: col LIKE 'A*B' doesn't work, i.e. it doesn't return all rows where col starts with A and ...
Score Easy question, need help on how to find the position of a record
Michael Rodriguez - 29 Mar 2005 4:13 PM - 2 messages
I have a basic customer data entry screen where the sort order is customer name.  Given a customer's ID#, I need to find the position of that record in the list that is sorted by name, i.e. in the form's currency manager.  In ...
Score Bulk insert to sql server
Ran Davidovitz - 29 Mar 2005 2:39 PM - 3 messages
Hi. We have an object model that return a list of about 2500 lins and i want to add them to sql as fast as i. How can I do a bulk insert to sql Using ADO.net? Thanks ...
Score is it possible
João Santa Bárbara - 29 Mar 2005 2:36 PM - 2 messages
hi all is it possible to use 2 datareaders at the same time with the same connection ???? how ??? if not ? how can i do a clone from a connection ???? thks JSB ...
Score How can I do a comum DAL to access SQL, Oracle, Access, etc
Fernando Lopes - 29 Mar 2005 2:16 PM - 4 messages
Hi. I want to develop a class (my Data Access Layer) to access all database what am I want (like Oracle, SQL Server, Access, MySQL) Someone did anything like that? Or know how can I do that? I hear something about Pet Shop 3 model access each Oracle than Sql Server. ...
Score how is SQLConenction associated to a Database
Abhishek - 29 Mar 2005 1:39 PM - 2 messages
Hello When we open a connection using some connectionstring the connection is associated to a database which we specify in the ConnectionString. Now my question is 1) When i do a changedatabase does the connection object closes the connection to the server and opens the connection again for a new ...
Score Determining the Better Approach of Transaction in n-tier Application Model and where Transactions ar
msnews.microsoft.com - 29 Mar 2005 10:35 AM - 2 messages
Hello, I have the scenario. I m building an application either in asp.net or window application. This application is base on n-tier application model. Let us take example of Northwind Database in SQL SERVER. i build an asp.net page. On that page i place the grid with one template column. In that column i put HTML Table with two rows. In First row there are one combobox and two textboxes. In the second row there is another DataGrid means Inner DataGrid. I select the data from the database and bind it with page. the data is shown in my required formate. When i click on the edit button then that row comes into edit mode. At that time i insert some rows in ther inner datagrid and delete some rows and update some rows. Then i click on update button. At behind i design the 3-tier application model. Now i update my database. The changes i made must be in a transaction. ...
Score Excel ADO question
Nikolay Petrov - 29 Mar 2005 5:56 AM - 9 messages
I use Excel file as a data source for my Web Service. I want to know a few things. 1. When reading from the Excel file, does it remain locked for the time of reading the data? Must I implement some logic, to check if the file is ...
Score News: VistaDB 2.0.14 embedded database for .NET released
Anthony Carrabino - 29 Mar 2005 5:45 AM - 1 message
VistaDB 2.0.14 embedded database engine update for .NET has been released. Features better .NET Provider performance, new VistaDBDataSet component that provides live data cursors that are fully compatible with databound controls, world's first 3rd party managed Membership Provider for ASP.NET 2.0, improved ...
Score retrieving a large amount of data across the network from SQL2000
Randy Collins - 29 Mar 2005 2:49 AM - 4 messages
We need to retrieve approx 200,000 records containing about 100 megabytes of data across the network from a SQL 2000 DB server to a VB.NET app that then cursors through this data, does some processing and outputs it to several ...
Score Yukon UDT Help
Rod O. - 29 Mar 2005 1:40 AM - 5 messages
Hi all, What is the syntax for adding a UDT that has a namespace? When I try    CREATE ASEMBLY Foo FROM "C:\Foo.dll" WITH PERMISSION_SET=SAFE    CREATE TYPE Bar EXTERNAL NAME Foo.SomeSpace.Bar I receive the error ...
Score disconnected experiment
barret bonden - 29 Mar 2005 12:39 AM - 3 messages
I get An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll   Additional information: Format of the initialization string does not conform to specification starting at index 175. from this line:  cn.ConnectionString = bs listing (more or less out of  page 712, MS's "Programming VB.net") ...
Score Cascading updates not working
Dave - 29 Mar 2005 12:16 AM - 2 messages
I have been using this feature for a long time and it's worked like a champ, but I've come across a time when it doesn't seem to work. Typically (when it works) there is a parent table that has it's Primary ...
Score [ANN] March 29, 2005, "ADO.NET with Visual Basic .NET" chat
Jason Cooke [MSFT] - 29 Mar 2005 12:01 AM - 1 message
Every application uses data. Join members of the Visual Studio and SQL teams (Steve Lasker, Eric Gruber, Kris Langohr, Steve Stein, Riaz Khan, Eddie Goziker, and John Chen) for a discussion of the best approaches for working with data in your applications. ...
Score Updating a Dataset 2nd part: Accepted/Rejected rows ?
Abelardo Vacca - 28 Mar 2005 9:21 PM - 2 messages
Hello, This is the second part of my question. Forgive me if this post is too long but I like to formulate a complete question. I am currently building the DALC for our company application. When updating a Dataset I thought it could be interesting to keep track of the rows that ...
Score Announcement::DataAccess Web Log
Sushil Chordia - 28 Mar 2005 9:18 PM - 2 messages
Hi All, If you haven't noticed yet, the Microsoft-DataWorks team now has its own blog site at: [link] You may not recognize the team, since its an internal team in Microsoft. In a nutshell, we are ...
Score refresh schema in designer
norm - 28 Mar 2005 9:14 PM - 1 message
I create a dataadapter by dragging onto the design surface and create the dataset. If I make changes to the SQL table, how do I get the dataadapter to see the new table changes? Do I have to make the changes manually, or is there a ...
Score Updating a Dataset: How the Adapter works inside ?
Abelardo Vacca - 28 Mar 2005 8:49 PM - 13 messages
Hello, I am currently writing a DAL.  When calling the DataAdapter.Update function for a Dataset, does the DataAdapter calls DataSet.GetChanges() internally before looping through rows? Or should my DAL be responsible to call GetChanges before updating? Thank you ...
Score connecting to the server
jack cutler via .NET 247 - 28 Mar 2005 7:57 PM - 1 message
(Type your message here) this is the second time this happend. my pop3 server .and my smip is not responing.i get a message :time out has occured and nothing happens. -------------------------------- From: jack cutler ----------------------- Posted by a user from .NET 247 ([link]) ...
Score Copy a table between databases
Patrick B - 28 Mar 2005 7:40 PM - 2 messages
If you have a DataTable full of data, what's the easiest way to save the DataTable as a new table in a Microsoft Access database? This is a C# application. What the application needs to do is: 1) Run a select query on an Access database and fill a DataTable with ...
Score SQL Server and Split function
Indy - 28 Mar 2005 6:33 PM - 4 messages
I wish to create a procedue (in SQL Server) that takes one long string - i.e. 25 names that are separated with a '#'. In C# I use Split function to get 25 different strings from that one, but I don't know how to do it in SQL ...
Score Problem on sending Email through .Net exe or VB6 exe
Beve Lyni - 28 Mar 2005 3:31 PM - 4 messages
I am running on Windows 2000 Professional with SP4. I have my SMTP server started. Thank you in advance for your support. Try #1: The code in .Net as in the following         Imports System.Web.Mail ...
Score Problem executing long running query using ADO.Net and DB2
tukaram.thatikonda - 28 Mar 2005 3:02 PM - 5 messages
Hi Guys, I have written a small windows application in VB.Net to test ADO.Net performance while executing long running query. The query works most of the time but fails sometime. I am trying to connect DB2 using federated database. The query returns around 25K ...
Score Adding variable default values to new record in datagrid
Mike VaughanEdwards via .NET 247 - 28 Mar 2005 1:41 PM - 3 messages
I want to add contect-specific default field values when I create a new record in a data grid.   It will not always be the same value so I need to set it in code rather than in the database design but I can not find the right object/event that will let me do this? ...
Score ADO.NET Samples
Roshawn Dawson - 28 Mar 2005 11:30 AM - 3 messages
Hi, Can anyone give me some samples using ADO.NET with the Publishers database? Thanks Roshawn ...
Score paradox file problem!!
daniel - 28 Mar 2005 8:53 AM - 4 messages
i have a paradox db file. i want  import it to sql 2000 database,  but sql 2000 database  display error msssage. i try it success in win2003, but it fail in win2000 and winxp. my customer operation system verion  is  win2000. ...
Score Print Access report using ADO
Charlie Holmes - 27 Mar 2005 9:42 PM - 3 messages
Is it possible to preview or print a report in an Access 2000 database using ADO? Thanks, Charlie ...
Score No DataView column filtering: design weakness?
LarryF - 27 Mar 2005 5:41 PM - 4 messages
One purpose of the DataView is to allow the classes that manage the data to limit the data provided to the classes that consume the data. The DataView lets you filter by row, but not by column. My data layer ...
Score ADO.NET and Webservices
Himanshu - 27 Mar 2005 2:27 PM - 3 messages
Hello, I'm trying to build a webservices 'application' that basically allows any sort of client to plug-in and do do updates to the database through ADO.NET (ODBC) So generally like this, [ CLIENT APP ]  <------> [ WEB SERVICES ] <-----> [ ADO.NET ] ...
Score HOw to set the horizontal align of the fields of a DataGrid
ad - 27 Mar 2005 12:51 PM - 4 messages
I am using VS.NET. I want some fields align to left, and other fields aling to right. How can I set the it in DataGrid? ...
Score OleDbReader and select query problem
rob merritt - 27 Mar 2005 6:51 AM - 5 messages
I have a function that on page load iterate through a OleDbDataReader this works with a simple query like SELECT * FROM TeachingExp WHERE (TeachingExp.UserId_fk='" + Session["UserName"] + "')" but with a more complicated query SELECT * FROM TeachingExp, TeacherPrefs, SubExp, References, personalData, EduHistory, EduEquity, CriminalRecord, Comments, ...
Score DataReader - RowsAffected property
J L - 27 Mar 2005 5:37 AM - 12 messages
Why and how is this property used? Documentation says it is number of rows changed, inserted, deleted and can only be used after the DataReader is closed. I thought the DataReader was for forward read only access...so how can there be rows ...
Score Suppress finalize in dataset constructor???
Alvin Bruney [ASP.NET MVP] - 27 Mar 2005 2:39 AM - 25 messages
Does any body know or have a clue why the constructor of DataSet needs GC.SuppressFinalize(this) call ...
Next »