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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|