Pioneers Code

cropping image using jquery

2011-11-15T23:27:00.004-08:00

Hi friends, Today i am going to explain the topic of "Image Cropping Using JQuery". Before you are doing this example, you should be add jquery plug-in into your project. Now I explain how to make Image Cropping using jquery.

Now, you just include the following Script and CSS in your HTML page head tag, these plug in available in jquery.com or click here to download complete application.

Add the following costume CSS styles in head tag:

Add this Code in Head Section Script Block:

Add this Code in Body Section:

Image Croping Using JQuery

That's It Friends,
Thank's

www.pioneerscode.com

MemCached for .net Developers

2011-11-03T03:06:00.001-07:00

Hi friends, In this article I would like to share some useful information about MemCached for Dotnet Developers. MemCached is a distributed caching system and Simply put, it is nothing but, memory spread across multiple servers. It is often used to speed up dynamic database-driven websites by caching data and objects in RAM to reduce the number of times database is accessed.

Advantages of MemCached:

MemCached is highly efficient in retrieving data for multiple clients.
Objects can be stored directly in MemCached.
MemCached uses binary serialization.
MemCached can run on UNIX, Windows and MacOS.
MemCached is distributed under a permissive free software license.

Pre-requisites:

Need to install MemCached server.
Need to install MemCached .NET client to access the MemCached servers.

How MemCached Works:

Server-side:

MemCached client communicates with server through TCP connection and default port is 11211.
MemCached server listens to the port configured, for any requests from MemCached clients.
Once the server receives a request from a client on the port, two-level hashing takes place.
- First level hashing is when out of the server pool, MemCached client connects to the correct server.
- Second level hashing is when the value is retrieved for the key provided.
The value is then returned to the client.

Client-side:

Opens connection with the server.
Sends commands like get(), set(), delete() to server.
Reads responses from server.
Closes the connection.

Two-level Hashing:

Step 1: The application requests keys “foo”, “bar” and “baz” using the client library, which calculates key-hash values, determining which MemCached server should receive requests.
Step 2: MemCached client sends parallel requests to all relevant MemCached servers.
Step 3: MemCached servers send responses to the client library.
Step 4: MemCached client library aggregates responses for the application. MemCached client library is responsible for sending requests to the correct servers.

MemCached Set-up:
Click here MemCached.exe to Download

Go to command prompt:
Run this command "c:/memcached/memcached.exe -d install"
then type "c:/memcached/memcached.exe -d start"
(To uninstall “memcached Server” service, in command-prompt, type sc delete “memcached Server”)

Run the Memcached server:

Go to Start -->Run --> and type services.msc
Ensure that “memcached Server” is up and running.

Default properties of MemCached are
- MemCached server listens to port 11211
- Memory limit is 64 MB.
Start → Run → and type regedit
- Go to HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/memcached Server.
- Modify value for Key “ImagPath” to “c:\memcached\memcached.exe” -d runservice -m 512 (This increases memory limit of the server to 512 Mb)
- ther options available to modify default values:
  To modify memory limit of the server: -m 1024
  To change port number that server listens to: -p 11211
  To modify maximum size allowed for storing an object: -I 32m (k for kilobytes, m for megabytes)

The maximum object size you can specify is 128MB, the default remains at 1MB.
Click here for Download .NET MemCached Client library.

Thanks,
www.pioneerscode.com

Calling Javascript Function from Code behind in Asp.net

2011-10-10T03:08:00.002-07:00

Hi Friends...
Today, I am going to explain the topic "Calling JavaScript Method from Code Behind" For Asp.net developers. And this code is supports all browsers. Now let's take each of these Steps one by one.

Add this script block in header part of aspx page:

Add this code block in body tag:

Add this code block in ASPX code behind(Button Click Event):

protected void btnJSformCS_Click(object sender, EventArgs e)
{

 if (!ClientScript.IsStartupScriptRegistered("JSfromCS"))
 {
     Page.ClientScript.RegisterStartupScript(this.GetType(),
             "JSfromCS", "CallJSfromCS();", true);
 }

}

Finally build the solution and check the output. That's it, I hope you like this article.

Thanks,
www.pioneerscode.com

Calling Silverlight Method using JavaScript in Asp.net

2011-09-28T01:33:00.002-07:00

Hi Folks...
Today, I am going to explain the topic "Calling Silverlight Method from JavaScript ". Before you are doing this example, check your Visual Studio has System.Web.Silverlight dll references other wise you need to add this reference in your application references. click here to download the System.Web.Silverlight.dll. Now let's take each of these steps one by one.

Step 1:

First download the System.Web.Silverlight dll from above link, After that download the file and then Unzip the file and save the file in your local system

Step 2:

open the visual studio 2008/2010 and select new silverlight application and change the name as
SilverlightApplication and press OK.

Then in solution explorer it will create two projects one for silverlight name it as “SilverlightApplication” and another one is webapplication name it as “SilverlightApplication.Web”

Step 3:

Next, Right click on the Web Project in the solution explorer and click on the Add Reference.

Step 4:

Next, click on the browse button and select the System.Web.Silverlight.dll file from your computer and add that System.Web.Silverlight.dll file to your application.
Let's discuss the Silverlight code behind:

The first thing that we need to add the following code to our Silverlight page constructor. after that, add the [ScriptableMember] Property at the top of method, which is calling method from javascript.

Let's go to the silverlight code behind cs file(MainPage.Xaml.cs):

using System.Windows.Browser; //[ScriptableMember] is property namespace.

namespace SilverlightApplication
{
     public partial class MainPage : UserControl
     {
      public MainPage()
      {
         InitializeComponent();
         System.Windows.Browser.HtmlPage.RegisterScriptableObject("SilverlightCodeBehind",this);                                                                 
      }

      [ScriptableMember]
      public float SumOfTwoNumbers(float firstVal, float secondVal)
      {
          return ( firstVal + secondVal );
      }
     }
}

Now add new aspx page in your webapplication and give name as CallingSLmethodFromJS.aspx

Add this code block on top of the aspx page:

<%@ Register Assembly="System.Web.Silverlight" Namespace="System.Web.UI.SilverlightControls" TagPrefix="asp" %>

Add this script block in header part of aspx page.

In the above method, first I try to get the object of the Silverlight Control and then get the two textbox values. After that I called the Silverlight Code behind method with two parameters which I am getting from textbox values.

Add this code block in body tag:

Here SilverlightApplication.xap is compressed file while building the application it will be created.


    

    
    

    


Calling Silverlight Method from JavaScript

In the above code block, I took two Textboxs and Button on my page, the click event of button will call the JavaScript method, and this method will call the Silverlight method.

Finally, build the solution and check the output.

Thats it, I hope you like this article.
Thanks,
www.pioneerscode.com

Different Date Formats in SQL Server

2011-09-26T06:41:00.002-07:00

Hi Folks,
In this article I would like to share some useful information about "How to get Different Date Formats in SQL Server".

SELECT convert(varchar, getdate(), 101) --mm/dd/yyyy

SELECT convert(varchar, getdate(), 102) --yyyy.mm.dd

SELECT convert(varchar, getdate(), 103) --dd/mm/yyyy

SELECT convert(varchar, getdate(), 104) --dd.mm.yyyy

SELECT convert(varchar, getdate(), 105) --dd-mm-yyyy

SELECT convert(varchar, getdate(), 106) --dd MMM yyyy

SELECT right(convert(varchar, getdate(), 106), 8) -- MMM YYYY

SELECT convert(varchar, getdate(), 107) --mon dd, yyyy

SELECT convert(varchar, getdate(), 108) --hh:mm:ss

SELECT convert(varchar, getdate(), 109) --MMM dd yyyy hh:mm:ss:mmmAM/PM

SELECT convert(varchar, getdate(), 110) --mm-dd-yyyy

SELECT convert(varchar, getdate(), 111) --yyyy/mm/dd

SELECT convert(varchar, getdate(), 112) --yyyymmdd

SELECT convert(varchar, getdate(), 113) --dd MMM yyyy hh:mm:ss:mmm

SELECT convert(varchar, getdate(), 114) --hh:mm:ss:mmm(24h)

SELECT convert(varchar, getdate(), 120) --yyyy-mm-dd hh:mm:ss(24h)

SELECT convert(varchar, getdate(), 121) --yyyy-mm-dd hh:mm:ss.mmm

SELECT convert(varchar, getdate(), 126) --yyyy-mm-ddThh:mm:ss.mmm

SELECT replace(convert(varchar, getdate(), 111), '/', '') --yyyymmdd

SELECT convert(varchar(7), getdate(), 126) --yyyy-mm.

That's It. I hope you like this article.

Thank's

www.pioneerscode.com

Jquery Datatable rowspan and colspan in Asp.Net

2011-09-15T23:26:00.003-07:00

Hi friends, Today i am going to explain the topic of "Jquery Datatable rowspan and colspan in Asp.Net". Before you are doing this example, you should be add jquery plug-in into your project. Now I explain how to make datatable colspan and rowsapn using jquery.

Now, you just include the following Script and CSS links in your web page head tag, these plug in available in jquery.com or click here to download complete application

Final Out Put Screen:

Copy and paste the following code in your .aspx page.

Add this Code in Head Section:

here I took json string, if you want to get the data from data base then use jquery ajax and call the (Web service/WCF) method and convert to json format.

Add this Code in Body Section:


                                                                     
                                                                             
                      
                                         Loading data from server


Loading data from server

That's It Friends,
Thank's

www.pioneerscode.com

Windows Shortcuts in Run Command

2011-07-14T23:19:00.002-07:00

Hi friends ,In this article i would like to share some useful information about short cut keys in run command.

Calc - Calculator 
Cfgwiz32 - ISDN Configuration Wizard 
Charmap - Character Map 
Chkdisk - Repair damaged files 
Cleanmgr - Cleans up hard drives 
Clipbrd - Windows Clipboard viewer 
Cmd - Opens a new Command Window (cmd.exe) 
Control - Displays Control Panel 
Dcomcnfg - DCOM user security 
Debug - Assembly language programming tool 
Defrag - Defragmentation tool 
Drwatson - Records programs crash & snapshots 
Dxdiag - DirectX Diagnostic Utility 
Explorer - Windows Explorer 
Fontview - Graphical font viewer 
Ftp - ftp.exe program 
Hostname - Returns Computer's name 
Ipconfig - Displays IP configuration for all network adapters 
Jview - Microsoft Command-line Loader for Java classes 
MMC - Microsoft Management Console 
Msconfig - Configuration to edit start-up files 
Msinfo32 - Microsoft System Information Utility 
Nbtstat - Displays stats and current connections using NetBios over TCP/IP 
Netstat - Displays all active network connections 
Nslookup - Returns your local DNS server 
Odbcad32 - ODBC Data Source Administrator 
Ping - Sends data to a specified host/IP 
Regedit - registry Editor 
Regsvr32 - register/de-register DLL/OCX/ActiveX 
Regwiz - Registration wizard 
Sfc /scannow - System File Checker 
Sndrec32 - Sound Recorder
Sndvol32 - Volume control for sound-card 
Sysedit - Edit system start-up files (config.sys, autoexec.bat, win.ini, etc.) 
Systeminfo - Display various system information in text console 
Taskmgr - Task manager 
Telnet - Telnet program 
Taskkill - kill processes using command line interface 
Tskill - reduced version of Task-kill from Windows XP Home 
Tracert - Traces and displays all paths required to reach an internet host 
Winchat - simple chat program for Windows networks 
Winipcfg - Displays IP configuration

Final Words
Click here to download this file

That's It. I hope you like this article.

Thank's,
www.pioneerscode.com

Get Browser Name and Version

2011-07-04T06:38:00.002-07:00

Hi Friends, I would like to explain how to get the browser name and version using JavaScript, this article is very useful for cross browser compatibility. I have facing a problem, the pop-up is working in IE but not working in Mac Firefox, so I wrote code based on browsers.

Step 1:
First add this browsercheck.js into your application and add the script into your html or asp file.

var isNav = false
var isIE = false
var isChrome = false
// This function returns the browser Name and Version of the browser
// Based on this function you can manipulates the browser compatibility also
function getBroserVersion() {    
    var agmt = navigator.userAgent.toLowerCase()
    var version = 0

    if (agmt.indexOf('msie') != -1) {
        isIE = true
        if (agmt.indexOf('msie 3.') != -1)
            version = 3
        else if (agmt.indexOf('msie 4.') != -1)
            version = 4
        else if (agmt.indexOf('msie 5.5') != -1)
            version = 5.5
        else if (agmt.indexOf('msie 5.') != -1)
            version = 5
        else if (agmt.indexOf('msie 6.') != -1)
            version = 6
        else if (agmt.indexOf('msie 7.') != -1)
            version = 7
        else if (agmt.indexOf('msie 8.') != -1)
            version = 8
        else if (agmt.indexOf('msie 9.') != -1)
            version = 9
    }
    else if (agmt.indexOf('firefox') != -1) {
        isNav = true
        if (agmt.indexOf('mozilla/2.0') != -1)
            version = 2
        else if (agmt.indexOf('mozilla/3.0') != -1)
            version = 3
        else if (agmt.indexOf('mozilla/4.0') != -1)
            version = 4
        else if (agmt.indexOf('mozilla/4.5') != -1)
            version = 4.5
        else if (agmt.indexOf('mozilla/4.6') != -1)
            version = 4.6
        else if (agmt.indexOf('mozilla/4.7') != -1)
            version = 4.7
        else if (agmt.indexOf('mozilla/4.8') != -1)
            version = 4.8
        else if (agmt.indexOf('mozilla/4.9') != -1)
            version = 4.9
        else if (agmt.indexOf('mozilla/5.') != -1)
            version = 5
        else if (agmt.indexOf('mozilla/6.') != -1)
            version = 6
        else if (agmt.indexOf('mozilla/7.') != -1)
            version = 7
        else if (agmt.indexOf('mozilla/8.') != -1)
            version = 8
        else if (agmt.indexOf('mozilla/9.') != -1)
            version = 9
    }
    else if (agmt.indexOf('chrome') != -1) {
        isChrome = true
    }
    //check broser and versions   
    if (isNav && version) {
        alert("Hi, This is Firefox and my version is " + version)            
    }
    if (isIE && version) {
        alert("Hi, This is IE and my version is "+version)
    }
    if (isChrome) {
        alert("Hi, This is Google Chrome")
    }
}

Step 2:add this code in html body.

How to get the Browser Name and Version

That’s it. I hope you like this article.

Final Words
Click here to download this code

Thank's
www.pioneerscode.com

JQuery pagination in asp.net

2011-07-01T11:23:00.002-07:00

Hi Friends In this article I would like to explain the pagination using JQuery. I have taken a double dimensional array and insert 148 records, and set the page size is 10 records. Bind the each page records, when user clicks the page.
Note: If you want to bind the records form data base, then replace the array with db details.
Now go to explanation:

Step 1:
First we have to add jquery-1.6.1.js file in your application.Click here to download this js file.
Step 2: add this JQuery functionalities in your script block.

Step 3: add this css in your style sheet.

Step 4: HTML Body


 
 Example of Pagination using JQuery and Javascript

Step 5:
That’s it. I hope you like this tutorial, and the above entire code is place in single html file.

Final words
Click here to download this code

Thank's
www.pioneerscode.com

Print HTML Page Using JavaScript

2011-06-30T11:09:00.002-07:00

Hi Friends, In this article i would like to share how to print the current web page using javascript.
<html>
<head><title>print this page using javascript</title>
</head>
<body>
<a href="JavaScript:window.print();">Print this page</a>
</body>
</html>

Click here to print my blog

Thank's
www.pioneerscode.com

Most frequently asked interview questions

2011-06-25T02:56:00.002-07:00

Hi friends, most of interviews asking these question only. If you prepare well then you got the job.

1) Explain your project? ---Should explain your project minimum 30min.

2) Explain difference frameworks in .net?

3) What is the D/B interface and abstract and explain?

4) What is use of private and static constructors and where u can use?

5) What is Reflection?

6) What is D/B Shared and Private Assemblers?

7) What is the indexer and explain?

8) What is the uses of Lambda expressions ?

9) What is session and how many sessions explain briefly? Are you used in your project and explain?

10) What is D/B data reader and data set?

11) What are the functions in data reader?

12) In a single page how many script manager are placed? If more than script managers are placed in a single page, if yes how?

13) What is use of AJAX? Are you used in your project and explain?

14) What is D/B Gridview control and Repeater control?

15) How many validations control and explain each?

16) Asking so many questions in grid operations?

17) What is D/B procedure and function explain minimum 5points?

18) What is D/B Delete and Truncate commands explain min 5 points?

19) What is index and how many index in sql?

20) What is trigger, explain use of trigger and are u used in your project?

21) What is D/B views/procedures/table/trigger?

Difference between delete and truncate commands in sql

2011-06-22T10:40:00.002-07:00

Hi friends,In this article i would like to explain delete and trncate commands.

Delete:

a) It is DML command and speed is slow.

b) Remove rows one by one and we can use where clause

c) we can rollback and fires trigger.

Truncate:

a) It is DDL command and speed is faster.

b) Remove all rows in one execution and we can't use where clause.

c) We can't rollback and does't fire trigger.