| 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 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 Inserting Records into SQL Server Tables Posted by Gary at 4/30/2004 7:06:01 PM I am currently writting an application in VB .Net and SQL Server. I am trying to insert new records into two SQL Server tables and would like to know whether it is best to insert the records using a stored procedure or through a dataset. Currently I have a form that consists of two parts. One part o...more >>
Transaction Commit TimeOut but Transaction still completes Posted by Huan at 4/30/2004 3:31:02 PM I'm faced with a weird problem that happens once a week in a production environment(20 transctions a second): I Attempt to commit a SQlTransaction, it throws a "TimeOut Expired" exception but the sqltransaction still commits. The Transacion Object is null which means that it can't be rolled back ...more >>
Unicode problem: Can read, but not store Chinese characters in database! Posted by Morten at 4/30/2004 3:03:18 PM Hi there!
I'm building a VB.NET application that connects to a MS SQL 2000 Server
through ADO.NET.
NOTE: My application can correctly read and show Chinese characters
retrieved from the database (they are stored in a 'nchar' column).
However, when I try to store some Chinese characters th...more >>
MySQL & ByteFX (Invalid PInvoke metadata format) Posted by Don Lopez at 4/30/2004 2:49:26 PM I get this exception when I try to run open on the MySQLConnection
object. It goes like this:
System.TypeLoadException: Invalid PInvoke metadata format.
at System.Net.OSSOCK.gethostbyname(String host)
at System.Net.Dns.GetHostByName(String hostname)
at ByteFX.Data.Common.StreamCrea...more >>
Mapping fields of two dataset schemas Posted by bboer60657 NO[at]SPAM yahoo.com at 4/30/2004 12:52:28 PM I have two dataset schemas and I want to map the fields of one to the
other. I know that I can use a dataadapter to map the fields of a
dataset to the results of select query executed as part of a Fill
call. But is there a datadapter for XML, as opposed to a database.
Any help would be appreci...more >>
SQL connection opening two connections Posted by Christopher at 4/30/2004 12:16:03 PM I have a question about Sql. When I run a simple open statement for a SQL database, it opens up two connections sometimes, and other times it opens up one connection. Does anyone know why this happens. Below is my source code where this is occuring. You will have to change the connection string, esp...more >>
ADO.NET Not Returning Error Posted by achobbs at 4/30/2004 10:36:02 AM If you run the following query
select
'CategoryID = ' + c.CategoryID
from
northwind.dbo.Categories
In Query Analyzer against the Northwind database, QA returns an error saying it cannot convert 'CategoryID = ' to an int. However, if you execute this statement using ADO.NET, no error is retu...more >>
one DataAdapter vs. many DbCommands Posted by juan5 NO[at]SPAM dev.com at 4/30/2004 9:41:01 AM Hi
I have a design decision to make. I must choose between a DataAdapter.Update() and many DbCommands (actually SqlCommands)
Let's assume that a small percentange of the columns need to be modified on average. This would suggest that long strings of SQL will be traveling to the server and back (a...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Array of datarows Posted by Brian Henry at 4/30/2004 9:15:01 AM If I have an array of data rows, how do i bind a listbox to that array of
rows and show whats in a column? right now if i bind to the array it just
shows "System.Data.DataRow" as the name, but if i bind to a table with the
same rows it works.
...more >>
TableMappings and FirstReturnedRecord Posted by Greg at 4/30/2004 9:11:42 AM We manually assign tablenames to our Datatables. We do not use
TableMappings.
When calling DataAdapter.Update like this:
dim i as integer = 0
i = da.Update(dsChanges.Tables("myTable"))
and setting the InsertCommand to a insert sproc that returns the inserted
record with a Select after t...more >>
Cancelling query with ADO and Oracle Posted by Sandra at 4/30/2004 9:11:13 AM Hi All,
I am running a VB.NET application which is using ADO to connect to an Oracle
9i database. I have a form which runs a query which can take a considerable
time to run depending on the criteria that is entered. This query is run on
a seperate thread as I wish to return control to the appl...more >>
Password problem of MS Access Posted by Arsalan Ahmad at 4/30/2004 9:01:43 AM Hi all,
I have a MS Access database (say abc.mdb). I have set the database password
and admin password to "abcdefg" (say). The problem is that when I create a
simple application (a form-based application or asp.net application) and try
to connect to the database using ado.net i get following e...more >>
Sttopid Q 2 Posted by JLW at 4/30/2004 8:39:30 AM What do I have to do to mey development webserver to remotly debug a
project using the IDE? Basically, I have my server, and I work on my
workstation, and create/run the projects from the server remotly, but
debugging won't work. I tried to install just the remote dubugging stuff
from VS.N...more >>
DataAdapter UpdateCommand Posted by markmatheney NO[at]SPAM hotmail.com at 4/30/2004 8:33:18 AM Please help. Simple question.
I want to update a row in an SQL table. (using VS2003)
There are 2 keys:
tts_tkey and tts_tskey
and 3 fields to modify:
tts_activeflag
tts_lastmoddate
tts_lastmodifiedby
SqlUpdateCommandTS.CommandText = "UPDATE TechnicianSchedule " & _
"SET tts_acti...more >>
MDAC 2.8 Issues Posted by GG at 4/30/2004 7:55:41 AM VB.Net Standard 2003, Win2k Pro w/all patches & updates.
My dumbass installed MDAC 2.8. Now I'm getting the following errors when I
try to build my solution....
Unable to find dependency 'INTEROP.ADODB' (Signature='(null)'
Version='2.8.0.0') of assembly 'Interop.JRO.dll'
Unable to find depe...more >>
Stoopid Question Posted by JLW at 4/30/2004 7:52:11 AM This is probably a really stoopid q, but I'm planning a multi-user
ASP.NET Data Entry system. Where should I declare the DataSet's and such,
so it's accesable throughout the entire application, and lasts only for the
users session?
Thank You
...more >>
error: There is already an open DataReader associated with this Connection which must be closed first Posted by powellmw NO[at]SPAM comcast.net at 4/30/2004 7:26:50 AM I am attempting to maintain a database connection across threads. I am
receiving the following exceptional error:
"There is already an open DataReader associated with this Connection
which must be closed first."
The code I use is in two stages: first, open the connection. Second,
execute th...more >>
joining 2 tables Posted by confused1 at 4/30/2004 6:36:02 AM I hope i explain this clearly. I have 2 tables. TABLE1 contains 250 rows with the following data:
quantit
part I
purchase order numbe
date
TABLE two has the same data plus a column for customer order ID with 150 rows of data
I want a query will return equal rows where quantity, part ID, purc...more >>
Using ADO.NET to prcoess T-SQL batches Posted by David R Hancock at 4/30/2004 6:31:03 AM In our development process we have to create T-SQL Scripts to be run against the "Live" databases (there are at least a dozen) so that any changes can be verified and/or tracked
Reading the text from the file is straight forward enough. Using SqlConnection/SqlCommand to actually execute the code i...more >>
Connection Pooling Posted by John at 4/30/2004 5:06:02 AM
Hi All
I have a single-threaded WinForms app which uses SQL Server 2000 as its database
Part of the app is a 'Restore from Backup' form which uses SQLDMO code. I keep gettin
errors telling me that there are other connections open - therefore the restore can't go ahead
I used sp_who to check co...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |