How to Access Microsoft Access database through AccessDataSource control easily

By // No comments:
Hi Friend,Today we will learn about AccessDataSource control in asp.net.The AccessDataSource control is used to access the data from the Microsoft Access Database File in asp.net.This control is very helpful to configure the connection with Microsoft Access Database . There is no need to write the c# or html codes for connections.This control creates the connection codes automatically.So you have to no worry about the c# codes.You can see the connection codes in Source file.
Here i have already configure the SqlDataSource Control as given in below link.
There are some steps to implement this whole concepts as given  below:-
3

How to draw different charts graphs using the chart control on asp.net website

By // No comments:
Hi Friend, Today,we will learn "how to display the database records on chart control".This chart includes different type of charts as pie,line,bar ,area etc.Here you can display your database records in different charts (pie,line,bar ,area etc).You can choose your chart type ,in which you want draw your graph.I have already displayed the records in different charts using Ajax Technology.You can learn it by following links as given below:-
There are some steps to implement this whole concepts as given below:-
Step 1:-First create a table(Goods Details) in your sql database and insert some values also as show below:-
3

How to use PagingBulletedListExtender Control on ASP.NET Web Page Easily

By // No comments:
The PagingaBulletedListExtender Control is used to display the different contents in the form of the bulleted list on the indices clicked.It provides client-side sorted paging.In this you can specify the number of characters that you want to use for creating heading indices or maximum number of items to display per index.This control uses page able  grid control to page through the items of the BulletedList control.This extender control is useful when the web page contains a long list of items.this control is helpful to organize all the bound items in pages and displays links of each of them. This control is every helpful in paging so we have to know about it in detail. before use this control You have to install Ajaxtoolkit on your visual studio first.
There are some important properties of this control as given below:-
3

Advanced c# and .NET Interview Questions and Answers Part 8

By // 1 comment:
1. ) What is a DiffGram Explain ?                                                                                              
  • A DiffGram is an XML format that is used to identify current and original versions of data elements.
  •  When sending and retrieving a DataSet from an XML Web service, the DiffGram format is implicitly used.
  • The DataSet uses the DiffGram format to load and persist its contents, and to serialize its contents for transport across a network connection. When a DataSet is written as a DiffGram, it populates the DiffGram with all the necessary information to accurately recreate the contents, though not the schema, of the DataSet, including column values from both the Original and Current row versions, row error information, and row order. 
2. ) How to use  DiffGram in xml web services ?                                                                 
  There are following way to use DiffGram in xml web Services.
<?xml version="1.0"?>
<diffgr:diffgram
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<DataInstance>
</DataInstance>

<diffgr:before>
</diffgr:before>

<diffgr:errors>
</diffgr:errors>
</diffgr:diffgram>

Descriptions:-
The DiffGram Format is divided into three sections as given below:-
1.) <DataInstance>
The name of this element, Data Instance, is used for explanation purposes in this documentation. A DataInstance element represents a DataSet or a row of a DataTable. Instead of Data Instance, the element would contain the name of the DataSet or DataTable. This block of the DiffGram format contains the current data, whether it has been modified or not. An element, or row, that has been modified is identified with the diffgr: has Changes annotation. 
2.) <diffgr:before
This block of the DiffGram format contains the original version of a row. Elements in this block are matched to elements in the DataInstance block using the diffgr:id annotation
3.) <diffgr:errors>
This block of the DiffGram format contains error information for a particular row in the DataInstance block. Elements in this block are matched to elements in the DataInstance block using the diffgr:id annotation. 
3. ) Where are the IIS log files stored ?                                                                                   
C:\WINDOWS\system32\Logfiles\W3SVC1
               OR
C:\winnt\system32\LogFiles\W3SVC1

4. ) What are the different IIS authentication modes in IIS 6.0 ?                                
There are different variety of authentication schemes of IIS.
  • Anonymous (enabled by default) authentication
  • Basic authentication
  • Digest authentication
  • Integrated Windows authentication (enabled by default) 
  • Client Certificate Mapping 
5. ) In which process does IIS (.exe file) runs ?                                                                   
inetinfo.exe is the Microsoft IIS server running, handling ASP.NET requests among other things.When an ASP.NET request is received (usually a file with .aspx extension), the ISAPI filter aspnet_isapi.dll takes care of it by passing the request to the actual worker process aspnet_wp.exe. 
6. ) What are the IIS isolation Levels ?                                                                                    
There are three isolation levels of IIS 5.0 .
  • Low(IIS Process)
  • Medium(pooled)
  • High(isolated)
7. ) How do I upload a file from my ASP.NET page ?                                                         
ReadDetails

8. ) How to send an email message from  ASP.NET page ?                                              
ReadDetails...

9. ) Can I pass SOAP messages through remoting?                                                            
Yes.
10. ) What is CAO and SAO Explain?                                                                                        
CAO means client activated Objects and SAO means Server activated objects.
  • Client Activated objects are those remote objects whose Lifetime is directly Controlled by the client. This is in direct contrast to SAO. Where the server, not the client has complete control over the lifetime of the objects. 
  • Client activated objects are instantiated on the server as soon as the client request the object to be created. Unlike as SAO a CAO doesn’t delay the object creation until the first method is called on the object. (In SAO the object is instantiated when the client calls the method on the object) 
11. ) What is singleton and singlecall Explain?                                                                     
  • Singleton types never have more than one instance at any one time. If an instance exists, all client requests are serviced by that instance.
  • Single Call types always have one instance per client request. The next method invocation will be serviced by a different server instance, even if the previous instance has not yet been recycled by the system. 
12. ) Are Web Services a replacement for other distributed computing platforms? 
No. Web Services is just a new way of looking at existing implementation platforms.

13. ) In webservice,Suppose we have to display 20 rows from a table who is best Dataset or DataReader ?
A WebService supports only Dataset. So Dataset is used,not DataReader.

Learn More .NET Interview Questions and Answers for Job Seekers
3

Readonly and Constant members in C# with Example

By // No comments:
1.) Read-only Field:-
The readonly keyword is  a modifier that you can use fields.When a field declaration includes a readonly modifier,assignments to the fields introduced by the declaration can only occur as part of the declaration or in a construction in the same class.You can learn constructor concepts more details.
You can assign a value to a readonly field only in the following way.
  • Variable can be initialized at declaration time.
           Ex. Public readonly int p=8;
  • For an instance field ,in the instance constructors of the class that contains the field declaration.
                                                                              OR
  • For a static field ,in the static constructor of the class that contains the field declaration .
  • You can also pass a readonly field as an out or ref parameter.
3

Advanced c# and .NET Interview Questions and Answers Part 7

By // No comments:
1.) How Garbage collector (GC) works in .NET ?                                                                 
In .NET,this class method influence when an object is garbage collected and when resources allocated by an object are released. Properties in this class provide information about the total amount of memory available in the system and the generation, or age category, of memory allocated to an object. Periodically, the garbage collector performs garbage collection to reclaim memory allocated to objects for which there are no valid references. Garbage collection happens automatically when a request for memory cannot be satisfied using available free memory. An application can force garbage collection using the Collect method.
There are following steps in Garbage collection as given below. 
  • The garbage collector searches for managed objects that are referenced in managed code. 
  • The garbage collector attempts to finalize objects that are not referenced. 
  • The garbage collector frees objects that are not referenced and reclaims their memory. 
3
Powered by Blogger.