| 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 bind variables oracle visual basic Posted by cptkirkh at 7/27/2007 8:51:09 PM I have a query that looks up the highest value for column a and then
returns column a and column b. It uses a nested select in the from
clause. I want to use bind variables for my parameters but have found
out i can't use bind variables in the from clause. It keeps returning
no records when i...more >>
What does DataSet.AcceptChanges do? Posted by Ronald S. Cook at 7/27/2007 6:45:06 PM If I delete rows in a DataTable and then do a DataSet.AcceptChanges, and
then pass that DataSet to the client, will the client have any idea of rows
that previously existed? I'm hoping not.
If the client would still see those rows (but as deleted), I guess I will
have to create a new DataT...more >>
Updated Primary Key (Identity) Value Posted by Lucas Bussey at 7/27/2007 4:05:24 PM 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 (LogFile is a class I've created simply to output to
a textfile):
---
...more >>
Compare two DataSets? Posted by Ronald S. Cook at 7/27/2007 3:06:01 PM Is there a way I can compare two DataSets to see if they are identical?
Thanks,
Ron
...more >>
It's back - the timeout problem Posted by David Thielen at 7/27/2007 10:52:04 AM 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 period elapsed prior to
completion of the operation or the server is not...more >>
Help - why does SqlException not list Procedure name on timeout? Posted by at 7/27/2007 8:31:07 AM 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 timeout period
elapsed prior to completion of the operation or the serve...more >>
Command parameters, DBNull and SQL Server image field Posted by Heinrich Moser at 7/27/2007 12:13:32 AM 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);
c.ExecuteNonQuery();
....usually works perfectly fine for all kinds ...more >>
update db ? Posted by Stupid1 at 7/26/2007 4:52:07 AM 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 the
ds to actually update the db. I know this is simple, but I can't see...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Indexing usefull or not?? Posted by Luc at 7/26/2007 4:50:02 AM
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...more >>
Problems in loading data from an access database into an array Posted by Fabiyi Olawale at 7/26/2007 12:00:00 AM 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
are availabele,booked or bought..i'll really appreciate input....
reg...more >>
Merge DataRow Items? Posted by lucius at 7/25/2007 3:52:51 PM
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.
...more >>
Null value Check in DataTable? Posted by lucius at 7/25/2007 3:00:00 PM
I have a DataRow in a DataTable. I want to know if there is a value. I
do this
if ( this.Rows[0]["Col_A"] == null )
{
throw new Exception ( "no" );
}
However this condition is never hit. Why?
Thanks....more >>
How to get the last created or modified dataset Posted by thalion77 NO[at]SPAM graffiti.net at 7/25/2007 12:38:23 AM 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 work in Oracle, MySQL, Access a.s.o.
Thanks in advance,
Norbert
...more >>
TransactionScope promotion & isolation levels Posted by clrudolphi at 7/24/2007 6:28:03 PM 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 few questions about how it behaves when a transaction is promoted to a
d...more >>
DataReader values and .ToString Posted by Michel Vanderbeke at 7/24/2007 5:03:02 PM 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 in SQL-Server.
When I enter e.g. ? 2,50 and I read it back with a DataRea...more >>
GridView databinding Posted by Gerhard at 7/23/2007 11:36:06 AM 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 some other functionality.
After the post back, and at the end of page loa...more >>
Database Persistance Posted by steve.a.bennett NO[at]SPAM gmail.com at 7/23/2007 8:55:59 AM Hi
I'm not sure whether I've given this post the correct title, but I'm a
bit unsure of where to put it.
I have a database that holds information about several of our users.
This database is stored on a central server, with an application that
periodically performs some processing, which ma...more >>
Detach database from SQL Server Posted by Michel at 7/23/2007 8:02:03 AM Hello,
When I have closed my appliciation in VB.NET, and I try to detach my
database from SQL SERVER, I often get a message that the database cannot be
detachted, because it is still in use.
So I think there is some code missing in my application (in the
MDI_FormClosing?)
to make my da...more >>
ExecuteNonQuery within the loop of a datareader Posted by Michel at 7/23/2007 3:54:26 AM Hello,
How can I use an ExecuteNonQuery within the loop of a datareader?
My code is as follows:
Dim cmdToProcess As New SqlClient.SqlCommand
Dim rdToProcess As SqlClient.SqlDataReader
With cmdToProcess
.CommandText = " SELECT * FROM tblDetails "
.Connection = cn
End With
rdToP...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |