| 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 Apostrophes Posted by Fred Chateau at 9/7/2007 7:09:59 PM What is the proper way of handling apostrophes in parameter strings for
stored procedures?
--
Regards,
Fred Chateau
fchateauAtComcastDotNet
...more >>
corruption updating a NCLOB field with ODP.Net Posted by Andy Fish at 9/7/2007 3:34:41 PM hi,
I am trying to insert/update an NCLOB field using ODP.Net. it seems to
execute OK but the data gets corrupted if I put in more than a couple of Kb
into the field.
here is a complete working example:
create table foo (id int, text1 nclob)
using Oracle.DataAccess.Client;
strin...more >>
How To Add/Update Record In ADO.NET Posted by Jeff Gaines at 9/7/2007 12:15:47 PM I am trying to learn ADO.NET having previously used ADODB, the data I am
using is in an Access 2007 database.
I want to know whether I should be updating an existing record or adding a
new one, in ADODB I would use Recordset.EOF to decide which action was
appropriate.
I have written the ...more >>
Optimistic Concurrency Posted by Laurahn at 9/7/2007 11:56:49 AM Hi:
I need a easy way for handling optimistic concurrency.
I found this article with the code.
http://msdn2.microsoft.com/en-us/library/aa720364(VS.71).aspx
Here create both, new parameter value and old parameter value for the update
command.
I don't want to use the version number ap...more >>
Best connection management Posted by Hornet77 at 9/7/2007 12:00:00 AM Hi all
I'm developing a software written in c# (.NET 2.0) with a SQL server
2005 database. I have 3 modules that need to access database:
- a simple ASP.NET website receiving event from remote devices via https
calls
- a windows service running 24/7 that act as a server
- a winform a...more >>
How migrate from SQL Express to SQL Server Posted by VB Programmer at 9/6/2007 11:50:23 AM Using ASP.NET 2.0
I have a website which uses SQL Express.
My hosting company supports only SQL Server.
Any suggestions? What's the easiest way to migrate when I deploy? Will I
have to change any code, or just the connection string?
Thanks!
...more >>
original and proposed are different in datarow with date when same date! Posted by Smokey Grindel at 9/6/2007 10:07:38 AM Try this code, why are the sames that are the same showing up as different?
when I run this it says they are different values!, but do it with strings
and they say they are the same... I am trying to write code to check if a
date changed in a data row and it is getting no where
Module Module1...more >>
Replacing tables in SQL EXPRESS Posted by Michel at 9/6/2007 2:10:23 AM Hello,
Can someone please set me on the way on how to replace certain tables in a
(new) SQL EXPRESS database file by tables of the same name in another
(target) SQL EXPRESS database file?
I would like to do this through code in VB.NET 2005. I presume I have to
use ADO.NET 2.0 code.
Is it...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
.select method fails to return records on datatable when big XML f Posted by Junior at 9/6/2007 12:08:03 AM Hi ! It seems to me that when I grow a XML database in size, a certain
..select call fails, although the records are there indeed.
This is the code :
Dim dsAcesso as New DataSet
dsAcesso.CaseSensitive = False
Dim FsXML As New FileStream("Test.xml", FileMode.Open)
Dim xtrXML As New XmlText...more >>
Can't Update Database Posted by Jonathan Wood at 9/5/2007 4:23:35 PM I'm still plugging along trying to learn .NET and all the database stuff.
I've now had two separate book database sample applications I've typed into
my computer. One was a desktop application and the other was a Web
application. Both appear to work just fine. But, in both cases, when I
upd...more >>
Why does ADO.NET behave oddly during network outage? Posted by davepkz NO[at]SPAM hotmail.com at 9/5/2007 3:04:46 PM Hi,
I have a C# Windows app that uses ADO.NET.
I place an Access db on a network drive and connect to it with my app.
Then I pull the network cable.
Under some conditions (I haven't been able to isolate the pattern), I
can continue to make database requests (e.g. "SELECT COUNT(*) OF
EMPLOYEE...more >>
Using ADO.Net on machines with comma for decimal point Posted by Heinz Kiosk at 9/5/2007 2:04:54 PM Hi,
The following code works fine on a UK/US machine but fails on a French
machine. I've isolated the failure to the "," decimal point on French
machines by using customise on Regional Settings in Control Panel.
I've found other references on the web to this problem but the responses
hav...more >>
Search results Posted by Manjree Garg at 9/5/2007 6:32:04 AM Hi
I am using SqlServer 2005 database in VC++ (via ADO.NET). I am using
stored procedure to search the database as
SELECT supplierID, sampleID
FROM Supplier
JOIN Sample ON Supplier.supplierID = Sample.supplierID
Now the problem is how to store these search results so that...more >>
Query help Posted by Joe at 9/4/2007 9:32:29 AM I don't think this is really the right place to post this question but I
couldn't find any sql groups...
Say there are 3 columns:
idx (key)
product (varchar)
mandate (datetime)
I want to run a query for all products that were sold on more than one day.
For example we may not make a pr...more >>
how to load timestamp type in dataset in oracle and sqlserver Posted by Napo at 9/3/2007 9:42:00 PM My app have two scenario. one type is base on sql server database,the other
is on oracle. In code, i used typed dataset to fill load data from DB.but i
met a problem,that the type of timestamp is differen between sql server and
oracle. so i can't define the type of timestamp cloumn in dataset....more >>
LINQ is Double Slower than traditional DATA Adapter - Correct ME Posted by Chakravarthy at 9/3/2007 7:58:03 AM Today, after watching the presentation by Amanda Silver from Channel 9,
started exploring the LINQ features. Surprisingly, few facts unearthed to
prove that LINQ is slower, much to double the time consumed by the usage of
traditional Data Adapter. Correct me if you find these facts can be prov...more >>
Any known weirdness with MySQL? Posted by PSiegmann NO[at]SPAM mail.nu at 9/2/2007 9:28:21 PM Hi.
For a currently smallish asp.net site we are running currently SQL
Server Express.
But the 4GB limit will be a problem sooner or later, and the licensing
cost for a full blown SQL Server is just too high for such a small
site.
So, I am thinking about using MySQL for it (with the mysq...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |