What is Access Modifier?

Objects in .NET are created from a class, struct, etc.  These definitions, as well as the properties, methods, or events within them, use an access modifer that determines who can access it.  A class or structure outside of the current class definition or even the in different projects have different access rights depending on the type of accessor used.  Take a look at the accessors below:
Access modifiers determine the extent to which a variable or method can be accessed from another class or object

The following five accessibility levels can be specified using the access modifiers

    * Private
    * Protected
    * Internal
    * Protected internal
    * Public 
public
This makes the member visible globally
Eg. class Gremlin { public Gremlin spawn() { return new Gremlin(); } }

protected
This makes the member visible to the current class and to child classes.  Protected members are only accessible in the same class or through inherited classes.
Eg. class ParentClass { protected int valueA; }
class ChildClass { public void doSomething() { valueA = 3; } }

private
This makes the member visible only to the current class.
Eg. class MyCollection { private int lastIndex; }

internal / Friend
This makes the member visible within the same assembly.
Eg. internal class ProprietaryStuff { }

protected internal / Protected Friend
A combination of protected and internal.  This makes the member visible within the same assembly and also makes the member visible to an inheriting class. An inheriting class does not need to be in the same assembly to access the member.
***********************************************************************************

Dotnet Framework Interview Questions for 1 Year Experience:

1. What is CLR and it's functions?
2. How memory is managed in Dotnet applications?
Hint: Automatically by Garbage collector
3. What is an assembly?
4. What is a strong name?
5. What is MSIL?

C# Interview Questions for 1 Year Experience:

1. What are the 4 pillars of Object Oriented Programming?
2. What is a Class? What is an Object?
3. What is a partial class?
4. What is a sealed class?
5. What is constructor?
6. What is stringbuilder?

ADO.Net Interview Questions for 1 Year Experience:

1. What is connection string?
2. What is Datareader?
3. Difference between Dataset and datareader?
4. What is Ado.Net?
5. Namespace for using sqlserver database?

ASP.Net Interview Questions for 1 Year Experience:

1. What is web.config file and it's use?
2. What is global.asax?
3. What is session?
4. Which all controls you have used in your project?
5. What is gridview?
6. What is Authentication in ASP.Net and types of authentication?

SQL Server Interview Questions for 1 Year Experience:

1. What is Primary key, unique key and difference between them?
2. What is index? Types of index?
3. What is a stored procedure? Why it is better than inline query?
Hint: Stored Procedure is precompiles and has a execution plan. Hence faster execution.
4. You might be asked to write simple query
5. What is inner join

Basic .NET, ASP.NET, OOPS and SQL Server Interview questions and answers.

• What is IL code, CLR, CTS, GAC & GC?
• How can we do Assembly versioning?
• can you explain how ASP.NET application life cycle and page life cycle events fire?
• What is the problem with Functional Programming?
• Can you define OOP and the 4 principles of OOP?
• What are Classes and Objects?
• What is Inheritance?
• What is Polymorphism, overloading, overriding and virtual?
• Can you explain encapsulation and abstraction?
• What is an abstract class?
• Define Interface & What is the diff. between abstract & interface?
• What problem does Delegate Solve ?
• What is a Multicast delegate ?
• What are events and what's the difference between delegates and events?
• How can we make Asynchronous method calls using delegates ?
• What is a stack, Heap, Value types and Reference types ?
• What is boxing and unboxing ?
• Can you explain ASP.NET application and Page life cycle ?
• What is Authentication, Authorization, Principal & Identity objects?
• How can we do Inproc and outProc session management ?
• How can we windows , forms and passport authentication and authorization in ASP.NET ?
• In a parent child relationship which constructor fires first ?

• How to create a simple "Hello World" using ASP.NET MVC template? - Lab 1
• How to pass data from controller to views? - Lab 2
• Can we see a simple sample of model using MVC template? - Lab 3
• How can we create simple input screens using MVC template? - Lab 4
• How can we create MVC views faster and make them strong typed by using HTML helper? - Lab 5
• Can we see how easy it is do unit testing for MVC application? - Lab 6
• What is MVC routing? - Lab 7
• How can we set default values & validate MVC routes? - Lab 8
• How we can define actions & navigate from one page to other page? - Lab 9

• What is SOA, Services and Messages ?
• What is the difference between Service and Component?
• What are basic steps to create a WCF service ?
• What are endpoints, address, contracts and bindings?
• What are various ways of hosting WCF service?
• What is the difference of hosting a WCF service on IIS and Self hosting?
• What is the difference between BasicHttpBinding and WsHttpBinding?
• How can we do debugging and tracing in WCF?
• Can you explain transactions in WCF (theory)?
• How can we self host WCF service ?
• What are the different ways of implementing WCF Security?
• How can we implement SSL security on WCF(Transport Security)?
• How can we implement transport security plus message security in WCF ?
• How can we do WCF instancing ?
• How Can we do WCF Concurency and throttling?
• Can you explain the architecture of Silverlight ?
• What are the basic things needed to make a silverlight application ?
• How can we do transformations in SilverLight ?
• Can you explain animation fundamentals in SilverLight?
• What are the different layout methodologies in SilverLight?
• Can you explain one way , two way and one time bindings?
• How can we consume WCF service in SilverLight?
• How can we connect databases using SilverLight?
• What is LINQ and can you explain same with example?
• Can you explain a simple example of LINQ to SQL?
• How can we define relationships using LINQ to SQL?
• How can we optimize LINQ relationships queries using ‘DataLoadOptions’?
• Can we see a simple example of how we can do CRUD using LINQ to SQL?
• How can we call a stored procedure using LINQ?
• What is the need of WPF when we had GDI, GDI+ and DirectX?
• Can you explain how we can make a simple WPF application?
• Can you explain the three rendering modes i.e. Tier 0 , Tier 1 and Tier 2?
• Can you explain the Architecture of WPF?
• What is Azure?
• Can you explain Azure Costing?
• Can we see a simple Azure sample program?
• What are the different steps to create a simple Worker application?
• Can we understand Blobs in steps, Tables & Queues ?
• Can we see a simple example for Azure tables?
• What is Package and One click deploy(Deployment Part - 1) ?
• What is Web.config transformation (Deployment Part-2)?
• What is MEF and how can we implement the same?
• How is MEF different from DIIOC?
• Can you show us a simple implementation of MEF in Silverlight ?

• Introduction
• Factory Design Pattern
• Abstract Factory Design Pattern
• Builder Design Pattern
• Prototype Design Pattern
• Singleton Design Pattern
• Adapter Design Pattern
• Bridge Design Pattern
• Composite Design Pattern
• Decorator Design Pattern
• Facade Design Pattern
• Flyweight Design Pattern
• Proxy Design Pattern
• Mediator Design Pattern
• Memento Design Pattern
• Interpreter Design Pattern
• Iterator Design Pattern
• COR Design Pattern
• Command Design Pattren
• State Design Pattern
• Strategy Design Pattern
• Observer Design Pattern
• Template Design Pattern
• Visitor Design Pattern
• Dependency IOC Design pattern
• MVC , MVP , DI IOC and MVVM Training / Interview Questions and Answers

• Introduction
• Use Case Diagrams
• Class Digrams
• Object Diagrams
• Sequence Digrams
• Collaboration Diagrams
• Activity Diagram
• State chart Diagrams
• Component Diagrams
• Deployment Diagrams
• Stereo Types Diagrams
• Package Diagram and UML Project Flow.

• Introduction
• Application Boundary
• EI Fundamentals
• EO Fundamentals
• EQ Fundamentals
• EIF
• Fundamentals
• ILF Fundamentals
• GSC Fundamentals
• Productivity Factor
• Costing and a complete estimation of customer screen using function points.
• FXCOP and Stylecop Training / Interview Questions and Answers

• VSTS questions and answer videos
• What is Unit Testing & can we see an example of the same?
• How can we write data driven test using NUNIT & VS Test?
• Can we see simple example of a unit test for database operation?
• How can we do automated testing using Visual Studio Test?
• How can we do Load Testing using VSTS test?
• Can you explain database unit testing?
• How can we do test coverage using VSTS system?
• How can we do manual Testing using VSTS?
• What is Ordered Test in VSTS test?

• Introduction
• Validation Application Block
• Logging Application Block
• Exception error Handling
• Data Application Block
• Caching Application Block
• Security Application Block
• Policy Injection Application Block and
• Unity Application Block

• Introduction to .NET Projects
• Different levels of Programming
• Necessary Tools
• What should we learn ?
• The IIS
• Making UI using .net IDE
• Database, The SQL Server
• Connecting ASP.net with Database
• Loading the Data Grid
• Update and Delete
• Validations
• Issue with the Code
• Two Tier Architecture
• Three Tier Architecture
• Database Normalization
• Session and State Management
• Using Enterprise Application Block
• Aggregation and Composition
• Implementing Interfaces and Factory
• Inheritance relationship
• Abstract Class Implementation

• What is SharePoint, WSS and MOSS?
• How does WSS actually work?
• What is Site and SiteCollection?
• What is the use of SQL server in SharePoint & use of Virtual path provider?
• What is Ghosting and UnGhosting in SharePoint?
• How can we create a site in SharePoint?
• How can we Customize a SharePoint Site?
• What kind of readymade functional modules exists collaboration?
• Can you display a simple Custom Page in SharePoint?
• How can we implement behind code ASPX pages in SharePoint?
• What is the concept of features in SharePoint?
• I want a feature to be only displayed to admin?
• How do we debug SharePoint error’s?
• Why customized pages are parsed using no-compile mode?
• Can you explain WSS model?
• How can we use custom controls in SharePoint?
• How can we display ASCX control in SharePoint pages?
• What are Web Parts?
• How can we deploy a simple Webpart in SharePoint?
• How can we achieve customization and personalization using WebParts?
• How can we create custom editor for WebPart?
• SharePoint is about centralizing documents, how similar is to the windows folder?
• What are custom fields and content types?
• Can you explain SharePoint Workflows?
• What is a three-state Workflow in SharePoint?
• How can we create sharepoint workflow using sharepoint designer?

• Basics :- Query plan, Logical operators and Logical reads
• Point 1 :- Unique keys improve table scan performance.
• Point 2 :- Choose Table scan for small & Seek scan for large records
• Point 3 :- Use Covering index to reduce RID (Row Identifier) lookup
• Point4:- Keep index size as small as possible.
• Point5:- use numeric as compared to text data type.
• Point6:- use indexed view for aggregated SQL Queries
• Finding high memory consuming functions
• Improve garbage collector performance using finalize/dispose pattern
• How to use performance counters to gather performance data

Common Questions
Difference between asp and asp.net
- How do you do exception management
- If you are using components in your application, how can you handle exceptions raised in a component
- Can we throw exception from catch block
- How do you relate an aspx page with its code behind page
- What are the types of assemblies and where can u store them and how
- What is difference between value and reference types
- Is array reference type / value type
- Is string reference type / value type
- What is web.config. How many web.config files can be allowed to use in an application
- What is differnce between machine.config and web.config
- What is shared and private assembly
- What are asynchronous callbacks
- How to write unmanaged code and how to identify whether the code is managed / unmanaged.
- How to authenticate users using web.config
- What is strong name and which tool is used for this
- What is gacutil.exe. Where do we store assemblies
- Should sn.exe be used before gacutil.exe
- What does assemblyinfo.cs file consists of
- What is boxing and unboxing
- Types of authentications in ASP.NET
- difference between Trace and Debug
- Difference between Dataset and DataReader
- What is custom tag in web.config
- How do you define authentication in web.Config
- What is sequence of code in retrieving data from database
- About DTS package
- What provider ADO.net use by default
- Where does web.config info stored? Will this be stored in the registry?
- How do you register the dotnet component or assembly?
- Difference between asp and asp.net
- Whis is stateless asp or asp.net?
- Authentication mechanism in dotnet
- State management in asp.net
- Types of values mode can hold session state in web.config
- About WebService
- What are Http handler
- What is view state and how this can be done and was this there in asp?
- Types of optimization and name a few and how do u do?
- About DataAdapters
- Features of a dataset
- How do you do role based security
- Difference between Response.Expires and Expires.Absolute
- Types of object in asp
- About duration in caching technique
- Types of configuration files and ther differences
- Difference between ADO and ADO.net
- About Postback
- If you are calling three SPs from a window application how do u check for the performance of the SPS

#61607; Database

