It's back - the timeout problem
(9 messages)
Date: Fri, 27 Jul 2007 10:52:04 -0700
Hi;
One of our testers is getting this now - and he is not running under a
debugger. The error is:
Exception(s):DataSourceException: executeQuery select=select CategoryName
from Categories Timeout expired. The timeout ...
|
Updated Primary Key (Identity) Value
(6 messages)
Date: Fri, 27 Jul 2007 16:05:24 GMT
To start, I'm using VB 2005 and SQL Server Express 2005.
This almost appears to be a bug, but I've yet to find an actual bug and
generally narrow my issues down to user-error on my part. I have the
following code snippet ...
|
Help - why does SqlException not list Procedure name on timeout?
(2 messages)
Date: Fri, 27 Jul 2007 08:31:07 -0700
When I have a timeout on invoking a stored procedure against SQL
Server, I have an exception returned that looks like the following:
{System.Data.SqlClient.SqlException}
System.SystemException: {"Timeout expired. The ...
|
LDAP: User associate to computer
(1 messages)
Date: Fri, 27 Jul 2007 16:50:19 +0200
Hi,
How to search the user (or users) associate to computer by ldap.
thanks
--
Jean-Yves BURLOT
SI - EVEN Lait
...
|
Command parameters, DBNull and SQL Server image field
(6 messages)
Date: 27 Jul 2007 00:13:32 +0200
Hi!
This code (using the System.Data.SqlClient namespace)...
SqlCommand c = myConnection.CreateCommand();
c.CommandText = "INSERT INTO myTable (myField) VALUES (@myParameter)";
c.Parameters.Add("@myParameter", myValue ...
|
Responding to DataGrid selection
(1 messages)
Date: Thu, 26 Jul 2007 15:02:02 -0700
With a .Net 2's WinForms which contain
1) a DataGrid which is assigned to a DataSet's DataTable (some columns are
"hidden" on screen)
2) a few TextBox which are aligned to different fields within the same
DataTable
What ...
|
update db ?
(10 messages)
Date: Thu, 26 Jul 2007 04:52:07 -0700
I am having an issue with getting my ds to update my db. I am pulling info
from the NW db on my Default.aspx page. I then click the edit btn and pass
the data to my Details.aspx page. That works fine. The issue is getting ...
|
Indexing usefull or not??
(2 messages)
Date: Thu, 26 Jul 2007 04:50:02 -0700
Maybe a stupid one,......
is it still usefull to make indexes on the SQL server since in ADO.NET we
work with complete datasets which contain complete or parts of tables???
--
Best regards
Luc N ...
|
Problems in loading data from an access database into an array
(5 messages)
Date: Thu, 26 Jul 2007 08:55:03 +0800
Please i'm new in VB.net and i'm designing a Cinema booking and purchase
system..I need to load the seat ID from the database into an array.please
how do i go about it.. or can anyone give me an idea of how i can show seats ...
|
Requesting some help
(1 messages)
Date: Wed, 25 Jul 2007 21:50:25 +0100
Hello community
I am scincerley asking for some help. I'm 31 years old and live in the UK,
I'm married with two children and have worked all my life as has my wife.
I have been given an opportunity to emigrate to Canada ...
|
|
Merge DataRow Items?
(4 messages)
Date: Wed, 25 Jul 2007 15:52:51 -0400
I have a DataTable with one row and I did a Merge() from another
DataTable and now I have two rows. How can I get the rows to be a
single row (assuming row 0 is the "dominant" one).
Thanks.
...
|
DataAdapter.Update() returns error.
(1 messages)
Date: Wed, 25 Jul 2007 10:56:07 -0700
Hi,
I am populating a dataset from a stored procedure, which returns
multiple resultsets. One of the resultset is formed with a join
condition from two tables. I am updating the fields of the
respective
datatable. ...
|
Unexplained entry in Oledb Excel schema table
(1 messages)
Date: Wed, 25 Jul 2007 05:14:07 -0700
Hi
I have an excel workbook with 4 worksheets. When I connect to this workbook
using an Oledb connection, I use GetOleDbTableSchema to retrieve the names of
the worksheets ("TABLE_NAME"), only the schema table returns ...
|
How to get the primary key
(1 messages)
Date: Wed, 25 Jul 2007 02:30:12 -0700
Hello there,
I want to write a function returning the primary key name of a certain
table.
The following function successfully returns the names of all fields of
a table:
public string[] GetFieldNames(string ...
|
How to get the last created or modified dataset
(2 messages)
Date: Wed, 25 Jul 2007 00:38:23 -0700
Hello,
is there a possibility to get the ID of the last created or modified
dataset of a table via ADO.NET? Is there a database independent way?
In SQL Server you can call the scope_identity() function, but this
won't ...
|
TransactionScope promotion & isolation levels
(2 messages)
Date: Tue, 24 Jul 2007 18:28:03 -0700
Our project is using the System.Transactions.TransactionScope class to
provide an ambient transaction which our DAL classes can leverage.
I'm looking for some information about the TransactionScope class to answer
a ...
|
DataReader values and .ToString
(1 messages)
Date: Tue, 24 Jul 2007 17:03:02 +0200
Hello,
In order to avoid errors, I have all my DataReader-fields converted with a
..ToString.
This in case some record could have Null-fields and an error would be
thrown.
This works fine, except for "money" fields ...
|
SqlDependency.Start KeyNotFoundException - Possible Bug
(1 messages)
Date: Mon, 23 Jul 2007 16:50:01 -0700
I'm working heavily with query notifications in SQL Server 2005 and I'm now
getting the following exception:
System.Collections.Generic.KeyNotFoundException: The given key was not
present in the dictionary.
This was ...
|
SqlDependency.Start - Getting KeyNotFoundException
(1 messages)
Date: Mon, 23 Jul 2007 23:41:53 -0000
I'm working heavily with query notifications in SQL Server 2005 and I
get the following exception:
System.Collections.Generic.KeyNotFoundException: The given key was
not
present in the dictionary.
This was working and ...
|
GridView databinding
(4 messages)
Date: Mon, 23 Jul 2007 11:36:06 -0700
I have a GridView which is bound to a table. The user has the ability to
change some defaults and then run a process from this.
This all worked fine until I added in an auto postback to one of the
controls to tie in ...
|
