|
|
|
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 Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 SQLException timeout Posted by Stavros Menegos at 4/26/2004 11:46:03 PM I am using the .NET SQLData Provider for accessing data from an SQL Server 2000 SP3 Server
I have an SQLDataAdapter that it is being provided an appropriate constructed SQLCommand object. The Command's object Timeout Property has been set to 0 i.e. "do not timeout". However, when I am using the SQL...more >>
Advice on connections Posted by Willie Neal at 4/26/2004 8:23:11 PM Is it possible to have an ado.net connection object that would connect to
both SQL Server 2000 and Oracle.
Thanks,
Will.
...more >>
Dataset to Access DB Posted by T Cordon at 4/26/2004 7:16:14 PM How can I insert all records from a DataSet to an Access Table.
Thanks
...more >>
Nulls from msaccess to Vb.Net Posted by Bryan at 4/26/2004 6:01:11 PM I've written the following and found that the ISNULL function is not working properly. I want to be able to query the Firstname record from an access database and have it return a string of my preference when the Firstname field is null. I found that this is isn't happening. Under transact-sql IS...more >>
testing for "" blank nulls Posted by Tony at 4/26/2004 3:54:57 PM vs 2002/xp pro/win forms/MS access 2002
I want to query my database where fieldA = "" (Blank)
Select MYDB where fieldA = "" or Blank or Null
What is the correct syntax for checking for "" blanks nulls
thanks
...more >>
How to determine that rows on server changed and dataset needs to be updated ? Posted by Grigol Avetikov at 4/26/2004 2:20:08 PM Hi,
I'm starting using ADO.NET and trying to understand if there is any
analog of Server side cursor in ADO.NET.
Using ADO i could just open recordset with serverside cursor and
adOpenDynamic options. Then if another user has changed values on the
server while recordet is opened, i got updated...more >>
DataSet.Merge - Expressions not recalculated - Known Bug? Posted by Cole at 4/26/2004 12:49:15 PM When merging a DataSet, if the the DataSet being merged into contains an
expression column and the DataSet merging does not, then the expression
column is not evaluated for new rows (they are DBNull). Of course, I strip
the expression column before updating because of the other bug that causes
...more >>
Attention William Ryan eMVP Posted by Sarah at 4/26/2004 10:07:29 AM Bill,
You were helping on a thread in this group: "Typed Dataset Problem" and
posted a reply to your post and I was hoping that you could reply to it.
Thanks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Execute requires the command to have a transaction object when the connection assigned to the command is in a pending local transaction Posted by victor NO[at]SPAM vanhillo.net at 4/26/2004 9:24:41 AM Hi there,
I have this code to select and insert data into the database. It all
works fine if i don't use a transaction but if i do i get the message:
Execute requires the command to have a transaction object when the
connection assigned to the command is in a pending local transaction.
What...more >>
Distributed transaction completed errors Posted by TC at 4/26/2004 7:36:02 AM I am encountering SQLClient errors in a COM+ object (spawned from Biztalk) that extracts data from an xml document and updates a SQL table (version 2000 8.00.760 SP3)
Under a fairly low load of documents, there seems to be no problems, but with several messages to process, these errors start to sta...more >>
Double or float - make your mind up! Posted by B0nj at 4/26/2004 5:46:06 AM I use floats in SQL server as they are its standard datatype for dealing with non-integral numbers
I thus thought it would be logical to use the SqlDbType.Float for accessing parameters of this type in ADO.NET, from C#
However, when I declare an SqlParameter with SqlDbType.Float as its datatype, i...more >>
Fastest db methods? Posted by B0nj at 4/26/2004 5:41:05 AM Could someone tell me which is faster, or no difference, between
Which is the fastest out of the following two methods??
Reading a recordset using SqlDataAdapter.Fill(a_dataset) / reading a recordset using SqlDataReader ??
Which is the fastest out of the following two methods??
Reading a recor...more >>
C# oracle connectivity Posted by DotNetJunkies User at 4/26/2004 4:41:32 AM Consider a situation that i need to connect to a remote oracle database using a ASP.NET interface. I dont have the access to change the TNSname.ora file. In that case, how can i connect to oracle using the following information:
1. Network Address
2. Port
3. SID
4. User Id
5 Password
Java do...more >>
Still unable to connect to SQL database on non-development machine Posted by debbie at 4/26/2004 3:26:05 AM Hi
I have still not been able to sort out the issue of a non-development machine not being able to open a connection to an SQL database.
Aaron, if you read this thanks for any help you can/could give me
The details are as below
My connection code is (using VB.net):
myConnection = N...more >>
Real Simple Insert - doesn't work Posted by dazzaLondon at 4/26/2004 2:46:03 AM Hey
Trying to do a real simple online Newsletter form - an Insert into a SQL Server DB, but when the submit button is pressed, the page refreshes, but nothing is added to the DB.
Code
Dim ConDB As SqlConnectio
Dim strINSERT As Strin
Dim cmdINSERT As SqlComman
...more >>
solve my problem Posted by Ramesh Kumar via .NET 247 at 4/26/2004 2:08:10 AM (Type your message here)
Hi all,
Now I am doing my project using VC++/MFC and sql server as a database.I hava to store the Bitmaps in the database.If anybody knows about how to store the bitmap in the sql server as a BLOB object & retrive it.please help me it is urgent.
----------------------...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |