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
What are the two fundamental objects in ADO.NET?
2
What is Diffgram in ADO.NET? When do we use Diffgram?
3
What is the importance of ExecuteNonQuery, ExecuteReader and ExecuteScalar methods in SqlCommand?
4
What is the purpose of database transactions?
5
Explain differences between Dataset and Datareader?

Comments