Explore topic-wise InterviewSolutions in Current Affairs.

• SQLCOMMAND is used to execute all kind of SQL queries LIKE DML(Insert, update,Delete) & DDL like(Create table, drop table etc),
• SQLCOMMANDBUILDER OBJECT is used to BUILD & execute SQL (DML) queries like select, insert, update & delete.

It has no such FEATURE.

It has no such feature.

No,

each have its own functionality,

ex : for SQL client , there is SQLCONNECTION OBJECT and for oledb client , there is OleDBConnection

No,

each have its own functionality,

ex : for sql client , there is SqlConnection object and for oledb client , there is OleDBConnection

1. DataSet is disconnected object TYPE. It USES XML to store data.
2. It fetches all data from the data SOURCE at a time
3. Modifications can be updated to the ACTUAL database
4. It will reduce the application PERFORMANCE.

DataReader is an forward only and read only cursor type if you are accessing data through DataReader it shows the data on the web form/ control but you can not perform the paging feature on that record (because it's forward only type). READER is best fit to SHOW the Data (where no need to work on data) DataAdapter is not only CONNECT with the DATABSE(through Command object) it provide four types of command (InsertCommand, UpdateCommand, DeleteCommand, SelectCommand), It supports to the disconnected ARCHITECTURE of .NET show we can populate the records to the DataSet, where as Dataadapter is best fit to work on data.

DataReader is an forward only and read only cursor type if you are accessing data through DataReader it shows the data on the web form/ control but you can not perform the paging feature on that record (because it's forward only type). Reader is best fit to show the Data (where no need to work on data) DataAdapter is not only connect with the Databse(through Command object) it provide four types of command (InsertCommand, UpdateCommand, DeleteCommand, SelectCommand), It supports to the disconnected Architecture of .NET show we can populate the records to the DataSet, where as Dataadapter is best fit to work on data.

Adv: The DATALIST's display is defined via templates, DataList allows for much more customization of the RENDERED HTML markup, by which it is more user-friendly displays of data.

DisAdv:

adding such functionality with the DataList takes more DEVELOPMENT time than with the DataGrid as,

1. The Edit/Update/Cancel buttons that can be created in a DataGrid via the EditCommandColumn column type, must be manually added to the DataList and,
2. The DataGrid BoundColumn column types automatically USE a TextBox Web control for the editing interface, whereas with the DataList you must explicitly specify the editing interface for the item being edited via the EditItemTemplate,
3. we can't do the paging and sorting with datalist controls.

Adv: The DataList's display is defined via templates, DataList allows for much more customization of the rendered HTML markup, by which it is more user-friendly displays of data.

DisAdv:

adding such functionality with the DataList takes more development time than with the DataGrid as,

you can CONNECT SQL USING oledbname SPACE.

you can connect sql using oledbname space.

1. Create a connection. This requires a connection string, which can be GIVEN declaratively or put in a well defined place like the .config files. Advantage of keeping in .config files is that it enables use of Connection Pooling by .Net framework, else even one small change in connection string will cause CLR to think it's not the same connection and will instantiate new connection for other request.
2. Open the connection and keep it open until done, typically done as using (con) { //use }
3. If using connected data model, create a SqlCommand object, decorate it with desired command, command type (stored procedure for eg), add any parameters and their values to the command, and then consume the command by using ExcuteReader or ExecuteScalar. In case of ExecuteReader, we will get back a handle to a fast-forward, read only pointer to the recordset. We can also decorate Command object with multiple recordsets in 2.0 and EXECUTE one by one (MARS - Multiple ACTIVE Record SETS)
4. If using disconnected data model, create a DATAADAPTER object, decorate it with desired SELECT, INSERT, UPDATE, DELETE commands, add parameters as necessary and then fill up a DataSet or DataTable using the DataAdapter. Subsequent SQL can be executed using insert, update, delete commands on the dataset.

UPDATE a dataset:

Update DATABASE through dataset.

Update a dataset:

Update database through dataset.

DELEGATE is an important ELEMENT of C# and is EXTENSIVELY used in EVERY type of .NET application. A delegate is a class WHOSE object (delegate object) can store a set of references to methods.

Delegate is an important element of C# and is extensively used in every type of .NET application. A delegate is a class whose object (delegate object) can store a set of references to methods.

CONNECTION String - a string which contains address of the DATABASE we WANT to CONNECT to.

connection String - a string which contains address of the database we want to connect to.

DATAREADER DataSet DATATABLE DataView DataAdapter

Answer: DataAdapter

DataReader DataSet DataTable DataView DataAdapter

Answer: DataAdapter

 Summary:

Executes the QUERY, and RETURNS the first column of the first row in the result SET returned by the query. Additional columns or rows are IGNORED.

 Summary:

Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

 SUMMARY:

 Executes a Transact-SQL STATEMENT against the connection and returns the NUMBER of rows affected.

 Summary:

 Executes a Transact-SQL statement against the connection and returns the number of rows affected.

If we execute 2 select command either in stored procedure or in select command and then executereader method FIRED of command object. it RETURN 2 tables in DATAREADER.

E.g:
string str="Select * from a;select * from b";
cmd.commandtext=str;
dr=cmd.executereader();

Now it return 2 tables in datareader (dr).

If we execute 2 select command either in stored procedure or in select command and then executereader method fired of command object. it return 2 tables in datareader.

E.g:
string str="Select * from a;select * from b";
cmd.commandtext=str;
dr=cmd.executereader();

Now it return 2 tables in datareader (dr).

 There is a method called Execute NON Query. This method EXECUTES the Update, Delete etc. This does not RETURN any rows but will give the number of rows AFFECTED.

 There is a method called Execute Non Query. This method executes the Update, Delete etc. This does not return any rows but will give the number of rows affected.

No,

its not at all POSSIBLE.

No,

its not at all possible.

yes,

we can connect two dataadapters to same DATASOURCE using single connection at same TIME.
There is a technology in ado.net 2.0 CALLED MARS usinng Mars in connection string we can do it.

for EG:

cn.ConnectionString = "SERVER=(local); database=employee; integrated security=sspi; Multiple Active Result Sets=True";

yes,

we can connect two dataadapters to same datasource using single connection at same time.
There is a technology in ado.net 2.0 called MARS usinng Mars in connection string we can do it.

for eg:

cn.ConnectionString = "server=(local); database=employee; integrated security=sspi; Multiple Active Result Sets=True";

MULTIPLE PROCESSES must agree that they will share the same CONNECTION, where every parameter is the same, including the security SETTINGS.

Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.

DELETES it from the MEMORY.

Deletes it from the memory.

Microsoft.Access.

Microsoft.Access.

The DATABASE NAME to CONNECT to.

The database name to connect to.

Web SERVICES MIGHT use it, as WELL as non-Windows applications.

Web Services might use it, as well as non-Windows applications.

WINDOWS Authentication is trusted because the username and PASSWORD are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

Windows AUTHENTICATION (VIA Active Directory) and SQL Server authentication (via MICROSOFT SQL Server user NAME and PASSWORDS).

Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server user name and passwords).

TRANSACTION must be Atomic (it is one unit of work and does not DEPENDENT on PREVIOUS and FOLLOWING transactions), Consistent (data is either committed or roll back, no “in-between” case where something has been UPDATED and something hasn’t), Isolated (no transaction sees the intermediate results of the current transaction), Durable (the values persist if the data had been committed even if the system crashes right after).

Transaction must be Atomic (it is one unit of work and does not dependent on previous and following transactions), Consistent (data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t), Isolated (no transaction sees the intermediate results of the current transaction), Durable (the values persist if the data had been committed even if the system crashes right after).

The wildcard character is %, the proper query with LIKE WOULD involve ‘LA%’.

The wildcard character is %, the proper query with LIKE would involve ‘La%’.

It RETURNS a read-only DATASET from the data SOURCE when the command is executed.

It returns a read-only dataset from the data source when the command is executed.

SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for ACCESSING other sources, like Oracle, DB2, Microsoft Access and INFORMIX, but it is a .NET layer on top of OLE layer, so not the fastest thing in the world. ODBC.NET is a DEPRECATED layer PROVIDED for backward compatibility to ODBC engines.

SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix, but it is a .NET layer on top of OLE layer, so not the fastest thing in the world. ODBC.NET is a deprecated layer provided for backward compatibility to ODBC engines.

PRESENTATION (UI), BUSINESS (LOGIC and underlying code) and data (from storage or other SOURCES).

Presentation (UI), business (logic and underlying code) and data (from storage or other sources).

Yes,

if you are debugging VIA Visual Studio.NET, just GO to Immediate window.

Yes,

if you are debugging via Visual Studio.NET, just go to Immediate window.

Positive test cases (correct data, correct output), negative test cases (broken or missing data, proper handling), exception test cases (exceptions are THROWN and CAUGHT PROPERLY).

Positive test cases (correct data, correct output), negative test cases (broken or missing data, proper handling), exception test cases (exceptions are thrown and caught properly).

ATTACH the aspnet_wp.exe PROCESS to the DbgClr DEBUGGER.

Attach the aspnet_wp.exe process to the DbgClr debugger.

To the Console or a TEXT FILE depending on the PARAMETER PASSED to the constructor.

To the Console or a text file depending on the parameter passed to the constructor.

The tracing dumps can be quite verbose and for some applications that are constantly RUNNING you run the RISK of OVERLOADING the MACHINE and the hard drive there. Five levels RANGE from None to Verbose, allowing to fine-tune the tracing activities.

The tracing dumps can be quite verbose and for some applications that are constantly running you run the risk of overloading the machine and the hard drive there. Five levels range from None to Verbose, allowing to fine-tune the tracing activities.

USE DEBUG CLASS for debug BUILDS, use TRACE class for both debug and release builds.

Use Debug class for debug builds, use Trace class for both debug and release builds.

In debug compilation, assert TAKES in a BOOLEAN CONDITION as a parameter, and shows the error dialog if the condition is false. The program PROCEEDS WITHOUT any interruption if the condition is true.

In debug compilation, assert takes in a Boolean condition as a parameter, and shows the error dialog if the condition is false. The program proceeds without any interruption if the condition is true.

It POINTS to the object that is POINTED to by this reference. Object is INSTANCE DATA is shown.

It points to the object that is pointed to by this reference. Object is instance data is shown.

CorDBG – command-line debugger, and DbgCLR – GRAPHIC debugger. VISUAL STUDIO .NET uses the DbgCLR. To use CorDbg, you must COMPILE the ORIGINAL C# file using the /debug switch.

CorDBG – command-line debugger, and DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR. To use CorDbg, you must compile the original C# file using the /debug switch.

YES,

so <STUDENT&GT; and <student> are different ELEMENTS.

Yes,

so <Student> and <student> are different elements.

SINGLE LINE CODE EXAMPLE and multiple-line code example.

Single line code example and multiple-line code example.

COMPILE it with a /DOC SWITCH.

Compile it with a /doc switch.

Single-line, multi-line and XML DOCUMENTATION COMMENTS.

Single-line, multi-line and XML documentation comments.

When you write a MULTILINGUAL or multi-cultural application in .NET, and want to DISTRIBUTE the core application separately from the localized MODULES, the localized assemblies that MODIFY the core application are CALLED satellite assemblies.

When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.

It is a DELEGATE that points to and eventually FIRES off several METHODS.

It is a delegate that points to and eventually fires off several methods.

A delegate OBJECT encapsulates a reference to a METHOD. In C++ they were REFERRED to as function pointers.

A delegate object encapsulates a reference to a method. In C++ they were referred to as function pointers.

Well, if at that POINT you KNOW that an error has occurred, then why not write the proper code to HANDLE that error instead of passing a new Exception object to the catch block? Throwing your own EXCEPTIONS signifies some DESIGN flaws in the project.

Well, if at that point you know that an error has occurred, then why not write the proper code to handle that error instead of passing a new Exception object to the catch block? Throwing your own exceptions signifies some design flaws in the project.

No,

once the proper catch CODE fires off, the CONTROL is TRANSFERRED to the finally BLOCK (if there are any), and then WHATEVER follows the finally block.

No,

once the proper catch code fires off, the control is transferred to the finally block (if there are any), and then whatever follows the finally block.

A CATCH BLOCK that catches the exception of type System.Exception. You can also omit the PARAMETER data type in this CASE and just write catch {}.

A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

Yes.

Yes.