| 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 31 Auto Incrementing Values Posted by Lora Connors at 12/17/2003 10:53:59 PM I have an Invoice table in my database with 'InvoiceID' as
its primary key. I would like the InvoiceID field to auto
increment values in the format INV1, INV2,
INV3........INV100.so on and so forth. How do I go about
it?
Thanks!
...more >>
Connection won't disappear from SQL Server until app closes Posted by Dave Sherrin at 12/17/2003 5:08:58 PM I have no problems connecting to SQL Server 2000 from VB.net and using all
it's functions. However, when I close the connection, it stays active on
the server until the application is closed. I have tried running commands
with the drop connection parameter, closing the connection with close,
d...more >>
No Results Posted by Jim Heavey at 12/17/2003 3:27:47 PM Hello, I have looked at this and then looked at it somemore, but I can't
see anything wrong...
Here is my senario.
I wrote a stored procedure to return information about the parms in a
stored procedure. The idea being is that I will build all my Parameters
for any stored procedure mechani...more >>
Bug in SqlConnection, SqlClient connection pool or DTC? Posted by smo_news NO[at]SPAM hotmail.com at 12/17/2003 1:47:05 PM SqlConnection throws an exception when disposed if it is manually
enlisted in a distributed transaction:
System.InvalidCastException: Specified cast is not valid.
Server stack trace:
at System.Data.SqlClient.ConnectionPool.PutConnectionManualEnlisted(SqlInternalConnection
con)
at Syst...more >>
navigation bar does not pass to added rows Posted by Yoramo at 12/17/2003 1:04:57 PM Hello
I have created a simple application that has a form that displays one
row each time.
I have used the wizard to generate the code.
my problem is that I can not navigate to added rows, I see the count of rows
increasing but the navigation controls refuse to point on th...more >>
to make datetime nullable Posted by Alex Liang at 12/17/2003 12:13:34 PM Dear all,
how can i pass an null or empty-value to datetime object?
I need to use a datatable to update an oracle table, and the datatable
contains a datacolumn, e.g. orderdate, which is of type datetime.
Any suggestion will be appreciated.
Alex
...more >>
Binding forms? Posted by grawsha2000 NO[at]SPAM yahoo.com at 12/17/2003 12:06:28 PM Hi,
Do I have to release binding of form controls to dataset every time I
do form search of filling?I mean, is there a shorter way than this?
'Binde textbox1 to dataset
textbox1.databindings.add("text",ds,"Employees.firstname")
'unbinde for ReUse of binding prpty. Loop through all co...more >>
BUG? OleDb AccessMdb Localization Posted by Jeroen Smits at 12/17/2003 11:09:14 AM I think I found a bug in .NET 1.1 using the OleDb classes
using:
..NET 1.1
Access MDB file (2000 format)
Localization set to Dutch (or probably any localization where the , is used
for decimal and . is used for thousands)
steps to reproduce problem:
Create a OleDbCommand with a sql st...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DataReader Posted by Jim Heavey at 12/17/2003 11:09:02 AM Hello, I am transitioning from VB to C# and I can't tell if my problem is
to do with the format of my command or something else.
I am getting an error of "Object reference not set to an instance of the
object" when it hits this line of code..
int rtnValue = (int) cmd.Parameters["@RETURN_VA...more >>
GUID as parameter to stored proc causes Invalid Cast Posted by Robert Storrs at 12/17/2003 10:44:15 AM I am using the Microsoft Data Access Application Block
for .NET code to interface to our SQL database. I have a
stored procedure (CREATE procedure ixe_MarkBranchStatus
@NodeState int = 0, @rootnode uniqueidentifier = null).
I have the data for rootnode store as a string
representation of...more >>
Multiple transactions on the same connection? Posted by kirbag NO[at]SPAM hotmail.com at 12/17/2003 10:23:05 AM Hi,
Wanted to know if I can have multiple transactions over the same
connection.
I am planning to have only one connection object in my application.
For multiple users I want to begin different transctions over the same
connection. I would be storing the transaction objects by userid in a
...more >>
ADO.Net Connection Strings Posted by ibeetb at 12/17/2003 9:09:26 AM Does anyone know the full connection string to use with ado.net for Sybase
as well as PostGresql 3.0?
Thanks
...more >>
DataTable row changed Posted by RA at 12/17/2003 8:47:38 AM Hi
Is there a way to know if rows has been added/deleted from a DataTable (not
using the exevts)?
Thanks,
Ronen
...more >>
DbType To SqlDbType Posted by Jim Heavey at 12/17/2003 8:13:07 AM Is there some documentation which identifies how to translate a DbType to a
SqlDbType and vice versa?...more >>
SqlDataType Mone/SmallMoney Posted by Jim Heavey at 12/17/2003 7:20:51 AM In a VB.Net client, what datatype do you use in to supply a parameter of
type "Money" or "smallMoney"
Thanks in advance for your assistance!...more >>
Beginner question: run .sql Posted by Carlo Marchesoni at 12/17/2003 3:59:45 AM I'm starting with ADO.NET and I found several samples
where they ask to run .sql files (for creating stored
procedures or so).
I have the MSDE SQL Desktop engine and do not know how to
run a sql script for this DB.
Can I do it from inside VS.net ?
Thanks...more >>
Updating hierarchical data Posted by PontiMax at 12/17/2003 2:29:37 AM I'm working with the Northwind database
tables 'Customers', 'Orders', and 'Order
Details': 'CustomerID' relates 'Orders' to 'Customers',
and 'OrderID' relates 'Order Details' to 'Orders'. For
displaying this hierarchical data I create a DataSet,
append and fill a DataTable for each databas...more >>
Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Posted by Ken North at 12/17/2003 2:13:55 AM The driver and provider lists (below) have recently been updated and moved to a
new web site (www.SQLSummit.com):
ODBC drivers
http://www.sqlsummit.com/ODBCVend.htm
..NET Providers
http://www.sqlsummit.com/DataProv.htm
OLE DB Providers
http://www.sqlsummit.com/oledbven.htm
JDBC drive...more >>
filtering child records Posted by Martin Williams at 12/17/2003 1:39:12 AM How can you get the child records of a master record and then further filter
the returned array down to more specific records? For instance, I search
the array containing the child records for rows that have a value of "Today"
in the Date column. I then want those identified rows copied to anot...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |