vbfeeds.com/Date

The content of the postings is owned by the respective author. vbfeeds.com is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on vbfeeds.com, please contact us at abuse@vbfeeds.com and we will remove it. Designated trademarks and brands are the property of their respective owners. vbfeeds.com Copyright © 2005 Serge Baranovsky. All rights reserved.

Tuesday, July 07, 2009

DAL: Retrieve a DataTable using a SQL Statement

by Deborah Kurata via Deborah Kurata on 7/7/2009 10:27:25 PM

This post provides an implementation of a method that retrieves a DataTable from a SQL Server database using a SQL Statement. Your application can then use the DataTable to populate your business objects or to bind directly to a UI control such as a Combo Box or Grid (such as the DataGridView). The code is first shown in both VB and C#. It is then described in detail below. In C#: public static DataTable ExecuteDataTable(string sqlStatement, & ... [ read more ] 1 comment(s)

DAL: Retrieve a DataTable using a Stored Procedure

by Deborah Kurata via Deborah Kurata on 7/7/2009 10:08:51 PM

This post provides an implementation of a method that retrieves a DataTable from a SQL Server database using a stored procedure. Your application can then use the DataTable to populate your business objects or to bind directly to a UI control such as a Combo Box or Grid (such as the DataGridView). NOTE: This post assumes you already have a stored procedure defined to select the required data from your database. For more information on stored procedures, see this link . The code is first s ... [ read more ] 4 comment(s)

DAL: Data Access Layer

by Deborah Kurata via Deborah Kurata on 7/7/2009 9:39:39 PM

One of the common ways to access data in a .NET application is to use the drag and drop TableAdapter tools or the new Entity Framework tools. But what if you want to write your data access code yourself? There are many ways to access data in an application without using the drag and drop tools: Retrieve a DataTable using a stored procedure ( example ) Retrieve a DataTable using a SQL string ( example ) Access a DataReader using a stored procedure ( example ) Access a ... [ read more ]

© 2005 Serge Baranovsky. All rights reserved.
All feed content is property of original publisher. Designated trademarks and brands are the property of their respective owners.

This site is maintained by SubMain(), a division of vbCity.com, LLC