|
|
|
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 ExecuteScalar alternative Posted by Frank Rizzo at 7/29/2004 10:26:28 PM ExecuteScalar is great - it returns the first field of the first row.
Is there a command that returns just the return value from the stored
proc? I can't seem to find it.
Thanks...more >>
TimeOut Expired. Using Temporary tables Posted by DotNetJunkies User at 7/29/2004 10:11:17 PM Hi,
I have a temporary table which contains around 2.7 million records. I am iterating through these records in a WHILE Loop and performing certain business rules on these records. Within the loop too i am using a large number of temporary tables.
This entire processing is being done in a store...more >>
DataView Question Posted by Paul J. Lay at 7/29/2004 5:09:13 PM I have a form that is passed byRef a dataView which is can updated many
times in the form. If the user decides to Cancel all the updates, I would
like to be able to restore the dataView to its contents at entry to the
contructor. Reject changes works fine in my form but causes other problems
f...more >>
Customized errors from Oracle Posted by rbscheer NO[at]SPAM my-deja.com at 7/29/2004 2:39:14 PM Hi.
I need to raise a customized error message from a stored procedure in
Oracle 8i and catch this error in my Try...Catches in VB.NET. Can
anyone point me to an article or something that teaches how to do it?
OTN site is terrible to find anything!!!
Thanks,
Robert Scheer...more >>
Tool for scripting out the database Posted by Frank Rizzo at 7/29/2004 2:38:28 PM Hello,
I am looking for a tool that will connect to the database and script the
entire thing out (i.e. tables structured, stored procs, views, etc...
including the data in the tables) to a file.
I would then run this script elsewhere to restore the database. I'd
prefer something that comm...more >>
DataRowView Trouble Posted by Roshawn at 7/29/2004 2:28:43 PM Hi,
I am using a DataRowView object that contains exactly one row. Here's my
code:
Dim dv as New DataView(ds.Tables(0), "City = 'Hammond'", "",
DataViewRowState.CurrentRows)
Dim row as DataRowView = dv(0)
The row contains a column that can contain empty data. How can you tell if
the s...more >>
Command and parameters Posted by Frédéric Mayot at 7/29/2004 12:34:01 PM Hi,
I'm trying to make a little wrapper to execute sql commands with parameters.
Execute("SELECT * FROM Table WHERE Stuff=@p1", somevar)
Public Shared Function Execute(ByVal sSQL As String, _
ByVal ParamArray params() As Object) As
Object
[...]
...more >>
SqlDataReader.Close() bug? Posted by Chris Gallucci at 7/29/2004 12:18:42 PM I have a program that creates an instance of a SqlDataReader via the
Microsoft Application Blocks Data Access code.
I use a typical try{} catch{} finally{} pattern for using it...
<codesnippet>
SqlDataReader rdr = SqlManager.ExecuteReader(/* yada, yada, yada */);
try {
while ( rdr.Read...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Output Parameter Help! Posted by Ben Smith at 7/29/2004 9:51:36 AM First off, I think there is a bug in the Data ApplicationBlocks when it =
comes to Output parameters. Even when I specify the direction the =
SQLHelper.ExecuteReader method still treats the parameter as an input =
parameter. But on to my questions...
I am having trouble returning a values ba...more >>
XML Attributes in a DataSet Posted by Ryan Rogers at 7/29/2004 9:22:22 AM How can one extract the Attribute values from a Dataset that has been loaded
with an XML file like the following at the bottom of the document. I have
to use a dataset and the XML file must remain the same?
Regards,
Ryan
<?xml version="1.0" encoding="utf-8" ?>
<Groups>
<Group Name="...more >>
Inserting rows in dataset bound to XmlDataDocument - Framework bug? Posted by Troy McLure at 7/29/2004 12:01:39 AM I have a C# Windows form with a datagrid. The datagrid displays a
dataset. The dataset is created by reading an xml file. The dataset is
read into an XmlDataDocument. The datagrid and the xml data will not
sync when inserting new rows:
When I insert a new row to the dataset by using
Syste...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |