blogspot visit counter

Thursday, 28 February 2013

Technical Interview technical interview question and answer

Interview Question and Answer For experience person

I think these questions are very helpful for the people who are trying to get the job on .NET The most common question for experience persons is

Why would you like to change the company?

1). I am looking for a more challenging career in a firm with a larger employee base such as yours.
2). Keeping in mind my career goals, the time has come for me to move onto the next rung of the ladder and make a mark for myself. This can be achieved in a company like this.
3). It is just a career move to enhance my knowledge in my own area of interest.After completion of this question only interview will go for further questions

Difference between stored procedure and function

1) . Procedure can return zero or n values whereas function can return one value which is mandatory.
2) . Procedures can have input, output parameters for it whereas functions can have only input parameters.
3) . Procedure allows select as well as DML statement in it whereas function allows only select statement in it.
4) .Functions can be called from procedure whereas procedures cannot be called from function.
5) .Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.
6) .We can go for transaction management in procedure whereas we can't go in function.
7) .Procedures cannot be utilized in a select statement whereas function can be embedded in a select statement.

Difference between Abstract and Interface

-Abstract class provides a set of rules to implement next class
-Rules will be provided through abstract methods
-Abstract method does not contain any definition
-While inheriting abstract class all abstract methods must be override--If a class contains at least one abstract method then it must be declared as an “Abstract Class”
-Abstract classes cannot be instantiated (i.e. we cannot create objects), but a reference can be created
-Reference depends on child class object’s memory
-Abstract classes are also called as “Partial abstract classes”
-Partial abstract class may contain functions with body and functions without body
-If a class contains all functions without body then it is called as “Fully Abstract Class” (Interface)
-If a class contains all abstract methods then that class is known as “Interface”
-Interfaces support like multiple inheritance
-In interface all methods r public abstract by default
-Interfaces r implementable
-Interfaces cannot be instantiated, but a reference can be created

Index types in SQL Server

Clustered Index
Only 1 allowed per table physically rearranges the data in the table to confirm to the index constraints for use on columns that are frequently searched for ranges of data for use on columns with low selectivity. Non-Clustered Index Up to 249 allowed per table creates a separate list of key values with pointers to the location of the data in the data pages For use on columns that are searched for single values
A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A non-clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non-clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

What is strong-typing versus weak-typing? Which is preferred? Why?

Strong typing: It checks the type of variables as soon as possible, usually at compile time. It prevents mixing operations between mismatched types.
A strong-typed programming language is one in which: All variables (or data types) are known at compile time There is strict enforcement of typing rules (a String can't be used where an Integer would be expected)
All exceptions to typing rules results in a compile time error
Weak Typing: While weak typing is delaying checking the types of the system as late as possible, usually to run-time. In this you can mix types without an explicit conversion.
A "weak-typed" programming language is simply one which is not strong-typed.
which is preferred depeneds on what you want. for scripts and good stuff you will usually want weak typing, because you want to write as much less code as possible. in big programs, strong typing can reduce errors at compile time.

What is the basic functionality of Garbage Collector in Microsft.Net?

The Common Language Runtime (CLR) requires that you create objects in the managed heap, but you do not have to bother with cleaning up the memory once the object goes out of the scope or is no longer needed. The Microsoft .NET Framework Garbage Collector provides memory management capabilities for managed resources. The Garbage Collector frees objects that are not referenced and reclaims their memory. You should set your references to Nothing(null) as soon as you are done with them to ensure your objects are eligible for collection as soon as possible.
Here are the list of some tasks performed by the Garbage collector: . Garbage collector reserves a piece of memory as the application starts for the managed heap.
. Garbage collector controls the managed heap memory currently used and available to an application.
. Garbage collector allocates memory for new objects within the application.
. The Garbage Collector attempts to reclaim the memory of objects that are not referenced.

What are differences between Array list and Hash table?

Ans: 1) Hash table store data as name, value pair. While in array only value is store.
2) To access value from hash table, you need to pass name. While in array, to access value, you need to pass index number.
3) you can store different type of data in hash table, say int, string etc. while in array you can store only similar type of data.

What are differences between system.stringbuilder and system.string?

The main difference is system.string is immutable and system.stringbuilder is a mutable. Append keyword is used in string builder but not in system.string.
Immutable means once we created we cannot modified. Suppose if we want give new value to old value simply it will discarded the old value and it will create new instance in memory to hold the new value.

What are the differences between Application object and session object?

Ans: The session object is used to maintain the session of each user.
If one user enter in to the application then they get session id if he leaves from the application then the session id is deleted.
If they again enter in to the application they get different session id.
But for application object the id is maintained for whole application.

What are the different types of indexes?

Ans: Two types of indexes are there one is clustered index and non-clustered index.

How many types of memories are there in .net?

Two types of memories are there in .net stack memory and heap memory.

Is it possible to set the session out time manually?

Yes we can set the session out time manually in web.config.

Can you Explain Page lifecycle in .net?

The life cycle starts when a user requests a web page through his/her browser. The Web server than process the page through a sequence of steps before response is sent back to the user's browser.
The steps are as: 1. Page Request
2. Start
3. Page Initialization
4. Load
5. Validation
6. PostBack Event Handling
7. Render
8. Unload
The below figure shows the Page Life Cycle of an ASP.NET and its controls
Page Request
The page request occurs before the page life cycle begins. When a user requests the page, ASP.NET determines whether the page needs to be parsed and compiled (therefore beginning the life of a page), or whether a cached version of the page can be sent in response without running the page.
In the start step, page properties such as Request and Response are set. At this stage, the page also determines whether the request is a postback or a new request and sets the IsPostBack property. Additionally, during the start step, the page's UICulture property is set.
Page Initialization
During page initialization, controls on the page are available and each control's UniqueID are generated but not their properties. Any themes are also applied to the page.
Developers have access to the Init, InitComplete and PreLoad methods in this stage. The methods are as follows:
Init: This event is raised after all controls have been initialized and any skin settings have been applied. This event is used to read or initialize control properties.
InitComplete: The Page object raises this event. This event is used for processing tasks that require completion of all initialization.
PreLoad: Use this event if you need to perform processing on your page or control before the Load event. After the Page raises this event, it loads view state for itself and all controls, and then processes any postback data included with the Request instance.
During load, if the current request is a postback, control properties are loaded with information recovered from view state and control state. The OnLoad event method is fired during this stage.
This is where you will want to set properties for all of the server controls on your page, request query strings, and establish database connections.
During validation, the Validate method of all validator controls is called, which sets the IsValid property of individual validator controls and of the page. PostBack Event Handling
If the request is a postback, any event handlers are called. The event handling for server controls occurs during this stage.
During rendering, view state is saved to the page and then the page calls on each control to contribute its rendered output to the OutputStream of the page's Response property. Render is not really an event. The HTML of the page and all controls are sent to the browser for rendering.
Unload is called when the page has been fully rendered, sent to the client, and is ready to be discarded. At this point, page properties such as Response and Request are unloaded and any cleanup is performed. The cleanup includes routines such as closing database connections and file streams, or, event logging and other tasks.
When a Web page is requested, the server creates objects associated with the page and all of its child controls objects and uses these to render the page to the browser. Once the final stage is complete, the web server destroys these objects, to free up resource to handle additional request.

what is managed and unmanaged code ?

Code that executes under CLR environment is called Managed code for example code written in c# needs CLR Environment to execute it.
Unmanaged code is a code that can execute without any CLR environment Just like code written in c,c++ languge.

how to use multiple web.config files in application or working with more than one web.config file in application ?

Here I will explain how to use multiple web.config files in single application using
I attended one interview at that time they asked one question that is it possible to use multiple web.config files in single application? For that question answer is Yes we can use multiple web.config files in single web application but how? By creating web.config file in sub root folders we can use multiple web.config files in our application but each folder should contains only one web.config file. Here I will explain step by step how we can use multiple web.config files in our application...

First create one new web application that contains Default.aspx page and one web.config file. Now right click on your application and select New folder after creation of new folder right click on new folder select Add new item and add one aspx page and one web.config file to this folder that files structure like this

After that write the following code in root folder web.config file appsettings section like this
<add key="rootfolder" value="Root Folder web.config"/>
<add key="test1" value="Testing the application for root folder web.config"/>
</appSettings >

  After that open Default.aspx page in root folder and write the following code

<html xmlns="">
<head runat="server">
<title>RootFolder web.config</title>
<form id="form1" runat="server">
Root Folder values
<br />
AppKey value:
<asp:Label ID="lbltxt" runat="server" Text="<%$appSettings:rootfolder %>"/>
<br />
Appkey Test value:
<asp:Label ID="Label1" runat="server" Text="<%$appSettings:test1 %>"/>

Now run your application and check the output for root folder

After that open the sub root folder web.config file and write the following code in appsettings section like this
<add key="subrootfolder" value="Sub Root Folder web.config"/>
<add key="test1" value="Testing the application for sub root folder web.config"/>
</appSettings >
After that open ChildPage.aspx page in sub root folder and write the following code
<html xmlns="">
<head id="Head1" runat="server">
<title>SubRoot Folder web.config</title>
<form id="form1" runat="server">
SubRoot Folder values
<br />
AppKey value:
<asp:Label ID="lbltxt" runat="server" Text="<%$appSettings:subrootfolder %>"/>
<br />
Appkey Test value:
<asp:Label ID="Label1" runat="server" Text="<%$appSettings:test1 %>"/>

Now run your application and check the output for sub root folder

If you observe above outputs Default.aspx page getting values from root folder web.config file and ChildPage.aspx page getting values from subroot folder web.config file.
In this way we can use multiple web.config files in web application. I hope it helps you.Please give a feedback if you like this..

Tuesday, 26 February 2013


What is C#?

.C# is a new object-oriented language from Microsoft that is currently used for application development on the .NET platform.
.It exhibits features found in languages such as C++, Java, Smalltalk, and Perl, among others.
.C# has been submitted to the standards body.

.NET Framework Process 


Terms Associated with Microsoft .NET
Common Language Runtime
Common Language Runtime also called CLR Provides a universal execution engine for developers code. It generates SOAP when it makes remote procedure calls. CLR is independent and is provided as part of the .NET Framework. The main features of CLR are as follows:
*Managed Code *Automatic application installation
*Memory Management
*Automatic Garbage Collection
*Very high level of Security while executing .NET Framework Class Libraries These class libraries works with any language under the common language runtime environment. It includes Visual Studio.NET, C-Sharp. Therefore if you are familiar with one .NET language then you can easily migrate to other .NET Languages. The figure given below shows the .NET Framework hierarchy
1->All namespaces should have to be called in your Program by applying the keyword using. For example if your programs needs to call System namespace, then it should be applied in the program as using System.
2->Classes cannot be called along with the using directive. 3->The using directive applies only to namespaces, just like importing packages in Java. Hence the following code will result in compilation error, using System.Console.
However you can create an alias like the following using mysys = System.Console. Then you have to apply the alias in your program as follows mysys.writeLine("Hello C#");

Introduction to object oriented programming concepts (oops) in 

Monday, 25 February 2013 oops

Asp.Net Web Services Examples

OOPS Features

* The object oriented programming (OOP) is a programming model where Programs are organized around object and data rather than action and logic.

*OOP allow decomposition of a problem into a number of entities called Object and then builds data and function around these objects.

The Program is divided into number of small units called Object. The data and function are build around these objects.

The data of the objects can be accessed only by the functions associated with that object.

The functions of one object can access the functions of other object.

OOP has the following important features.


A class is the core of any modern Object Oriented Programming language such as C#.

In OOP languages it is must to create a class for representing data.

Class is a blueprint of an object that contains variables for storing data and functions to performing operations on these data.

Class will not occupy any memory space and hence it is only logical

representation of data.

To create a class, you simply use the keyword "class" followed by the class name:

class Employee


} webservices

Asp.Net Web Services Examples

  Categories : - 

Create RESTful WCF Service API: Step By Step Guide with source code


What is Web Service?

Web Service is an application that is designed to interact directly with other applications over the internet. In simple sense, Web Services are means for interacting with objects over the Internet. The Web serivce consumers are able to invoke method calls on remote objects by using SOAP and HTTP over the Web. WebService is language independent and Web Services communicate by using standard web protocols and data formats, such as

Example of Creating Web Service in .Net

Here are samples codes which I use to create and consume ASP.NET Web Service:
Step 1- Create the ASP.NET Web Service Source File
Open Visual Studio 2010 and create a new web site.->Select .Net Framework 3.5. ->Select ASP.NET Web Service page -> Then, you have to give the name of your service. In this example I am giving it's name "mywebservice". Then Click the ok Button. A screen-shot of these activity is given below.
Step 2- click on the "ok" button; you will see the following window.
Here (in the above figure), you will note that there is predefined method "HelloWorld" which returns the string "Hello World". You can use your own method and can perform various operations. Here I made a simple method which returns the multiplication of two numbers using the code.
Service.cs using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
[WebService(Namespace = "")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class Service : System.Web.Services.WebService
public int Multiplication(int a,int b)
return (a*b);
Before Debugging the above Web Service see some important term
using System.Web.Services;
This directive allows you to refer to objects in the System.Web.Services namespace without having to fully qualify the request. This statement is optional, but if it is not included, every reference to an object in this namespace must be fully qualified. An example is the next line, which is our class declaration. With the using statement, it looks as follows in C#:
The [WebMethod] attributeThe Service class exposes a single method, the public method Multiplication, which takes two integer arguments and returns the multiplication of two number as integer. To expose a method as a part of a web service, you must decorate it with the WebMethod attribute, which tells the compiler to treat it as such. Any method marked with the WebMethod attribute must be defined as public. Class methods exposed as web services follow the same object-oriented rules as any other class, and therefore methods marked private, protected, or internal are not accessible and will return an error if you attempt to expose them using the WebMethod attribute.

In the Solution Explorer you will see

Service.asmx- which contains the following code:

<%@ WebService Language="C#" CodeBehind="~/App_Code/Service.cs" Class="Service" %>
The page directive WebService is required and the class is the name of the .NET Class to expose the Web Service, each method exposes as Web Service Class Method need to have a declarative attribute statement.
The WebService directive is similar to the Page directive that begins most .aspx pages. For the Multiplication web service to work, you must assign values to two WebService directive attributes: Language and Class.
The required Language attribute lets .NET know which programming language the class has been written in. As you might guess, the acceptable values for the language attribute are currently C#, VB, and JS for JScript.NET.
The Class attribute, also required, tells ASP.NET the name of the class to expose as a web service. Because a web service application can comprise multiple classes, some of which may not be web services, you must tell .NET which class to expose, a step analogous to declaring a Main() method to indicate the entry point of a .NET console application or component. Note that even if your web service contains only one class, setting this attribute is required.
Now back to the our web service.
Step 3- Build Web Service and Run the Web Service for testing by pressing F5 function key.

Copy the url of this web service for further use.
Click on the Mutiplication button to test the web service.

Enter the value of a and b.

By pressing the "Invoke" button a XML file is generated.

Now our web service is ready to use; we just need to create a new web site to consume the web service.
Example of Testing Web Service in .Net.
Step 5- Create a Test Web Site by File > New > Web Site > Web Site

Name the web site, for example here I have choosen the name "Test".
Step 6- Right-click Solution Explorer and choose "Add Web Reference".

Step 7- Paste the url of the web service and click on 'Go' button and then 'Add reference'.

Step 8- Now your web service is ready to use in the Solution Explorer you will see.

Step 9- Go to the design of the Default.aspx page; drag and drop three Textboxes and one button.

step 10-Go to Default.cs page and on the button click event use the following code.
protected void Button1_Click(object sender, EventArgs e)
localhost.Service mys = new localhost.Service(); // you need to create the object of the web service
int a = Convert.ToInt32(TextBox1.Text);
int b = Convert.ToInt32(TextBox2.Text);
int c = mys.Multiplication(a, b);
TextBox3.Text = c.ToString();
Step 11- After pressing the F5 function key to run the website, you will see:

Enter the number.

Press the show button

Create RESTful WCF Service API: Step By Step Guide with source code

Sunday, 24 February 2013



11. What is Required Field Validator?

It checks whether the control have any value. It is used when you want the control should not be empty.

12. What is Range Validator?

It checks if the value in validated controls is in that specific range.

13 What’s the difference between Response.Write() and Response.Output.Write()?

Response.Output.Write() allows you to write formatted output.

13 What’s the difference between Response.Write() and Response.Output.Write()?

Init() - when the page is instantiated
Load() - when the page is loaded into server memory
PreRender() - the brief moment before the page is displayed to the user as HTML
Unload() - when page finishes loading.

Saturday, 23 February 2013

Categories -: interview question with answer for 1 and 2 year experience person

1. What is ASP.NET?

Active:An ASP page provides dynamic content that's updated every time that is accessed.
Server : An ASP page contains script code that the Web server executes.
Page: An ASP page is a Web page that the user navigates to and is displayed in his or her browser.

2. What are the types of validation controls in

. Required Field Validator
. Range Validator
. Compare Validator
. Regular Expression Validator
. Custom Validator
. Validation Summary

3. What are the namespaces that automatically imported into every ASP.NET page?

. System
. System.Collections
. System.I0
. System.Web
. System.Web.UI
. System.Web.UI.WebControls
. System.Web.UI.HTMLControls

4. How can you redirect users to a different page?

Use the Response.Redirect method to direct users to different pages. Remember that you must call this method before any HTML is rendered for a page.

5. What is the difference between server-side and client-side caching?

Server-side caching caches output before it's sent to the browser. Subsequent requests to that data will retrieve from the cache.
Client-side caching stores data (such as pages accessed over the Internet) on a user's hard drive so that it doesn't need to be downloaded again.

6. What is the difference between user and server controls?

User controls are created by the developer to allow for the reuse of controls that need specific functionality, while the Server controls are built-in.

7. What are the types of Authentication technique in Asp.Net?

There are three types of Authentication techniques are . Windows Authentication
. Passport Authentication
. Form Authentication

8. How can we identify that the page is Post Back?

Page object has an "Ispostback" property, which can be checked to know that is the page posted back.

9. How ASP.NET different from ASP?

Scripting is separated from the HTML, Code is compiled as a DLL, these DLLs can be executed on the server.



  Dotnet :- Dot Net is a software technology, which was introduced bu microsoft in the year 2002.
Dot Net is a Framework technology, that means which is integrated with multiple technologies like windows, web, webservices, etc.
The main reason, why dot net called to be framework technology is “Using single dotnet technology a programmer can develop multiple type of applications like below
console applications
Windows applications
Web applications
Web services..
Dot Net supports multiple programming technologies
  • c# .Net
  • VB.Net
  • VC++.Net
  • c++.Net
  • v5#.Net
  • F#
  • J#
  • Others include fortran, cobol, delphi, eiffel,apl, Forth, Java, rpg, python just to name a few
ASP.NET is a development framework for building web pages and web sites with HTML, CSS, JavaScript and server scripting.
ASP.NET supports three different development methods:Web Pages, MVC (Model View Controller), and Web Forms.

Web Pages
Single Pages Model
Model View Controller
Web Forms
Event Driven Model

Simplest ASP.NET model.

Similar to PHP and classic ASP.

Built-in templates and helpers for database, video, graphics, social media and more.

MVC separates web applications into 3 different components:

Models for data
Views for display
Controllers for input

The traditional ASP.NET event driven development model:

Web pages with added server controls, server events, and server code.

Classic ASP - Active Server Pages

Active Server Pages (ASP), also known as Classic ASP, was introduced in 1998 as Microsoft's first server side scripting engine.
ASP is a technology that enables scripts in web pages to be executed by an Internet server.
ASP pages have the file extension .asp, and are normally written in VBScript.


ASP.NET is a new ASP generation. It is not compatible with Classic ASP, but ASP.NET may include Classic ASP.
ASP.NET pages are compiled, which makes them faster than Classic ASP.
ASP.NET has better language support, a large set of user controls, XML-based components, and integrated user authentication.
ASP.NET pages have the extension .aspx, and are normally written in VB (Visual Basic) or C# (C sharp).
User controls in ASP.NET can be written in different languages, including C++ and Java.
When a browser requests an ASP.NET file, the ASP.NET engine reads the file, compiles and executes the scripts in the file, and returns the result to the browser as plain HTML

Difference Between .net framework 2.0,3.0 and 3.5

NET framework 2.0:

It brings a lot of evolution in class of the framework and refactor control including the support of

Anonymous methods
Partial class
Nullable type
The new API gives a fine grain control on the behavior of the runtime with regards to multithreading, memory allocation, assembly loading and more
Full 64-bit support for both the x64 and the IA64 hardware platforms
New personalization features for ASP.NET, such as support for themes, skins and webparts.
.NET Micro Framework

.NET framework 3.0:

Also called WinFX,includes a new set of managed code APIs that are an integral part of Windows Vista and Windows Server 2008 operating systems and provides

Windows Communication Foundation (WCF), formerly called Indigo; a service-oriented messaging system which allows programs to interoperate locally or remotely similar to web services.
Windows Presentation Foundation (WPF), formerly called Avalon; a new user interface subsystem and API based on XML and vector graphics, which uses 3D computer graphics hardware and Direct3D technologies.
Windows Workflow Foundation (WF) allows for building of task automation and integrated transactions using workflows.
Windows CardSpace, formerly called InfoCard; a software component which securely stores a person's digital identities and provides a unified interface for choosing the identity for a particular transaction, such as logging in to a website

.NET framework 3.5:

It implement Linq evolution in language. So we have the folowing evolution in class:

Linq for SQL, XML, Dataset, Object
Addin system
p2p base class
Active directory
Anonymous types with static type inference
Paging support for ADO.NET
ADO.NET synchronization API to synchronize local caches and server side datastores
Asynchronous network I/O API
Support for HTTP pipelining and syndication feeds.
New System.CodeDom namespace.

So lets first start with the difference between 1.0 and 2.0.

Support for 64 bit application.
SQL cache dependency
Master pages
Membership and roles

Now the next difference .NET 2.0 and 3.0

WCS ( card space)

3.0 and 3.5
Ajax inbuilt
ADO Entity framework
ADO data services
Multi targeting

Finally 3.5 and 4.0
Parallel computing
DLR dynamic
Code contract
language runtime
Lazy initializatio

Friday, 22 February 2013

Internet Information Services

Categorie:-    how to install and configure the tomcat server
1->  Restart IIS Using Command Prompt 
2-Resetting Internet Information Service
3->  IIS Configuration
4-> Restart Mysql Server From cmd Prompt 
5 ->MySQL Server is Gone Away

How to reset IIS with the  command Prompt

1 )    From the Start menu, click Run.
2 )   In the Open box, type cmd, and click OK.
3 )  At the command prompt, type iisreset /stop. IIS will attempt to stop all services and will return confirmation once all services have been stopped.

4 ) At the command prompt, type iisreset /start.

5 ) That’s it! IIS has been restarted.

  • Typing iisreset directly from the run command window will reset IIS.
  • iisreset /status will show the current status of IIS
  • iisreset /noforce will prevent the server from forcing close applications and process. This can cause IIS to reset slower but is more graceful.


Resetting Internet Information Service (IIS)

Occasionally, Internet Information Services (IIS) will need to be reset for such reasons such as resetting the web server, clearing all current connections, and applying web site changes. This can be done either directly through IIS, or from the Command Prompt. This article will outline both methods. We will start with executing the command directly through IIS.
Performing an IIS reset will not cause the loss of any of your site data, but merely refresh the Windows Service which enables it to be viewed over the Internet.
Navigate to Start -> Administrative Tools -> Internet Information Services (IIS) Manager.

Once open, click on the Local Computer, then from the menu bar at the top click on Actions -> All Tasks -> Restart IIS.

By default, the option will be set to Restart Internet Services on (Computer Name). Leave this option as-is, and click OK.

You should now see dialog box confirming that IIS is restarting. All sites hosted on the server will be non-functional during the time IIS is restarting. Depending on the number of sites hosted on the server, it can take anywhere from 60 seconds (for 5-10 sites) to 30 minutes (50-100 sites).

Now we will examine how to perform an IIS reset from the Command Prompt.

Navigate to Start -> Run. Next to the field which says Run, type in CMD and click OK.

Once open, type 'iisreset', and press Enter.

You should receive a message that IIS has successfully stopped and started.


  3..                              IIS Configuration

Installing IIS

1.) Go to Start > Control Panel > Add/Remove Programs > Add/Remove Windows Components.
2.) Double-click Application Server.

 3.) You will see that Internet Information Services (IIS) is not checked. Check the box. Press “OK”.

You may need your Windows CD in the server drive before you can do this.
Once completed, IIS is installed. You will now need to refer to IIS documentation to start configuring it to your requirements. 


 4                            Restart Mysql Server From cmd Prompt 

1-> Click Start and type cmd  [Open Command Prompt]
2- > write the line as shown below in command prompt

3-> Press Enter  and show MySql is Restated now  as show below screen



5.                              MySQL Server is Gone Away 

Step 1-> Go To     C:\Program Files\MySQL\MySQL Server 5.5 
  Change in  my.ini file  and save

Check our database type and replace then

MyISAM specifications


port = 3306
socket = /tmp/mysql.sock
key_buffer = 384M
max_allowed_packet = 64M
table_cache = 4096
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 64M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M

InnoDB specifications

innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 10M
innodb_log_buffer_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 180

  and restart the mysql  server as shown abo


Related Posts Plugin for WordPress, Blogger...