Sunday, September 25, 2011

Welcome to My Blog

Welcome.
Welcome To Technowallet. This blog is a beginners guide to develop web applications using .Net Technologies.
All the articles helps u to quickly learn the related technologies. 

Thursday, September 15, 2011

GridView

GridView:
Displays the values of a data source in a table where each column represents a field and each row represents a record. The GridView control allows you to select, sort, and edit these items.
Working with GridView DataSource controls to display data:
GridView can be bind with any one of the following DataSource controls:
SqlDataSource
LinqDataSource
ObjectDataSource
XmlDataSource.
Without need to write any line of code directly one can directly bind the DataSource Controls to display the data in GridView. In the below examples we will work with SqlDataSource and ObjectDataSource controls.
1.       SqlDataSource:
2.      ObjectDataSource:
In general the ObjectDataSource control is used to bind the data from the business logic class. So, first we will take a look at how to create a class that can bind data to GridView.
Creating your Movie class:
Follow the steps to create the Movie Class:
1. Open visual studio, create a new Empty Web Site and save it in u r local directory with some name.
.
2.      Go to solution explorer add a new master page and then add a new content page.

Monday, September 12, 2011

Sql Command

Sql Command:

Sql Command is a connected class of Ado.Net Object model. Sql Command Class is used to perform various database operations over a given connection object (Sql server Database). Sql Command Class is used to perform both synchronous and asynchronous operations. The available methods and properties of Command Object allow you to execute a Sql query or stored procedure.

Saturday, September 10, 2011

Stored Procedure

Stored Procedure:

Stored Procedures are precompiled Sql server objects which store the Sql queries and executes whenever the stored procedure is called. In this tutorial we will see how to work with stored procedure. The following things are discussed in this article.
  1. Create and Execute Stored Procedure.
  2. Stored Procedure with parameter.
  3. Stored Procedure with output parameter.
  4. Return a value from stored procedure.
  5. Call a Stored Procedure from another Stored Procedure

Friday, September 9, 2011

Sql Data Reader

Sql Data Reader:

Data Reader object allows you to perform forward only read only operations over the database. Data Reader is another connected class of Ado.net and is one of the two available data storages objects of Ado.net object model.