ADO.NET interview questions


Total available count: 25
Subject - Microsoft Technologies
Subsubject - ADO.NET

Explain about SqlCommand.CommandTimeout property?

CommandTimeout property is used to get or set the time duration to execute the command with out Timeout error.

SqlCommand cmd = new SqlCommand("SPName",Connection);
cmd.CommandTimeout = 5; //Time in seconds
//Default timeout time is 30 seconds.

 




Next 5 interview question(s)

1
Explain differences between Dataset and Datareader?
2
Explain the methods of DataAdapter.Update() and DataSetAcceptChanges()?
3
Explain the steps to access the database in ADO.NET?
4
How can a user determine which SQL commands are part of a transaction?
5
How to connect a database through SqlConnection?


Comments