| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 December 2007 January 2008 February 2008 March 2008 April 2008 |
Filter by week: 1 2 3 4 5 SqlConnection.ClearPool as best practice on command timeout? Posted by Ira Gladnick at 3/7/2008 2:43:54 PM If a timeout occurs on a SqlCommand while it is in the middle of
executing a transaction contained withing a stored procedure
(transaction is started in the stored procedure with BEGIN TRANS, as
opposed to being started in the .Net application), database resources
can stay locked even after the ...more >>
retrieving individual row counts from a stored procedure Posted by Andy Fish at 3/7/2008 11:20:05 AM (this is related to my previous post yesterday but I think i'm asking a
distinct question so it's a new post)
say I have a stored procedure that does 3 updates:
update table1 set .... where ...
update table2 set .... where ...
update table3 set .... where ...
if I execute this using ...more >>
returned row count when a trigger is invoked Posted by Andy Fish at 3/6/2008 6:12:05 PM Hi,
in my .net application, I am using IDbCommand.ExecuteNonQuery() to update a
single row. as a matter of good programming practice, I check the "rows
affected" return value to verify that only 1 row was updated.
the problem comes if there is a database trigger on the table which does
f...more >>
DataTable.Load() Posted by Scott M. at 3/6/2008 5:33:29 PM Does the DataTable.Load() method do its operation in one database round-trip
when it is passed a DataReader?
...more >>
How Do I setup a RowChangedEvent in a Typed DataSet Posted by Devon-S at 3/6/2008 1:06:05 PM Greetings,
I have a strongly typed dataset and when I write the identity column to the
database, I set it and retrieve it. This works fine.
Now I want an event to trigger for each record that is set and retrieved
from the DataSet to update the children of the DataSet with the new identity ...more >>
MDAC required Posted by Mathieu_Pagé at 3/6/2008 10:34:36 AM Hi,
I have an application (that I wrote) that use ADO.NET to access an JET
(Access) database. My application was working fine, until I installed
and uninstalled a trial version of Microsoft Office 2007. I don't know
if it was working between the installation and uninstallation of office,
...more >>
DataAdapter and DataSet in Disconnected Mode Posted by A K at 3/5/2008 9:05:45 PM I am new to ADO.Net and trying to use DataAdapter & DataSet.
I read the data from database table into dataset using DataAdapter.
Do I have to use the same DataAdapter object to update and commit the
changes made to DataSet?
I will appreciate any pointers to articles / documentations.
Re...more >>
Get error raised from sql command? Posted by Smokey Grindel at 3/5/2008 7:55:14 PM Is there a way to get an error that is raised from a sql server stored
procedure when executed from a sqlcommand object? thanks!
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Silly ODBC Connection problem Posted by DingoBoy at 3/5/2008 2:36:09 PM I have an Oracle database running on Windows Server 2003, for which I have
created a System DSN named "MyDSN" in the ODBC Administrator tool. I can test
the connection without problems in the ODBC Administrator, however when I use
conn = gcnew OdbcConnection("DSN=MyDSN;UID=User;PWD=Pass");
...more >>
Data migration questions? Posted by Mervin Williams at 3/5/2008 9:34:37 AM I am about to develop code to migrate data from an old application to our
new one. But first, I have a couple of questions:
First, should I use a DataSet to bring the data down to the local machine
that will run the code and execute the transformation logic from it.
Considerations: The so...more >>
How to install .NET wrapper for old ADODB dll? Posted by Norbert_Pürringer at 3/5/2008 8:34:10 AM Hello,
does anyone know how to get a .NET wrapper assembly for old ADODB? In
C:\Windows\assemby I do not have the assembly ADODB version
7.0.3300.0. So I have to install the assembly explicitely. Any ideas?
Thanks in advance,
Norbert...more >>
datacolumn datetime from UTC to Localtime Posted by georgejetson at 3/5/2008 3:06:01 AM Hi,
VB.net 2005 CLR 2.0
I have a dataset with a datatable...there is one datetime field, and about
30 double fields.
The datetime field is in UTC Time, but my client application needs to see
this in localtime.
The datetime field is accurate to the millisecond...
The data source is...more >>
ODBCCommandBuilder produces different UpdateCommand with Oracle using field name aliases Posted by Eric at 3/4/2008 10:54:54 AM If I use a command that contains field name aliases, I get a different
result for _cmdBldr.GetUpdateCommand().CommandText, depending on
whether I am connected to SQL Server 2005 or Oracle 10g.
Here is the code in question:
string _sqlString = "SELECT ID, PLANGROUP AS PG, DESC_R FROM TABLEA
...more >>
How to connect to a database through code? Posted by peter.taslimi@hotmail.com at 3/4/2008 7:53:52 AM Beginner question:
Can anyone point me in the right direction for learning (url's, books, etc.)
how to connect to an sql or access database through code rather than using
typed datasets? What I am most interested in is sample code that would
connect to say the Northwind database and allow a...more >>
Transactions in ADO.NET or SQL SP Posted by Don at 3/3/2008 9:58:00 PM What is the best approach?
I've created a .NET 2.0 windows service which queries & updates data in SQL
using Stored Procedures.
Note, this windows service spawns a few worker threads which query/update
the database - thus ending up with multiple simultaneous database connections
(queries/u...more >>
Scope_Identity() Posted by Luc at 3/3/2008 2:15:00 AM Dear,
how can I get the scope_identity after inserting records into the database
<System.ComponentModel.DataObjectMethod(ComponentModel.DataObjectMethodType.Select, True)> _
Public Function Insertdata(@Name, @firstname) as integer
return adapter.insert(@name,@firstname)
end f...more >>
ado.net data access performance Posted by John at 3/1/2008 2:11:22 AM Hi
I am using a strongly typed dataset created by vs 2008. I have added a query
to select next record to the data adapter as below;
SELECT TOP 1 <field list>
FROM MyTable
WHERE (ID > ?)
ORDER BY ID
? is replaced by the ID of the current record.
My problem is when I fill using this q...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |