|
What is difference between ExecuteReader, ExecuteNonQuery and ExecuteScalar?
|
- ExecuteReader : Use for accessing data. It provides a forward-only, read-only, connected recordset.
- ExecuteNonQuery : Use for data manipulation, such as Insert, Update, Delete.
- ExecuteScalar : Use for retriving 1 row 1 col. value., i.e. Single value. eg: for retriving aggregate function. It is faster than other ways of retriving a single value from DB.
|
|
|
|
|
|
|
|
What is the default maximum size of the file that can be uplaoded by the ASP.Net application.
|
|
4096 KB (4MB)
|
|
|
|
|
|
|
|
Can I lock a configuration setting so that a Web.config file that appears lower in the hierarchy cannot override it?
|
|
Yes. By setting the location element Override attribute to false, you can lock a specific setting so that it does not inherit settings from below.
|
|
|
|
|
|
|
|
How are ASP.Net configuration files secured against unauthorized access?
|
|
ASP.Net configures IIS to deny access to any user that requests access to the Machine.config or Web.config files.
|
|
|
|
|
|
|
|
Where are the ASP.Net configuration files stored?
|
|
System-wide configuration settings and some ASP.NET schema settings are stored in a file named Machine.config, which is located in the %SystemRoot%\Microsoft .NET\Framework\versionNumber\CONFIG directory. This directory also contains other default settings for ASP.NET Web applications in a file that is referred to as the root Web.config file. ASP.NET configuration files for individual Web sites and applications, which are also named Web.config files, can be stored in any Web site root directory, application root directory, application subdirectory, or all of these.
|
|
|
|
|
|
|
|