Knowledge Sharing

How to turn your laptop device Into a WiFi Access Point (Hot spot)

2015-01-10T04:57:00.000-06:00

Previous editions of Windows allowed users to create ad hoc wireless connections between computers. You could use those connections to create a wireless network between multiple computers or to share the Internet connection that was available on one of them. This can no longer be done in Windows 8.1, at least not using a visual interface and the mouse. However, with the help of the Command Prompt and a few commands, you too can turn your Windows 8.1 laptop or hybrid device into a WiFi access point. Here's how:

What You Need in Order for This to Work

In order to use your Windows 8.1 laptop or hybrid device as an WiFi access point for other devices, it must have at least 2 network cards installed and one of them must be a wireless network card. One of them must be connected to the internet.

Setup scenarios we tested and worked great include:

One laptop using its Ethernet connection for Internet access and its WiFi adapter to broadcast - use a network cable to connect your Windows 8.1 laptop to the Internet and the wireless network card for the access point that's sharing the Internet access with other devices.
One laptop that is connected to the Internet through a USB mobile modem and broadcasts the wireless network through its WiFi adapter - most users will have a USB mobile modem available with 3G or 4G connectivity. They can use it for Internet access and use the wireless network adapter for creating the access point and sharing the Internet access with others.
One laptop and two wireless network adapters, one connected to the Internet and the other acting as an access point - this scenario won't be encountered too often as laptops and hybrid devices don't come with two wireless network cards installed. However, you can install a USB wireless adapter and use it for creating the access point.

Step 1. Create a Virtual WiFi Network in Windows 8 & 8.1

To begin, we'll need to open the Command Prompt with administrative privileges and use a command to create a virtual wireless network that is broadcasted by your Windows 8.1 device.

To exemplify, we will create a wireless network called Hotspot. The password for this network will be "blkarwasara".

Inside the Command Prompt window, type the following command:

netsh wlan set hostednetwork mode=allow ssid=Hotspot key=blkarwasara

Notice that the name of the network is set using the SSID parameter and the password is set using the KEY parameter. Obviously, you can set your own values for them.

To create the access point, press Enter. If all goes well, you should see that the hosted network has been set.

Now you have created a virtual adapter that can function as a wireless access point for other computers and devices in your area. However, in order for it to work, you need to make one more step: turn on this virtual adapter.

Do not close the Command Prompt. Keep it open and enter the following command:

netsh wlan start hostednetwork

Then, press Enter.

The virtual wireless adapter is now started and shown in the Network and Sharing Center.

You can connect all your devices to the newly created wireless network. However, it has no Internet access. If you stop at this point, when you connect other devices and computers to the newly created access point, you can create a network between them and use it to share files and resource.

Step 2. Allow Internet Access for the Devices that are Connected to the Virtual WiFi Network

Open the Network and Sharing Center. Notice that the virtual network adapter you just created is displayed as active, but it has no Internet access at this time.

Click or tap the connection of the physical network adapter that currently has Internet access. In our case, it is an Ethernet connection.

This opens the Status window for the selected network adapter. Click or tap Properties.

In the Properties window, go to the Sharing tab.

In order to give Internet access to the virtual WiFi adapter that was created earlier, check the box near "Allow other network users to connect through this computer's Internet connection".

Then, select the virtual adapter that was created earlier.

Click or tap OK and Close to save the settings you've made.

Go back to the Network and Sharing Center and you will notice that the virtual network adapter now has Internet access.

The virtual adapter now gives Internet access to all the devices that are connected to it.

Step 3. Connect Your Wireless Devices to the Access Point

The next step is to connect your wireless devices to the virtual WiFi access point and use them to access the Internet. Also, the devices that are connected to your laptop or hybrid PC, are placed in the same network with the access point. You can use that network to share files and folders between devices.

Conclusion

As you can see, with the help of a few clicks and commands, you can create a virtual wireless connection in Windows 8.1. Try it out for yourself and let us know how well it worked for you. Also, do you know other ways to create a wireless network connection between computers? If you do, share it with us in the comments below.

*.mdf file is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

2013-06-15T01:26:00.001-05:00

I was trying to move y database files (.MDF and .LDF) to different directory by below query -

Step 1
USE MASTER;
GO
-- Take database in single user mode
-- if you are facing errors
-- This may terminate your active transactions for database
ALTER DATABASE dbDatabase
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
-- Detach DB
EXEC MASTER.dbo.sp_detach_db @dbname = N'dbDatabase'
GO

Step 2
-- Move MDF File from Loc1 to Loc 2
-- Re-Attached DB
CREATE DATABASE dbDatabaseON
( FILENAME = N'E:\SQL Database\Data\dbDatabase.mdf' ),
( FILENAME = N'E:\SQL Database\Data\dbDatabase_log.ldf' )
FOR ATTACH
GO

Then i was getting error “The file 'D:\SQL Databse\DATA\dbDatabase.ldf' is compressed but does not reside in a read-only database or file group. The file must be decompressed.”

I remember the free space on drive was running low and windows ask me to compress the files that were not use frequently. So that was the reason cause this error. I looked at the property of the MDF and LDF files. At the advance tab the check box “compress content to save space” was checked. So I unchecked this box and save. After that I moved my database successfully.

Let me know if there is any challenges?

Principles of software design

2013-03-22T11:54:00.002-05:00

Every software application, whether you apply design patterns or not, you should adhere to the design principles. Applying design principles makes your application robust and easy to maintain. Also design principles must be learned before you can embark on a journey to learn design patterns. Allow me to introduce you to design principles with the so called SOLID design principles.

S: Single Responsibility Principle

Like the name suggests, what this means is that every object should be built for one reason only. You should avoid writing multi purpose classes. For example in the .net class library, the string functions are in its own single purpose System.String class and the math functions are in System.Math class.

O: Open-Closed Principle
A class should be open for extension and closed for modification. This means once a class has had a stable release, the existing functionality should never be modified. It it however okay to add new functionality.

L: Liskov Substitution Principle

This principle states that you should be able to use a derived class in place on the parent class and the derived class should behave the same as its parent class.

I: Interface Segregation Principle

This principle is tells you to separate interfaces based on their responsibility. Do not have one huge interface for everything. For example imagine the IEnumerable interface also made you implement a lot of methods that you don't need for a foreach loop. Thats obviously an unwanted inconvenience, if all you want is to apply a foreach loop. This is avoided by having only the methods required for a foreach loop as a part of the IEnumerable interface.

D: Dependency Inversion Principle (or the Inversion of Control Principle )
The Dependency Inversion Principle states when one class uses another class, both the code in both classes can be totally independent of each other and should only depend on interfaces (or abstract classes).
There are three ways to achieve this, namely

Constructor Injection
Method Injection
Property Injection

SQL Server Isolation Levels By Example

2013-03-22T10:29:00.001-05:00

Isolation levels in SQL Server control the way locking works between transactions.
SQL Server 2008 supports the following isolation levels

Read Uncommitted
Read Committed (The default)
Repeatable Read
Serializable
Snapshot

Before I run through each of these in detail you may want to create a new database to run the examples, run the following script on the new database to create the sample data. Note : You’ll also want to drop the IsolationTests table and re-run this script before each example to reset the data.

CREATE TABLE IsolationTests
(
    Id INT IDENTITY,
    Col1 INT,
    Col2 INT,
    Col3 INT
)
 
INSERT INTO IsolationTests(Col1,Col2,Col3)
SELECT 1,2,3
UNION ALL SELECT 1,2,3
UNION ALL SELECT 1,2,3
UNION ALL SELECT 1,2,3
UNION ALL SELECT 1,2,3
UNION ALL SELECT 1,2,3
UNION ALL SELECT 1,2,3

Also before we go any further it is important to understand these two terms….

Dirty Reads – This is when you read uncommitted data, when doing this there is no guarantee that data read will ever be committed meaning the data could well be bad.
Phantom Reads – This is when data that you are working with has been changed by another transaction since you first read it in. This means subsequent reads of this data in the same transaction could well be different.

Read Uncommitted

This is the lowest isolation level there is. Read uncommitted causes no shared locks to be requested which allows you to read data that is currently being modified in other transactions. It also allows other transactions to modify data that you are reading.
As you can probably imagine this can cause some unexpected results in a variety of different ways. For example data returned by the select could be in a half way state if an update was running in another transaction causing some of your rows to come back with the updated values and some not to.
To see read uncommitted in action lets run Query1 in one tab of Management Studio and then quickly run Query2 in another tab before Query1 completes.
Query1

BEGIN TRAN
UPDATE Tests SET Col1 = 2
--Simulate having some intensive processing here with a wait
WAITFOR DELAY '00:00:10'
ROLLBACK

Query2

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT * FROM IsolationTests

Notice that Query2 will not wait for Query1 to finish, also more importantly Query2 returns dirty data. Remember Query1 rolls back all its changes however Query2 has returned the data anyway, this is because it didn’t wait for all the other transactions with exclusive locks on this data it just returned what was there at the time.
There is a syntactic shortcut for querying data using the read uncommitted isolation level by using the NOLOCK table hint. You could change the above Query2 to look like this and it would do the exact same thing.

SELECT * FROM IsolationTests WITH(NOLOCK)

Read Committed

This is the default isolation level and means selects will only return committed data. Select statements will issue shared lock requests against data you’re querying this causes you to wait if another transaction already has an exclusive lock on that data. Once you have your shared lock any other transactions trying to modify that data will request an exclusive lock and be made to wait until your Read Committed transaction finishes.
You can see an example of a read transaction waiting for a modify transaction to complete before returning the data by running the following Queries in separate tabs as you did with Read Uncommitted.
Query1

BEGIN TRAN
UPDATE Tests SET Col1 = 2
--Simulate having some intensive processing here with a wait
WAITFOR DELAY '00:00:10'
ROLLBACK

Query2

SELECT * FROM IsolationTests

Notice how Query2 waited for the first transaction to complete before returning and also how the data returned is the data we started off with as Query1 did a rollback. The reason no isolation level was specified is because Read Committed is the default isolation level for SQL Server. If you want to check what isolation level you are running under you can run “DBCC useroptions”. Remember isolation levels are Connection/Transaction specific so different queries on the same database are often run under different isolation levels.

Repeatable Read

This is similar to Read Committed but with the additional guarantee that if you issue the same select twice in a transaction you will get the same results both times. It does this by holding on to the shared locks it obtains on the records it reads until the end of the transaction, This means any transactions that try to modify these records are forced to wait for the read transaction to complete.
As before run Query1 then while its running run Query2
Query1

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN TRAN
SELECT * FROM IsolationTests
WAITFOR DELAY '00:00:10'
SELECT * FROM IsolationTests
ROLLBACK

Query2

UPDATE IsolationTests SET Col1 = -1

Notice that Query1 returns the same data for both selects even though you ran a query to modify the data before the second select ran. This is because the Update query was forced to wait for Query1 to finish due to the exclusive locks that were opened as you specified Repeatable Read.
If you rerun the above Queries but change Query1 to Read Committed you will notice the two selects return different data and that Query2 does not wait for Query1 to finish.
One last thing to know about Repeatable Read is that the data can change between 2 queries if more records are added. Repeatable Read guarantees records queried by a previous select will not be changed or deleted, it does not stop new records being inserted so it is still very possible to get Phantom Reads at this isolation level.

Serializable

This isolation level takes Repeatable Read and adds the guarantee that no new data will be added eradicating the chance of getting Phantom Reads. It does this by placing range locks on the queried data. This causes any other transactions trying to modify or insert data touched on by this transaction to wait until it has finished.
You know the drill by now run these queries side by side…
Query1

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
BEGIN TRAN
SELECT * FROM IsolationTests
WAITFOR DELAY '00:00:10'
SELECT * FROM IsolationTests
ROLLBACK

Query2

INSERT INTO IsolationTests(Col1,Col2,Col3)
VALUES (100,100,100)

You’ll see that the insert in Query2 waits for Query1 to complete before it runs eradicating the chance of a phantom read. If you change the isolation level in Query1 to repeatable read, you’ll see the insert no longer gets blocked and the two select statements in Query1 return a different amount of rows.

Snapshot

This provides the same guarantees as serializable. So what’s the difference? Well it’s more in the way it works, using snapshot doesn’t block other queries from inserting or updating the data touched by the snapshot transaction. Instead row versioning is used so when data is changed the old version is kept in tempdb so existing transactions will see the version without the change. When all transactions that started before the changes are complete the previous row version is removed from tempdb. This means that even if another transaction has made changes you will always get the same results as you did the first time in that transaction.
So on the plus side your not blocking anyone else from modifying the data whilst you run your transaction but…. You’re using extra resources on the SQL Server to hold multiple versions of your changes.
To use the snapshot isolation level you need to enable it on the database by running the following command

ALTER DATABASE IsolationTests
SET ALLOW_SNAPSHOT_ISOLATION ON

If you rerun the examples from serializable but change the isolation level to snapshot you will notice that you still get the same data returned but Query2 no longer waits for Query1 to complete.

Summary

You should now have a good idea how each of the different isolation levels work. You can see how the higher the level you use the less concurrency you are offering and the more blocking you bring to the table. You should always try to use the lowest isolation level you can which is usually read committed.

How IIS Process ASP.NET Request

2013-02-24T12:03:00.000-06:00

Introduction

When request come from client to the server a lot of operation is performed before sending response to the client. This is all about how IIS Process the request. Here I am not going to describe the Page Life Cycle and there events, this article is all about the operation of IIS Level. Before we start with the actual details, let’s start from the beginning so that each and everyone understand it’s details easily. Please provide your valuable feedback and suggestion to improve this article.

What is Web Server ?

When we run our ASP.NET Web Application from visual studio IDE, VS Integrated ASP.NET Engine is responsible to execute all kind of asp.net requests and responses. The process name is “WebDev.WebServer.Exe” which actually takw care of all request and response of an web application which is running from Visual Studio IDE.
Now, the name “Web Server” comes into picture when we want to host the application on a centralized location and wanted to access from many locations. Web server is responsible for handle all the requests that are coming from clients, process them and provide the responses.

What is IIS ?

IIS (Internet Information Server) is one of the most powerful web servers from Microsoft that is used to host your ASP.NET Web application. IIS has it’s own ASP.NET Process Engine to handle the ASP.NET request. So, when a request comes from client to server, IIS takes that request and process it and send response back to clients.

Request Processing :

