JavaScript Break and Continue Statements

Posted in Labels: | at 7:50 PM

JavaScript Break and Continue Statements

The break StatementThe break statement will break the loop and continue executing the code that follows after the loop (if any).


var i=0;
for (i=0;i<=10;i++)
{
if (i==3)
{
break;
}
document.write("The number is " + i);
document.write("
");
}




output

The number is 0
The number is 1
The number is 2

The continue StatementThe continue statement will break the current loop and continue with the next value.



var i=0
for (i=0;i<=10;i++)
{
if (i==3)
{
continue;
}
document.write("The number is " + i);
document.write("
");
}




output

The number is 0
The number is 1
The number is 2
The number is 4
The number is 5
The number is 6
The number is 7
The number is 8
The number is 9
The number is 10

JavaScript For...In Statement
The for...in statement loops through the elements of an array or through the properties of an object.




var x;
var mycars = new Array();
mycars[0] = "Saab";
mycars[1] = "Volvo";
mycars[2] = "BMW";

for (x in mycars)
{
document.write(mycars[x] + "
");
}





output

Saab
Volvo
BMW

Read Users' Comments (0)

Interview Questions with answers

Posted in Labels: | at 10:27 AM

Transactions :


database level transactions

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[csp_DeleteExamQuestion]
@intExaminationQuestionId int,
@intIsSucess int OUTPUT
AS
BEGIN
DECLARE @intExaminationId AS INT
DECLARE @intQuestionSeqId AS TINYINT
DECLARE @intSectionId AS TINYINT

SET @intIsSucess = 0;
BEGIN TRANSACTION
BEGIN TRY
SELECT
@intExaminationId = intExaminationId ,
@intQuestionSeqId = intQuestionSeqId,
@intSectionId = intSectionId
FROM tblExaminationQuestion
WHERE intExaminationQuestionId = @intExaminationQuestionId

Print @intExaminationId
Print @intQuestionSeqId

DELETE FROM tblExaminationQuestion
WHERE intExaminationQuestionId = @intExaminationQuestionId

UPDATE tblExaminationQuestion
SET intQuestionSeqId = (intQuestionSeqId -1)
WHERE intExaminationId = @intExaminationId
AND intSectionId = @intSectionId
AND intQuestionSeqId > @intQuestionSeqId

SET @intIsSucess = 1
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber
,ERROR_SEVERITY() AS ErrorSeverity
,ERROR_STATE() AS ErrorState
,ERROR_PROCEDURE() AS ErrorProcedure
,ERROR_LINE() AS ErrorLine
,ERROR_MESSAGE() AS ErrorMessage;

IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION;
END CATCH;

IF @@TRANCOUNT > 0
BEGIN
COMMIT TRANSACTION;
SET @intIsSucess = 1
END

RETURN @intIsSucess

END


Ado.net Level Transactions :


public int AddExaminationSections(bool isAdd,
List examinationSectionList)
{
int returnId = 0;

try
{
using (TransactionScope scope = new TransactionScope())
{
int returnExaminationSectionId = 0;
bool tempIsAdd = true;
foreach (ExaminationSection examinationSection in examinationSectionList)
{
if (examinationSection != null)
{
if (!isAdd && examinationSection.ExaminationSectionId > 0)
{
tempIsAdd = false;
}
}

returnExaminationSectionId = AddExaminationSection(tempIsAdd,
examinationSection.ExaminationSectionId,
examinationSection.ExaminationId,
examinationSection.SectionId,
examinationSection.NoOfQuestions);

if (returnExaminationSectionId > 0)
{
returnId = examinationSection.ExaminationId;
}
else
{
return 0;
}
}

if (returnExaminationSectionId > 0)
{
scope.Complete();
//returnId = examinationSection.;
}
}
}
catch (Exception ex)
{
ELearning.ErrorLogger.Error.WriteErrorLog(ex);
}
return returnId;
}

Read Users' Comments (0)

Interview Training

Posted in Labels: | at 8:37 AM

Essential List :


1. Transaction code(with ACID definition rule)
2. SQL queries inner join/outer join as well(nearly 5 queries)
3. Learn Sub queries
4. Cashing concepts
5. how to code web config configurations like database connection string settings like
6. why do we use "using" statement in our code
7. special SQL queries like(Select top 5)
8. use Share point - work flows
9. ASP.net - use validates
10. what is the different between server.transfer vs response.redirect?
11. use custom validates and range validates(when to use)
12. Basic definitions of LINQ
13. Basic understanding about State management
14. Basic understanding about ADO.NET

Read Users' Comments (0)

Useful URLs

Posted in Labels: | at 5:44 AM

This page reveals the useful URL's. So check it out :

convert Word to PDF

LINQ

Read Users' Comments (0)

Five Pillars of .NET Programming

Posted in Labels: | at 5:04 AM

Five Pillars of .NET Programming


VB.Net => C# converter

Read Users' Comments (0)

Delegate Example

Posted in Labels: | at 8:41 AM

http://www.codeproject.com/KB/cs/DelegatesOMy.aspx


Read Users' Comments (0)

ADO.NET

Posted in Labels: | at 8:34 AM

1). What is the namespace in which .NET has the data functionality classes ?

Following are the namespaces provided by .NET for data management :-

1. System.data :

This contains the basic objects used for accessing and storing relational data, such as
DataSet,DataTable, and DataRelation. Each of these is independent of the type of data
source and the way we connect to it.

2. System.Data.OleDB

It contains the objects that we use to connect to a data source via an OLE-DB provider,
such as OleDbConnection, OleDbCommand, etc. These objects inherit from the common
base classes, and so have the same properties, methods, and events as the SqlClient
equivalents.

3. System.Data.SqlClient

This contains the objects that we use to connect to a data source via the Tabular Data
Stream (TDS) interface of Microsoft SQL Server (only). This can generally provide better performance as it removes some of the intermediate layers required by an OLE-DB
connection.

4. System.XML

This Contains the basic objects required to create, read, store, write, and manipulate
XML documents according to W3C recommendations.

2). Can you give a overview of ADO.NET architecture ?

The most important section in ADO.NET architecture is “Data Provider”. Data Provider
provides access to datasource (SQL SERVER, ACCESS, ORACLE).In short it provides
object to achieve functionalities like opening and closing connection, retrieve data and
update data. In the below figure you can see the four main sections of a data provider :-

1. Connection.
2. Command object (This is the responsible object to use stored procedures)
3. Data Adapter (This object acts as a bridge between datastore and dataset).
4. Datareader (This object reads data from data store in forward only mode).

*** “DataView” object is used to sort and filter data in Datatable.

3). What are the two fundamental objects in ADO.NET ?

Datareader and Dataset

4). What is difference between dataset and datareader ?

DataReader provides forward-only and read-only access to data, while the
DataSet object can hold more than one table (in other words more than one
rowset) from the same data source as well as the relationships between them.

Dataset is a disconnected architecture while datareader is connected
architecture.

Dataset can persist contents while datareader can not persist contents, they
are forward only.

5). What are major difference between classic ADO and ADO.NET ?

Following are some major differences between both

√ As in classic ADO we had client and server side cursors they are no more
present in ADO.NET. Note it's a disconnected model so they are no more
applicable.
√ Locking is not supported due to disconnected model.
√ All data persist in XML as compared to classic ADO where data
persisted in Binary format also

6). What is the use of connection object ?

They are used to connect a data to a Command object.

√ An OleDbConnection object is used with an OLE-DB provider255
√ A SqlConnection object uses Tabular Data Services (TDS) with MS SQL Server

7). What is the use of command objects ?

They are used to connect connection object to Datareader or dataset. Following are the
methods provided by command object :-

√ ExecuteNonQuery :- Executes the command defined in the CommandText
property against the connection defined in the Connection property for a query
that does not return any row (an UPDATE, DELETE or INSERT). Returns
an Integer indicating the number of rows affected by the query.

√ ExecuteReader :- Executes the command defined in the CommandText property
against the connection defined in the Connection property. Returns a "reader"
object that is connected to the resulting rowset within the database, allowing
the rows to be retrieved.

√ ExecuteScalar :- Executes the command defined in the CommandText property
against the connection defined in the Connection property. Returns only
single value (effectively the first column of the first row of the resulting rowset)
any other returned columns and rows are discarded. It is fast and efficient
when only a "singleton" value is required

8). What is the use of dataadapter ?

These are objects that connect one or more Command objects to a Dataset object. They
provide logic that would get data from the data store and populates the tables in the
DataSet, or pushes the changes in the DataSet back into the data store.
√ An OleDbDataAdapter object is used with an OLE-DB provider
√ A SqlDataAdapter object uses Tabular Data Services with MS SQL Server.

Read Users' Comments (0)

Subscribe to: Posts (Atom)