What are the pros and cons in using Enterprise Library?
(8 messages)
Date: Tue, 17 Jul 2007 12:24:10 -0700
I'm new to .net. It seems that those application blocks in Enterprise
Library are very useful especially when one tries to build a new application.
I want to know the pros and cons in using those blocks. Is MS going ...
|
NULL GUID fields in a Nested Query
(4 messages)
Date: Tue, 17 Jul 2007 07:58:12 -0700
Hi there,
Firstly, I hope this is in the right place!
I have a problem with a nested query I am generating at runtime.
My table (tblIndexValue) has values in every cell in all rows including the
createdUserID column ...
|
Flummoxed by Connection Problem
(2 messages)
Date: Tue, 17 Jul 2007 12:28:33 +0100
Everything was working fine until suddenly this problem appeared from
nowhere:
Boot up the pc and go into SQL Server Management Studio. The database is
present and the data can be accessed.
Go into VB2005 Express ...
|
Computed Field In Typed Dataset
(1 messages)
Date: Mon, 16 Jul 2007 13:16:06 -0700
I have a list box that is bound to an object data source. I added a column,
say ColumnC, to my typed data set (using the designer) and for the expression
property I entered
ColumnA + ': ' + ColumnB
When I preview ...
|
!VB.NET/Access: OleDbException (Data type mismatch in criteria expression)
(1 messages)
Date: Mon, 16 Jul 2007 20:35:46 +0100
Dear ADO.NET experts!
I hope someone can help me, as I've been tearing my hair out with this one
all day!
I'm getting very odd "Data type mismatch in criteria expression" errors that
I can absolutely not nail down or ...
|
Ado.net and SQl view ???
(2 messages)
Date: Mon, 16 Jul 2007 10:52:03 -0700
Dear all,
I would like to bind a datgrid control to an SQL view.
How set SQL command type for a view ? Is it Text ?
IN which form the sql view is returned, data set ?
When I get my view bind to my grid, if new data ...
|
Sending a set of data to a stored procedure
(4 messages)
Date: Mon, 16 Jul 2007 08:36:09 -0700
Hello
I need to write a stored procedure that executes a bunch of bulked and
related(stock) trades. For example, the customer may have requested four
trades to be placed. The trades are related because the money from ...
|
Syntax error in INSERT INTO statement. vb.net
(2 messages)
Date: Mon, 16 Jul 2007 10:56:58 -0400
I am using VB.net
The Error message is :Syntax error in INSERT INTO statement. vb.net
Could this be casused by my primary Key? if my primary key is "ID" and it is
(autonumber). I tried inseting a blank field, number in ...
|
How to insert data row and reading out the ID of the new dataset
(7 messages)
Date: Mon, 16 Jul 2007 04:57:15 -0700
Hello there,
what is the best way to add an dataset and, then, to read out the ID
value of the created dataset?
ExecuteNonQuery() does not retrieve informations about the new ID of
the dataset. Of course I can execute ...
|
System.Transactions.Diagnostics.DiagnosticTrace throws an exception of initialization
(2 messages)
Date: Mon, 16 Jul 2007 07:39:44 -0000
I use .Net 2.0 and connect to a database access, on the
connection.open() I've this message "The type initializer for
'System.Transactions.Diagnotics.DiagnosticTrace' threw an exception"
Code :
public DataSet ...
|
|
Sharing a DataSet among different Projects in a solution?
(1 messages)
Date: Sun, 15 Jul 2007 19:12:44 +0330
I have genearated a Typed DataSet in a C# project and am able to use it in
the from designer (I can drop a dataset Object from tool box and Set its
DataSetName Property this typed dataset very normally)
my Question is:
Can ...
|
From ADO.NET 1.1 to SQL 2005 and SQL 2008
(2 messages)
Date: Sun, 15 Jul 2007 08:12:00 -0700
Dear Sirs.
I have Client Server Application
on Client Side i have .NET 1.1 WinForm Application
on Server Side i have SQL Server 2000
I'm using "OLE DB PROVIDER FOR SQL SERVER" for the Data Access
1)
I'd ...
|
finding column/row that causes System.Number.FormatException
(1 messages)
Date: Sun, 15 Jul 2007 04:35:26 -0000
I'm reading in xml into a dataset. I'm having to mess around with the
types of the xsd as well, since there are many null values in the
data. The data is about 25% string, 10% int, the rest decimals.
When I read this data ...
|
Strongly Typed DataSets and "Refresh the data table" Option
(6 messages)
Date: Sat, 14 Jul 2007 22:57:09 -0400
Hi,
Using Visual Studio 2005 and SQL Server 2005:
I am trying to understand the stored procedures that Strongly Typed Datasets
wizard generates for me.
When we create a new strongly typed Datasets, and choose the ...
|
How save DataSet back to database?
(2 messages)
Date: Sat, 14 Jul 2007 15:24:14 -0600
In my client Windows application, I am receiving a DataSet containing one
DataTable. This comes to my client via the business tier on a different
physical machine (we're using WCF if that matters).
After I make changes ...
|
How best to automatically update
(1 messages)
Date: Sat, 14 Jul 2007 19:14:20 +0100
What is the best way to update a row in a DataGrid to the server database
automatically whenever a user edits and then steps off the row they have
been editing (rather like in Access). There doesn't seem to be an
explicit ...
|
HELP: CLR Trigger Fails when inside a user defined transaction!
(1 messages)
Date: Sat, 14 Jul 2007 15:49:01 +0330
when I use my C# Application to update My DB using a transation I get the
following Exception
The context transaction which was active before entering user defined
routine, trigger or aggregate "UpdateIntegrityCheck" ...
|
probleum in running asp
(3 messages)
Date: Fri, 13 Jul 2007 22:34:01 -0700
i am facing the probleum in running asp onmy machine. i am using window xp
2000 and also i have installed iis on my machine but the asp does't work
plese guide me how can i remove this probleum ...
|
Can ADO to leave remnant data behind?
(1 messages)
Date: Fri, 13 Jul 2007 18:56:53 -0500
I have encountered a situation where supposedly a function returning a
datatable does not always clear the datatable before loading. This is
according to a client, but I have not been able to verify that this is
indeed ...
|
EnterpriseLibrary. Return Recordset from oracle stored procedure
(3 messages)
Date: Fri, 13 Jul 2007 13:12:04 -0700
Hi,
I'm trying to use an EnterpriseLibrary 3.1 and return recordset from oracle
database using stored procedure.
As you may know, oracle stored procedures have out parameter of type cursor
in order to return a dataset ...
|