- What is normalization
- What is an index and types of indexes. How many number of indexes can be used per table
- What is a constraint. Types of constraints
- What are code pages
- What is referential integrity
- What is a trigger
- What are different types of joins
- What is a self join
- Authentication mechanisms in Sql Server
- What are user defined stored procedures.
- What is INSTEAD OF trigger
- Difference between SQL server 7.0 and 2000
- How to optimize a query that retrieves data by joining 4 tables
- Usage of DTS
- How to disable an index using select query
- Is non-clustered index faster than clustered index
- Types of optimization in querries
- Difference between ISQL and OSQL
- How you log an exception directly into sql server what is used for this
- About Replication in Database
- What is the default optimization done in oracle and sql server
- How can i make a coulmn as unique
- How many no of tables can be joined in same sql server
- How many coulmns can exist per table
- About Sql Profiler usage

• HR & Project

- About yourself
- About work experience
- How long you are working on .NET
- Are you willing to relocate
- When will you join
- Why do u what to change from current organization
- Why do you want to join Accenture
- What are your weaknesses / areas of improvement
- What is your current project and your responsibilities
- Have you done database design / development
- What is D in ACID

#61656; Microsoft

• HR (Screening)
- Tell about yourself
- Tell about your work experience
- Tell about projects
- Tell about your current project and your role in it
- What is your current salary p.a.

• Technical

#61607; .NET
- How do you manage session in ASP and ASP.NET
- How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode.
- What are different authentication types. How do you retreive user id in case of windows authentication
- For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this.
- What is custom control. What is the difference between custom control and user control
- What is the syntax for datagrid and specifying columns
- How do you add a javascript function for a link button in a datagrid.
- Does C# supports multi-dimensional arrays
- How to transpose rows into columns and columns into rows in a multi-dimensional array
- What are object oriented concepts
- How do you create multiple inheritance in C#
- ADO and ADO.NET differences
- Features and disadvantages of dataset
- What is the difference between and ActiveX dll and control
- How do you perform validations
- What is reflection and disadvantages of reflection
- What is boxing and how it is done internally
- Types of authentications in IIS
- What are the security issues if we send a query from the application
- Difference between ByVal and ByRef
- Disadvantages of COM components

- How do we invoke queries from the application
- What is the provider and namespaces being used to access oracle database
- How do you load XML document and perform validation of the document
- How do you access elements in XML document
- What is ODP.NET
- Types of session management in ASP.NET
- Difference between datareader and dataset
- What are the steps in connecting to database
- How do you register a .NET assembly
- Usage of web.config
- About remoting and web services. Difference between them
- Caching techniques in .NET
- About CLS and CTS
- Is overloading possible in web services
- Difference between .NET and previous version
- Types of chaching. How to implement caching
- Features in ASP.NET
- How do you do validations. Whether client-side or server-side validations are better
- How do you implement multiple inheritance in .NET
- Difference between multi-level and multiple inheritance
- Difference between dataset and datareader
- What are runtime hosts
- What is an application domain
- What is viewstate
- About CLR, reflection and assemblies
- Difference between .NET components and COM components
- What does assemblyinfo.cs consists
- Types of objects in ASP

#61607; Database

- What are the blocks in stored procedure
- How do you handle exceptions. Give the syntax for it
- What is normalization and types of normalization
- When would you denormalize
- Difference between a query and strored procedure
- What is clustered and non-clustered indexes
- Types of joins
- How do you get all records from 2 tables. Which join do you use
- Types of optimization
- Difference between inline query and stored procedure

#61607; Project related
- Tell about your current project
- Tell about your role
- What is the toughest situation you faced in the development
- How often you communicate with the client
- For what purposes, you communicate with the client
- What is the process followed
- Explain complete process followed for the development
- What is the life cycle model used for the development
- How do communicate with team members
- How do you say you are having excellent team management skills
- If your client gives a change and asks for early delivery. How will you manage.
- How will gather requirements and where do you record. Is it in word / Excel or do you have any tool for that
- What is the stage when code is delivered to the client and he is testing it.
- What are the different phases of SDLC
- How do you handle change requests
- How do you perform impact analysis
- How do you write unit test cases.
- About current project architecture

#61656; Keane on 12th October 2003

• Technical

#61607; .NET
- Write steps of retrieving data using ado.net
- Call a stored procedure from ado.net and pass parameter to it
- Different type of validation controls in asp.net
- Difference between server.Execute and response.redirect
- What is Response.Flush method
- How Response.flush works in server.Execute
- What is the need of clinet side and server side validation
- Tell About Global.asax
- What is application variable and when it is initialized
- Tell About Web.config
- Can we write one page in c# and other in vb in one application
- When web.config is called
- How many web.config a application can have
- How do you set language in web.cofig


#61607; Database
- How do you rate yourrself in oracle and sql server
- What is E-R diagram
- Draw E-R diagram for many to many relationship
- Design databaseraw er diagram for a certain scenario(many author many books)
- Diff between primary key and unique key
- What is Normalization
- Difference between sub query and nested query
- Indexes in oracle
- Querry to retrieve record for a many to many relationship
- Querry to get max and second max in oracle in one querry
- Write a simple Store procedure and pass parameter to it

#61656; Digital Globalsoft

• Technical

#61607; .NET
- Difference between VB dll and assemblies in .NET
- What is machine.config and web.config
- Tell about WSDL
- About web methods and its various attributes
- What is manifest
- Types of caching
- What does connection string consists of
- Where do you store connection string
- What is the difference between session state and session variables
- How do you pass session values from one page to another
- What are WSDL ports
- What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET
- What is abstract class
- What is difference between interface inheritance and class inheritance
- What are the collection classes
- Which namespace is used for encryption
- What are the various authentication mechanisms in ASP.NET
- What is the difference between authentication and autherization
- What are the types of threading models
- How do you send an XML document from client to server
- How do you create dlls in .NET
- What is inetermediate language in .NET
- What is CLR and how it generates native code
- Can we store PROGID informatoin in database and dynamically load the component
- Is VB.NET object oriented? What are the inheritances does VB.NET support.
- What is strong name and what is the need of it
- Any disadvantages in Dataset and in reflection
- Advantage of vb.net over vb
- What is runtime host
- How to send a DataReader as a parameter to a remote client
- How do you consume a webservice
- What happens when a reference to webservice is added
- How do you reference to a private & shared assembly
- What is the purpose of System.EnterpriseServices namespace
- About .Net remoting
- Difference between remoting and webservice
- Types of statemanagement techniques
- How to register a shared assembly
- About stateless and statefull webservice
- How to invoke .net components from com components,give the sequence
- How to check null values in dataset
- About how soap messages are sent and received in webservice
- Error handling and how this is done
- Features in .net framework 1.1
- Any problem found in vs.et
- Optimization technique description
- About disco and uddi
- What providers does ado.net uses internally
- Oops concepts
- Disadvantages of vb
- XML serialization
- What providers do you use to connect to oracle database?

#61607; Database
- Types of joins

#61607; General
- What are various life cycle model in S/W development

#61656; Infosys

• Technical

#61607; .NET
- How do you rate yourself in .NET
- What is caching and types of caching
- What does VS.NET contains
- What is JIT, what are types of JITS and their pupose
- What is SOAP, UDDI and WSDL
- What is dataset

#61607; Database
- How do you optimize SQL queries

#61607; General
- Tell about yourself and job
- Tell about current project
- What are sequence diagrams, collaboration diagrams and difference between them
- What is your role in the current project and what kinds of responsibilites you are handling
- What is the team size and how do you ensure quality of code
- What is the S/W model used in the project. What are the optimization techniques used. Give examples.
- What are the SDLC phases you have invloved

#61656; Satyam

• Technical

#61607; .NET
- Types of threading models in VB.net
- Types of compatability in VB and their usage
- Difference between CDATA and PCDATA in XML
- What is Assync in XML api which version of XML parser u worked with
- Types of ASP objects
- Difference between application and session
- What is web application virtual directory
- Can two web application share a session and application variable
- If i have a page where i create an instance of a dll and without invoking any method can I send values to next page
- Diffeernce between Active Exe and /Dll
- Can the dictionary object be created in client’s ccope?
- About MTS and it’s purpose
- About writting a query and SP which is better
- I have a component with 3 parameter and deployed to client side now i changed my dll method which takes 4 parameter.How can i deploy this without affecting the clent’s code
- How do you do multithreading application in VB
- About Global .asax
- Connection pooling in MTS
- If cookies is disabled in clinet browser will session work
- About XLST
- How do you attach an XSL to an XML in presenting output
- What is XML
- How do you make your site SSL enabled
- Did you work on IIS adminisdtration
-
#61607; Database
- dd
#61607; General
- dd
• HR
- About educational background
- About work experience
- About area of work
- Current salary, why are looking for a change and about notice period
- About company strength, verticals, clients, domains etc.
- Rate yourself in different areas of .NET and SQL

