Archived Months
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


all groups > dotnet ado.net > july 2004 > threads for tuesday july 20

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

Late binding confusion
Posted by Earl at 7/20/2004 10:19:12 PM
I can bind an arraylist to a combobox without a "late binding" error, but I cannot get to the value directly. Because? For example, I create an public arraylist of employee objects in the module (note the Employee is a separate class with the 4 properties being assigned). I can then bind that ...more >>

multiple datasets/one dataset?
Posted by dkode NO[at]SPAM cfl.rr.com at 7/20/2004 8:30:12 PM
I have decided to try to have my data layer project datasets to my business layer in a new app I am developing to see how it will work out. I have one question tho regarding datasets/datatables... What is the significance of having all of my tables in one dataset vs. seperating it out to ha...more >>

Accessing Oracle 9i tables on a Linux box
Posted by Ron Fluegge at 7/20/2004 7:37:20 PM
Will ADO.NET have any problems accessing Oracle 9i tables running on a Linux box using the Microsoft .net managed provider for Oracle? I am assuming not, but it won't be the first time that I have seriously underestimated the issues involved in such a project. I have looked at Oracle's .net ...more >>

Binding to filtered rows
Posted by Roshawn at 7/20/2004 6:49:03 PM
Hi, How do you databind to filtered rows of a DataView? Can I just bind to the DataView or must the filtered rows be moved to some other container (like another DataTable) and binding be done on the container? Roshawn ...more >>

Problem filling Strongly Typed DataSet from an Oracle 9i stored procedure that returns multiple ref cursors
Posted by DotNetGruven at 7/20/2004 5:15:02 PM
Hi, I'm returning 12 tables worth of data from one Oracle stored procedure using the technique documented in: http://support.microsoft.com/default.aspx?scid=kb;EN-US;321715 The problem I'm having is getting the .Fill() to do the right thing. Depending on which overload of Fill()...more >>

Cancel a myDataAdapter.fill(myDataSet) ?
Posted by Sylvain Ross at 7/20/2004 5:05:01 PM
Hi, I've looking around for canceling the filling of a dataset with the : da.fill(ds,"blah") with da a SqlDataAdapter and ds a dataset. I tried to do from a different thread : da.SelectCommand.Cancel, but it doesnt work. I also tried to run the da.fill(ds,"blah") from a different thread an...more >>

250 Character limit on db writes?
Posted by Jason at 7/20/2004 4:45:52 PM
I have a simply sql insert statement that takes a txtbox as a parameter and writes it to the database. When I do so however, it truncates the text from the txtbox to 250 characters. I know the txtbox allows more than 250 characters (I set a max length to 2500 characters in fact) and the datab...more >>

Retrieving the stored procedure parameter list in ado.net
Posted by Irishmaninusa at 7/20/2004 4:36:43 PM
http://www.15seconds.com/issue/010718.htm I am current writing a data access layer for a project I am on, and one of the things I want to be able to do is use stored procedures with optional values. The stored procedure part is not an issue, what is the issue is how I call the stored procedure...more >>



DataAdapter Questions
Posted by Bob Day at 7/20/2004 3:55:28 PM
Using VS 2003, VB.Net, MSDE.. Question 1) Is there anyway to get a collection of the DataAdapters created in the component designer? I think the answer is no. Something like the following would be perfect: Dim DataAdapter as SQLDataAdapter For each DataAdapter in ComponenetDesigne...more >>

Simple CrystalReport Chart using SQL Query?
Posted by Don Wash at 7/20/2004 3:33:52 PM
Hi All! I've been searching everywhere for a simple sample of producing a bar graph using CrystalReport by specifying SQL Query, and I've found none of it! I find so many complex samples with so many features buried in the sample but all I want to know is a very simple thing, how to create bar...more >>

DataRow to Hashtable
Posted by Tony Yates at 7/20/2004 2:06:10 PM
I am wanting to know the most effecient way of converting a datrow to a hashtable. Many thanks if you can help Kind Regards Tony...more >>

Datagrid, data relations and joins revisited
Posted by Earl at 7/20/2004 1:33:59 PM
I have to believe this is a fairly common scenario. I have several form classes where I provide a grid to display historical information. My database tables are normalized so calling for, say, the supplier table gives me some foreign keys instead of the actual text that I would like to display i...more >>

Unable to debug SQL from within the .NET IDE
Posted by Andrew Gaskell at 7/20/2004 11:38:28 AM
Hi All When I try to step into a stored procedure in the Northwind database, in MSDE installed locally, using the .NET IDE, I get the error message: "cannot debug stored procedures because the SQL Server database is not set up correctly or user does not have permission to execute master.sp_sd...more >>

Assembly System.Data.OracleClient not found, from framework 1.1?
Posted by Thomas H at 7/20/2004 11:07:09 AM
Hello everyone, hopefully someone can help me out! I'm writing a C# console application that will access an Oracle database. VS.NET isn't recognizing the System.Data.OracleClient namespace! I have intellisense enabled, when I start typing "using System.Data.", I can only choose from Common, O...more >>

Stored Procedures in Vb.NET Standard Ed.?
Posted by steve at 7/20/2004 10:19:36 AM
The vb.net standard edition, doesn't allow the user to create stored procedures with the wizard ?. ...more >>

Access Modifiers for Typed Datasets
Posted by GregC at 7/20/2004 10:09:03 AM
Greetings! I have need of sharing a typed dataset between two projects (one for UI and one for a class library) and have encountered a "problem". By default, the classes generated for a Typed Dataset do not use the access modifiers that I need /would like (e.g. Column properties are declared as ...more >>

How do you call a stored procedure that returns a cursor?
Posted by burak.gunay NO[at]SPAM xpandcorp.com at 7/20/2004 7:31:38 AM
Hello, I have an oracle stored procedue that returns a cursor PROCEDURE GetNumTitleUniqueFamilies ( word in varchar, src in varchar,onetfam in varchar, wordrows out types.word_cursor_type) as begin open wordrows for select distinct substr(ONETCODE, 1, 2) from PROCESSEDWORDS...more >>

SQL:BatchCompleted and RPC:Completed
Posted by googlegroups NO[at]SPAM gawab.com at 7/20/2004 6:07:28 AM
I am executing storedprocedures from C# using SQLClinet. In the SQL Profiler, I get SQL:BatchCompleted for one of them and RPC:Completed for another. Can anyone tell me what SQL:BatchCompleted and RPC:Completed are? and why i am getting a different results for these two sprocs? The st...more >>

Serialize DataSet with ExpressionColumn
Posted by Manuel at 7/20/2004 2:40:21 AM
Hi, I want to send a DataSet containing a DataTable with an expression column via WebService. Seems like the (de-) serialization doesn't work, an exception "InvalidOperationException: There is an error in XML document" is thrown. Anybody any hints, tips or fixes? Kind regards, Manu...more >>


DevelopmentNow Blog