Does anyone have an example using asp.net with an oracle database
specifically calling stored procedures that return collection types of a
user defined type or simple data type? What driver did you use? What
hurdles did you have to over come?

I can create Stored procedures directly in SQL Server using the enterprise
manager but can't get VS.NET 2003 to let me. I am logged in as an
aministrator on the server, and using .NET on the database server. What
permissions am I missing to let me do this?

How can i use DataReader with Datagrid paging ?
Excuse me for bad english...

I'm completely lost and need some help to understand how the Visual Studios
data components work, deals with database, datsets, datasources, etc...  I'm
extremely new to Visual Studio and am having a hard time making the
conversion from Borland's C++ Builder to Visual Studio.

I have no idea what is going on here, maybe someone can help me out.
I have developed an application for my company's intranet using ASP.ne
and SQL Server. We have two servers, one hosts the .NET apps and th
other runs SQL Server 2000. The application runs without a hitch mos

I am retrieving a SQL ntext column from a table and inserting it into a
datagrid. However, it ignores line breaks so I get large blocks of
unformatted text. Is there a way to show the data as it is stored either by
doing some convert or cast in the SQL statement that retrieves ...

I am using the SQLConnection object to establish a connection a SQL Server
2000 PC running on my local PC. Whenever I open the connection I get two
loggins on the SQL Server. Does anyone know what is causing this to happen?

All,
Can anyone help me understand the best way to copy all rows from an existing
DataTable into a second DataTable which also has existing rows. The following
code takes 6-7 seconds for 1200 rows in sourceTable and 1 or more rows in

I just want to know the advantages vs disadvantages of using Component
Services to handle our web application transactions over creating and
passing around a transaction object of our own?  When would you use one over
the other, or use one instead of the other?

       I have a module of application for updating a record from serveral
tables and I used optimistic locking at the beginning, but the feedback is
user feel frustrated when they knew the records can't be saved since it had
been updated by others after they input all the ...

I using OleDbConnection.GetOleDbSchemaTable to read the database schema from
an access database.
The question is if I do the same operation on a different database provider
(for example sql server) will the tables/columns of the schema be the same ?

I am using disconnected datasets and ADO.Net. How would I get the SPID for a
pooled connection?
I would like to log the user name and SPID each time a user performs a
database update transaction, and then correlate this with the the transaction

another question that I hope someone can help me out with. I have started
usin Paging with a Windows Form Datagrid in .Net. What I want to know is is
there a method to dynamically page the query from the database in the same
fashion as Enterprise Manager. I can page x rows at a time ...

Is it possible pass the file name from a File Dialog to the Data Adapter? I
need to select an Access database to "open". There are many different access
files which have the same data structure. I know I can copy the file to a
temp.mdb and handle it that way. I was just wondering ...

I need to get the elementnames and the no of elements froman XSD. I used
readXMLSchema method to read the schema, but i am not able to get the element
names. here is my schema...
<?xml version="1.0" ?>