#61656; Cognizent

• Technical

#61607; .NET
- About response.buffer and repsonse.flush
- About dataset and data mining
- About SOAP
- Usage of htmlencode and urlencode
- Usage of server variables
- How to find the client browser type
- How do you trap errors in ASP and how do you invoke a component in ASP
#61607; Database
- About types of indexes in SQL server
- Difference between writing SQL query and stored procedure
- About DTS usage
- How do you optimize Sql queries

#61607; General
- Dfs
- Rate yourself in .NET and SQL
- About 5 processes
- About current project and your role
• HR
- About educational background, work experience, and area of work
-


#61656; TCS

• Technical

#61607; .NET
- Define .NET architecture
- Where does ADO.NET and XML web services come in the architecture
- What is MSIL code
- Types of JIT and what is econo-JIT
- What is CTS, CLS and CLR
- Uses of CLR
- Difference between ASP and ASP.NET
- What are webservices, its attributes. Where they are available
- What is UDDI and how to register a web service
- Without UDDI, is it possible to access a remote web service
- How a web service is exposed to outside world
- What is boxing and unboxing
- What is WSDL and disco file
- What is web.config and machine.config
- What is difference between ASP and ASP.NET
- What is dataset and uses of dataset
- What does ADO.NET consists of?
- What are various authentication mechanisms in ASP.NET
- What do you mean by passport authentication and windows authentication
- What is an assembly and what does manifest consists
- What is strong name and what is the purpose of strong name
- What are various types of assemblies
- Difference between VB.NET and C#. Which is faster
- Types of caching
- How WSDL is stored
- What is the key feature of ADO.NET compared to ADO
- How does dataset acts in a disconnected fashion
- Does the following statement executes successfully:
Response.Write(“value of i = ” + i);
- What is ODP.NET
- What are the providers available with VS.NET
- What is a process
- What is binding in web service
- How a proxy is generated for a web service
- About delegates
- What are static assemblies and dynamic assemlies. Differences between them

#61607; Database
- What are the types of triggers
- Types of locks in database
- Types of indexes. What is the default key created when a primary key is created in a table
- What is clustered, non-clustured and unique index. How many indexes can be created on a table
- Can we create non-clustured index on a clustered index
- Types of backups
- What is INSTEAD OF trigger
- What is difference between triggers and stored procedures. And advantages of SP over triggers
- What is DTS and purpose of DTS
- Write a query to get 2nd maximum salary in an employee table
- Types of joins.
- What is currency type in database
- What are nested triggers
- What is a heap related to database

#61607; General

• HR
- About yourdelf
- About procsses followed
- Notice period
- Appraisal process
- What is SOAP and why it is required
- About effort estimation
- Whether salary negotiable
- Why are looking for a change
- How fo you appraise a person
- Do you think CMM process takes time
- About peer reviews
- How do you communicate with TL / PM / Onsite team

#61656; DELL
• Technical

#61607; .NET
- Any disadvantages in Dataset and in reflection
- Difference between Active Exe and Activex dll
- Can we make activex dll also ti execute in some process as that of client ? How can we do?
- Types of compatabilities and explain them
- Types of instancing properties and explain each. Tell the difference between multiuse,singleuse and globalmultiuse and which is default
- What is assembly?
- Difference between COM and .NET component
- What is early binding and Late binding. Difference which is better
- What happens when we instantiate a COM component
- What happens when we instantiate a .NET component
- Are you aware of containment and Aggregation
- What is UUID and GUID what is the size of this ID?
- About Iunknown interface Queue ,its methods Querry Interface Addref,Release and Explane each
- What ‘ll u do in early and late binding
- In early binding will the method invoked on com component will verify it’s existance in the system or not?
- Difference between dynamic query and static query
- About performance issues on retrieving records
- About ADO and its objects
- What is unmannaged code and will CLR handle this kind of code or not .
- Garbage collector’s functionality on unmanaged code
- If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?
- Threading Types.
- How about the security in Activex DLL and Activex EXE

