Difference Between Procedure Oriented Programming & Object Oriented Programming

Q:-What Is Difference Between  Procedure Oriented Programming & Object Oriented Programming

Procedure Oriented Programming		Object Oriented Programming
1	In POP, program is divided into small parts called functions.	1	In OOP, program is divided into parts called objectes.
2	POP follows Top Down approach.	2	OOP follows Bottom Up approach.
3	POP does not have any access specifier.	3	OOP has access specifies named Public, Private, Protected, etc.
4	POP does not have any proper way for hiding data so it is less secure.	4	OOP provides Data Hiding so provides more security
5	In POP, Overloading is not possible.	5	In OOP, overloading is possible in the form of Function Overloading and Operator Overloading.
6	Example of POP are : C, VB, FORTRAN, Pascal.	6	Example of OOP are : C++, JAVA, VB.NET, C#.NET.

Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar

Q:-Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar

ExecuteNonQuery

ExecuteNonQuery method will return number of rows effected with INSERT, DELETE or UPDATE operations.This ExecuteNonQuery method will be used only for insert, update and delete, Create, and SETstatements. 

ExecuteScalar

Execute Scalar will return single row single column value i.e. single value, on execution of SQL Query or Stored procedure using command object. It’s very fast to retrieve single values from database. 

ExecuteReader

Execute Reader will be used to return the set of rows, on execution of SQL Query or Stored procedure using command object. This one is forward only retrieval of records and it is used to read the table values from first to last. 

Difference Between Array & Structure

Q;- What Is Difference Between Array & Structure

ARRAY		STRUCTURE
1	An array is a collection of related data elements of same type.	1	Structure can have elements of different types
2	An array is a derived data type .	2	A structure is a programmer-defined data type
3	Any array behaves like a built-in data types. All we have to do is to declare an array variable and use it.	3	first we have to design and declare a data structure before the variable of that type are declared and used.

Difference between Web Form & Window Form

Q:- what is difference between Web Form & Window Form

Web Form		Windows Form
1	Web app. can be access from any were in the world through the internet	1	Window based app. need to be install on your Machine to access.
2	Web applications run on web servers (usually IIS)	2	Win forms Applications run on Clients
3	Web services & Websites (ASP.NET) are typical web applications	3	Win forms applications are programs with a GUI put together by controls in the System.Windows.Forms namespace
4	web applications have the authentication/authorization mechanism partially built	4	desktop applications (windows forms) need the entire mechanism built
5	web apps have validation controls	5	windows apps don't have validation controls, data needs to be validated through code

Difference Between Method And Function.

Q:- What Is Difference Between Method And Function.

Difference Between Function And Method

Introduction To AJAX.

Q:- What Is AJAX.

• Ajax is a Group of Interrelated Web Development Techniques used on the client-side to create asynchronous Web applications.

• AJAX stands for Asynchronous JavaScript and XML.

• AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS and Java Script.

Difference Between Procedure And Function In Asp.Net?

Q:- What Is Difference Between Procedure And Function In Asp.Net?

PROCEDURE		FUNCTION
1	Procedure can return zero or n values	1	function can return one value which is mandatory
2	Procedures can have input, output parameters for it	2	Function can have only input parameters.
3	Procedure allows select as well as DML(INSERT/UPDATE/DELETE) statements in it	3	Function allows only select statement in it.
4	Procedures cannot be called from function.	4	Functions can be called from procedure
5	Exception can be handled by try-catch block in a procedure	5	Try-catch block cannot be used in a function.
6	Stored Procedure is a group of sql statements that has been created once and stored in server database.	6	Function is not pre-compiled object it will execute every time whenever it was called.
7	Return type is not must	7	Return type is must