1. What is Command?
Ans: We use this object to execute SQL command and Store Procedure.
Sqlcommand cmd = new Sqlcommand(query)
Alternatively to use a storeprocedure………
qlcommand cmd = new Sqlcommand(query,con)
cmd.commandtype = commandtype.storeprocedure;
However dataset cannot directly retrieve data from database. Data Adapter are used to link Database with dataset.
4. What is Data Adapter?
Ans: Data is transferred to and from database through data adapter.
Two types:
a. Sqldataadapter
b. Oledbdataadapter
Some important properties of data adapter:
a. Select command
b. Insert Command
c. Update command
d. Delete command
e. Fill()
f. Update()
5. What is Data Reader?
Ans: Data Reader is used to retrieve the data from the database in a read only and forward only mode.
Data Reader uses connection object to connect to the database.
6. What is Data Provider?
Ans: Data provider is used for connecting to the database, retrieving data, storing data in dataset, reading the retrieve data, and updating the database.
1. OleDataProvider
2. SQL Data Provider
.
7. What are the components of .NET Data Provider?
Ans: 1.Connection Object
2. Data Reader Object
3. Data Adapter Object
4. Command object
4.1 Execute Non Query(): Execute Non-select command such as SQL command that INSERT, UPDATE, DELETE RECORD.
The return value indicates the number of rows affected by this command.
4.2 Execute Reader(): Executes a SELECT query and return a data reader object.
4.3 Execute Scalar(): Execute a SELECT query and returns the value of the first field of the first row.
8. What is Event?
Ans: When a action is performed, this action is notice by computer application. This action is known as Event.
9. What is Delegate?
Ans: Delegate is like a function pointer but they are secure and type safe. Delegate instance encapsulate a static or instance object
10. What is Serialization?
Ans: Serialization is the process of converting object into stream of bytes.
DOT NET has two serialization:
a. XML Serialization
b. BINARY Serialization
Ans: We use this object to execute SQL command and Store Procedure.
Sqlcommand cmd = new Sqlcommand(query)
Alternatively to use a storeprocedure………
qlcommand cmd = new Sqlcommand(query,con)
cmd.commandtype = commandtype.storeprocedure;
2. What is Disconnector Data Architecture?
Ans: Ado.Net uses Disconnector Data Architecture. Application connect to the database only while retriving and updating data. After the data are retrived, the connection with original data source(database) is closed. When the database needs to update, then the connection is reopen.
3. What is Dataset?
Ans: In ADO.NET, dataset is the most common method of accessing data from the database.However dataset cannot directly retrieve data from database. Data Adapter are used to link Database with dataset.
4. What is Data Adapter?
Ans: Data is transferred to and from database through data adapter.
Two types:
a. Sqldataadapter
b. Oledbdataadapter
Some important properties of data adapter:
a. Select command
b. Insert Command
c. Update command
d. Delete command
e. Fill()
f. Update()
5. What is Data Reader?
Ans: Data Reader is used to retrieve the data from the database in a read only and forward only mode.
Data Reader uses connection object to connect to the database.
6. What is Data Provider?
Ans: Data provider is used for connecting to the database, retrieving data, storing data in dataset, reading the retrieve data, and updating the database.
1. OleDataProvider
2. SQL Data Provider
.
7. What are the components of .NET Data Provider?
Ans: 1.Connection Object
2. Data Reader Object
3. Data Adapter Object
4. Command object
4.1 Execute Non Query(): Execute Non-select command such as SQL command that INSERT, UPDATE, DELETE RECORD.
The return value indicates the number of rows affected by this command.
4.2 Execute Reader(): Executes a SELECT query and return a data reader object.
4.3 Execute Scalar(): Execute a SELECT query and returns the value of the first field of the first row.
8. What is Event?
Ans: When a action is performed, this action is notice by computer application. This action is known as Event.
Ans: Delegate is like a function pointer but they are secure and type safe. Delegate instance encapsulate a static or instance object
10. What is Serialization?
Ans: Serialization is the process of converting object into stream of bytes.
DOT NET has two serialization:
a. XML Serialization
b. BINARY Serialization
| Previous | Next |
:: Click the links below for similar type Questions and answers ::
Posted in: 
4 comments:
It's very nice blog,keep update at
.Net Online Course Bangalore
Super Blog, When i was read this blog i learnt lot of things & its truly have good stuff related to developing technology, Thank you so much for sharing this blog. Keep doing more blog like this.
Dot Net Training in Chennai
Java Training Institute in Chennai
PHP Course in Chennai
Software Testing Training in Chennai
Post a Comment