#61607; Database
- Types of cursors and explanation each of them
- Types of cursor locations and explanation on each of them
- Types of cursor locks and explanation each of them
- How do you retrieve set of records from database server.{Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

• HR & Project

- Rate yourself in vb and com
- Whether I have any specific technology in mind to work on.


#61656; MMTTS

• Technical

#61607; .NET
- About .NET Framework
- About Assembly in .NET, types of assemblies, their difference, How to register into GAC. How to generate the strong names & its use.
- What is side by side Execution?
- What is serialization?
- Life cycle of ASP.NET page when a request is made.
- If there is submit button in a from tell us the sequence what happens if submit is clicked and in form action is specified as some other page.
- About a class access specifiers and method access specifiers.
- What is overloading and how can this be done.
- How to you declare connection strings and how to you make use of web.config.
- How many web.copnfig can exists in a web application & which will be used.
- About .NET Remoting and types of remoting
- About Virtual functions and their use.
- How do you implement Inheritance in dot net
- About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
- What does CLR do as soon as an assembly is created
- How do you retrieve information from web.config.
- How do you declare delegates and are delegates and events one and the same and explain how do you declare delegates and invoke them.
- If I want to override a method 1 of class A and in class b then how do you declare?
- What does CLR do after the IL is generated and machine language is generated .Will it look for main method
- About friend and Protected friend
- About multi level and multiple inheritance how to achieve in .net
- Sequence to connect and retrieve data from database useig dataset
- About sn.exe
- What was the problem in traditional component why side by side execution is supported in .net
- How .net assemblies are registred as private and shared assembly
- All kind of access specifiers for a class and for methods
- On ODP.net
- Types of assemblies that can be created in dotnet
- About namespaces
- OOPs concept
- More on CLR

• HR & Project
- About yourself
- About the current employer
- About expertise
- What type of job you are expecting
- What is current and expected is it negotiable
- Can you justify why r you expecting more in professional terms
- What are you looking for in Dell

Step1- Register the Crstal Report DLL (Not Need to include the DLL In Bin Folder) by using the following lines

<%@ Register Assembly="CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
    Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
Step2- Take the Crystal Report Viewer control onto the page Like this
<CR:CrystalReportViewer ID="Crv" runat="server" AutoDataBind="true" />
Step-3- Create Report: first of Create an XSD then bind the report with the XSD (here not need to create a new connection)
Step-4 Use these function to bind the report
private DataSet GetReportData()
    {
        try
        {
            DataSet dsReport = new DataSet();
            DataTable dtParent = new DataTable();
            dtParent.Columns.Add("ParentID");
            dtParent.Columns.Add("ParentName");
            for (int i = 1; i <= 3; i++)
            {
                dtParent.Rows.Add(i, "Parent " + i.ToString());
            }
            dsReport.Tables.Add(dtParent);

            DataTable dtChild = new DataTable();
            DataTable dtSubReport = new DataTable();
            dtChild.Columns.Add("ParentID");
            dtChild.Columns.Add("ClientID");
            dtChild.Columns.Add("ClientName");
            dtChild.Columns.Add("ClientAddress");
            dtChild.Columns.Add("DOB");
            dtSubReport.Columns.Add("ClientID");
            dtSubReport.Columns.Add("ProductDetails");
            for (int j = 1; j <= 3; j++)
            {
                for (int i = 21; i <= 23; i++)
                {
                    dtChild.Rows.Add(j, j.ToString() + i.ToString(), "ClientName " + i.ToString(), "ClientAddress " + i.ToString(), "DOB " + i.ToString());
                    dtSubReport.Rows.Add(j.ToString() + i.ToString(), "ProductDetails " + i.ToString());
                }
            }
            dsReport.Tables.Add(dtChild);
            dsReport.Tables.Add(dtSubReport);

            return dsReport;
        }
        catch
        {
           
            throw;
        }
    }

    private void ShowReport()
    {
        try
        {
            string ReportName = string.Empty;
            this.Title = "MMNDY:RMSC Medicines List";
            DataSet dsReport = new DataSet();
            dsReport = GetReportData();

            ReportDocument rpt = new ReportDocument();
            string path = Server.MapPath("") + "\\Reports\\GroupBylReport.rpt";
            rpt.Load(path);
            rpt.Database.Tables[0].SetDataSource(dsReport);
            rpt.SetParameterValue("Title", "My Test Report");
            rpt.SetParameterValue("DesignedBy", "Harish & Asvini");
            Crv.ReportSource = rpt;
            Crv.DataBind();
        }
        catch
        {
           
            throw;
        }
    }

This will show the report on the page.

Introduction

I noticed that there are several articles on using Web Setup projects, but no articles could be found for Windows Setup projects. So I decided to share what I know about the VS Windows Setup Projects. I will be using the RunOnlyOnceCS.exe demo app I created for another CodeProject article, as the application we are creating the setup for.

Background

Sooner or later, you need to create a setup project for an application. Personally, I am not a big fan of this type of distribution for an application. Still it has its uses. Using a setup project can be a good solution for a Windows application that has many dependencies on other assemblies / DLLs. The setup will figure out what the dependencies are for the application and automatically include them.
Note: This does not include the .NET framework.

Creating a Setup Project

This article is going to rely on screen prints since there really isn�t any code for this. The output will be a *.msi file that will install the application file(s), and add a shortcut to the desktop and to the Programs menu.
Note: if the user does not have admin rights to their box, they will not be able to run the MSI script or install new applications on their box.

After you have created a new setup project, the first thing you will want to do is change the ProductName property on the setup project to match the application you are creating the setup for. I would also suggest changing the RemovePreviousVersion property to true. This is helpful when you want to release your next version of your app through this setup project.

Next, click on the "Application folder", then right click, and click on Add/File. At this point, you will be able to add the Exe you are trying to create the setup for.
Note: if you make changes to the Exe, you will need to re-compile the setup project as well. It might be a good choice to add a setup project to your Windows project solution. Then you can choose the project output option instead of the file.
Note: if you know what a merge module is and want to add one to the setup project, you need to right click on the setup project and click Add Merge Module.
Note: you must also add any config or icon files you may need for this solution, here:

Next, I always set the Always Create for the Program Directory to true. This is done by clicking on the "Application Folder" and then going to the properties.
Note: the DefaultLocation property will always be: [ProgramFilesFolder] [Manufacturer]\[ProductName]. If you want it to be something else, this is where to change it. Notice that the solution explorer has recognized the dependency or need for the .NET Framework for this app to run.
Note: this does not mean that the setup will install the .NET re-distributable framework. That is its own setup. The setup file is around 24 MB in size and can be downloaded from here.
Note: the setup can not install a .NET application without the .NET Framework already installed.

Next, we want to create a shortcut to our application on the desktop. First, click on the "User's desktop" folder. Then right click and click on "Create New Shortcut".

Next, you will see a dialog box to choose the application you want to create a shortcut to. Go to "Application folder" and add the exe you added in the previous step.

If you click on the "User's desktop" and go to the Properties window, you will see some options. Something I normally add to the shortcut is a check to see if it already exists. This is an example of what little coding you can do in a setup project. I have turned on AlwaysCreate on the shortcut property. In doing this, I need to have a condition or I will multiply my desktop shortcuts with every new release. So I set the Transitive property to True and I set the condition to FILEEXISTS1<>"Shortcut to RunOnceOnlyCS.exe", where what is in the "" needs to match the name of the shortcut.

Note: if you want your shortcut to have your application's icon, you need to add your icon file to the "Application folder". Next, click on the shortcut you just created in your "User's desktop". There is an icon property. Click the down arrow to get the dialog box. Navigate to the "Application folder" and select the icon file you just added.
Next, if you want to create a shortcut in the Start/All Programs menu, it is very similar to creating a shortcut on the "User's desktop". First, click on the "User's programs menu", then right click and add a folder. Name the folder the same as whatever your company or manufacturer name would be. Then, click on that newly created folder and add a shortcut just like we did in the step above.

Finally, when you need to create a new setup for the next release of your application, you need to go to the setup project properties and change the version before you re-compile the setup project.

Once you click off the version property, you will get a prompt to update the GUID for the ProductCode.
Note: if you do not click the Yes button in the dialog, you must manually get a new GUID for the ProductCode for the setup to properly remove the old program and install the new program.

Note Do Not: change the UpgradeCode GUID. If you do, the user will have to uninstall the old program manually before the new version can be installed.