Write a program to show connection to Excel in ASP.NET?
OleDbConnection x;
OleDbCommand y;
OleDbDataReader z;
protected void Page_Load(object sender, EventArgs e)
{
x = new OleDbConnection(\"provider=microsoft.jet.oledb.4.0;data source=c:\\book1.xls;Extended Properties=excel 8.0\");
x.Open();
y = new OleDbCommand(\"select * from [sheet1$]\", x);
z = y.ExecuteReader();
while (z.Read())
{
Response.Write(\"<li>\");
Response.Write(z[\"ename\"]);
}
z.Close();
y.Dispose();
x.Close();
}
More interview questions and answers |
---|
|
|
How to create a SharePoint web part using File upload control.give example? |
|
What is BulletedList Control in Share Point. Give an example? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
How to create voting poll system in asp.net which allows user to see the results? |
|
|
|
|
1.Asp .net is compiled while asp is interpreted. 2.ASP is mostly written using VB Script and HTML. while asp .net can be written in C#, J# and VB etc. 3.Asp .net have 4 built in classes session , application , request response, while asp .net have more than 2000 built in classes. 4.ASP does not have any server side components whereas Asp .net have server side components such as Button , Text Box etc. 5.Asp does not have page level transaction while Asp .net have page level transaction. ASP .NET pages only support one language on a single page, while Asp support multiple language on a single page. 6.Page functions must be declared as |
|
Exception handling prevents the unusual error in the asp.net application,when apllication executed.If the exceptions are handled properly, the application will never get terminated abruptly. |
When the page is posted back to the server, the server control is recreated with the state stored in viewstate.It allows the page to save the users input on a form across postbacks. It saves all the server side values for a given control into ViewState, which is stored as a hidden value on the page before sending the page to the clients browser. |
|
Difference between Session object and Profile object in ASP.NET? |
|
What is the Default Expiration Period For Session and Cookies,and maximum size of viewstate? |
|
What is the use of Global.asax File in ASP.NET Application ? |
|
For more safty and better performance strongly typed collections are useful for the user. System.Collections.Generic having interfaces and classes which define strongly typed generic collections. |
What is GAC and name of the utility used to add an assembly into the GAC ? |
|
Whether we can use vbscript and javascript combination for validation? |
WE cant use them togather,since compiler are different. |
|
|
|
|
|
To identify the request from the browser used sessionID. SessionId value stored in a cookie. Configure the application to store SessionId in the URL for a \"cookieless\" session. |
|
|
|
What are the Session State Modes? Define each Session State mode supported by ASP.NET. |
|
For consistent layout for the pages in application used Master Pages.A single master page defines the look and feel and standard behavior that you want for all of the pages (or a group of pages) in your application.Then user create individual content pages that share all the information and lay out of a Master Page. |
What are the 2 important parts of a master page and file extension for a Master Page? |
|
How do you identify a Master Page and how do you bind a Content Page to a Master Page? |
|
|
From the content page code how can you reference a control on the master page? |
|
|
What are the 3 different ways to globalize web applications? |
|
What are the steps to follow to get user\'s culture at run time? |
|
Neutral cultures represent general languages, such as English or Spanish and a specific language and region.ASP.NET assigns that culture to all the threads running for that Web application.When user set culture attribute for a Web application in Web.config.ASP.NET maintains multiple threads for a Web application within the aspnet_wp.exe worker process. |
What is the advantage of using Windows authentication in a Web application? |
|
What is the default authentication method when you create a new Web application project? |
Windows authentication is the default authentication method when you create a new Web application project. |
|
|
Can you specify authorization settings both in Web.config and in IIS? |
Yes,It wil be done. For this, the IIS setting is evaluated first and then the setting in Web.config is evaluated. Hence we can say,the most restrictive setting will be used. |
|
|
|
Explain the difference between a database administrator and a data administrator. |
What is the difference between Server.Transfer and Response.Redirect? |
|
Can you explain the difference between an ADO.NET Dataset and an ADO Recordset? |
|
When you want to inherit (use the functionality of) another class. Base Class Employee. A Manager class could be derived from the Employee base class. |
No, You have to use Server.Transfer to pass the data to another page. |
Store global information about the application |
When you have a complex control, like DataGrid, writing an event processing routine for each object (cell, button, row, etc.) is quite tedious. The controls can bubble up their eventhandlers, allowing the main DataGrid event handler to take care of its constituents. |
Inline code written along side the html in a page. Code-behind is code written in a separate file and referenced by the .aspx page. |
Which method do you invoke on the DataAdapter control to load your generated dataset with data? |
The .Fill() method |
No, it just reads the information from its data source |
Which template must you provide, in order to display data in a Repeater control? |
ItemTemplate |
How can you provide an alternating color scheme in a Repeater control? |
Use the AlternatingItemTemplate |
You must set the DataSource property and call the DataBind method. |
ControlToValidate property and Text property |
Where does the Web page belong in the .NET Framework class hierarchy? |
System.Web.UI.Page |
System.Web.UI.Page.Culture |
This is where you can set the specific variables for the Application and Session objects. |
What is the transport protocol you use to call a Web service? |
SOAP is the preferred protocol. |
The webservice comes with a test page and it provides HTTP-GET method to test. |
|
The references go on the stack, while the objects themselves go on the heap. However, in reality things are more elaborate. |
The value-type variables are not garbage-collected, they just fall off the stack when they fall out of scope, the reference-type objects are picked up by GC when their references go null. |
aASP.NET uses the global.asax to establish any global objects that your Web application uses. The .asax extension denotes an application file rather than .aspx for a page file. Each ASP.NET application can contain at most one global.asax file. The file is compiled on the first page hit to your Web application. ASP.NET is also configured so that any attempts to browse to the global.asax page directly are rejected. However, you can specify application-wide settings in the web.config file. The web.config is an XML-formatted text file that resides in the Web sites root directory. Through Web.config you can specify settings like custom 404 error pages, authentication and authorization settings for the Web site, compilation options for the ASP.NET Web pages, if tracing should be enabled, etc |
The Simple Object Access Protocol (SOAP) uses XML to define a protocol for the exchange of information in distributed computing environments. SOAP consists of three components: an envelope, a set of encoding rules, and a convention for representing remote procedure calls. Unless experience with SOAP is a direct requirement for the open position, knowing the specifics of the protocol, or how it can be used in conjunction with HTTP, is not as important as identifying it as a natural application of XML. |
Using XSLT, how would you extract a specific attribute from an element in an XML document? |
Successful candidates should recognize this as one of the most basic applications of XSLT. If they are not able to construct a reply similar to the example below, they should at least be able to identify the components necessary for this operation: xsl:template to match the appropriate XML element, xsl:value-of to select the attribute value, and the optional xsl:apply-templates to continue processing the document. |
|
What is typical about a Windows process in regards to memory allocation? |
|
Explain what relationship is between a Process, Application Domain, and Application? |
A process is an instance of a running application. An application is an executable on the hard drive or network. There can be numerous processes launched of the same application (5 copies of Word running), but 1 process can run just 1 application. |
Define the possible implementations of distributed applications in .NET? |
|
Give your idea when deciding to use .NET Remoting or ASP.NET Web Services? |
|
Do you know the proxy of the server object in .NET Remoting? |
|
|
Channels represent the objects that transfer the other serialized objects from one application domain to another and from one computer to another, as well as one process to another on the same box. A channel must exist before an object can be transferred. |
None. |
|
|
How can you automatically generate interface for the remotable object in .NET? |
Use the Soapsuds tool. |
System.Object. |
Difference between System.String and System.Text.StringBuilder classes? |
|
Difference between the System.Array.Clone() and System.Array.CopyTo()? |
The Clone() method returns a new array (a shallow copy) object containing all the elements in the original array. The CopyTo() method copies the elements into another existing array. Both perform a shallow copy. A shallow copy means the contents (each array element) contains references to the same object as the elements in the original array. A deep copy (which neither of these methods performs) would create a new instance of each element\'s object, resulting in a different, yet identacle object. |
What is the .NET collection class that allows an element to be accessed using a unique key? |
HashTable. |
A sorted HashTable. |
How to prevent your class from being inherited by another class? |
|
How to allowed a class to be inherited, but it must be prevent the method from being over-ridden? |
Just leave the class public and make the method sealed. |
|
|
Interfaces, like classes, define a set of properties, methods, and events. But unlike classes, interfaces do not provide implementation. They are implemented by classes, and defined as separate entities from classes. |
How to Specify the accessibility modifier for methods inside the interface? |
|
What is the difference between an interface and abstract class ? |
|
Tell me implicit name of the parameter that gets passed into the set property of a class? |
|
|