Retrieve two tables of data at the same time by using data reader

C# oops | 4:17 AM

Collection in c# | Type of collection

Collection in c#

Collection provide a more flexible way to work with group of objects unlike array, the group of object you work can grow and shrink directly as the need of application change.

For some collections, you can assign it to an object that you put into the collection so that you can quickly retrive the object by using the key.

Acollection is a class,you must declare a new collection before you can add element to that collection.

If your Collection contain elements of only on data type,you can use one of the classes in the System.Collection.Generics namespace.

A collection enforces type safety so that no other data type can be added to it. When you retrive an element from a generics collection collection,you do not have determine if data type for convert it.

Type of collection

Many common collection are provided by the .NET Fremework. Each type of collection is designed for a specific purpose. The following groups of collection classes are described in this section.

System.Collection.Generics
System.Collection

System.Collection class:

The classes in the System.Collection namespace do not store elements as specially typed objects,but as objects of type Object.

Whenever possible,you should use the generics collection in the System.Collection.Generics namespace or the System.Collection.Concurrent namespace instead of the legacy types in the System.Collection namespace.

Their are some frequently used classes in the System.Collection namespace.

#Queue: Represents a first in, first out (FIFO) collection of object.
#Stack: Represents a list in,first out (LIFO) collection of object.
#ArrayList: Represents an array of objects whose size is dynamically increased as required.
#HasTable: Represents a collection of key/value pairs the are organised based on the hash code of the key.

System.Collection.Generic class:

You can create a generics collection by using on of the classes in the System.Collecion.Generic namespace. A generics collection is useful when every item in the collection had the same data type.
A generic collection enforces strong typing by allowing only the desired data type to be added.

Their are some frequently used classes in the System.Collection.Generic namespace.

#Dictionary<T Key, T Values>: Represents a collection of key/value pairs that are organized based on the key.

#List<T>: Represent a collection of object that can be accessed by index. Provides method to search ,short and modify lists.
#Queue<T>: Represents a first in,first out (FIFO) collection of objects.
#Stack<T>: Represents a last in. first out (LIFO) collection of objects.

Generic:

Generic allow you to delay the specification of the data type of programming elements in a class or a method, until it is actually used in our program. In other word, generic allow you to write a class or method that can work with any data type.

You write the specification for the class or the method, with substitute parameters for data types. When the compiler encounters a constructor for the class or a function call for the method, it generates code to handle the specific data type.

Features of Generic

Generic is a technique that enriches your program in the following ways:

1. It helps you to maximize code reuse,type safety and performance.

2. You can create your own generic interfaces,classes,methods,events and delegate.

3. You may create generic classes constrained to enable access to method on particular data types.

4. You may get information on the types used in a generic data type at run-time by means of reflection.

Read More:

Type of key ued In MS SQL

TAGS: collection c#,collection in csharp,collection in c# .net, c#collection, type of collection in c#,c# collection types,generics collection.

Asp.Net Mvc | 4:13 AM

What is asp.net MVC - A small tutorial

What is asp.net MVC

What is asp.net MVC the model view controller it is better to separate an application into three main components.

The model
The view
The controller

The ASP.net MVC Framework provide an alternative to the asp.net webform pattern for creating web application the ASP.net MVC framework is a lightweight, highly testable presentation framework that is integrated with existing asp.net features, such as master page and membership based authentication. The MVC Framework is defined in the System.web.mvc assembly . Full control over HTML JavaScript and css it is better as well as recommended approach for large scale application where different teams are working together.

Asp.Net Mvc reference namespace

System.Web.Mvc: Contains class and interfaces that support the MVC pattern for ASP.net web application. This namespace includes classes that represent controllers, controller factories, action results,views, partial views and model model binders

System.Web.Mvc.Ajax: Contains classes that support ajax script in an ASP.net MVC application. That namespace includes support for ajax script and ajax option settings

System.Web.Mvc.Async: Contains classes and interfaces that support asynchronous action in an ASP.net MVC application.

