Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score ODBC.NET
David Thielen - 7 Oct 2006 10:16 PM - 12 messages
Hi; I've looked and can't find this but I am guessing I just missed it somehow. Using an ODBC.NET connection how can I: 1) Get a list of all tables in that database? 2) Get a list of all views in that database? ...
Score SqlBulCopy and sql server 2005 crash
Bart - 7 Oct 2006 11:53 AM - 7 messages
Hi, when I use the sqlbulkcopy.writetoserver the sql server crashed. sql server 2005 sp1 is installed. any idea? Thanks Bart ...
Score Bitwise comparison in RowFilter expressions
Mark Rae - 7 Oct 2006 11:51 AM - 3 messages
Hi, This isn't *specifically* an ASP.NET question, so I've also posted it in the ADO.NET group - however, it's not too far off-topic... Imagine a SQL Server 2005 database with a table with an int column used for ...
Score "Error 1 Invalid Resx file"
PJ6 - 6 Oct 2006 9:48 PM - 1 message
Whenever I change something in a DataViewgrid that triggers the WinForms designer to recreate Form code, I get these errors: Error 1 Invalid Resx file. Could not load type TestApp.MainDataSet, TestApp, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null which is used in the ...
Score AcceptChangesDuringUpdate Too Literal?
jlspublic - 6 Oct 2006 5:34 PM - 2 messages
I am attempting to update two database tables from a single DataTable using DataAdapters.  I set the AcceptChangesDuringUpdate property to "False" on the DataAdapter used to update the first table but it doesn't work quite the way I'd hoped.  As expected, any rows which are ...
Score Very strange error in ASP.NET 2.0
Hardy Wang - 6 Oct 2006 2:28 PM - 6 messages
Hi all, I am migrating an old web application developed in .Net 1.1 to .Net 2.0. During my new development and testing, I had following error while executing an stored procedure. It worked fine in .Net 1.1, and it doesn't happen all ...
Score Synchronizing databases
chad - 6 Oct 2006 2:23 PM - 2 messages
Hi Everyone, I'm experimenting with a vb.net 2.0 win application that is connected to a large database (mysql, +-45000 rows). The app has to import/synchronize changed rows from a 2nd smaller database which has the same table ...
Score ASP.NET Using Atlas
vikram.lakhotia@gmail.com - 6 Oct 2006 9:33 AM - 3 messages
Hi Here are some blog on how to use Atlas controls [link] Hope this helps Thanks Vikram [link] ...
Score How to query a linked server
Romano - 5 Oct 2006 9:58 PM - 2 messages
I have an existing Linked Server on SQL Server 2005 where the Provider is "OLE DB Provider for Microsoft Directory Services". I need to query this provider from a C# application and store the results in a dataset.  The closest information I could find is ...
Score CompareAllSearchableValues creates an update state too long for Access
sprockett - 5 Oct 2006 9:07 PM - 2 messages
My access table has over 100 columns.  When I use the CommandBuilder to create my update statement with this option I can see that it is creating three criteria per field in the WHERE clause. example: AND ((? = 1 AND `WellConfig` IS NULL) OR (`WellConfig` = ?)) ...
Score Typed datasets in the business layer
pabloch2 - 5 Oct 2006 1:55 PM - 3 messages
Why the data access layer should use untyped datasets? and Why the business layer should use strongly typed datasets? Is this applicable to the 3 layered architecture in general or is it related with the implementation in .net? Can someone recommend me a good book to learn in depth the 3 layered ...
Score Any way to force an update after DBConcurrencyException thrown?
mracuraintegra - 5 Oct 2006 1:16 PM - 7 messages
I've tried everything I can think of, but I'm still struggling with a solution to force an update to a table, even if a DBConcurrencyException is thrown in my application. Is there any tried-and-true solution to allow an Update to occur, even if the ...
Score 3 different sqldatasource insert queries in 1 transaction...?
Jan - 5 Oct 2006 11:54 AM - 2 messages
Hi , In the asp.net application I am working on we use 3 different sqldatasource objects with each a insert command in it. I call:   sqldatasource1.Insert();   sqldatasource2.Insert();   sqldatasource3.Insert(); what i want is wrap these three inserts in 1 transaction. ...
Score SqlDataReader.GetSchemaTable returns too many columns
John - 5 Oct 2006 6:07 AM - 7 messages
I've run into a problem I can't seem to explain or work around.  I'm calling SqlDataReader.GetSchemaTable() on a database view (SQL Server 2005).  It is returning rows not only for the columns in the view, but also for another ...
Score Formatting error in posted messages - arrows and quotes
LouArnold - 5 Oct 2006 1:50 AM - 1 message
In the absence of a place to post these comments, I opted to post it here. Messages in posts have their double quote and right-arrow characters replaced by ampersand and other keywords. A message appears normally at first but on subsequent displayes, the text has embedded codes. ...
Score Updating sql05 with Stored Procedure
Chuck P - 4 Oct 2006 10:04 PM - 12 messages
I have a typical windows forms application that uses a DataGridView, a dataset, a bindingsource, and a TableAdapter. If I modify one row in the datagridview everything works fine. If I modify more than one row only the first modified row gets ...
Score quickly transferring data from a DbDataAdapter to TableAdapter?
chirag - 4 Oct 2006 7:17 PM - 3 messages
Basically, I have the following code which fills up a DbDataAdapter (which is of DataAdatper  type). Is there a quick way to map the columns and transfer the data in this adapter to a new TableAdapter ? This new TableAdapter will be linked to a SQL database. ...
Score Merge PreserveChanges = False not working -- need help
Liam - 4 Oct 2006 7:03 PM - 2 messages
I have been chasing my tail and need some help from someone who has succeeded in real-world-handling (i.e. not merely detecting) a concurrency violation in ADO.NET with SQL Server back-end. My data layer class invokes the DataAdapter.Update method and traps ...
Score Fill method ignoring CommandTimeout value
eric.burgin - 4 Oct 2006 6:39 PM - 4 messages
Under the .NET framework 2.0.50727.42, we are encountering a problem with timeouts while performing a query using a SQL TableAdapter. Whatever we set the timeout to gets ignored if we call the Fill method overload that takes a DataTable (or DataSet) only as a parameter.  No ...
Score Using a message queue as a buffer
Massimo - 4 Oct 2006 6:06 PM - 7 messages
I'm developing a server application which will, basically, receive data from some TCP/IP clients and store them into a database; it's being developed using .NET 2.0/C#. The size of each data packet will be small (a few bytes), but the ...
Score logging driver for ADO.Net?
Michael Burstin - 4 Oct 2006 6:06 PM - 8 messages
I was wondering if anyone knew of a logging driver for ADO.Net.  In Java/JDBC, there are a few projects that are essentially driver "shims" that get configured as a JDBC Driver which a program will use, that in ...
Score Identity Column & Dataset relation
G Hustis - 4 Oct 2006 3:23 PM - 6 messages
Using SQL server2000 VB.Net. I have a parent table that uses an identity column as its primary key. I also have a child table that uses the identity to create the relation between the parent & child rows. My form has a grid ...
Score dbdirect methods with timestamp columns
T Ray Humphrey - 4 Oct 2006 11:41 AM - 3 messages
I inherited a SQL database for which I am building a .NET C# web front-end. The tables have a Timestamp column, called "ts", that I thought I might as well use for optimistic concurrency. I'm going VS 2005 all the way, so I have TableAdapter as my DAL that ...
Score dataset record locking
hharry - 3 Oct 2006 9:47 PM - 1 message
hello all, I have a webservice which writes requests to a requests log table in sql server I have a windows service with a function that kicks-off every 30 seconds to process the records in the requests log table. ...
Score TableAdapters are a joke.
Earl - 3 Oct 2006 9:36 PM - 5 messages
I have just flat given up on TableAdapters. What a joke. I'm not even going to detail all the nonsense I've gone through trying to get these godforsaken "features" to work properly. The concept was good but usability is worse ...
Score How to change the column type?
ad - 3 Oct 2006 8:24 PM - 5 messages
I have a DataTable. How can I change the the type of one column from bool to int ? ...
Score ¦p¦ó±NXP ­ìª©¥úºÐ¤É¯Å¨ìSP2
ad - 3 Oct 2006 8:19 PM - 1 message
¤p§Ì®Ú¾Ú[link] §ÚXP ªº¦w¸Ëµ{¦¡§ó·s¨ìSP2¤F ...
Score Q: Advice on Client/Server app.
Martin Arvidsson - 3 Oct 2006 6:51 PM - 1 message
Hi! Im developing my first client/server application. So ofcourse i got a cople of questions for you gurus out there ;) Created a simple order/detail, with fields and a datagrid, works excelent. Now, in a walkthru i read in the helpfile it updates the grid in three ...
Score ADO.NET the fastest? My foot!
Rex the Strange - 3 Oct 2006 4:55 PM - 18 messages
I just benchmarked a query against an Oracle database using three different access techniques (OLDDB, ADO.NET and ODBC) and I found that ADO.NET fared worse than all of them - almost twice as long as OLEDB! Surely something is wrong here. I was under the impression that ADO.NET ...
Score using DetailsView control, update works, insert fails
oaksong - 3 Oct 2006 2:57 PM - 3 messages
Here are the commands in the sqlDataSource line. InsertCommand="INSERT INTO T_ADMIN_LOGIN (ALID, LNAME, FNAME, USERID, DOMAIN, STATUS) VALUES (S_ADMIN_LOGIN.NEXTVAL, :Lname, :Fname, :Userid, 'AAC', 1)" UpdateCommand='UPDATE T_ADMIN_LOGIN SET LNAME = :Lname, FNAME = :Fname, USERID = :Userid, STATUS = :Status where alid=:alid'> ...
Score Process slows when do Re-Query of Database
Joe - 3 Oct 2006 2:35 PM - 1 message
Hi I am taking a db creating a dataset then  reading some textfiles for changes to insert into the database After I process a file I requery (I call FillDS) the database to update my dataset to get the new inserted records into my dataset ...
Score Ado.Net and Unicode (N')
Jarle NygÃ¥rd - 3 Oct 2006 11:21 AM - 5 messages
So, we're converting a large ASP.Net application from ASCII only to Unicode. The only issue we've run into, on SQL Server, is the N prefix for literals. We create all our Sql statements dynamically, and most of the time we do not ...
Score CommandBuilder ConflictOption fallback
Thomas Weingartner - 3 Oct 2006 8:20 AM - 2 messages
I've already read the post about "CommandBuilder ConflictOption usage" [link] Because this option is new, I tried out some of the options: ...
Score Creating a datatable on a SQL server from a dataset
Yellow Dog - 3 Oct 2006 4:46 AM - 3 messages
This is probably covered somewhere, but I am having a total brain cramp. I have a DataSet that gets loaded from an XML file. I want to do some processing on it and then save it to a SQL Server data table. I am ...
Score Help: DataGridView Invalid data DataError Problem
LouArnold - 3 Oct 2006 1:35 AM - 1 message
I have two tables feeding through one dataset: A main table with a foreign key into a lookup table. Primary keys in both tables are defined as INTEGER UNSIGNED NOT NULL. The foreign key in the main tables is defined as INTEGER ...
Score DataGrid - Array List - Ordering Columns
Doug - 2 Oct 2006 11:40 PM - 5 messages
Hi, I am using a datagrid in a windows app and binding it to an ArrayList. The columns in the array list were appearing out of order so I fixed that by using the DataGridColumnStyle object in the DataGrid and ...
Score ?fill dataTable created at design time with dataAdpter at runtime
Rich - 2 Oct 2006 11:33 PM - 10 messages
Hello, I created a dataset and dataTable in the designer (VB2005) as the datasource for a Reportviewer control.  Up to now I have been creating dataTables/datasets/dataAdapters on the fly at runtime.  But I need to set ...
Score Q: Creating a head / detail view, not uppdating correctly?
Martin Arvidsson - 2 Oct 2006 10:02 PM - 1 message
Hi! I am doing my first tries to create a order / detail view. I have created two tables in SQL, set relation from the details table to the head table. In Studio 2005 i use the DataSet wizard to create connection, creating the ...
Score Multidimension string into DataTable
tshad - 2 Oct 2006 7:57 PM - 1 message
Is there an easy way to move a Multidimension string array (string [][]) into a DataTable? I tried: ru.employerList is a string[][]. DataTable testTable; testTable = ArrayToDataTable(ru.employerList); This gives me an error: The name 'ArrayToDataTable' does not exist in the class or namespace ...
Score Working with table adapters and multiple fills
Earl - 2 Oct 2006 6:41 PM - 1 message
Having done all this untyped and with a lot of typing in the past, I'm trying to make efficient use of table adapters instead of data adapters. I understand that it's just a wrapper. But what I don't understand is how ...
Score da.update and Bool --> yes/no type
Stephen Plotnick - 2 Oct 2006 4:50 PM - 3 messages
In a data grid using Access as the data source.. The da.update is failing with "object reference not set to an instance of anobject" It looks like everything is ok and I was wondering if there is a problem ...
Score dataview relations
sebastian gereck - 2 Oct 2006 7:42 AM - 2 messages
hallo i try to fill 3 grids with relational data. customer -> orders -> orderdetail dvcustomer   = dvm.createdataview( ds.tables["customer"]);//dvm->dataviewmanager dvorders     = dvm.createdataview( ds.tables["orders"]); dvorderdetail= dvm.createdataview( ds.tables["orderdetail"]); ...
Score rowfilter date formats
Al Christoph - 1 Oct 2006 8:31 PM - 10 messages
Forgive me if this is not the right place to post this. I've already had it booted from the vb.database forum. ------------------------------ I'm thoroughly confused. The following expression works fine as a table view rowfilter when locale is ...
Score A connection pooling error has occurred
SalamElias - 1 Oct 2006 6:29 PM - 6 messages
I am trying to clean an object in its Finalize method regarrding connection pbjects as follows :                 objConnection.Dispose()                 objConnection = Nothing ...
Score Storing data from multiple clients
Massimo - 1 Oct 2006 4:00 PM - 10 messages
Hi to all. I'm developing a network server application which will be constantly receiving data from mobile GPRS clients and storing them in a centralized database (probably SQL Server or Oracle); from the server's point of view, the clients will just be standard TCP/IP clients, sending data using a ...
Score Marginalizing parameter
pamelafluente - 1 Oct 2006 8:14 AM - 3 messages
In case I had a parametric query SELECT Name, Phone from MyFriends WHERE MyFriends.city = @CITY is it possible to specify a string value for @CITY in order to have the query to behave exacly like : SELECT Name, Phone from MyFriends      ?? ...
Score Subselect, TableAdapter and MS-Access
herbert - 1 Oct 2006 6:53 AM - 2 messages
1) I generated a Subselect query in MS-Access which works fine there: SELECT (SELECT Name FROM Players WHERE Players.PlayerID = PlannedGames.PlayerID) AS PlayerName, (SELECT Surname FROM Players WHERE Players.PlayerID = PlannedGames.PlayerID) AS PlayerSurname, * FROM PlannedGames This Subselect is recommended in Scott Mitchel's excellent MSDN Article ...
Score Timeout expired connection
SalamElias - 1 Oct 2006 6:45 AM - 3 messages
Ihave an application (.Net 1.1, wi2k3 SP1, SQL 2005) that works fine after severalminutes of browsing then I start to get the following error : Servor Error in '/myVirtualServer' Timeout expired. The timeout period elapsed prior to obtaining a connection ...
Next »