Exception at SqlCommand.Connection.Open() in nested TransactionScope
(1 messages)
Date: Fri, 13 Jul 2007 17:00:49 +0800
Hi,
I have a VB class to update a MS SQL server according to different incoming
parameters in .Net 2.0. However, I keep getting the error message
"Communication with the underlying transaction manager has failed." when ...
|
Copying Rows from a DataSet
(6 messages)
Date: Thu, 12 Jul 2007 17:29:55 -0400
Is there an easy way to copy rows from one data set to another other than
field by field copy?
Thanks
Brad
...
|
DataSet.ReadXml and "Input string was not in a correct format."
(1 messages)
Date: Thu, 12 Jul 2007 09:22:01 -0700
Hi
I have a strongly typed dataset which I am trying to populate with data from
an XML document. I am getting the error:
Input string was not in a correct format.
The problem is that one of the columns in one ...
|
Collections, databinding, column name
(1 messages)
Date: Thu, 12 Jul 2007 07:13:00 -0700
There seems to be an infinite way to create a business object in which
a .NET control can bind to: Strings(), Arraylist, datasets, a vast
collection library...
But none of them that I create seem to show the .NET control ...
|
TableAdapter Wizard Unique Keys Not Created Automatically
(1 messages)
Date: Thu, 12 Jul 2007 06:12:00 -0700
Hi,
I have a table in SQL Server 2005 that has a unique key on two columns.
When I run the TableAdapter wizard and create a corresponding tableadapter
for the table the unique key constraint is not created. I have to ...
|
How to make Raiserror report to ado.net
(3 messages)
Date: Thu, 12 Jul 2007 06:10:44 -0700
Hi group,
I have put some validation logic in a trigger and when it doesn't
validate I do a rollback + raiserror.
So for so good but how do I detect this in ADO.NET ?
Is there a way to use raiserror or some othe mechanism ...
|
SQL JOIN between DataTables in a DataSet
(5 messages)
Date: Thu, 12 Jul 2007 01:30:00 -0700
Hello,
Am I correct in thinking that it is currently not possible to perform an SQL
JOIN across multiple DataTables in a DataSet in .NET? I have a typed DataSet
with three relational tables which need to be placed into ...
|
How to put ' and " into sql
(1 messages)
Date: Thu, 12 Jul 2007 09:41:49 +0200
I need to put " and ' into sql server database.
I write:
string SQL = "INSERT INTO SomeTable (Email, Message) VALUES (' +
txtName.Text + "','" + txtMessage.text +')";
What if someone enters character ' in text box? Than ...
|
How write SQL's "ISNULL(ThemeRank, 255)" instead in ADO.NET when sorting DataView?
(2 messages)
Date: Wed, 11 Jul 2007 19:58:03 -0600
In SQL, I can write:
SELECT *
FROM Product
ORDER BY ISNULL(ProductRank,255)
To return:
Alpha 1
Delta 2
Golf 3
Foxtrot 4
Charlie 5
Echo NULL
Bravo NULL
But how can I ...
|
tableadapter update - existing primary key
(4 messages)
Date: Wed, 11 Jul 2007 14:30:33 -0700
I have two seperate .net programs that are working with the same table
in a SQL database. Both programs are using TableAdapters to read/
write to the table. Both programs can create a record in their
TableAdapters using ...
|
|
How sort DataView so blanks are at bottom, not top?
(2 messages)
Date: Wed, 11 Jul 2007 14:04:51 -0600
I have a DataTable with column "Sequence". Values are like:
Sequence
--------
5
1
3
(blank/null)
7
6
(blank/null)
4
When I create a DataView and do a sort, I get
Sequence
--------
(blank/null)
(blank/null ...
|
Question about automatic connection string settings using VS2005
(3 messages)
Date: Wed, 11 Jul 2007 10:02:01 -0700
I feel like I'm forgetting something. Assume Visual Studio 2005 (VB) and
assume you have created a data source and dataset by the usual means.
Assume multiple tables.
Now you have a designer.vb module associated ...
|
sqltransaction timeout
(2 messages)
Date: Wed, 11 Jul 2007 16:10:48 -0000
Hello,
I have a asp.net application in which users can create content and
then save everything to a SQLServer2000 database.
When they hit the save button on the form here is what I do :
Dim conn As SqlClient.SqlConnection ...
|
DataTable Performance
(1 messages)
Date: Wed, 11 Jul 2007 07:55:20 -0700
I'm interested in knowing the runtime complexity of the DataTable.Find
method in 2.0 when attempting to find a row by the primary key. The
MSDN documentation is vague...probably intentionally. I used .NET
Reflector to examine ...
|
Access to tables in dataset
(6 messages)
Date: Wed, 11 Jul 2007 13:17:27 +0100
Is it possible to treat the tables in the dataset the same as any other
tables, i.e. run queries on them, etc. ?
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ ...
|
value NOTHING can appear in the Object() array filled by the OleDBDataReader ?
(3 messages)
Date: Wed, 11 Jul 2007 02:06:48 -0700
I am using an OledbDataReader to read each record into an array of
objects, as usual.
My question is:
is it ever possible that one of the values contained in the array be
Nothing.
I have never seen ...
|
Problem adding table to DataSet
(2 messages)
Date: Wed, 11 Jul 2007 08:00:10 +0200
..NET 2.0
I'm working on .NET 2.0 project which contains a DataSet. On this DataSet I
can right click on the tables and select "preview data" and I can a preview
of table data - which to me shows that VS2005 somehow is ...
|
Iteration SLOW!!!
(8 messages)
Date: Wed, 11 Jul 2007 00:50:36 -0400
WTF did Microsoft do when it came to ADO.NET????????????????????????
Using an OLEDB connection and Dataset it took hours to iterate through 5000+
records in one simple table.
That is horrible. If I go into Access 2003 ...
|
How to solve these data access issues in VS2005?
(3 messages)
Date: Tue, 10 Jul 2007 16:00:00 -0700
1. Connection String needs to be customizable by users during runtime.
2. Source of Connection String can be changed programmatically.
3. Tables can be modified by users.
4. Use table adapters or use data adapters
5 ...
|
deploying from vs.net 2005 vc++.net on vista to sql2005 on w2k
(2 messages)
Date: Tue, 10 Jul 2007 12:48:03 -0700
Hi,
I am using VS2005, using c++ to build a CLR DLL as an extended stored
procedure for an SQL2005 instance.
My VS2005 is running on Vista.
I built a dll using clr and am tring to use the "deploy" feature from the
list ...
|
