How may I use the IN operator when using a RowFilter on a DataView?
(2 messages)
Date: Tue, 10 Jul 2007 10:02:03 -0700
How may I use the IN operator when using a RowFilter on a DataView? -
Such that I can query whether a value is in a column from the Table
associated with the DataView.
Suppose I have the following table
myTable ...
|
Why double escape for apostrophe?
(5 messages)
Date: Tue, 10 Jul 2007 12:33:28 -0400
Anyone know why the RowFilter has to be double-escaped? Anticipating names
with apostrophes, a single escape does not provide the proper name to filter
on.
For example, this would cause an exception:
Dim strname As String
strname ...
|
Writing to Excel File via OleDB
(3 messages)
Date: Tue, 10 Jul 2007 16:57:54 +0200
Hello.
I'm trying to write to an Excel file via an OleDbConnection. It always fails
with the error "Operation must use an updateable query".
The Excel file is not read-only and the process has enough rights to write
data ...
|
Asyc reader in .NET 2
(3 messages)
Date: Tue, 10 Jul 2007 08:49:37 -0400
Is it possible to process data as it is pulled back in asyc mode? I want to
process records as they come back from the SQL Server basically and convert
them to local objects... which right now takes a lot of time doing it ...
|
Update fails with Primary Key Violation
(2 messages)
Date: Tue, 10 Jul 2007 11:17:32 -0000
Hi,
i'm copying a table from one SQL server to another. here i'm just
selecting all rows from source table and selecting 0 row from dest
table just to create the commands for insert/update/delete etc...now
problem is when ...
|
UpdateCommand
(1 messages)
Date: Tue, 10 Jul 2007 03:38:06 -0700
Hi.
In a WinForms App, I have a DataGridView. My SELECT command uses data from
Table A in a SQL Server database plus 4 calculated columns using data from
tables TableB and TableC. This works OK. The calculated values ...
|
Kailua ver 1.0.2 released
(1 messages)
Date: Mon, 9 Jul 2007 17:38:01 -0700
Our open source project that provides the "forgetten API" for ADO.NET -
http://www.windwardreports.com/open_source.htm
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www ...
|
What are Table Adapter and Data Adapter?
(3 messages)
Date: Mon, 9 Jul 2007 16:04:00 -0700
Does Table Adapter contain Data Adapter or the other way around? It seems
that Table Adapter exists in VS2005 but not VS2003. ...
|
TdsParser failures
(4 messages)
Date: Mon, 09 Jul 2007 13:11:14 -0700
I have written a multi threaded Windows service in c#, .net 2.0. The
application sends data to a database using stored procedures. The
application works fine on a LAN, but I cannot stabilize it over our
WAN links. The WAN ...
|
Doubleclick with dragdrop
(2 messages)
Date: Mon, 09 Jul 2007 20:03:46 -0000
Hello all:
I hope I'm simply missing something obvious...
I have a windows form, on which is a list box and a text box. I have
the MouseDown event of the ListBox coded to initiate a drag-and-drop
operation:
Me.DoDragDrop(ListBox ...
|
|
Return data to listbox
(3 messages)
Date: Mon, 09 Jul 2007 11:47:20 -0700
Simple question for you all. I'm new to ADO.net and i'm trying to run
a querry on a SQL 2000 database and return all the rows found to a
listbox.
Below the code i have returns one item to the listbox and if i run my
querry ...
|
Copy Entity Based on DataTable?
(3 messages)
Date: Mon, 09 Jul 2007 11:51:50 -0400
I have some complex objects that inherit from DataTable. I want to
copy the actual data along with the custom properties and etc, so I
don't think I can use the .Copy() method in DataTable. Do I need to
override it in some ...
|
More than one Data reader in a single connection
(3 messages)
Date: Sat, 7 Jul 2007 09:42:01 -0700
Hi All,
Is it possible to have more than one data reader in a single connection
(MSDN documentation dated July 2002 says that to have more than one data
reader, there should be more than one connection, one for each data ...
|
Need help with SYNTAX Error
(6 messages)
Date: Fri, 6 Jul 2007 22:28:28 -0600
I'm getting a SYNTAX error in this statement:
INSERT INTO Usenet (MessageID,Subject,ArticleDate,From,Lines) VALUES (
'<131prkkuk51ed5@news.supernews.com>',
'TG FM - The Eternal Candle - "eternalcandle_v.1.1.zip" 22716KB ...
|
Distributing the database mdf file.
(1 messages)
Date: Fri, 6 Jul 2007 13:30:00 -0700
Hi,
I would like to ask how you solve the problem with the database file
distribution, if the customer has installed the SQL Server (Express) with the
different collation than it is used in your database file.
Is it ...
|
Transaction Scope and DTC Needs?
(4 messages)
Date: Fri, 06 Jul 2007 15:44:33 -0400
I am trying to use a lightweight transaction to encapsulate multiple
sqlcommands on a connection (they update different databases in the
same named sqlserver instance) so if one update fails they will all
roll back ...
|
Data Table Row (.net 2)
(2 messages)
Date: Fri, 6 Jul 2007 09:28:00 -0700
If I have a typed data set with columns ColumnA and ColumnB (both strings) in
a table, I was thinking that I could do something like this
Partial Public Class TheTDS
....
Partial Public Class TheDataTableRow
...
|
datagrid to display bcp file
(1 messages)
Date: Fri, 6 Jul 2007 10:48:05 -0500
is there a class/control to display a SQL Server bcp file in datagrid. given
the dataformat file. or i have to do it programatically
Any alternatives for faster implementation?
TIA
...
|
Randomly get timeout on SqlClient hitting localhost
(12 messages)
Date: Thu, 5 Jul 2007 22:38:00 -0700
Hi;
I get this error randomly on both my home and work computer. I'm hitting Sql
Server 2000 dev version on localhost. This happens on both my home and work
computer.
Here's the exception:
System.Data.SqlClient.SqlException ...
|
Transaction appears to be timing out
(1 messages)
Date: Thu, 05 Jul 2007 19:09:04 -0700
Okay, so I'm using table adapters to update my database. I have about
20+ tables that get updated in a single transaction. Here is
essentially how it is setup:
MyDataSet dsChanges = _theDataSet.GetChanges() as MyDataSet;
Transaction ...
|
