.Net Technology

Contact Us

2012-10-03T22:26:00.001-07:00

If you want to contact me then please comment in the commnet Box.

Contact Us

2012-06-29T03:24:00.001-07:00

If you want to contact me then please comment in the commnet Box.

WCF Interview Questions and Answer

2012-05-01T22:56:00.000-07:00

Q1. What is WCF?
WCF stands for Windows Communication Foundation. It is a Software development kit for developing services on Windows. WCF is introduced in .NET 3.0. in the System.ServiceModel namespace. WCF is based on basic concepts of Service oriented architecture (SOA)

Q2. What is endpoint in WCF service?
The endpoint is an Interface which defines how a client will communicate with the service. It consists of three main points: Address,Binding and Contract.

Q3. Explain Address,Binding and contract for a WCF Service?
Address:Address defines where the service resides.
Binding:Binding defines how to communicate with the service.
Contract:Contract defines what is done by the service.

Q4. What are the various address format in WCF?
a)HTTP Address Format:--> http://localhost:
b)TCP Address Format:--> net.tcp://localhost:
c)MSMQ Address Format:--> net.msmq://localhost:

Q5. What are the types of binding available in WCF?
A binding is identified by the transport it supports and the encoding it uses. Transport may be HTTP,TCP etc and encoding may be text,binary etc. The popular types of binding may be as below:
a)BasicHttpBinding
b)NetTcpBinding
c)WSHttpBinding
d)NetMsmqBinding

Q6. What are the types of contract available in WCF?
The main contracts are:
a)Service Contract:Describes what operations the client can perform.
b)Operation Contract : defines the method inside Interface of Service.
c)Data Contract:Defines what data types are passed
d)Message Contract:Defines wheather a service can interact directly with messages

Q7. What are the various ways of hosting a WCF Service?
a)IIS b)Self Hosting c)WAS (Windows Activation Service)

Q8. WWhat is the proxy for WCF Service?
A proxy is a class by which a service client can Interact with the service.
By the use of proxy in the client application we are able to call the different methods exposed by the service

Q9. How can we create Proxy for the WCF Service?
We can create proxy using the tool svcutil.exe after creating the service.
We can use the following command at command line.
svcutil.exe *.wsdl *.xsd /language:C# /out:SampleProxy.cs /config:app.config

Q10.What is the difference between WCF Service and Web Service?
a)WCF Service supports both http and tcp protocol while webservice supports only http protocol.
b)WCF Service is more flexible than web service.

Q11.What is DataContract and ServiceContract?Explain
Data represented by creating DataContract which expose the
data which will be transefered /consumend from the serive
to its clients.

**Operations which is the functions provided by this
service.

To write an operation on WCF,you have to write it as an
interface,This interface contains the "Signature" of the
methods tagged by ServiceContract attribute,and all methods
signature will be impelemtned on this interface tagged with
OperationContract attribute.

and to implement these serivce contract you have to create
a class which implement the interface and the actual
implementation will be on that class.

Code Below show How to create a Service Contract:

Code

[ServiceContract]
Public Interface IEmpOperations
{
[OperationContract]
Decimal Get EmpSal(int EmpId);

}

Class MyEmp: IEmpOperations
{
Decimal Get EmpSal()
{
// Implementation of this method.
}
}

What is Substring? || Substring Function || Sql Server Substring Function || Sql Server Substring Function example

2012-04-27T20:05:00.001-07:00

Hi Friends ,in this article i will explain about SUBSTRING in sql server.

Substring:

Substring is function. It has 3 parameters.It will returns the part of a character,binary,image or text.

Syntax:

SUBSTRING ( expression , start , length )

For more inforamation please click on the below link.

http://aspdotnet-roja.blogspot.in/2012/04/what-is-substring-substring-function.html

What is an application object in ASP.NET | where we use application object in asp.net | application object sample example using asp.net | What is an application object in .NET

2012-04-26T02:33:00.003-07:00

Hi Friends, in this article i will explain about the application object in .NET.

Application Object:

The Application object is used to store and access variables from any page in an application.

The Application object holds information that will be used by many pages in the application.

If you want more the details please click on the below link.

http://aspdotnet-roja.blogspot.in/2012/04/what-is-application-object-in-aspnet.html

What is Substring? || Substring Function || Sql Server Substring Function || Sql Server Substring Function example

2012-04-25T03:03:00.003-07:00

Hi Friends ,in this article i will explain about SUBSTRING in sql server.

Substring:

Substring is function. It has 3 parameters.It will returns the part of a character,binary,image or text.

Syntax:

SUBSTRING ( expression , start , length )

For more inforamation please click on the below link.

http://aspdotnet-roja.blogspot.in/2012/04/what-is-substring-substring-function.html

Is it possible to set the session out time manually in ASP.NET? || How to set session timeout more than 20 min.? || How to set session timeout in web.config file?

2012-04-23T21:10:00.003-07:00

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

In ASP.NET we can set the session timeout in the web.config file.The code below set the session timeout to 30 minutes.

If you want more information please click on the below link.

http://aspdotnet-roja.blogspot.in/2012/04/is-it-possible-to-set-session-out-time.html

How too create web services in asp.net || What is web service || How webservice is Work || How to consume Webserices || How to create simple webservice..

2012-04-23T03:04:00.000-07:00

Hi Friends, In this article i will explain about how to create simple webservice in .NET.

What is webService?

Webservice is used to convert your applications into web applications.

Webservices are integrate web based application using XML,SOAP,SWDL and UDDI .

XML is used to tag the data like <webservice >hi</webservice>

For more information click on the below link.

http://aspdotnet-roja.blogspot.in/2012/04/how-too-create-web-services-in-aspnet.html

Difference between Abstract class and interface. || what is abstract class || what is interface || Features of Abstract Classes and interfaces

2012-04-23T00:03:00.004-07:00

What is an Abstract class?

Abstract class is a class that cannot be instantiated, it exists extensively for inheritance and it must be inherited. There are scenarios in which it is useful to define classes that is not intended to instantiate; because such classes normally are used as base-classes in inheritance hierarchies, we call such classes abstract classes.
For more information please click on the below link.
http://aspdotnet-roja.blogspot.in/2012/04/difference-between-abstract-class-and.html

How to add Google Talk Popup to your blog || how to chat with friends using Google Talk || Code for Google Talk || Know about Google Talk || How to add Google Talk Gadget to your blog

2012-04-22T20:53:00.003-07:00

Hi friends, in this article i will explain about how to add Google Talk pop up to your website.

Take one new .ASPX page and add the following code to .aspx page .

For more information click on the below link.

http://aspdotnet-roja.blogspot.in/2012/04/how-to-add-google-talk-popup-to-your.html

How to create Mater pages in ASP.NET || What is the use of Master Pages in ASP.NET || How to add Master page to .ASPX page

2012-04-22T20:52:00.002-07:00

Master Page in ASP.NET:

Hi friends,in this article i will explain about how to create the master pages in ASP.NET.

What is the use of master pages?

1.It is mainly used to reusability like function. If we write the code in the master page then we can use this page in many pages.

For more information click on the below link.

http://aspdotnet-roja.blogspot.in/2012/04/how-to-create-mater-pages-in-aspnet.html

How to display image in windows forms || How to add image in windows form

2012-04-22T20:51:00.000-07:00

Hi Friends ,in this article i will explain about how to display image in windows forms.

For this click on the below link.

http://aspdotnet-roja.blogspot.in/2012/04/how-to-display-image-in-windows-forms.html#more

Happy Reading.........

What is Web Service? || History of Web Service or How Web Service comes into existence? || Example of Web Service || Terms which are frequently used with web services || Example of Creating Web Service in .Net

2012-04-18T20:31:00.001-07:00

All About Web Service in .Net

This article will explain you everything about Web Services in .Net, so lets get started with Web Service

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.
Web Service is

Language Independent
Protocol Independent
Platform Independent
It assumes a stateless service architecture.

We will discuss more on web service as the article proceed. Before that lets understand bit on how web service comes into picture.

History of Web Service or How Web Service comes into existence?

As i have mention before that Web Service is nothing but means for Interacting with objects over the Internet.
1. Initially Object - Oriented Language comes which allow us to interact with two object within same application.
2. Than comes Component Object Model (COM) which allows to interact two objects on the same computer, but in different applications.
3. Than comes Distributed Component Object Model (DCOM) which allows to interact two objects on different computers, but within same local network.
4. And finally the web services, which allows two object to interact internet. That is it allows to interact between two object on different computers and even not within same local network.

Example of Web Service

Weather Reporting: You can use Weather Reporting web service to display weather information in your personal website.
Stock Quote: You can display latest update of Share market with Stock Quote on your web site.
News Headline: You can display latest news update by using News Headline Web Service in your website.
In summary you can any use any web service which is available to use. You can make your own web service and let others use it. Example you can make Free SMS Sending Service with footer with your companies advertisement, so whosoever use this service indirectly advertise your company... You can apply your ideas in N no. of ways to take advantage of it.

Web Service Communication
Web Services communicate by using standard web protocols and data formats, such as

HTTP
XML
SOAP

Advantages of Web Service Communication
Web Service messages are formatted as XML, a standard way for communication between two incompatible system. And this message is sent via HTTP, so that they can reach to any machine on the internet without being blocked by firewall.

Terms which are frequently used with web services

What is SOAP?

SOAP are remote function calls that invokes method and execute them on Remote machine and translate the object communication into XML format. In short, SOAP are way by which method calls are translate into XML format and sent via HTTP.

What is WSDL?

WSDL stands for Web Service Description Language, a standard by which a web service can tell clients what messages it accepts and which results it will return.
WSDL contains every details regarding using web service

Method and Properties provided by web service
URLs from which those method can be accessed.
Data Types used.
Communication Protocol used.

What is UDDI?

UDDI allows you to find web services by connecting to a directory.

What is Discovery or .Disco Files?

Discovery files are used to group common services together on a web server.
Discovery files .Disco and .VsDisco are XML based files that contains link in the form of URLs to resources that provides discovery information for a web service.
.Disco File (static)

.Disco File contains

URL for the WSDL
URL for the documentation
URL to which SOAP messages should be sent.

A static discovery file is an XML document that contains links to other resources that describe web services.

.VsDisco File (dynamic)

A dynamic discovery files are dynamic discovery document that are automatically generated by VS.Net during the development phase of a web service.

What is difference between Disco and UDDI?

Disco is Microsoft's Standard format for discovery documents which contains information about Web Services, while UDDI is a multi-vendor standard for discovery documents which contains information about Web Services.

What is Web Service Discovery Tool (disco.exe) ?

The Web Services Discovery Tool (disco.exe) can retrieve discovery information from a server that exposes a web service.

What is Proxy Class?

A proxy class is code that looks exactly like the class it meant to represent; however the proxy class doesn't contain any of the application logic. Instead, the proxy class contains marshalling and transport logic.
A proxy class object allows a client to access a web service as if it were a local COM object.
The Proxy must be on the computer that has the web application.

What is Web Service Description Language Tool (wsdl.exe)?

This tool can take a WSDL file and generate a corresponding proxy class that you can use to invoke the web service.
Alternate of generating Proxy class through WSDL.exe is you can use web reference. Web Reference automatically generate a proxy classes for a web service by setting a web reference to point to the web service.
Advantage of using Web Reference as compare to using WSDL.exe Tool is you can update changes done in web service class easily by updating web reference, which is more tedious task with WSDL.exe tool.

Testing a Web Service?

You can test web service without building an entire client application.

With Asp.net you can simply run the application and test the method by entering valid input paramters.
You can also use .Net Web Service Studio Tool comes from Microsoft.

Example of Creating Web Service in .NetThis Web Service will retrieve CustomerList Country Wise and return as dataset to client application for display.
Step1: Create a Web Service Application by File > New > Web Site > Asp.net Web Services
Named the web service, for example here i have choosen name "WSGetCustomerCountryWise"

Step2: Rename the default Service.asmx file to proper name, you also need to switch design view and change the class name with the same name you use to rename the service.asmx.
For example, "WSGetCustomerCountryWise.asmx" and switch to design view and change the class="Service" to class="WSGetCustomerCountryWise"

Step3: Rename the Service.CS File to proper name, you need to change the class name and constructor name too.
For example, "WSGetCustomerCountryWise.CS" and switch to code view and change the class and constructor name to "WSGetCustomerCountryWise"

After three steps your solution explorer looks as shown in figure

Step4: Create a Logic for Web Service

Create a Method "GetCustomerCountryWise"
Note: You need to specify [WebMethod] before method definition, if you want it to be accessible public, otherwise the method would not be accessible remotely.
Specify proper argument and return type for method in web service.
It is also good practise to specify the use "Description" attribute to tell what method is meant for.

For example, here i need to access data of northwind customers and want to return customer list country wise, so add namespace for

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

[WebMethod(Description="It will generate Customer List, Country Wise")] public System.Xml.XmlElement GetCustomerCountryWise(string sCountry)
{
string sConn = ConfigurationManager.ConnectionStrings["connStr"].ToString();

string sSQL = "select CustomerId, CompanyName, ContactTitle, City " +
" from Customers where country = '" + sCountry + "'";

SqlConnection connCustomer = new SqlConnection(sConn);

DataSet dsCustomer = new DataSet();

SqlDataAdapter daCustomer = new SqlDataAdapter(sSQL, sConn);

daCustomer.Fill(dsCustomer,"Customers");

//Known bug while return "DataSet" is "Data source is an invalid type.
It must be either an IListSource, IEnumerable, or IDataSource."
//For more details on Error: http://support.microsoft.com/kb/317340

//So to access data we need to make use of XmlElement.

// Return the DataSet as an XmlElement.
System.Xml.XmlDataDocument xdd = new System.Xml.XmlDataDocument(dsCustomer);
System.Xml.XmlElement docElem = xdd.DocumentElement;
return docElem;
}
Step5: Build Web Service and Run the Web Service for testing by pressing F5 function key.

By pressing "Invoke" button will generate XML File.

So you are done creating web service application.

Example of Testing Web Service in .NetThis Web Service will display the information which had been retrieved from Remote computer by accessing public method "GetCustomerCountryWise".

Step1: Create a Test Web Site by File > New > Web Site > Asp.net Web Site
Named the web site, for example here i have choosen name "TestGetCustomerCountryWise"

Step2: Displaying data in gridview, so drag the gridview on to the form.

Step3: Right Click Solution Explorer and Choose "Add Web Reference"

Step4: Choose the option Web Service on the local machine or you can enter the .WSDL File address directly in URL space and press Go button.

Step5: Press "Add Reference button"

Step6: Writing Code for Displaying data in GridView
Here note: I have Pass "USA" as parameter in Country Field.

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Create object of WSGetCustomerCountryWise Object
localhost.WSGetCustomerCountryWise objGetCustomerCountryWise
= new localhost.WSGetCustomerCountryWise();

DataSet dsCustomer = new DataSet();

// Get the data from Webservice.
XmlElement elem = objGetCustomerCountryWise.GetCustomerCountryWise("USA");

// Load the XML to the Typed DataSet that you want.
XmlNodeReader nodeReader = new XmlNodeReader(elem);
dsCustomer.ReadXml(nodeReader, XmlReadMode.Auto);

GridView1.DataSource = dsCustomer;

GridView1.DataBind();
}
}

Step7: Output as data displayed in GridView.

Few Facts about Web Service in .Net

Each Response from web service is a new object, with a new state.
Web Service are asynchronous because the request object from the client application and the response object from the web service are unique SOAP envelopes that do not require shared connection.
This allow client application and the web service to continue processing while the interaction is ongoing.
Instead of a user interface, it provides a standard defined interface called a contract.

Chat with your friends using Google Talk || Google chat || Connecting people through Google Talk

2012-04-11T03:17:00.000-07:00

Hi Friends ,i am very happy to announce that i put Google Talk in the my blog. Check it once and chat with your friends .

If you don’t find the Google chat in my blog. See the tabs see the last one or press CTRL+ F and type Google Chat and press Enter then you can find the Google Chat Tab where i put this. Happy Chatting and keep reading my blog.If you want to any more suggestions to me then please contact me through putting the comments.

Difference between cookies and session in ASP.NET || Cookie in ASP.NET || Session in ASP.NET

2012-04-05T03:31:00.002-07:00

State Management in APS.NET is managed by two ways:

Client-Side or Server-Side

Client-Side:Cookies,HiddenFields,ViewState and Query

Strings.

Serve-Side:Application,Session and Database.

COOKIE:

A cookie is a small amount of data stored either in a text file on the client's file system or in-memory in the client browser session. Cookies are mainly used for tracking data settings. Let’s take an example: say we want to customize a welcome web page, when the user request the default web

page, the application first to detect if the user has logined before, we can retrieve the user informatin from cookies:

[c#]

if (Request.Cookies[“username”]!=null)

lbMessage.text=”Dear “+Request.Cookies[“username”].Value+”,

Welcome shopping here!”;

Else

lbMessage.text=”Welcome shopping here!”;

If you want to store client’s information, you can use the

following code:

[c#]

Response.Cookies[“username’].Value=username;

So next time when the user request the web page, you can easily recongnize the user again.

SESSION:

Session object can be used for storing session-specific information that needs to be maintained between server round trips and between requests for pages. Session object is per-client basis, which means different clients generate

different session object.The ideal data to store in session-state variables is short-lived, sensitive data that is specific to an individual session.

Each active ASP.NET session is identified and tracked using a 120-bit SessionID string containing URL-legal ASCII characters. SessionID values are generated using an algorithm that guarantees uniqueness so that sessions do

not collide, and SessionID’s randomness makes it harder to guess the session ID of an existing session. SessionIDs are communicated across client-server requests either by an HTTP cookie or a modified URL, depending on how you set the application's configuration settings.

Every web application must have a configuration file named web.config, it is a XML-Based file, there is a section name ‘sessionState’, the following is an example:

<sessionState mode="InProc"

stateConnectionString = "tcpip=127.0.0.1:42424"

sqlConnectionString = "data source=127.0.0.1;user"

id=sa;password=" cookieless="false" timeout="20" />

‘cookieless’ option can be ‘true’ or ‘false’. When it

is ‘false’(default value), ASP.NET will use HTTP cookie to

identify users. When it is ‘true’, ASP.NET will randomly

generate a unique number and put it just right ahead of the

requested file, this number is used to identify users

[c#]

//to store information

Session[“myname”]=”Mike”;

//to retrieve information

myname=Session[“myname”];

this is briefly about cookies and sessions in ASP.NET

· The main difference between cookies and sessions is that cookies are stored in the user's browser, and sessions are not. This difference determines what each is best used for.

· A cookie can keep information in the user's browser until deleted. If a person has a login and password, this can be set as a cookie in their browser so they do not have to re-login to your website every time they visit. You can store almost anything in a browser cookie

· Sessions are not reliant on the user allowing a cookie. They work instead like a token allowing access and passing information while the user has their browser open. The problem with sessions is that when you close your browser you also lose the session. So, if you had a site requiring a login, this couldn't be saved as a session like it could as a cookie, and the user would be forced to re-login every time they visit.

· The trouble is that a user can block cookies or delete them at any time. If, for example, your websites shopping cart utilized cookies, and a person had their browser set to block them, then they could not shop at your website.

Shortcut Keys for Visual Studio || ShortCut KEYS

2012-04-04T22:37:00.000-07:00

Shortcut Key	Description
Ctrl+Shift+B	Builds the solution
Ctrl-X or Shift-Delete	Cuts the currently selected item.
Ctrl-C or Ctrl-Insert	Copies the currently selected item
Ctrl-V or Shift-Insert	Pastes the item w
Ctrl-Z or Alt-Backspace	Undo previous editing action
Ctrl-Y or Ctrl-Shift-Z	Redo the previous undo action
Ctrl-Shift-V or Ctrl-Shift-Insert	Pastes an item from the clipboard ring tab of the Toolbox at the cursor in the file and automatically selects the pasted item. Cycle through the items on the clipboard by pressing the shortcut keys repeatedly
Esc	Closes a menu or dialog, cancels an operation in progress, or places focus in the current document window
Ctrl-S	Saves the selected files in the current project (usually the file that is being edited)
Ctrl-Shift-S	Saves all documents and projects
Ctrl-P	Displays the Print dialog
F7	Switches from the design view to the code view in the editor
Shift-F7	Switches from the code view to the design view in the editor
F8	Moves the cursor to the next item, for example in the TaskList window or Find Results window
Shift-F8	Moves the cursor to the previous item, for example in the TaskList window or Find Results window
Shift-F12	Finds a reference to the selected item or the item under the cursor
Ctrl-Shift-G	Opens the file whose name is under the cursor or is currently selected
Ctrl-/	Switches focus to the Find/Command box on the Standard toolbar
Ctrl-Shift-F12	Moves to the next task in the TaskList window
Ctrl-Shift-8	Moves backward in the browse history. Available in the object browser or Class View window
Alt-Left Arrow	Go back in the web browser history
Alt-Right Arrow	Go forward in the web browser history

Object browser

Shortcut key	Description
Alt-F12	Displays the Find Symbol dialog
Ctrl-F12	Displays the declaration of the selected symbol in the code
F12	Displays the definition for the selected symbol in code
Ctrl-Alt-F12	Displays the Find Symbol Results window
Ctrl-Alt-J	Displays the Object Browser to view the classes, properties, methods, events, and constants defined either in your project or by components and type libraries referenced by your project
Alt-+	Moves back to the previously selected object in the selection history of the object browser
Shift-Alt-+	Moves forward to the next object in the selection history of the object browser

See more shortcut keys in

http://www.dofactory.com/ShortCutKeys/ShortCutKeys.aspx

Difference Between DLL and EXE in .NET || Dynamic Link Library in .NET || .EXE in .NET

2012-03-06T23:01:00.002-08:00

a) In shortcut .exe is an executable file & DLL (Dynamic Link Library) is not an executable file.

b) DLL is an in-process server while exe is a out-process server it means DLL works within the thread of application, while exe works after creating its own thread.

c) If DLL fails the application became fail if exe fails DLL doesn't fail because it's not work within the thread of application but the part of the exe could not work properly.

d) An EXE is visible to the system as a regular Win32 executable. Its entry point refers to a small loader, which initializes the .NET runtime and tells it to load and execute the assembly contained in the EXE. A DLL is visible to the system as a Win32 DLL but most likely without any entry points. The .NET runtime stores information about the contained assembly in its own header.

DLL:

1) It has versioning

2) It is not self executable

3) It runs in application process memory

4) It has no entry point

5) It is reusable

6) Out Process Server

Exe:

1) It is self executable

2) it has no versioning

3) It runs in own memory

4) It has main function (Entry point)

5) It is self executable

6) In Process Server

URL Rewriting in .Net || How URL Rewriting works || HTTP Module in .NET || installing the HTTP Module

2012-03-06T19:27:00.002-08:00

What is URL Rewriting?

Most dynamic sites include variables in their URLs that tell the site what information to show the user. Typically, this gives URLs like the following, telling the relevant script on a site to load product number 7.

http://www.roja-dotnet.com/show_a_product.aspx?product_id=7

The problems with this kind of URL structure are that the URL is not at all memorable. It's difficult to read out over the phone (you'd be surprised how many people pass URLs this way). Search engines and users alike get no useful information about the content of a page from that URL. You can't tell from that URL that that page allows you to buy a Norwegian Blue Parrot (lovely plumage). It's a fairly standard URL - the sort you'd get by default from most CMSes. Compare that to this URL:

http://www.roja-dotnet.com/products/7/

For those who are unsure URL rewriting is the practice of providing virtual URLs to hide or mask their real physical equivalent. This can be done for SEO, security or aesthetic reasons but overall is a nice addition to any website making urls attractive and readable (e.g "http://www.example.com/content.aspx?id=0125475&cont=twet" becomes "http://www.example.com/articles/example-article").

How it Works

It works by having a HTTP module which is called every time the web application receives a HTTP request and transfers the server path to one designated in the code. It takes very little time to install and is very easy to customise. It is initially set up to just match requested virtual URLs in a switch case and transfer them the corresponding physical URL. This way of working is highly manual but it could easily be switched to work using URLs pulled from a database or text file depending on the content you are serving.

The HTTP Module

The HTTP module is just a class which inherits IHttpModule from the System.Web library. Create a class in your App_Code directory called "URLRewriter.cs" or "URLRewriter.vb" and put in the following code (depending on which language you are using).

C#.NET

using System;

using System.Web;

public class URLRewriter : IHttpModule

{

public void Init(HttpApplication inst)

{

inst.BeginRequest += new EventHandler(OnBeginRequest);

}

public void OnBeginRequest(Object s, EventArgs e)

{

HttpApplication inst = s as HttpApplication;

string req_path = inst.Context.Request.Path;

string trans_path = "";

switch (req_path.ToLower())

{

case "/virtual/path/to/page1":

trans_path = "/physical/path/to/page.aspx?page=1";

break;

case "/virtual/path/to/page2":

trans_path = "/physical/path/to/page.aspx?page=2";

break;

default:

trans_path = "/";

break;

}

inst.Context.Server.Transfer(trans_path);

}

public void Dispose() { }

}

Visual Basic.NET

Imports Microsoft.VisualBasic

Imports System

Imports System.Web

Public Class URLRewriter

Implements IHttpModule

Public Sub Init(ByVal inst As System.Web.HttpApplication) Implements System.Web.IHttpModule.Init

AddHandler inst.BeginRequest, AddressOf Me.OnBeginRequest

End Sub

Public Sub OnBeginRequest(ByVal app As Object, ByVal e As EventArgs)

Dim inst As HttpApplication = CType(app, HttpApplication)

Dim req_path As String = inst.Context.Request.Path

Dim trans_path As String = ""

Select Case req_path.ToLower()

Case "/virtual/path/to/page1"

trans_path = "/physical/path/to/page.aspx?page=1"

Case "/virtual/path/to/page2"

trans_path = "/physical/path/to/page.aspx?page=2"

Case Else

trans_path = "/"

End Select

inst.Context.Server.Transfer(trans_path)

End Sub

Public Sub Dispose() Implements System.Web.IHttpModule.Dispose

End Sub

End Class

The above class named URLRewriter will handle all HTTP requests made to the web application so edit the switch case in the OnBeginRequest method to meet the requirements of your own site.

Installing the HTTP Module

Now the HTTP module is in place it’s time to configure your web application to call it when it receives HTTP requests. This is done by adding a line to the web.config. Insert the line within the httpModules node which can be found inside the system.web node.

<system.web>

</httpModules>

</system.web>

With that setting added to the web.config it should now be up and running. Fire up the server and give it a go, if there are any compilation problems its a good chance you've missed something so check it all over.

Windows Authentication to Access SQL Server Through a ASP.NET Web Application || Configuring SQL Server || Configuring IIS: || Configuring the ASP.NET Web Application || Creating Connection Strings

2012-03-04T19:43:00.001-08:00

We need to configure the following four different areas to access Windows integrated security:

1. SQL Server

2. IIS Web Server

3. ASP.Net web application

4. ConnectionString

SQL Server be running on same IIS machine. If both are on different machines, we should go for analternative security model such as Forms authentication, which is not covered in this article. The access users must be in the same domain where the Web server is running.
If you want know about below then click on the below link.

Configuring SQL Server
Configuring IIS:
Configuring the ASP.NET Web Application

http://aspdotnet-roja.blogspot.in/2012/07/windows-authentication-to-access-sql.html

How do you apply Themes to an entire application? || To apply a theme to a Web site in .NET

2012-03-01T04:06:00.001-08:00

To apply a theme to a Web site

In the application's Web.config file, set the <pages> element to the name of the theme, either a global theme or a page theme, as shown in the following example:

Eg: <configuration>

<system.web>

</system.web>

</configuration>

2. To set a theme as a style sheet theme and be subordinated to local control settings), set the styleSheetTheme attribute instead:

<system.web>

</system.web>

</configuration>

3.The following examples show you how you can define a theme named "SmokeAndGlass" in your application by different methods:

<%@ Page Theme="SmokeAndGlass" Language="C#"%>

4.Themes can be set programmatically under the Page_PreInit event handler. It is necessary to define them in this event handler as all the looks are applied to the server controls defined in a particular theme before the page loads. Here is how you can set themes programmatically:

Protected Sub Page_PreInit(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreInit

Page.Theme = "SmokeAndGlass"

End Sub

Improve Perfomance in ASP.net and make it fast your Page.

2012-02-29T21:58:00.002-08:00

While developing any web site, we should keep some points in our mind.

1) Set debug=false under compilation as follows:

2) Use Server.Transfer instead of Response.Redirect.

3) Always check Page.IsValid when using Validator Controls

4) Use Foreach loop instead of For loop for String Iteration.

5) Use Client-Side Validation. (but not all the time you have to validate even on the server side)

6) Check “Page.IsPostBack”. To avoid repetition code execution.

7) GIF and PNG are similar, but PNG typically produces a lower file size. (True, but some browsers not supporting PNG format)

8) Use the AppOffline.htm when updating binaries

9) Turn off Tracing unless until required. (by default it's off, use on the pages where it's required)

ASP.NET Page is very slow. What will you do to make it fast

1. Find out which is slow, is it the application or the database : If the page is executing SQL queries or stored procedures, run those on the database and check how long do they take to run. If the queries are taking most of the time, then you know you have to tune the queries for better performance. To tune the queries, there are several ways and I have listed some of them below.

a) Check if there are indexes to help the query

b) Select only the required columns, avoid Select *.

c) Check if there is a possibility to reduce the number of joins

d) If possible use NO LOCK on your select statements

e) Check if there are cursors and if you can replace them with joins

2. If the queries are running fast, then we know it is the application code that is causing the slowness. Isolate the page event that is causing the issue by turning tracing on. To turn tracing on, set Trace="true" in the page directive. Once you have tracing turned on you should see trace information at the bottom of the page as shown in the image below. In this case Page Load event is taking the maximum time. So we know, the code in Page_Load event is causing the issue. Once you look at the code, you should be able to nail down the issue.

Introduction to WPF(Windows Presentation Foundation) in .NET

2012-02-29T01:13:00.001-08:00

Windows Presentation Foundation (WPF) is a next-generation presentation system for building Windows client applications with visually stunning user experiences. With WPF, you can create a wide range of both standalone and browser-hosted applications.

It is part of the .NET framework 3.0 and higher.

WPF combines application UIs, 2D graphics, 3D graphics, documents and multimedia into one single framework.

As the name says all, WPF is actually a new framework introduced with .NET framework 3.0 which actually puts forward a new set of classes and assemblies which allows us to write programs more efficiently and flexibly. It uses Direct3D rendering which employs graphics cards to render the output on the screen. Thus the drawing in the form will be smooth and also there is a chance to utilize the hardware capabilities installed in your machine. In case of traditional GDI forms application, it is not possible to use advanced graphics capabilities and hence Windows Forms application will always be inefficient in comparison to WPF. Another important thing that I must address in this regard, GDI Windows forms application uses Operating system controls to build its application. Thus it is basically very hard to customize them in your own application. WPF controls are actually drawn over the screen, and hence you can customize controls totally and modify its behavior when required.

Separation of Appearance and Behavior

WPF separates the appearance of an user interface from its behavior. The appearance is generally specified in the Extensible Application Markup Language (XAML), the behavior is implemented in a managed programming language like C# or Visual Basic. The two parts are tied together by databinding, events and commands. The separation of appearance and behavior brings the following benefits:

Appearance and behaviour are loosely coupled
Designers and developers can work on separate models.
Graphical design tools can work on simple XML documents instead of parsing code.

Rich composition

Controls in WPF are extremely composable. You can define almost any type of controls as content of another. Although these flexibility sounds horrible to designers, its a very powerful feature if you use it appropriate. Put an image into a button to create an image button, or put a list of videos into a combobox to choose a video file.

</StackPanel>

</Button>

Highly customizable

Because of the strict separation of appearance and behavior you can easily change the look of a control. The concept ofstyles let you skin controls almost like CSS in HTML. Templates let you replace the entire appearance of a control.

The following example shows an default WPF button and a customized button.

Resolution independence

All measures in WPF are logical units - not pixels. A logical unit is a 1/96 of an inch. If you increase the resolution of your screen, the user interface stays the same size - it just gets crispier. Since WPF builds on a vector based rendering engine it's incredibly easy to build scaleable user interfaces.

What is XAML ?

XAML is an XML-based markup language that is used to implement an application's appearance declaratively. It is typically used to create windows, dialog boxes, pages, and user controls, and to fill them with controls, shapes, and graphics.

The following example uses XAML to implement the appearance of a window that contains a single button.
ExpressionBuilder is the best tool to generate XAML.

Advantages of XAML

All you can do in XAML can also be done in code. XAML ist just another way to create and initialize objects. You can use WPF without using XAML. It's up to you if you want to declare it in XAML or write it in code. Declare your UI in XAML has some advantages:

XAML code is short and clear to read
Separation of designer code and logic
Graphical design tools like Expression Blend require XAML as source.
The separation of XAML and UI logic allows it to clearly separate the roles of designer and developer.

<Window

xmlns="http://roja-dotnet.blogspot.com"

Title="Button"

Width="250" Height="100">

<Button Name="button">Click Me</Button>

  </Window>

Then the output of the above code is like the below figure.

XAML vs. Code

As an example we build a simple StackPanel with a textblock and a button in XAML and compare it to the same code in C#.

<TextBlock Margin="20">Welcome to XAML</TextBlock>

  </StackPanel>

The same expressed in VB.NET code will look like this:

' Create the StackPanel

Dim stackPanel As New StackPanel()

Me.Content = stackPanel

' Create the TextBlock

Dim textBlock As New TextBlock()

textBlock.Margin = New Thickness(10)

textBlock.Text = "Welcome to the World of XAML"

stackPanel.Children.Add(textBlock)

' Create the Button

Dim button As New Button()

button.Margin = New Thickness(20)

button.Content = "OK"

        stackPanel.Children.Add(button)

As you can see is the XAML version much shorter and clearer to read. And that's the power of XAMLs expressiveness.

Detect Click into Iframe using JavaScript

2012-02-27T21:51:00.001-08:00

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Detect IFrame Clicks</title>

var isOverIFrame = false;

function processMouseOut() {

log("IFrame mouse >> OUT << detected.");

isOverIFrame = false;

top.focus();

}

function processMouseOver() {

log("IFrame mouse >> OVER << detected.");

isOverIFrame = true;

}

function processIFrameClick() {

if(isOverIFrame) {

// replace with your function

log("IFrame >> CLICK << detected. ");

}

function log(message) {

var console = document.getElementById("console");

var text = console.value;

text = text + message + "\n";

console.value = text;

}

function attachOnloadEvent(func, obj) {

if(typeof window.addEventListener != 'undefined') {

window.addEventListener('load', func, false);

} else if (typeof document.addEventListener != 'undefined') {

document.addEventListener('load', func, false);

} else if (typeof window.attachEvent != 'undefined') {

window.attachEvent('onload', func);

} else {

if (typeof window.onload == 'function') {

var oldonload = onload;

window.onload = function() {

oldonload();

func();

};

} else {

window.onload = func;

}

function init() {

var element = document.getElementsByTagName("iframe");

for (var i=0; i<element.length; i++) {

element[i].onmouseover = processMouseOver;

element[i].onmouseout = processMouseOut;

}

if (typeof window.attachEvent != 'undefined') {

top.attachEvent('onblur', processIFrameClick);

}

else if (typeof window.addEventListener != 'undefined') {

top.addEventListener('blur', processIFrameClick, false);

}

attachOnloadEvent(init);

</script>

</head>

<body>

<form name="form" id="form" action=""><textarea name="console"

id="console" style="width: 100%; height: 300px;" cols="" rows=""></textarea>

<button name="clear" id="clear" type="reset">Clear</button>

</form>

</body>

</html>

Create an Excel 2007 file and change font for the ceel in the Excel in VB.NET 2005

2012-02-24T21:44:00.002-08:00

From the following sections you can find how to create an Excel 2007 worksheet through VB.NET 2005. For creating an Excel 2007 worksheet in VB.NET 2005 , you have to add the Microsoft Excel 12.0 Object Library in you project.

1. Create a new project and add a button to the Form.

Select Add reference from Project menu and in the COM Tab select Microsoft Excel 12.0 Object Library and click OK button

2. Now you can start coding to create a new Excel file.

Imports Excel = Microsoft.Office.Interop.Excel

Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, _

ByVal e As System.EventArgs) Handles Button1.Click

Dim xlApp As Excel.Application

Dim xlWorkBook As Excel.Workbook

Dim xlWorkSheet As Excel.Worksheet

Dim misValue As Object = System.Reflection.Missing.Value

Dim chartRange As Excel.Range

xlApp = New Excel.ApplicationClass

xlWorkBook = xlApp.Workbooks.Add(misValue)

xlWorkSheet = xlWorkBook.Sheets("sheet1")

'add data

xlWorkSheet.Cells(4, 2) = ""

xlWorkSheet.Cells(4, 3) = "Student1"

xlWorkSheet.Cells(4, 4) = "Student2"

xlWorkSheet.Cells(4, 5) = "Student3"

xlWorkSheet.Cells(5, 2) = "Maths"

xlWorkSheet.Cells(5, 3) = "80"

xlWorkSheet.Cells(5, 4) = "65"

xlWorkSheet.Cells(5, 5) = "45"

xlWorkSheet.Cells(6, 2) = "English"

xlWorkSheet.Cells(6, 3) = "78"

xlWorkSheet.Cells(6, 4) = "72"

xlWorkSheet.Cells(6, 5) = "60"

xlWorkSheet.Cells(7, 2) = "Telugu"

xlWorkSheet.Cells(7, 3) = "82"

xlWorkSheet.Cells(7, 4) = "80"

xlWorkSheet.Cells(7, 5) = "65"

xlWorkSheet.Cells(8, 2) = "Science"

xlWorkSheet.Cells(8, 3) = "75"

xlWorkSheet.Cells(8, 4) = "82"

xlWorkSheet.Cells(8, 5) = "68"

xlWorkSheet.Cells(9, 2) = "Total"

xlWorkSheet.Cells(9, 3) = "315"

xlWorkSheet.Cells(9, 4) = "299"

xlWorkSheet.Cells(9, 5) = "238"

chartRange = xlWorkSheet.Range("b2", "e3")

chartRange.Merge()

chartRange.FormulaR1C1 = "MARKS LIST"

chartRange.HorizontalAlignment = 3

chartRange.VerticalAlignment = 3
chartRange.Font.FontStyle = "arial"
chartRange.ColumnWidth = "120"

chartRange = xlWorkSheet.Range("b4", "e4")

chartRange.Font.Bold = True

chartRange = xlWorkSheet.Range("b9", "e9")

chartRange.Font.Bold = True

chartRange = xlWorkSheet.Range("b2", "e9")

chartRange.BorderAround(Excel.XlLineStyle.xlContinuous, _

Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex. _

xlColorIndexAutomatic, Excel.XlColorIndex.xlColorIndexAutomatic)

xlWorkSheet.SaveAs("MarksExcel.csv")

xlWorkBook.Close()

xlApp.Quit()

releaseObject(xlApp)

releaseObject(xlWorkBook)

releaseObject(xlWorkSheet)

MsgBox("File created Successfully !")

End Sub

Private Sub releaseObject(ByVal obj As Object)

Try

System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)

obj = Nothing

Catch ex As Exception

obj = Nothing

Finally

GC.Collect()

End Try

End Sub

End Class

How to export DataTable to CSV File Format

2012-02-23T22:32:00.003-08:00

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)

Dim Con As String = ConfigurationManager.ConnectionStrings("ConnectionString").ToString()

Dim conn As New SqlConnection(Con)

Dim da As New SqlDataAdapter("select * from employees", conn)

Dim ds As New DataSet()

da.Fill(ds, "Emp")

GridView1.DataSource = ds.Tables("Emp").DefaultView

GridView1.DataBind()

Dim dt As DataTable = ds.Tables("Emp")

CreateCSVFile(dt, "c:\csvData.csv")

End Sub