|
|
|
|
|
Total Hits: 16 | Today: 0
|
Author: Bob Beauchemin
|
Rating:
|
|
In my previous article, I pointed out that Visual Studio 2005 Server Explorer now uses a dialog box containing a list of .NET data providers (rather than OLE DB providers) to prompt for connection information. When you decide on a connection string and add a Data Connection, each Data Connection also displays a tree of information about the database objects (like tables, views, and stored procedures) visible directly through the connection. But where does this information come from? Is Visual St...
|
|
|
|
Total Hits: 52 | Today: 0
|
Author: programmersheaven
|
Rating:
|
|
ADO.net Programming article which focus on both how to write efficient code and how to represent the information which take advantage of layered design of .net framework. Articles describes how you can write code efficiently and improve performance of application and avoids errors due to poor coding style....
|
|
|
|
Total Hits: 56 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
This article demonstrates how to call an Oracle package to retrieve a recordset using ADO on Active Server Pages (ASP).
This article assumes that:
• You are proficient with Visual Basic Scripting Edition (VBScript), ActiveX Data Objects (ADO), and Active Server Pages (ASP).
• You understand Oracle's Procedural Language/Structured Query Language, if you will also be creating Oracle packages.
• Your Internet Information Server (IIS) is configured properly to the Oracle database. Fo...
|
|
|
|
Total Hits: 77 | Today: 0
|
Author: Steven Smith
|
Rating:
|
|
This article covers simply HOW to use stored procedures with ADO. WHY you should do so is covered in another article, but suffice to say that you should. SQL code in your ASP page is BAD. Remember that and you'll do fine. Now let's look at some code....
|
|
|
|
Total Hits: 61 | Today: 0
|
Author: 4guysfromrolla
|
Rating:
|
|
This article assumes that you know what a stored procedure is, and have had experience creating them and executing them via an ASP page....
|
|
|
|
Total Hits: 23 | Today: 0
|
Author: Omri Gazitt
|
Rating:
|
|
ADO+ is the new set of data access services for the .NET Framework. ADO+ is a natural evolution of ADO, built around n-tier development and architected with XML at its core. This article presents the design motivations behind ADO+, as well as a brief introduction to the various classes in the two layers that comprise the ADO+ framework—the connected Managed Providers and the disconnected DataSet. A drilldown into DataSets that covers populating data stores, relationships, filtering, searching an...
|
|
|
|
Total Hits: 15 | Today: 0
|
Author: Sunny Ahuwanya
|
Rating:
|
|
It is generally a good idea to create a wrapper method for every stored procedure that an application needs to call. Such methods can then be grouped into a single data access utility class. This approach improves type safety and portability. These methods generally call the Command.ExecuteScalar, Command.ExecuteNonQuery and Command.ExecuteReader ADO.NET methods. They also perform tasks like checking if the Connection object is still connected, adding stored procedure parameters to the Command o...
|
|
|
|
Total Hits: 8 | Today: 0
|
Author: Johnny Worker
|
Rating:
|
|
The program contains a .aspx and a .aspx.vb file. In VS2008 (whether you create your website with C# or VB), add them to your project as existing files, then do a little modification to the code (see below), and it should work. Once opened, it lists your SQL Server table schema and generates the CRUD codes, including the Stored Procedures and the ADO.NET commands (currently in VB only) that use the Stored Procedures generated....
|
|
|
|
Total Hits: 87 | Today: 0
|
Author: Robert Gelb
|
Rating:
|
|
Contrary to popular belief, Recordset.Clone doesn't actually clone the recordset. It doesn't actually create a new object in memory - it simply returns a reference to the original recordset with the option of making the reference read-only. To verify this claim, simply delete a record from the cloned recordset and you will see that the .RecordCount on the original recordset also decreases.
So how do you actually make a true clone of the recordset with no dependencies or dangling reference...
|
|
|
|
Total Hits: 44 | Today: 0
|
Author: David R. K. DeLoveh
|
Rating:
|
|
This article shows how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. You may already have experience using ADOX or SQL-DMO to accomplish this, but please keep in mind that the method displayed here is meant to be simple enough that anyone with ADO experience can use it. (ADOX and SQL-DMO will be addressed later.)...
|
|
|
|
Total Hits: 36 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
In the .NET Framework, Microsoft introduces ADO.NET, an evolution of the data access architecture provided by the Microsoft® ActiveX® Data Objects (ADO) programming model. ADO.NET does not replace ADO for the COM programmer; rather, it provides the .NET programmer with access to relational data sources, XML, and application data. ADO.NET supports a variety of development needs, including the creation of database clients and middle-tier business objects used by applications, tools, languages, and...
|
|
|
|
Total Hits: 24 | Today: 0
|
Author: Gurneet Singh
|
Rating:
|
|
When I started my search on the .NET Platform from Microsoft a few months ago I was pretty confused about the whole idea of .NET, what exactly it is. For any Visual Basic programmer the most basic thing and for most of us the most important thing to run any of our applications is Database Access and yes it means a lot to an experienced VB programmer.
When I use the word confused the very idea of using it is that within a short span of 3-4 years Visual Basic has seen itself go so fast that we ...
|
|
|
|
Total Hits: 207 | Today: 0
|
Author: sandeep@s.
|
Rating:
|
|
Stored Procedures are a set of sql commands which are compiled and are stored inside the database. Every time you execute a sql command, the command is parsed, optimization is done and then the command is executed. Parsing and optimization the command each time you run the query is very expensive. To solve this we have a set of commands collectively called as stored procedure, which are already parsed and optimized and are executed when ever we call them. This article describes about how to call...
|
|
|
|
Total Hits: 161 | Today: 0
|
Author: Paul Kimmel
|
Rating:
|
|
Because stored procedures are not written in Visual Basic .NET, VB.NET programmers have to learn stored procedure grammar and keywords and practice writing SQL to use them. In a perfect world, the division of labor in software development would be divided between a stored procedure programmer and a Visual Basic .NET programmer so neither would have to know the ins and outs of the other's work. However, dividing these jobs in a team environment carries the risk of one programmer inadvertently dro...
|
|
|
|
|
|