Hope, till now it’s clear to you that what is Web server and IIS is and what is the use of them. Now let’s have a look how they do things internally. Before we move ahead, you have to know about two main concepts
1. Worker Process
2. Application Pool
Worker Process: Worker Process (w3wp.exe) runs the ASP.Net application in IIS. This process is responsible to manage all the request and response that are coming from client system. All the ASP.Net functionality runs under the scope of worker process. When a request comes to the server from a client worker process is responsible to generate the request and response. In a single word we can say worker process is the heart of ASP.NET Web Application which runs on IIS.
Application Pool: Application pool is the container of worker process. Application pools is used to separate sets of IIS worker processes that share the same configuration. Application pools enables a better security, reliability, and availability for any web application. The worker process serves as the process boundary that separates each application pool so that when one worker process or application is having an issue or recycles, other applications or worker processes are not affected. This makes sure that a particular web application doesn’t not impact other web application as they they are configured into different application pools.

Application Pool with multiple worker process is called “Web Garden”.
Now, I have covered all the basic stuff like Web server, Application Pool, Worker process. Now let’s have look how IIS process the request when a new request comes up from client.
If we look into the IIS 6.0 Architecture, we can divided them into Two Layer

1. Kernel Mode
2. User Mode

Now, Kernel mode is introduced with IIS 6.0, which contains the HTTP.SYS. So whenever a request comes from Client to Server, it will hit HTTP.SYS First.

Now, HTTP.SYS is Responsible for pass the request to particular Application pool. Now here is one question, How HTTP.SYS comes to know where to send the request? This is not a random pickup. Whenever we creates a new Application Pool, the ID of the Application Pool is being generated and it’s registered with the HTTP.SYS. So whenever HTTP.SYS Received the request from any web application, it checks for the Application Pool and based on the application pool it send the request.

So, this was the first steps of IIS Request Processing.
Till now, Client Requested for some information and request came to the Kernel level of IIS means at HTTP.SYS. HTTP.SYS has been identified the name of the application pool where to send. Now, let’s see how this request moves from HTTP.SYS to Application Pool.
In User Level of IIS, we have Web Admin Services (WAS) which takes the request from HTTP.SYS and pass it to the respective application pool.

When Application pool receive the request, it simply pass the request to worker process (w3wp.exe) . The worker process “w3wp.exe” looks up the URL of the request in order to load the correct ISAPI extension. ISAPI extensions are the IIS way to handle requests for different resources. Once ASP.NET is installed, it installs its own ISAPI extension (aspnet_isapi.dll) and adds the mapping into IIS.
Note : Sometimes if we install IIS after installing asp.net, we need to register the extension with IIS using aspnet_regiis command.

When Worker process loads the aspnet_isapi.dll, it start an HTTPRuntime, which is the entry point of an application. HTTPRuntime is a class which calls the ProcessRequest method to start Processing.

When this methods called, a new instance of HTTPContext is been created. Which is accessible using HTTPContext.Current Properties. This object still remains alive during life time of object request. Using HttpContext.Current we can access some other objects like Request, Response, Session etc.

After that HttpRuntime load an HttpApplication object with the help of HttpApplicationFactory class.. Each and every request should pass through the corresponding HTTPModule to reach to HTTPHandler, this list of module are configured by the HTTPApplication.
Now, the concept comes called “HTTPPipeline”. It is called a pipeline because it contains a set of HttpModules ( For Both Web.config and Machine.config level) that intercept the request on its way to the HttpHandler. HTTPModules are classes that have access to the incoming request. We can also create our own HTTPModule if we need to handle anything during upcoming request and response.

HTTP Handlers are the endpoints in the HTTP pipeline. All request that are passing through the HTTPModule should reached to HTTPHandler. Then HTTP Handler generates the output for the requested resource. So, when we requesting for any aspx web pages, it returns the corresponding HTML output.
All the request now passes from httpModule to respective HTTPHandler then method and the ASP.NET Page life cycle starts. This ends the IIS Request processing and start the ASP.NET Page Lifecycle.

Conclusion

When client request for some information from a web server, request first reaches to HTTP.SYS of IIS. HTTP.SYS then send the request to respective Application Pool. Application Pool then forward the request to worker process to load the ISAPI Extension which will create an HTTPRuntime Object to Process the request via HTTPModule and HTTPHanlder. After that the ASP.NET Page LifeCycle events starts.
This was just overview of IIS Request Processing to let Beginner’s know how the request get processed in backend. If you want to learn in details please check the link for Reference and further Study section.

Reference and Further Study

A low-level Look at the ASP.NET Architecture
IIS Architecture

ASP.NET Session State: Architectural and Performance Considerations

2013-01-15T14:35:00.000-06:00

As you're probably aware, state management is an important consideration for web developers. The HTTP protocol is connectionless, so any web application that persists data across multiple web page requests needs some mechanism to ensure this session-based data is maintained. Examples of session-based data include shopping carts (on an ecommerce site), the currently logged-on user credentials, and other application-specific data that would normally be held on a client. Various strategies have been utilised over the last few years, including hidden forms, cookies and server-based state engines. Of these choices, the latter is perhaps architecturally most attractive since it reduces the dependence on a client; unfortunately, maintaining session state on the server can be expensive on resources and makes it hard to scale out using web farms or secure pages with HTTPS.
Enter the ASP.NET session state engine, which attempts to make server-side session state a much more viable option. ASP.NET offers three separate choices for session state storage when it's switched on: locally on the server (InProc), remotely in a SQL Server database (SqlServer), or remotely using a session state service (StateServer). I'll go through each of those options and compare the benefits of each.
InProc
The local option is not dissimilar to that provided by ASP, in that it requires all requests to come to the same physical server rather than being randomly split across multiple IIS machines. The upside is that it's very fast (it runs in-process), and it's simple to implement. If you've just got one web server, this is the best choice in most scenarios. The only time when you might want to consider something else in this scenario is when the session data is expensive to rebuild, since any InProc session data is flushed when the ASP.NET worker process or IIS restarts. If, for example, you're maintaining a shopping cart as local session data that gets cleared out, you risk annoying customers sufficiently that they take their business elsewhere.
For multiple servers, InProc is unsuitable unless you can implement some form of server affinity, so that every time a particular client requests a web page they are directed back to that same server. Services such as Network Load Balancing (part of Windows Server 2003 Enterprise Edition) can provide this, although they inevitably add their own overhead.
StateServer
I've come across a few developers who haven't come across this choice. The state server relies on a Windows service which is disabled by default, which perhaps explains why people haven't noticed it - go to Administrative Tools / Services and enable the ASP.NET State Service to get it working. You can run the state service on a dedicated machine or shared with a web server host; the main requirement to make this service work efficiently is plenty of RAM. Because the service is isolated from IIS, you can restart IIS without losing the session data contained within it, and you can point multiple distributed ASP.NET boxes at the same service, thereby removing server affinity issues. However, the session data isn't persisted onto disk, so it can't be backed up and a server reboot will lose the data. On the plus side, you don't need SQL Server or anything beyond a Windows licence to run it, making this option easy to set up and maintain. This option is however signficantly slower than using InProc, due to network latency and roundtrip costs. Keeping the state server on a dedicated private LAN with the other web server boxes will help.
Finally, don't forget that you can run the ASP.NET State Service in a single web server environment - this provides durability against IIS restarts, but at a performance cost due to it running out of process.
SqlServer
This is the high-end option in terms of flexibility and reliability, but is also the most expensive to build and maintain. Rather than storing session data in memory, it is persisted to a SQL Server instance. It's more reliable than any of the other approaches, since the data is persisted in a more durable form (e.g. it will survive a server restart and can be backed up). You can even use SQL Server clustering support to increase session state reliability still further. From a performance point of view, it's generally comparable to the StateServer service when you've got multiple web servers using it for session state. The session state itself is stored as a BLOB in a persisted or temporary table, which can reduce the serialization cost but makes it harder to view the session data itself.
In most cases, integrated Windows authentication is the best choice, preferably utilising Kerberos (NTLM requires an extra roundtrip for authentication). Connection pooling can be used to minimise the initial performance hit.

Shuffle and update data column values in sql server

2012-03-26T08:47:00.000-05:00

Problem:
Shuffel data column value of tables any particular column.

Solution:

CREATE TABLE dbo.tblUser
(

intUserId INT PRIMARY KEY IDENTITY (1,1) NOT NULL ,

strFileName VARCHAR(50) NOT NULL DEFAULT '' ,

)
GO

-- Add Column for Sequential Order
ALTER TABLE tblUser
ADD tmpOrder1 INT
GO

-- Add Sequential Order
UPDATE c1
SET tmpOrder1 = RowNum
FROM tblUser c1
INNER JOIN
(

SELECT intUserId, ROW_NUMBER() OVER (ORDER BY intUserId) 'RowNum' FROM tblUser

) c2 ON c2.intUserId = c1.intUserId
GO

-- Add Column for Random Order
ALTER TABLE tblUser
ADD tmpOrder2 INT
GO

-- Add Random Order
UPDATE tblUser
SET tmpOrder2 = ABS(CHECKSUM(NEWID())) % (SELECT COUNT(*) FROM tblUser)
GO

-- Update strFileName
UPDATE c1
SET strFileName = c2.strFileName
FROM tblUser c1
INNER JOIN tblUser c2 ON c2.tmpOrder1 = c1.tmpOrder2
GO

-- Re-randomise
UPDATE tblUser
SET tmpOrder2 = ABS(CHECKSUM(NEWID()))%(SELECT COUNT(*) FROM tblUser)
GO

ALTER TABLE tblUser
DROP COLUMN tmpOrder1
GO

ALTER TABLE tblUser
DROP COLUMN tmpOrder2
GO

-- In other way

SET NOCOUNT ON

DECLARE @intUserId INT
DECLARE @strFileName VARCHAR(50)

DECLARE myCursor CURSOR FOR

SELECT intUserId
FROM tblUser
WHERE intUserId > -1
ORDER BY intUserId

OPEN myCursor
FETCH NEXT FROM myCursor INTO @intUserId
WHILE @@FETCH_STATUS = 0
BEGIN

SELECT

@strFileName = (SELECT TOP 1 strFileName FROM tblUser ORDER BY NEWID())

UPDATE tblUser

SET strFileName = @strFileName

WHERE intUserId = @intUserId

FETCH NEXT FROM myCursor INTO @intUserId

END

CLOSE myCursor
DEALLOCATE myCursor

Please let me know if there is any issue.

Thanks

Unable to start debugging on the web server.

2012-03-02T11:23:00.000-06:00

1. Open application property page,
2. then in Web tab under server section
3. If application is hosted in IIS
   i. Check Use IIS web server radio button and mention url and same port no as IIS. as https://localhost:8031
   ii. Then build, it will work
4. If application is not hosted in IIS and you want to run it directly then
   i. Check Use virtual studio development server
   ii. Specify port let say 8999
   iii. Build and run, it worked in my case.

Let me know if there is any issue.

Exception Details: System.Security.Policy.PolicyException: Required permissions cannot be acquired.

2012-02-13T03:55:00.000-06:00

Figured it out. IIS 7 introduced App Pool Identity "issues" that I didn't know to check into.

Tucson, try this (not optimal security, but for my local dev machine, it's at least got me running for now):

Go to IIS / Applications Pools
Right-click DefaultAppPool / Advanced Settings
In the Process Model section, click Identity.
Change it to a Custom Account, and then select your local admin account. (If you're on a domain, you may have to type <localComputerName>\<UserName>) or Select NETWOR SERVICE.

Read Document Text Directly from Microsoft Word Files (.doc, .docx, .rtf, .txt)

2012-02-07T02:21:00.000-06:00

Description

Reading word office document file in .NET web application.

Requirement/ Preparation

Add DLL of Microsoft.Office.Interop.Word to referances.

Aspx code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="doc.aspx.cs" Inherits="doc" %>

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

<title>Doc file parsing sample</title>

</head>

<body>

<div>

<asp:TextBox ID="txtFilePath" runat="server" Width="813px"></asp:TextBox>

<asp:Button ID="btnGetCVDetails" runat="server" OnClick="btnGetCVDetails_Click" Text="Button" /><br />

<asp:TextBox ID="txtDocFileData" runat="server" Height="724px" TextMode="MultiLine"

Width="875px"></asp:TextBox>

</div>

</form>

</body>

</html>

.cs file code

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using Microsoft.Office.Interop.Word;

public partial class doc : System.Web.UI.Page

{

protected void btnGetCVDetails_Click(object sender, EventArgs e)

{

readFileContent(txtFilePath.Text.Trim());

}

private void readFileContent(string path)

{

Microsoft.Office.Interop.Word.ApplicationClass wordApp = new ApplicationClass();

object file = path;

object nullobj = System.Reflection.Missing.Value;

Microsoft.Office.Interop.Word.Document doc = wordApp.Documents.Open(ref file, ref nullobj, ref nullobj,

ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj,

ref nullobj, ref nullobj, ref nullobj, ref nullobj, ref nullobj);

doc.ActiveWindow.Selection.WholeStory();

doc.ActiveWindow.Selection.Copy();

txtDocFileData.Text = doc.Content.Text;

doc.Close(ref nullobj, ref nullobj, ref nullobj);

wordApp.Quit(ref nullobj, ref nullobj, ref nullobj);

}

Please let me know if there is any issue.

Your comment could motivate me...

IIS URL Rewrite – rewriting non-www to www

2012-01-28T19:32:00.000-06:00

If you’re using IIS 7.0 (or 7.5), URL Rewrite is a valuable tool, well worth installing and using.
One common use of URL Rewrite is redirecting http://domain.com to http://www.domain.com. Many people are doing this for search engine optimization (SEO) so that search engines only see the one site, rather than two sites. The goal is to set a permanent 301 redirect.
You can download URL Rewrite from http://www.iis.net/expand/URLRewrite. For this walkthrough and screenshots I’ll use URL Rewrite 2.0 RC1, but everything that I’ll cover also works for version 1.0 and 1.1.
URL Rewrite works at the global level, or site level (or application level for that matter). Where you apply it is really up to how you manage your server. Either will work for a domain name redirect like this.
You can choose to create the rules using IIS Manager, or using a text editor and updating web.config directly. I’ll show both, starting with IIS Manager.
Let’s get started. First, open IIS Manager and double-click on the “URL Rewrite” icon.

Next, click on “Add Rules…” from the Actions pane.
Here you’ll have a choice from a few wizard options, and with URL Rewrite 2.0 you can also create outbound rules. Create a Blank rule (inbound rules).

Give your rule a good friendly “Name”. I’ll call mine “Redirect domain.com to www”.
In the “Using” dropdown box you can choose between Regular Expressions and Wildcards. Use wildcards if you aren’t familiar with regular expressions since they are much more intuitive. However, if you later need to create more complex rules, regex may be necessary.
For this demo select Wildcards. However, I’ll include instructions for those wanting to use regular expressions.
Enter * for the “Pattern”. That means anything qualifies. We’ll use a condition later instead of matching to the URL. (for Regular Expressions, use .*).
Now expand the “Conditions” section and click “Add”. In the “Add Condition” dialogue enter the following:

Condition input:	{HTTP_HOST}
Check if input string:	Matches the Pattern
Pattern:	domain.com (for regex, enter ^domain.com$)
Ignore case:	checked

Click OK.
Finally, it’s time to set the Action.
In the Action section make sure that the “Action Type” is set to Redirect.
For the “Action Properties”, enter http://www.domain.com/{R:0}. The {R:0} retains the existing URL so if someone typed something like http://domain.com/aboutus it would retain the aboutus as it adds the www.

Be sure that the “Append query string” remains checked so that the querystring part is also retained.
Also, be sure that the “Redirect Type” is set to Permanent (301), which is what the search engines like. This tells the search engines to do a permanent redirect, use the new location and ignore the previous location.

Finally, Apply the rule and test!

Using a Text Editor
You can also create this rule manually by adding the following to your site’s web.config (or applicationHost.config if you set this at the server level).
In the <system.webServer> section of your web.config, add the following:

Wildcards

<rewrite>

    <rules>

        <rule name="Redirect domain.com to www" patternSyntax="Wildcard" stopProcessing="true">

            <match url="*" />

            <conditions>

                <add input="{HTTP_HOST}" pattern="domain.com" />

            </conditions>

            <action type="Redirect" url="http://www.domain.com/{R:0}" />

        </rule>

    </rules>

</rewrite>

Save and you should be set.
Or, if you prefer Regular Expressions, use this instead:

Regular Expressions

<rewrite>

    <rules>

        <rule name="Redirect domain.com to www" patternSyntax="ECMAScript" stopProcessing="true">

            <match url=".*" />

            <conditions>

                <add input="{HTTP_HOST}" pattern="^domain.com$" />

            </conditions>

            <action type="Redirect" url="http://www.domain.com/{R:0}" />

        </rule>

    </rules>

</rewrite>

Distinct values from arraylist

2012-01-28T18:49:00.003-06:00

How can we receive distinct values from a huge arraylist?

Solution

//create a test arraylist of integers
int[] arr = { 1, 2, 3, 3, 3, 4, 4, 5, 5, 6, 7, 7, 7, 8, 8, 9, 9 };
ArrayList arrList = new ArrayList(arr);

//use a hashtable to create a unique list
Hashtable ht = new Hashtable();

foreach (int item in arrList)
{
//set a key in the hashtable for our arraylist value - leaving the hashtable value empty
ht.Item[item] = null;
}

//now grab the keys from that hashtable into another arraylist
ArrayList distincArray = new ArrayList(ht.Keys);

Please let me know if there is any issue.

ASP.NET Tab is Missing in IIS 6.0

2012-01-19T06:07:00.000-06:00

Here are the steps to fix the issue:
1) Stop the IIS Admin service (and any services that depend on it)

2) Open C:\WINDOWS\system32\inetsrv\MetaBase.xml in notepad or your favorite XML Editor. _DELETE_ the line that reads ‘Enable32BitAppOnWin64=”TRUE”’

3) Start -> Run -> iisreset

Your tab should now be back and functional.

Please let me know if there is any issue and don't forgot to make comment on this.

The URL-encoded form data is not valid, Operation is not valid due to the current state of the object...

2012-01-17T14:07:00.000-06:00

Due to a Microsoft Security Update intended to address an ASP.NET Security Vulnerability, some Orion Web Console views may fail to load, if they contain too much information. Specifically, views that require large numbers of HTTP collection keys will generate errors in the OrionWeb.log

Windows Updates auto updated our wintel 2008 servers today morning and one of my web forms stopped working - got two related messages
1. The URL-encoded form data is not valid.
2. Operation not valid due to the current state of the object.

This particular web form was data entry intensive. Explicitely specifying a numeric value for the MaxHttpCollectionKeys app setting resolved the issue.

Resolution

To resolve this issue, increase the value configured for the aspnet:MaxHttpCollectionKeys key, as indicated in the following procedure.
To increase the value configured for the aspnet:MaxHttpCollectionKeys key:
Note: All edits made in this procedure are overwritten if and when the SolarWinds Configuration Wizard runs. If you run the SolarWinds Configuration Wizard, you will need to make this edit again.

Using an account with administrative privileges, log on to your SolarWinds server.
In a text editor, open the Orion Web Console configuration file, web.config.
Note: The default location of web.config is C:\Inetpub\SolarWinds\.
Locate the following line in the <appsettings></appsettings> section:
<add key="aspnet:MaxHttpCollectionKeys" value="number" />
Increase the value for the aspnet:MaxHttpCollectionKeys key
Note: Internal testing has shown that 2000 may be an acceptable value.
Save web.config.

Please let me know if there is any issue on the same...

Detecting close button of browser by Javascript

2012-01-03T23:12:00.000-06:00

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>Browser close button tracking</title>
<script type="text/javascript" language="javascript">
window.onbeforeunload = function(event)
{
    var msg = 'Are you sure you want to leave?';
    if (((window.event.clientX || event.clientX) < 0) || ((window.event.clientY || event.clientY)<0)) // close button
    {
        event=window.event;
        event.returnValue = msg;
        return msg;
    }
    if ((window.event.clientX < 0) || (window.event.clientY<0)) // close button
    {
        event=window.event;
        event.returnValue = msg;
        return msg;
    }
    else if (window.event.altKey == true || window.event.ctrlKey == true) // ALT + F4
    {
        event=window.event;
        event.returnValue = msg;
        return msg;
    }
    else // for all other unload events
    {
    }
}
</script>
</head>
<body>
    
</body>
</html>

CREATE USER For MS SQL Server

2011-11-08T12:33:00.000-06:00

Add a user to the current database.

Syntax
      CREATE USER user 
         [{ FOR | FROM } LOGIN login_name] [WITH DEFAULT_SCHEMA = schema]

      CREATE USER user 
         [{ FOR | FROM } CERTIFICATE certificate] [WITH DEFAULT_SCHEMA = schema]

      CREATE USER user 
         [{ FOR | FROM } ASYMMETRIC KEY asym_key] [WITH DEFAULT_SCHEMA = schema]

      CREATE USER user WITHOUT LOGIN


Key
   user          Name for the user in this database, up to 128 characters.

   login_name    A valid SQL Server login. When this SQL Server login enters the
                 database it will acquire the name and ID of user.
                 By default user will be mapped to the SQL Server login with the

                 same name.

   certificate   The certificate for which the database user is being created.

   asym_key      The asymmetric key for which the database user is being created.

   schema        The first schema that will used to resolve object names for user.
                 default schema = dbo

   WITHOUT LOGIN Don't map user to an existing login.

All members of the sysadmin fixed server role have a default schema of dbo.

A user that is not mapped to a SQL Server login may connect to other databases as guest, this just requires GRANT CONNECT TO guest;

Examples

CREATE LOGIN Karwasara
    WITH PASSWORD = 'pa$$word';
USE MyDatabase;
CREATE USER Karwasara FOR LOGIN Karwasara;
GO

CREATE LOGIN Karwasara1
    WITH PASSWORD = 'pa$$word';
USE MyDatabase;
CREATE USER Karwasara1 FOR LOGIN Karwasara1
    WITH DEFAULT_SCHEMA = dbo;
GO

Single Selection RadioButton on GridView

2011-11-06T09:12:00.000-06:00

If your going to use a gridview and u want to put a radio button on a TemplateField to act as a pointer to your selection just use this code on the RadioButton_CheckedChange Event(). By the way, I've used a temporary template field where i can put the reference value of my radio buttons that has been clicked

protected void rbSelector_CheckedChanged(object sender, System.EventArgs e)
{
    //Clear the existing selected row
    foreach (GridViewRow oldrow in GridView1.Rows)
    {
        ((RadioButton)oldrow.FindControl("rbSelector")).Checked = false;
    }

    //Set the new selected row
    RadioButton rb = (RadioButton)sender;
    GridViewRow row = (GridViewRow)rb.NamingContainer;
    ((RadioButton)row.FindControl("rbSelector")).Checked = true;
}

How to group RadioButtons in Datalist/Gridview control

2011-11-06T06:58:00.000-06:00

To select one radio button at a time in datalist, please follow below steos

Step 1: Write this Past below javascript in the aspx source code

<script type="text/javascript" language="javascript">
function CheckOnes(spanChk)
{
var oItem = spanChk.children;
var theBox= (spanChk.type=="radio") ?
spanChk : spanChk.children.item[0];

xState=theBox.unchecked;
elm=theBox.form.elements;

for(i=0;i<elm.length;i++)
if(elm[i].type=="radio" && elm[i].id!=theBox.id)
{
elm[i].checked=xState;
}
}
</script>

Step 2: Now data list as

<asp:DataList ID="dlExample" runat="server" RepeatDirection="Vertical" RepeatColumns="4" OnItemDataBound="dlExample_ItemDataBound" >
<ItemTemplate>
<table> <tr> <td> <asp:RadioButton ID="rdb" runat="server" /> </td> </tr> </table>
</ItemTemplate>
</asp:DataList>

Step 3: In code behind

protected void dlExample_ItemDataBound(object sender, DataListItemEventArgs e)
{
RadioButton rdb;
rdb = (RadioButton)e.Item.FindControl("rdb");
if(rdb != null)
rdb.Attributes.Add("onclick", "CheckOnes(this);");
}

Please let me know if there is any doubt.

Thanks

How to Install SQL Server 2005 - A Quick Guide

2011-10-13T14:17:00.003-05:00

To describe how to perform a basic installation of SQL Server 2005

Click here or copy and past below link to find all steps...

https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B5L4JO4PFkqdYzViZWJmNDEtMGNjNy00MDY2LWEwMzAtNzg4NTVmMWRmYjRh&hl=en

Google maps integration into your web pages

2011-08-26T15:47:00.002-05:00

Step 1: Sign up for a Google Maps API Key

Sign up for a Google Maps API key here. You will need a different API key for each directory on your web server. This means that if two web pages are in different web folders (directories) on your web server, then you will need separate Google Maps API keys for both web pages.

Step 2: Build a Simple Google Map

Save the example code below to web page. To effectively embed the Google Map into the web page, replace

API_KEY_GOES_HERE (shown in bold below) with your API key. Be sure that you upload
the file into the same directory that you specified when signing up for 
the Google Maps API key in Step 1. If you did not specify a sub-directory, then the

file should go into your root folder.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
    <title>Google Maps API Example</title>
    <script src="http://maps.google.com/maps?file=api&v=2&key=API_KEY_GOES_HERE"
      type="text/javascript"></script>
    <script type="text/javascript">
    //<![CDATA[
    function load() {
      if (GBrowserIsCompatible()) {
        var map = new GMap2(document.getElementById("map"));
        map.setCenter(new GLatLng(37.4419, -122.1419), 13);
      }
    }
    //]]>
    </script>
  </head>
  <body onload="load()" onunload="GUnload()">
    <div id="map" style="width: 500px; height: 300px"></div>
  </body>
</html>

Step 3: Modify the Simple Google Map

You most likely want a different map location than the selected location specified by the coordinates in the map

code above. You may also want to add a marker icon and an info window to your map. We've done these things

in the map shown below. We've also added directional and zoom controls as well as map type controls (to change

to  satellite view). Underneath our embedded Google map display is our map code followed by a list of our

modifications to the simple Google Map example code shown above. We show you the specific lines that we've

added or modified. Be sure to study the code to understand how each feature was added to the embedded Google Map code.
Once again, you'll need to replace API_KEY_GOES_HERE (shown in bold below) with your Google Maps API key.

Below is the code for the map above (minus our building image). To include your own image in a map's info window, just add the image code as you normally would in html by using img tags
(e.g. <img src="path/to/image.jpg" align="left"> ).

*NOTE: When copying and pasting the example below, the following WINDOW_HTML variable code needs to be put entirely on one line.

var WINDOW_HTML = '<div style="width: 210px; padding: 10px">BL Karwasaras' Office</div>';

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
    <title>Google Maps API Example</title>
    <script src="http://maps.google.com/maps?file=api&v=2&key=API_KEY_GOES_HERE"
      type="text/javascript"></script>
    <script type="text/javascript">
    //<![CDATA[
	
    var WINDOW_HTML = '<div style="width: 210px;padding: 10px">BL Karwasaras' Office</div>';	
	
    function load() {
      if (GBrowserIsCompatible()) {
        var map = new GMap2(document.getElementById("map"));
	map.addControl(new GSmallMapControl());
	map.addControl(new GMapTypeControl());
        map.setCenter(new GLatLng(42.8487, -73.755), 13);
	var marker = new GMarker(new GLatLng(42.8487, -73.755));
	map.addOverlay(marker);
	GEvent.addListener(marker, "click", function() {
	marker.openInfoWindowHtml(WINDOW_HTML);
	  });
	marker.openInfoWindowHtml(WINDOW_HTML);			
      }
    }
    //]]>
    </script>
  </head>
  <body onload="load()" onunload="GUnload()">
    <div id="map" style="width: 500px; height: 300px"></div>
  </body>
</html>

Change the Location
To change the map location, you'll need to modify the coordinates (latitude, longitude) in the Google map code above. Look at the line:

map.setCenter(new GLatLng(42.8487, -73.755), 13);

Notice our new coordinates 42.8487, -73.755 which is the location of the SearchEngineKnowledge servers at HostRocket's facility in Clifton Park, NY. The number 13 after the map coordinates represents the zoom level, which ranges from 0-17 (where 17 is the closest level of zoom). To get the coordinates of your location, open up the Google Maps web site and search an address. On the resulting page, click the 'Link to this page' link near the top right (next to the email link). Now study the url address in your browser window. Look for something similar to ll=40.25635,-79.794675 (where ll stands for latitude and longitude). Copy the latitude and longitude values into your map code.
Map Zoom Controls
To add zoom and directional controls to your embedded Google map, you'll need to add the following line to your code (Refer to the map code example above to see where to add this new line of map code):

map.addControl(new GSmallMapControl());
Map Type Controls
To add the Map, Satellite and Hybrid buttons, include the line of code shown below:

map.addControl(new GMapTypeControl());
Add a Map Marker
To add a Google map marker (the upside down red water drop) to your map, include the following two lines of code with the marker coordinates specified. *Note: Your marker coordinates may likely be close to or the same as your location coordinates.

var marker = new GMarker(new GLatLng(42.8487, -73.755));
map.addOverlay(marker);
Add an Information Window
Map info windows help to describe your location, and in this case the info window will appear as a shadowed speech bubble over your map marker. To add a Google Map info window, you'll have to do the following two steps after you've included the code for the map marker (above):
1. Assign the Info Window Code to a Variable
  You'll need to assign the code that you want displayed in the info window to a JavaScript variable, as we've done below. You can include images, text, etc in the code. For example, you could show a company logo or a building photo in the info window to represent a company's headquarters.(*NOTE: To get the map to work correctly, put the code below entirely on one line.)
  
  var WINDOW_HTML = '<div style="width: 210px;
  padding-right: 10px"><a href="http://www.hostrocket.com">
  HostRocket</a> servers are located at
  21 Corporate Drive, Clifton Park, NY 12065.
  Phone: 1-866-519-7079</div>';
2. Add Code to Display the Info Window Variable (set in step 1)
  To display the variable WINDOW_HTML that we set in step 1, put the code below into your embedded Google Map as we've done in the modified map code shown earlier.
  
  GEvent.addListener(marker, "click", function() {
  marker.openInfoWindowHtml(WINDOW_HTML);
  });
  marker.openInfoWindowHtml(WINDOW_HTML);
  
  If you want the info window to appear only when a user clicks on the map marker, then insert the code below instead.
  
  GEvent.addListener(marker, "click", function() {
  marker.openInfoWindowHtml(WINDOW_HTML);
  });

After implementing the three steps above, it will be easy for you to embed Google Maps into your web pages using the Google Maps API. For more features and instruction, visit the Maps Documentation section at Google.

ASP.NET, FileUpload Control width issue in Firefox.

2011-08-20T05:39:00.000-05:00

I've been pretty annoyed about the fact that FireFox ignores the width property of the ASP.NET FileUpload control.

It doesn't matter if you set it by CSS or even in JavaScript, Firefox always ignores it and that results in a crippled layout since you have no control over the width of the upload input field. This actually has nothing to do with the FileUpload control, but with the rendered output of that control, which is just a standard <input type="file"...> field.

Here the width is set to 400px. The FileUpload control renders the Width attribute to the correct CSS style value of 400px at runtime.

<asp:FileUpload runat="server" ID="txtUpload" Width="400" />

But as mentioned, Firefox totally ignores that. Then I remembered a forum thread I read some years ago about a size attribute.

This is what I ended up with. The size attribute actually works in Firefox and IE ignores it, but adheres to the Width attribute instead.

<asp:FileUpload runat="server" ID="txtUpload" Width="400" size="50" />

The size attribute determines the number of characters should be visible and then adjusts the width accordingly.

It is not the same as setting a maximum length of the file name, so it doesn't break anything.

You should think that since a size of 50 generates the same width as 400px that you could always just divide the width in pixels with 8 to find the equivalent size.

That is not the case.

You have to manually adjust every time until you find the right size value that matches the pixel width.

Please let me kn ow if there is any issue.

Calling serverside function from javascript

2011-08-10T11:42:00.000-05:00

App_Code class:

Command.cs

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Reflection;
using System.Data.SqlClient;
/// <summary>
/// Summary description for Command
/// </summary>
namespace CallingSSF
{
    public class Command
    {
        #region Command functionality

        private string m_CommandName = "";

        public Command(string commandName)
        {
            m_CommandName = commandName;
        }

        public static Command Create(string commandName)
        {
            return new Command(commandName);
        }

        public object Execute(object data)
        {
            Type type = this.GetType();
            MethodInfo method = type.GetMethod(m_CommandName);
            object[] args = new object[] { data };
            try
            {
                return method.Invoke(this, args);
            }
            catch (Exception ex)
            {
                // TODO: Add logging functionality
                throw;
            }
        }

        #endregion

        #region Public execution commands

        public object GetTime(object data)
        {
            return DateTime.Now;
        }

        public object GetProductNameFromDatabase(object data)
        {
            // TODO: add real functionality later
            if ((int)data == 1)
            {
                return "Computer";
            }
            else
            {
                return "Unknown";
            }
        }

        public object ChangeDropDownValue(object data)
        {
               // TODO: add real functionality later
                return o;
            }
            catch (Exception ex)
            {
                return null;
            }
        }
        #endregion
    }
}

Markup

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Server side fuction calling from Js</title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager EnablePageMethods="true" ID="MainSM" runat="server" ScriptMode="Release"
            LoadScriptsBeforeUI="true">
            <scripts>
                <asp:ScriptReference Path="~/Scripts/Main.js" />
            </scripts>
        </asp:ScriptManager>

        <script type="text/javascript">
    var methodHandlers = {};
        methodHandlers.ShowTime = function(obj) {
            /// <summary>
            /// method that shows result from
            /// page method "GetTime"
            /// </summary>
            document.getElementById("timeDiv").innerHTML = obj;
        };
        methodHandlers.ShowProduct = function(obj) {
            /// <summary>
            /// method that shows result from
            /// page method "GetProductNameFromDatabase"
            /// </summary>
            document.getElementById("productDiv").innerHTML = obj;
        };
        methodHandlers.UpdateDropdown= function(obj) {
            /// <summary>
            /// method that shows result from
            /// page method "GetProductNameFromDatabase"
            /// </summary>
            document.getElementById("NewValueDiv").innerHTML = obj;
        };
        </script>

        Click on the button to get time from the server.
        <br />
        <br />
        <input value="Get Time" type="button" onclick="mainScreen.ExecuteCommand('GetTime','methodHandlers.ShowTime',null);" />
        <br />
        <br />
        <div style="border: dashed 1px black;" id="timeDiv">
             
        </div>
        <br />
        <br />
        Click on the button to get product name from the server for specified id.
        <br />
        <br />
        <input type="text" id="inpProductId" value="1" />
        <input value="Get Product" type="button" onclick="mainScreen.ExecuteCommand(
            'GetProductNameFromDatabase',
            'methodHandlers.ShowProduct',
            parseInt($get('inpProductId').value));" />
        <br />
        <br />
        <div style="border: dashed 1px black;" id="productDiv">
             
        </div>
    </form>
</body>
</html>

Code behind

Imports CallingSSF
Partial Class Independent
    Inherits System.Web.UI.Page
    <System.Web.Services.WebMethod()> _
Public Shared Function ExecuteCommand(ByVal commandName As String, ByVal targetMethod As String, ByVal data As Object) As Object()
        Try
            Dim result As Object() = New Object(1) {}
            result(0) = Command.Create(commandName).Execute(data)
            result(1) = targetMethod
            Return result
        Catch ex As Exception
            ' TODO: add logging functionality
            Throw
        End Try
    End Function
End Class

Javascript file

Main.js

/// --------------------------------------------------
/// mainScreen object
/// --------------------------------------------------
var mainScreen =
{
    result : null
}

mainScreen.Init = function() {
    /// <summary>
    /// Initializes mainScreen variables
    /// </summary>

    // TODO: add initialization code here
};
mainScreen.ExecuteCommand = function (methodName, targetMethod, parameters) {
    /// <summary>
    /// Executes method on the server
    /// </summary>
    /// <param name="methodName">
    /// Page method name
    /// </param>
    /// <param name="targetMethod">
    /// Javascript method name that will be executed on
    /// client browser, when server returns result
    /// </param>
    /// <param name="parameters">Data to pass to the page method</param>
    PageMethods.ExecuteCommand(methodName, targetMethod, parameters, mainScreen.ExecuteCommandCallback, mainScreen.ExecuteCommandFailed);
};
mainScreen.ExecuteCommandCallback = function (result) {
    /// <summary>
    /// Is called when server sent result back
    /// </summary>
    /// <param name="result">Result of calling server command</param>
    if(result) {
        try {
            mainScreen.result = result[0];
            eval(result[1]+"(mainScreen.result);");
        } catch(err) {
            ; // TODO: Add error handling
        }
    }
};
mainScreen.ExecuteCommandFailed = function (error, userContext, methodName) {
    /// <summary>
    /// Callback function invoked on failure of the page method
    /// </summary>
    /// <param name="error">error object containing error</param>
    /// <param name="userContext">userContext object</param>
    /// <param name="methodName">methodName object</param>
    if(error) {
        ;// TODO: add error handling, and show it to the user
    }
};

/// --------------------------------------------------
/// Page events processing
/// --------------------------------------------------

Sys.Application.add_load(applicationLoadHandler);
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(endRequestHandler);
Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(beginRequestHandler);

function applicationLoadHandler() {
    /// <summary>
    /// Raised after all scripts have been loaded and
    /// the objects in the application have been created
    /// and initialized.
    /// </summary>
    mainScreen.Init()
}

function endRequestHandler() {
    /// <summary>
    /// Raised before processing of an asynchronous
    /// postback starts and the postback request is
    /// sent to the server.
    /// </summary>

    // TODO: Add your custom processing for event
}

function beginRequestHandler() {
    /// <summary>
    /// Raised after an asynchronous postback is
    /// finished and control has been returned
    /// to the browser.
    /// </summary>

    // TODO: Add your custom processing for event
}

Let me know if you need any help regarding this...

Nested Repeaters - ItemDataBound event on Inner Repeaters and check and uncheck all respected child checkboxed using javascript.

2011-08-10T10:41:00.001-05:00

Click on parent check box to check all and un-check child check boxes and also preserving text and value in the hidden field control.

Markup:

<asp:TextBox ID="txtLocation" runat="server" ReadOnly="true"></asp:TextBox>
<asp:HiddenField ID="hdLocation" runat="server" />
<asp:Repeater ID="rptParentValueLocation" runat="server" OnItemDataBound="rptParentValueLocation_ItemDataBound">
<ItemTemplate>
<li>
<asp:CheckBox ID="cbxParentValueLocation" runat="server" Text='<%#Eval("strValue") %>' />
<asp:HiddenField ID="hfParentValueLocation" runat="server" Value='<%#Eval("intLookupId") %>' />
<ul>
<asp:Repeater ID="rptChildValueLocation" runat="server">
<ItemTemplate>
<li>
<asp:CheckBox ID="cbxChildValueLocation" runat="server" Text='<%#Eval("strValue") %>' />
<asp:HiddenField ID="hfChildValueLocation" runat="server" Value='<%#Eval("intLookupId") %>' />
</li>
</ItemTemplate>
</asp:Repeater>
</ul>
</li>
</ItemTemplate>
</asp:Repeater>

Code behind:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not Page.IsPostBack Then
            rptParentValueLocation.DataSource = Data source
            rptParentValueLocation.DataBind()
        End If
End Sub

Protected Sub rptParentValueLocation_ItemDataBound(ByVal sender As Object, ByVal e As RepeaterItemEventArgs)
If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
Dim _Parenthf As HiddenField = DirectCast(e.Item.FindControl("hfParentValueLocation"), HiddenField)
Dim _childrpt As Repeater = DirectCast(e.Item.FindControl("rptChildValueLocation"), Repeater)

_childrpt.DataSource = Data source 'for child control
AddHandler _childrpt.ItemDataBound, AddressOf rptChildValueLocation_ItemDataBound
_childrpt.DataBind()

Dim _cbxParentValueLocation As CheckBox = DirectCast(e.Item.FindControl("cbxParentValueLocation"), CheckBox)

_cbxParentValueLocation.Attributes.Add("onclick", "toggleRepeatorSelection(this,'" + _childrpt.ClientID + "');setRepeatorSelectionValuesToTextBox(this,'" + txtLocation.ClientID + "','" + hdLocation.ClientID + "');")
End If
End Sub

Protected Sub rptChildValueLocation_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs)
If e.Item.ItemType = ListItemType.Item OrElse e.Item.ItemType = ListItemType.AlternatingItem Then
' do what you need to
Dim _cbxChildValueLocation As CheckBox = CType(e.Item.FindControl("cbxChildValueLocation"), CheckBox)
_cbxChildValueLocation.Attributes.Add("onclick", "setRepeatorSelectionValuesToTextBox(this,'" + txtLocation.ClientID + "','" + btnShowValuesLocation.ClientID + "','" + hdLocation.ClientID + "')")
End If
End Sub

Java script:

//For location sector dropdowns
function toggleRepeatorSelection(source, targetID) {
      var target = source.parentNode;

    // Find all checkboxes
    var inputs = target.getElementsByTagName('input');
    //Check all
    if (source.checked)
        for (var i = 0; i < inputs.length; i++) {
            if (inputs[i].type == "checkbox")
                inputs[i].checked = true;
        }
    // Uncheck all
    else
        for (var i = 0; i < inputs.length; i++) {
            if (inputs[i].type == "checkbox")
                inputs[i].checked = false;

        }
}
function setRepeatorSelectionValuesToTextBox(source,textBox,hdLocation)
{
    var target = source.parentNode.parentNode.parentNode.parentNode;
    var inputs = target.getElementsByTagName('input');

    //values to set to Textbox
    var selections="";
    var selectionsValues="";

    for (var i = 0; i < inputs.length; i++) {
        if (inputs[i].type == "checkbox" && inputs[i].checked == true)
        {
            if (selections=="")
            {
                selections=inputs[i].nextSibling.innerHTML;
                selectionsValues=inputs[i].nextSibling.nextSibling.nextSibling.value;
            }
            else
            {
                selections=selections+", "+inputs[i].nextSibling.innerHTML;
                selectionsValues=selectionsValues+","+inputs[i].nextSibling.nextSibling.nextSibling.value;
            }
        }
    }

    //Set all text values
    document.getElementById(textBox).value=selections;
    document.getElementById(textBox).title=selections;

    //Set Values
    document.getElementById(hdLocation).value=selectionsValues;
}

Please let me know if there is any doubt on the same...

Retain carriage returns or line breaks in an asp.NET web page

2011-08-05T15:45:00.000-05:00

Many newcomers to web development cannot get their head around why the carriage returns they made in their data on input from a textarea, or from a text file, Excel spreadsheet etc. do not appear when the web page renders.

The solution is fairly obvious once the newcomer realises that a web page is only the browser's interpretation of html markup, and that a new line in html is represented by the
tag. So what is needed is a way to swap carriage returns or line feeds with the
tag. Well, a way to Replace() them, actually.

<%# Eval("MyMultiLineValue").ToString().Replace(,"
") %>

The string.Replace() method allows this, but we also need to identify what we want to replace with the html tag. How is a new line represented in C# or VB.Net?

In C#, it's "\r\n", while in VB.Net, it's vbcrlf. However, there is also a language independent option that does just the same thing: Environment.NewLine.

<%# Eval("MyMultiLineValue").ToString().Replace(Environment.NewLine,"
") %>

SQL tabular split function

2011-07-14T15:17:00.001-05:00

-- =============================================
-- Author:       <BL Karwasara>
-- Create date: <Nov 08, 2011>
-- Description:   <Split values by del>
-- SELECT * FROM dbo.Split(',', '1,2,3,4')
-- =============================================
ALTER FUNCTION [dbo].[Split]
(
   @sep VARCHAR(32),
   @s VARCHAR(MAX)
)
RETURNS @t TABLE
(
   val VARCHAR(MAX)
)
AS
BEGIN
    DECLARE @xml XML
    SET @XML = N'<root><r>' + REPLACE(@s, @sep, '</r><r>') + '</r></root>'

    INSERT INTO @t(val)
    SELECT r.value('.','VARCHAR(MAX)') as Item
    FROM @xml.nodes('//root/r') AS RECORDS(r)

    RETURN
END