System.Web.Mvc.Html: Contents classes that helper render HTML control in an MVC application. The namespace includes classes that support forms, input control, links, partial view and validation.

MVC Architechture

An ASP.net MVC application have three main folders which is model,view and Controller and also be have more folder to place script file and App_Start and much more so let's talk about these folders.

Model:

Model is used to store Data classes which is created by SQL or entity framework or may be reference of service from WCF or many more at last we just use model to represent the data schema for a view or partial view.

View:

View folder is used to store the view page or partial view page for a particular Action is declared into controller class, Basically view folder maybe contains a shared Folder also in which we can store to common pages or user control that can be used into any controller every request for a view or partial view page from an Action method is also check the page extension into shared folder also.

Controller:

Controller is just used to store some business logic class controller is a collection of only classes and every class is a child class of System.Web.Mvc.Controller class, a controller class is only contain some method known as Action method which is responsible to return a View, Partial view, Content JSON Data and much more.

Action method in asp.net MVC

Action method are the only a special type of method which is used write the code for a particular task and after that is also responsible to returns something to the user and that can be a page or partial page any action handle the two type of http request.

1.Http Get

2.Http Post

Http Get: Http Get action is only used to handle this request are come directly from user and also we can say those request come at first time for an Action method.

Http Post: Http Post action is only call call at that time when any already you exist on client side and user will submit an HTML form by Anthony submit type button so at the time that type of action will call and that can also written the all control value in Form Collection type object from HTML form

An action method may use type of return type to return different-different type of info or value to the user we have some many type of returned from an action to user but maximum time we will use Action Result because it's a parent type any other type which can be used in an action method as a return type

Action Result is an abstract class that can have serval subtype

Action Result SubTypes:

ViewResult: Renders a specified for the user.
EmptyResult: An empty response returned.

PartialViewResult: Renders a specified partial view to the response stream.

RedirectToRouteResult: Perform Http redirection to URL that is determined by the routing engine based on given route data.

Jason result: serial as a given view data object to JSON format.
JavaScriptResult : Return a piece of JavaScript code that can be executed on the client side.

ContentResult: Write content to the response stream without requiring and view.
FileContentResult: Returns a file to the client.
FileStreamResult: Written a file to the client which is provided by a string.

Advantage of asp.net MVC framework

1. It makes very easy to manage complexity by dividing an application into the model ,view and the controller.
2. It does not use Viewstate or server side forms.
3. Full control over HTML JavaScript and css.
4. It provides better support for test driven development(TDD).
5. It works well for web application that are supported by large team of developer and for web designer who need a high degree of control over the application behaviour.
6. By default support of Facebook and Google authentication.
7. It easy to manage ilaj application to dividing in multiple areas.

Type of key used In MS SQL

Faq | 7:58 AM

How do you retrieve two tables of data at the same time by using data reader

Retrieve two tables of data at the same time by using data reader

Include 2 select statements either in a stored procedure or in a select command and call the ExecuteReader() method on the command object. This will automatically fill the DataReader with 2 Tables of data.

The datareader will always return the data from first table only. If you want to get the second table then you need to use ReaderObject.NextResult() method. The NextResult() method will return true if there is another table. The following code shows you how do it.

//Create the SQL Query with 2 Select statements

string SQLQuery = "Select * from Customers;Select * from Employees;";

//Create the Connection Object

SqlConnection ConnectionObject = new SqlConnection(ConnectionString);

//Create the Command Object

SqlCommand CommandObject = new SqlCommand(SQLQuery, ConnectionObject);

//Open the connection

ConnectionObject.Open();

//Execute the command. Now reader object will have 2 tables of data.

SqlDataReader ReaderObject = CommandObject.ExecuteReader();

//Loop thru the tables in the DataReader object

while (ReaderObject.NextResult())

{

while (ReaderObject.Read())

{

//Do Something

}

//Close the Reader

ReaderObject.Close();

//Close the Connection

ConnectionObject.Close();

See More:

Type of key ued In MS SQL