DOT NET MY LIFE

Google Search In ASP NET

2013-11-07T03:12:00.002-08:00

Introduction

This article describes how to add a Google search feature in ASP.Net. Here I will describe how to communicate with the Google search API.

Description

Since it is third party software, we require a third-party DLL to be referenced by our application that will communicate with the Google server.

For this we must download the Google Search API:

GoogleSearchAPI.dll

You can download it from the source code attached in this article.

Design

Now add one TextBox,one Button and one Datalist.

In the Datalist I used one linkbutton to show the search result title with link and label to show the search description.

Design your screen as in the following screen.

Or you can copy the following source code:

<body>
    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="TextBox1" runat="server" Width="300px"></asp:TextBox>
        <asp:Button ID="btnSearch" runat="server" Text="Google Search" OnClick="Button1_Click" /><br />
        <asp:DataList ID="dlSearch" runat="server" Width="600px">
            <ItemTemplate>
                <asp:LinkButton ID="LinkButton1" runat="server" Text='<%#Eval("Title") %>' PostBackUrl='<%#Eval("Url") %>'></asp:LinkButton><br />
                <asp:Label ID="Label1" runat="server" Text='<%#Eval("Content") %>'></asp:Label><br />
                <br />
            </ItemTemplate>
            <FooterTemplate>
                <asp:Label Visible='<%#bool.Parse((dlSearch.Items.Count==0).ToString())%>' runat="server"
                  ID="lblNoRecord" Text="No Record Found!"></asp:Label>
           </FooterTemplate>
        </asp:DataList>
    </div>
    </form>
</body>

Now go to the code view.

Next add a reference of the following Google Search API DLL to your website:

GoogleSearchAPI.dll

And write the following code in the .cs file:
using System;
using System.Collections.Generic;
using Google.API.Search;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            dlSearch.DataSource = null;
            dlSearch.DataBind();
            TextBox1.Text = "";
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("Title", typeof(string)));
        dt.Columns.Add(new DataColumn("Content", typeof(string)));
        dt.Columns.Add(new DataColumn("Url", typeof(string)));
        GwebSearchClient client = new GwebSearchClient("www.c-sharpcorner.com");
        IList<IWebResult> results = client.Search(TextBox1.Text, 30);
        foreach (IWebResult result in results)
        {
            DataRow dr = dt.NewRow();
            dr["Title"] = result.Title.ToString();
            dr["Content"] = result.Content.ToString();
            dr["Url"] = result.Url;
            dt.Rows.Add(dr);
        }
        dlSearch.DataSource = dt;
        dlSearch.DataBind();
    }
}

In the code above I passed the TextBox value in the button click to Google server.

After getting the result I bound it to the datatable then to the datalist control.

Just check these two lines:

GwebSearchClient client = new GwebSearchClient("www.c-sharpcorner.com");
IList<IWebResult> results = client.Search(TextBox1.Text, 30);

In the first line I am passing "www.c-sharpcorner.com" as the Client because it required a hosted site for Security purposes.

If you dodn't pass that then it will show an exception.

In the second line I am passing 30 and a TextBox value. Here 30 means I am getting 30 search results.

So you can increase or decrease this value as needed.

Now build your application. Enter a search query then press the button.

It will show all the Google search results.

Now click on the link to see the corresponding site.

For any modifications or problems please comment.

To download Source Click here

Thank You.

GridView Sorting Using jQuery Plugin

2013-11-04T04:11:00.003-08:00

Introduction

This article describes how to use GridView in ASP.Net and jQuery. We can do it server-side but if you do it using jQuery then you are putting less load on the server. You can handle it client-side.

Description

To create this application you need the jQuery plugins listed below.

jquery.tablesorter.min.js
jquery-1.4.3.min.js

You can download them from the source code attached in this page.

Design

Add a GridView with AutogeneratedColumn=false and apply any design.

Now design your screen like the following screen:

Or you can copy the following source code:

<form id="form1" runat="server">
     <div>
         <asp:GridView ID="gvDept" runat="server" AutoGenerateColumns="False" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None">
             <AlternatingRowStyle BackColor="PaleGoldenrod" />
             <Columns>
                 <asp:BoundField DataField="DEPTNO" HeaderText="Id">
                     <ItemStyle Width="50px" />
                 </asp:BoundField>
                 <asp:BoundField DataField="DNAME" HeaderText="Dept Name" />
                 <asp:BoundField DataField="LOC" HeaderText="Location" />
             </Columns>
             <FooterStyle BackColor="Tan" />
            <HeaderStyle BackColor="Tan" Font-Bold="True" />
             <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue"
HorizontalAlign="Center" />
             <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
             <SortedAscendingCellStyle BackColor="#FAFAE7" />
            <SortedAscendingHeaderStyle BackColor="#DAC09E" />
            <SortedDescendingCellStyle BackColor="#E1DB9C" />
             <SortedDescendingHeaderStyle BackColor="#C2A47B" />
         </asp:GridView>
     </div>
     </form>
Next add the following JavaScript and CSS style code in the head tag (it's used for sorting):<style type="text/css">        th
        {
            cursor: pointer;
            background-color: #dadada;
            color: Black;
            font-weight: bold;
            text-align: left;
        }
        th.headerSortUp
        {
            background-image: url(images/asc.gif);
            background-position: right center;
            background-repeat: no-repeat;
        }
       th.headerSortDown
        {
            background-image: url(images/desc.gif);
            background-position: right center;
            background-repeat: no-repeat;
        }
        td
        {
            border-bottom: solid 1px #dadada;
        }
    </style>
<script src="scripts/jquery-1.4.3.min.js" type="text/javascript"></script>
<script src="scripts/jquery.tablesorter.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
          $("#gvDept").tablesorter();
        });
    </script>

Now go to the code view.

Write the BindGrid method using the database or you can use a static datatable.

After binding, write these two lines that are requeired for sorting:

gvDept.UseAccessibleHeader = true;

gvDept.HeaderRow.TableSection = TableRowSection.TableHeader;

And write the following code .cs file:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page{
    private void BindGrid()
    {
        SqlConnection con = new SqlConnection("Data Source=Sanjeeb;database=MYDB;user id=test;password=Test");
        SqlCommand cmd = new SqlCommand("select * from DEPT", con);
        SqlDataAdapter dr = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        dr.Fill(ds);
        gvDept.DataSource = ds;
        gvDept.DataBind();
        gvDept.UseAccessibleHeader = true;
        gvDept.HeaderRow.TableSection = TableRowSection.TableHeader;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            BindGrid();
        }
    }
}

Now build your application. Click on every header; it will sort the corresponding grid column with ascending and descending image.

For any modifications or problems please comment.

For download source Click Here

Thanks.

How to Get Latitude and Longitude of a Place Using Google Map API

2013-10-29T03:49:00.001-07:00

Introduction

This article describes how to get the latitude and longitude of a location using the Google Map API in ASP.Net. Here I will describe how to communicate with the Google Map API.

Description

To use the Google Map API you need to add the following link to the Head section.

<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?sensor=false"></script>

Design Now add two Text Boxes,one Button and one Label.

Design your screen as in the following screen.

Or you can copy the following source code:
<body>
    <form id="form1" runat="server">
    <div>
        <table>
            <tr>
                <td>
                    Country :
                </td>
                <td>
                    <asp:TextBox ID="txtCon" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td>
                    City :
                </td>
                <td>
                    <asp:TextBox ID="txtCity" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td colspan="2" align="center">
                    <input id="btn" type="button" value="Search Coordinates" />
                </td>
            </tr>
            <tr>
                <td colspan="2" align="center">
                    <asp:Label ID="lblresult" runat="server" ForeColor="Red"></asp:Label>
                </td>
            </tr>
        </table>
    </div>
    </form>

</body>Now add the following jQuery and Google map references in the Head section:

<script src="jquery-1.9.1.js" type="text/javascript"></script>
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?sensor=false"></script>
Now write the following JavaScript code in the Head section that will communicate with the Google map API.

<script type="text/javascript">
        $(document).ready(function () {
            $("#btn").click(function () {
                var geocoder = new google.maps.Geocoder();
                var con = document.getElementById('txtCon').value;
                var city = document.getElementById('txtCity').value;
                var res = document.getElementById('lblresult');
                var com = city + "," + con;
                geocoder.geocode({ 'address': com }, function (results, status) {
                    if (status == google.maps.GeocoderStatus.OK) {
                        res.innerHTML = "Latitude : " + results[0].geometry.location.lat() + "<br/>Longitude :" +
results[0].geometry.location.lng();
                    } else {
                        res.innerHTML = "Wrong Details: " + status;
                    }
                });
            });
        });

</script>

Now build your application. Enter a City and Country in the respective text boxes then press the button.

It will show the latitude and longitude of that place in the label.

Thank you.

GridView Animations Using jQuery

2013-10-29T03:36:00.000-07:00

Introduction

This article describes how to apply an animation to a GridView in ASP.Net using jQuery UI.

Description

To create this application you need the jQuery files listed below.

jquery-1.9.1.js
jquery-ui.js
jquery-ui.css

You can download them from the source code attached in this page.
Here I create three pages for checking various animations on GridView.

Dragable GridView
Zoom able GridView
Animated Effect to GridView

Dragable GridView
In this example I will show how to drag a GridView to any position in a browser's screen.
Design
Add a GridView to a page and apply any design.
Now design your screen like the following screen:

Or you can copy the following source code:

<body>
   <form id="form1" runat="server">
    <div id="draggable">
        <asp:GridView ID="gvDetails" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <SortedAscendingCellStyle BackColor="#FDF5AC" />
            <SortedAscendingHeaderStyle BackColor="#4D0000" />
            <SortedDescendingCellStyle BackColor="#FCF6C0" />
            <SortedDescendingHeaderStyle BackColor="#820000" />
        </asp:GridView>
    </div>
    </form>

In the code above just check this div:

<div id="draggable"></div>
Within this div what element you put the dragable feature applied on that.

Next add the following JavaScript and CSS style code in the head tag of an aspx file (this is used to apply the drag feature to the div in which the grid is present).

<head runat="server">
    <title></title>
    <script src="Scripts/jquery-1.9.1.js" type="text/javascript"></script>
    <script src="Scripts/jquery-ui.js" type="text/javascript"></script>
    <style>
        #draggable
        {
            width: 150px;
            height: 150px;
            padding: 0.5em;
        }
    </style>
    <script>
        $(function () {
            $("#draggable").draggable();
        });
    </script>
</head>

Now go to the code view.
And write the following code in the .cs file for binding data to the grid:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class DragAbleGrid : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        BindGridDetails();
    }
    protected void BindGridDetails()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("EmpId", typeof(Int32));
        dt.Columns.Add("EmpName", typeof(string));
        dt.Columns.Add("Education", typeof(string));
        dt.Columns.Add("Place", typeof(string));
        DataRow dtrow = dt.NewRow();
        dtrow["EmpId"] = 1;
        dtrow["EmpName"] = "Sanjeeb";
        dtrow["Education"] = "MCA";
        dtrow["Place"] = "Hyderabad";
        dt.Rows.Add(dtrow);
        dtrow = dt.NewRow();
        dtrow["EmpId"] = 2;
        dtrow["EmpName"] = "Laku";
        dtrow["Education"] = "MBA";
        dtrow["Place"] = "Hyderabad";
        dt.Rows.Add(dtrow);
        dtrow = dt.NewRow();
        dtrow["EmpId"] = 3;
        dtrow["EmpName"] = "Pankaj";
        dtrow["Education"] = "B.Tech";
        dtrow["Place"] = "Bihar";
        dt.Rows.Add(dtrow);
        dtrow = dt.NewRow();
        dtrow["EmpId"] = 4;
        dtrow["EmpName"] = "Srikanth";
        dtrow["Education"] = "B.Tech";
        dtrow["Place"] = "Hyderabad";
        dt.Rows.Add(dtrow);
        gvDetails.DataSource = dt;
        gvDetails.DataBind();
    }
}
Now build your application and check.

Default view in browser:

After dragging it in the browser:

Zoomable GridView In this example I will show how to Zoom a GridView on button click.
Design
Add a GridView to a page and apply any design and one hyperlink.
Now design your screen like the following screen:

Or you can copy the following source code:

<body>
   <form id="form1" runat="server">
<div>
        <a href="#" id="button">Click to Zoom In</a>
    </div>
    <div class="toggler">
        <div id="effect" class="newClass ui-corner-all">
        <asp:GridView ID="gvDetails" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <SortedAscendingCellStyle BackColor="#FDF5AC" />
            <SortedAscendingHeaderStyle BackColor="#4D0000" />
            <SortedDescendingCellStyle BackColor="#FCF6C0" />
            <SortedDescendingHeaderStyle BackColor="#820000" />
        </asp:GridView>
    </div>
</div>
    </form>

In the code above just check this div:

<div class="toggler">
        <div id="effect" class="newClass ui-corner-all">
</div>
</div>
Within this div what element you put the Zoom feature applied on that.

Next add the following JavaScript and CSS style code in the head tag of an aspx file (this is used to apply the Zoom feature to the div in which the grid is present).

<head runat="server">
    <title></title>
    <script src="Scripts/jquery-1.9.1.js" type="text/javascript"></script>
    <script src="Scripts/jquery-ui.js" type="text/javascript"></script>
    <style type="text/css">
        .toggler
        {
            width: 500px;
            height: 200px;
            position: relative;
        }
        #effect
        {
            position: relative;
        }
        .newClass
        {
            width: 240px;
            padding: 1em;
            letter-spacing: 0;
            font-size: 1.2em;
            margin: 0;
        }
        .anotherNewClass
        {
            text-indent: 40px;
            letter-spacing: .4em;
            width: 410px;
            height: 100px;
            padding: 30px;
            margin: 10px;
            font-size: 1.6em;
        }
    </style>
    <script type="text/javascript">
        $(function () {
            $("#button").click(function () {
                $(".newClass").switchClass("newClass", "anotherNewClass", 1000);
    $(".anotherNewClass").switchClass("anotherNewClass", "newClass", 1000);
                return false;
            });
        });
    </script>
</head>

Now go to the code view.

And write the following code in the .cs file for binding data to the grid:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class ZoomAbleGrid : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        BindGridDetails();
    }
    protected void BindGridDetails()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("EmpId", typeof(Int32));
        dt.Columns.Add("EmpName", typeof(string));
        dt.Columns.Add("Education", typeof(string));
        dt.Columns.Add("Place", typeof(string));
        DataRow dtrow = dt.NewRow();
        dtrow["EmpId"] = 1;
        dtrow["EmpName"] = "Sanjeeb";
        dtrow["Education"] = "MCA";
        dtrow["Place"] = "Hyderabad";
        dt.Rows.Add(dtrow);
        dtrow = dt.NewRow();
        dtrow["EmpId"] = 2;
        dtrow["EmpName"] = "Laku";
        dtrow["Education"] = "MBA";
        dtrow["Place"] = "Hyderabad";
        dt.Rows.Add(dtrow);
        dtrow = dt.NewRow();
        dtrow["EmpId"] = 3;
        dtrow["EmpName"] = "Pankaj";
        dtrow["Education"] = "B.Tech";
        dtrow["Place"] = "Bihar";
        dt.Rows.Add(dtrow);
        dtrow = dt.NewRow();
        dtrow["EmpId"] = 4;
        dtrow["EmpName"] = "Srikanth";
        dtrow["Education"] = "B.Tech";
        dtrow["Place"] = "Hyderabad";
        dt.Rows.Add(dtrow);
        gvDetails.DataSource = dt;
        gvDetails.DataBind();
    }
}
Now build your application and check.

Default view in browser:

Now click on "Zoom" in Hyper link.

Animated Effect to GridView In this example I will show how to apply an animation effect to a GridView on a button click.
Design
Add a GridView to a page and apply any design, one dropdown and one hyperlink.
The Dropdown will show all the animation effects.

Now design your screen as in the following screen:

Or you can copy the following source code:

<body>
   <form id="form1" runat="server">
<select name="effects" id="effectTypes">
        <option value="blind">Blind</option>
        <option value="bounce">Bounce</option>
        <option value="clip">Clip</option>
        <option value="drop">Drop</option>
        <option value="explode">Explode</option>
        <option value="fade">Fade</option>
        <option value="fold">Fold</option>
        <option value="highlight">Highlight</option>
        <option value="puff">Puff</option>
        <option value="pulsate">Pulsate</option>
        <option value="scale">Scale</option>
        <option value="shake">Shake</option>
        <option value="size">Size</option>
        <option value="slide">Slide</option>
        <option value="transfer">Transfer</option>
    </select>
    <a href="#" id="button" class="ui-state-default ui-corner-all">Apply effect</a>
    <br />
    <br />
    <div class="toggler">
        <div id="effect" class="ui-corner-all">
            <asp:GridView ID="gvDetails" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None"
                Height="125px" Width="243px">
                <AlternatingRowStyle BackColor="White" />
                <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                <SortedAscendingCellStyle BackColor="#FDF5AC" />
                <SortedAscendingHeaderStyle BackColor="#4D0000" />
                <SortedDescendingCellStyle BackColor="#FCF6C0" />
                <SortedDescendingHeaderStyle BackColor="#820000" />
            </asp:GridView>
        </div>
    </div>
    </form>

In the code above just check this div:

<div class="toggler">
<div id="effect" class="ui-corner-all">

</div>
</div>
Within this div what element you put the Animation effect feature applied on that.

Next add the following JavaScript and CSS style code in the head tag of an aspx file (this is used to apply an Animation effect feature to a div in which a grid is present).

<head runat="server">
    <title></title>
    <link href="Styles/jquery-ui.css" rel="stylesheet" type="text/css" />
    <script src="Scripts/jquery-1.9.1.js" type="text/javascript"></script>
    <script src="Scripts/jquery-ui.js" type="text/javascript"></script>
    <style type="text/css">
        .toggler
        {
            width: 500px;
            height: 200px;
            position: relative;
        }
        #effect
        {
            width: 240px;
            height: 135px;
            padding: 0.4em;
            position: relative;
        }
    </style>
    <script type="text/javascript">
        $(function () {
          // run the currently selected effect
            function runEffect() {
                // get effect type from
                var selectedEffect = $("#effectTypes").val();
                // most effect types need no options passed by default
                var options = {};
                // some effects have required parameters
                if (selectedEffect === "scale") {
                    options = { percent: 0 };
                } else if (selectedEffect === "transfer") {
                    options = { to: "#button", className: "ui-effects-transfer" };
                } else if (selectedEffect === "size") {
                    options = { to: { width: 200, height: 60} };
                }
                // run the effect
                $("#effect").effect(selectedEffect, options, 500, callback);
            };
            // callback function to bring a hidden box back
            function callback() {
                setTimeout(function () {
                    $("#effect").removeAttr("style").hide().fadeIn();
                }, 1000);
            };
            // set effect from select menu value
            $("#button").click(function () {
                runEffect();
                return false;
            });
        });
    </script>
</head>

Now go to the code view.

And write the following code in the .cs file for binding data to the grid:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class EffectToGrid : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        BindGridDetails();
    }
    protected void BindGridDetails()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("EmpId", typeof(Int32));
        dt.Columns.Add("EmpName", typeof(string));
        dt.Columns.Add("Education", typeof(string));
        dt.Columns.Add("Place", typeof(string));
        DataRow dtrow = dt.NewRow();
        dtrow["EmpId"] = 1;
        dtrow["EmpName"] = "Sanjeeb";
        dtrow["Education"] = "MCA";
        dtrow["Place"] = "Hyderabad";
        dt.Rows.Add(dtrow);
        dtrow = dt.NewRow();
        dtrow["EmpId"] = 2;
        dtrow["EmpName"] = "Laku";
        dtrow["Education"] = "MBA";
        dtrow["Place"] = "Hyderabad";
        dt.Rows.Add(dtrow);
        dtrow = dt.NewRow();
        dtrow["EmpId"] = 3;
        dtrow["EmpName"] = "Pankaj";
        dtrow["Education"] = "B.Tech";
        dtrow["Place"] = "Bihar";
        dt.Rows.Add(dtrow);
        dtrow = dt.NewRow();
        dtrow["EmpId"] = 4;
        dtrow["EmpName"] = "Srikanth";
        dtrow["Education"] = "B.Tech";
        dtrow["Place"] = "Hyderabad";
        dt.Rows.Add(dtrow);
        gvDetails.DataSource = dt;
        gvDetails.DataBind();
    }
}
Now build your application. Select any effect from the dropdown and click on "apply effect".

If you have any modifications to suggest then please comment.
to download click here
Thank you.

jQuery Autocomplete Getting Data From Database in ASP.Net

2013-10-24T23:45:00.000-07:00

Introduction
This article describes how to add an Auto Complete feature to a text box and get the data from a database in ASP.Net using a jQuery UI .

Description
To create this application you need the jQuery files listed below.

jquery-1.9.1.js
jquery-ui.js
jquery-ui.css

You can download them from the source code attached to this page.
Design
Go to the database and design your table or execute the following script:

CREATE TABLE [dbo].[DEPT]

(DEPTNO NUMERIC(2),

DNAME VARCHAR(14),

LOC VARCHAR(13) );

INSERT INTO [dbo].[DEPT] VALUES (10, 'ACCOUNTING', 'NEW YORK');

INSERT INTO [dbo].[DEPT] VALUES (20, 'RESEARCH', 'DALLAS');

INSERT INTO [dbo].[DEPT] VALUES (30, 'SALES', 'CHICAGO');

INSERT INTO [dbo].[DEPT] VALUES (40, 'OPERATIONS', 'BOSTON');

In Visual Studio create a website and add a page.

Add a Text Box to the page for searching.
Now design your screen as in the following screen:

Or you can copy the following source code:

<body>

Search Department :<asp:TextBox ID="txtSearch" runat="server" ></asp:TextBox>

</form>

</body>

Next add the following JavaScript and CSS style code in the head tag of an aspx file
(this is used to get the data to show the auto complete).

$(document).ready(function () {

$("#txtSearch").autocomplete({

source: function (request, response) {

$.ajax({

type: "POST",

contentType: "application/json; charset=utf-8",

url: "WebService.asmx/GetData",

data: "{'DName':'" + document.getElementById('txtSearch').value + "'}",

dataType: "json",

success: function (data) {

response(data.d);

error: function (result) {

alert("Error......");

}

});

}

});

</script>

</head>

Now go to Solution Explorer and add a Web Service to the project (for example, "WebService.asmx").

Now write the following code in the .cs file of the Web Service:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Services;

using System.Data.SqlClient;

/// <summary>

/// Summary description for WebService

/// </summary>

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. [System.Web.Script.Services.ScriptService]

public class WebService : System.Web.Services.WebService

{

[WebMethod]

public List<string> GetData(string DName)

{

List<string> result = new List<string>();

using (SqlConnection con = new SqlConnection("Data Source=SYSTEM-30;database=DB_Test_Trainees;user id=test;password=Test"))

{

using (SqlCommand cmd = new SqlCommand("select Dname from DEPTDHII where Dname like '%'+@SearchText+'%'", con))

{

con.Open();

cmd.Parameters.AddWithValue("@SearchText", DName);

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())

{

result.Add(dr["DName"].ToString());

}

return result;

}

}

Now check this line in the code above:

[System.Web.Script.Services.ScriptService]

By default this line is commented. To allow this Web Service to be called from a script using ASP.NET AJAX, uncomment the line.

Now build your application. Enter a search query in the TextBox.

To download Source Click Here

How to use a Web Service in Windows Form Application

2013-10-22T02:22:00.001-07:00

Introduction

This blog describes how to Communicate with a web service in Windows Form application.

In previous article we saw How to Create a Simple Web Service and Use it in ASP.Net.

Now here I am going to use that same service in Windows Form application.

Creating the client application

Now create a Windows Form Application and design your form as in the following screen.

Add a web reference to the Application

Go to Solution Explorer then select the solution then click on "Add Service Reference". it will open an window

Then click on Advanced button on that window.

A new window will open. then click on "Add Web Reference".

A new window will open. Then within the URL type the service reference path.

(For example: http://localhost:65312/WebServiceSample/Airthmatic.asmx) then click on the "Go" button.

Nowyou will see your service methods. Change the web reference name from "localhost" to any other name as you like (for example: Airthmatic).

Click on the "Add Reference" button. It will create a Proxy at the client side.

Now go to the cs code and add a reference for the Service.

Write the following code.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace WindowsAirthmatic

{

public partial class Form1 : Form

{

Airthmatic.Airthmatic obj = new Airthmatic.Airthmatic();

int a, b, c;

public Form1()

{

InitializeComponent();

}

private void btnAdd_Click(object sender, EventArgs e)

{

a = Convert.ToInt32(textBox1.Text);

b = Convert.ToInt32(textBox3.Text);

c = obj.Add(a, b);

label4.Text = c.ToString();

}

private void btnSub_Click(object sender, EventArgs e)

{

a = Convert.ToInt32(textBox1.Text);

b = Convert.ToInt32(textBox3.Text);

c = obj.Sub(a, b);

label4.Text = c.ToString();

}

private void btnMul_Click(object sender, EventArgs e)

{

a = Convert.ToInt32(textBox1.Text);

b = Convert.ToInt32(textBox3.Text);

c = obj.Mul(a, b);

label4.Text = c.ToString();

}

private void btnDiv_Click(object sender, EventArgs e)

{

a = Convert.ToInt32(textBox1.Text);

b = Convert.ToInt32(textBox3.Text);

c = obj.Div(a, b);

label4.Text = c.ToString();

}

}

Now first run the Web service then the application.

How to Create a Simple Web Service and Use it in ASP.Net

2013-10-22T02:09:00.000-07:00

Introduction

This article describes how to create a web service in ASP.NET and use it in a client application.

What is Web Service?

A Web Service is a reusable piece of code used to communicate among Heterogeneous Applications.

Once a web service is created and hosted on the server in the internet it can be consumed by any kind of application developed in any technology.

How to create a Web Service

Step 1
Go to Visual Studio then click on "File" -> "Website" -> "ASP.NET empty website template".
Then provide the website name (for example: WebServiceSample).

Step 2: Add a Web Service File

Go to Solution Explorer, then select the solution then click on "Add new item".

Choose the Web Service template.

Enter the name (for example: Airthmatic.cs) then click on "Add".

This will create the following two files:

Airthmatic.asmx (the service file)
Airthmatic.cs (the code file for the service; it will be in the "App_code" folder)

Open the file Airthmatic.cs and write the following code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
/// <summary>
/// used for Airthmatic calculation
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class Airthmatic : System.Web.Services.WebService
{
     public Airthmatic()   {
         //Uncomment the following line if using designed components
         //InitializeComponent();
     }
     [WebMethod]
     public int Add(int x, int y)
     {
         return x + y;
     }
     [WebMethod]
     public int Sub(int x, int y)
     {
         return x - y;
     }
     [WebMethod]
     public int Mul(int x, int y)
     {
         return x * y;
     }
     [WebMethod]
     public int Div(int x, int y)
     {
         return x / y;
     }
}

Attaching the WebMethod attribute to a Public method indicates that you want the method exposed as part of the XML Web service. You can also use the properties of this attribute to further configure the behavior of the XML Web service method. The WebMethod attribute provides the following properties:

BufferResponse

CacheDuration

Description

EnableSession

MessageName

TransactionOption

For more details of web methods click here.

Step 3

To see whether the service is running correctly go to the Solution Explorer then open "Airthmatic.asmx" and run your application.

Now you will find all the method names in the browser.

To see the WSDL format click on the service description link or add "?WSDL" to the URL.

Example: http://localhost:65312/WebServiceSample/Airthmatic.asmx?WSDL

It will show the WSDL.

To determine whether the functions are working, click on one of the functions (for example: "Add").

Now you will see two TextBoxes for checking. Enter the value for x and y and click on the "Invoke" button.

Now you will see the result in an open standard form (XML).

Now your service is ready for use.

Step 4: Creating the client application

Now create a website and design your form as in the following screen.

Or you can copy the following source code.

<body>
     <form id="form1" runat="server">
     <div>
         <table border="2" cellpadding="2" cellspacing="2">
             <tr>
                 <td align="right">
                     <asp:Label ID="Label1" runat="server" Text="Enter 1st Number"></asp:Label>
                 </td>
                 <td align="left">
                     <asp:TextBox ID="txtFno" runat="server"></asp:TextBox>
                 </td>
             </tr>
             <tr>
                 <td align="right">
                     <asp:Label ID="Label2" runat="server" Text="Enter 2nd Number"></asp:Label>
                 </td>
                 <td align="left">
                     <asp:TextBox ID="txtSno" runat="server"></asp:TextBox>
                 </td>
             </tr>
             <tr>
                 <td align="right">
                     <asp:Label ID="Label3" runat="server" Text="Result"></asp:Label>
                 </td>
                 <td align="left">
                     <asp:Label ID="lblResult" runat="server"></asp:Label>
                 </td>
             </tr>
             <tr>
                 <td align="center">
                     <asp:Button ID="btnAdd" runat="server" Text="Add(+)" OnClick="btnAdd_Click" />
                 </td>
                 <td align="center">
                     <asp:Button ID="btnSub" runat="server" Text="Sub(-)" OnClick="btnSub_Click" />
                 </td>
             </tr>
             <tr>
                 <td align="center">
                     <asp:Button ID="BtnMul" runat="server" Text="Mul(*)" OnClick="BtnMul_Click" />
                 </td>
                 <td align="center">
                     <asp:Button ID="btnDiv" runat="server" Text="Div(/)" OnClick="btnDiv_Click" />
                 </td>
             </tr>
         </table>
     </div>
     </form>
</body>

Step 5: Add a web reference to the Website

Go to Solution Explorer then select the solution then click on "AddWeb Reference" then within the URL type the service reference path.

(For example: http://localhost:65312/WebServiceSample/Airthmatic.asmx) then click on the "Go" button.

Now you will see your service methods. Change the web reference name from "localhost" to any other name as you like (for example: WebAirthmatic).

Click on the "Add Reference" button. It will create a Proxy at the client side.

Now go to the cs code and add a reference for the Service.

Example: using WebAirthmatic;

Write the following code.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using WebAirthmatic;
public partial class _Default : System.Web.UI.Page
{
     Airthmatic obj = new Airthmatic();
     int a, b, c;
     protected void Page_Load(object sender, EventArgs e)
     {
     }
     protected void btnAdd_Click(object sender, EventArgs e)
     {
         a = Convert.ToInt32(txtFno.Text);
         b = Convert.ToInt32(txtSno.Text);
         c = obj.Add(a, b);
         lblResult.Text = c.ToString();
     }
     protected void btnSub_Click(object sender, EventArgs e)
     {
         a = Convert.ToInt32(txtFno.Text);
         b = Convert.ToInt32(txtSno.Text);
         c = obj.Sub(a, b);
         lblResult.Text = c.ToString();
     }
     protected void BtnMul_Click(object sender, EventArgs e)
     {
         a = Convert.ToInt32(txtFno.Text);
         b = Convert.ToInt32(txtSno.Text);
         c = obj.Mul(a, b);
         lblResult.Text = c.ToString();
   }
     protected void btnDiv_Click(object sender, EventArgs e)
     {
         a = Convert.ToInt32(txtFno.Text);
         b = Convert.ToInt32(txtSno.Text);
         c = obj.Div(a, b);
         lblResult.Text = c.ToString();
     }
}

Now first run the Web service then the application.

Now you will be able to communicate with the web service.

Translate Your Web Site Using Bing Translator Widget

2013-10-21T02:09:00.003-07:00

Introduction
This article describes how to translate your website using the Bing Translator Widget.
Description
The Translator web page widget allows you to bring real-time, in-place translation to your web site.
You just need to copy and paste some JavaScript code or API to your website.
Open the following link:
http://www.bing.com/widget/translator
Copy the code.

Or copy the following code that I copied from that link and paste it into your HTML.

</div>

setTimeout(function () {

{

var s = document.createElement('script');

s.type = 'text/javascript'; s.charset = 'UTF-8';

s.src = ((location && location.href && location.href.indexOf('https') == 0) ? 'https://ssl.microsofttranslator.com' : 'http://www.microsofttranslator.com') + '/ajax/v3/WidgetV3.ashx?siteData=ueOIGRSKkd965FeEGM5JtQ**&ctf=True&ui=true&settings=Manual&from=en';

var p = document.getElementsByTagName('head')[0] || document.documentElement; p.insertBefore(s,

p.firstChild);

}

}, 0);

</script>

Sample to check
Now create a website and a page and add some content to it.

Now design your screen as in the following screen.

Or you can copy the following source code:

<div>

<table>

<tr>

<td>

</div>

setTimeout(function () {

{

var s = document.createElement('script');

s.type = 'text/javascript'; s.charset = 'UTF-8';

var p = document.getElementsByTagName('head')[0] || document.documentElement; p.insertBefore(s,

p.firstChild);

}

}, 0);

</script>

</td>

</tr>

<tr>

C# (pronounced see sharp) is a multi-paradigm programming language encompassing

strong typing, imperative, declarative, functional, procedural, generic, object-oriented

(class-based), and component-oriented programming disciplines. It was developed

by Microsoft within its .NET initiative and later approved as a standard by Ecma

(ECMA-334) and ISO (ISO/IEC 23270:2006). C# is one of the programming languages

designed for the Common Language Infrastructure. C# is intended to be a simple,

modern, general-purpose, object-oriented programming language.[6] Its development

team is led by Anders Hejlsberg. The most recent version is C# 5.0, which was released

on August 15, 2012.

</td>

</tr>

</table>

</div>

</form>

Now build your application.
And click on the "Translate" button.

It will open a panel with all languages and select the language from the list to translate.

Here I selected Hindi. So my webpage content will be translated to Hindi.

Thank you.

To download the Source Click here.

Get the Battery Details of Your System in Windows Form

2013-10-17T04:00:00.002-07:00

Introduction

This article explains how to get the details of the battery connected to your system. Here I will get the information from the Win32_Battery class.

What Win32_Battery is

The Win32_Battery WMI class a represents battery connected to the computer system..

Design

Create a new Windows Forms Application Project.

Add one button control to the form.

Design your screen as in the following screen:

Next add a reference for "System.Management".

To add the reference use the following procedure.

Go to Solution Explorer, select the project and right-click on that and choose "Add Reference" from the menu.

A window will open; in that choose the ".Net" tab.

It will show a list. In that list, choose "System.Management" and click the "OK" Button.

Now go to code view

Add the namespace "using System.Management;".

Write the following code in the Button Click event:

private void button1_Click(object sender, EventArgs e)
{
        SelectQuery Sq = new SelectQuery("Win32_Battery");
        ManagementObjectSearcher objOSDetails = new ManagementObjectSearcher(Sq);
        ManagementObjectCollection osDetailsCollection = objOSDetails.Get();
        StringBuilder sb = new StringBuilder();
        foreach (ManagementObject mo in osDetailsCollection)
{
sb.AppendLine(string.Format("Availability: {0}", (ushort)mo["Availability"]));
sb.AppendLine(string.Format("BatteryRechargeTime: {0}", (string)mo["BatteryRechargeTime"]));
sb.AppendLine(string.Format("BatteryStatus: {0}", (ushort)mo["BatteryStatus"]));
sb.AppendLine(string.Format("Caption: {0}", (string)mo["Caption"]));
sb.AppendLine(string.Format("Chemistry: {0}", (ushort)mo["Chemistry"]));
sb.AppendLine(string.Format("ConfigManagerErrorCode: {0}", (string)mo["ConfigManagerErrorCode"]));
sb.AppendLine(string.Format("InstallDate: {0}", Convert.ToDateTime(mo["InstallDate"]).ToString()));
sb.AppendLine(string.Format("ConfigManagerUserConfig: {0}", (string)mo["ConfigManagerUserConfig"]));
sb.AppendLine(string.Format("CreationClassName : {0}", (string)mo["CreationClassName"]));
sb.AppendLine(string.Format("Description: {0}", (string)mo["Description"]));
sb.AppendLine(string.Format("DesignCapacity : {0}", (string)mo["DesignCapacity"]));
sb.AppendLine(string.Format("DesignVoltage: {0}", (ulong)mo["DesignVoltage"]));
sb.AppendLine(string.Format("DeviceID : {0}", (string)mo["DeviceID"]));
sb.AppendLine(string.Format("ErrorCleared: {0}", (string)mo["ErrorCleared"]));
sb.AppendLine(string.Format("ErrorDescription : {0}", (string)mo["ErrorDescription"]));
sb.AppendLine(string.Format("EstimatedChargeRemaining: {0}", (ushort)mo["EstimatedChargeRemaining"]));
sb.AppendLine(string.Format("EstimatedRunTime : {0}", mo["EstimatedRunTime"]).ToString());
sb.AppendLine(string.Format("ExpectedBatteryLife: {0}", (string)mo["ExpectedBatteryLife"]));
sb.AppendLine(string.Format("ExpectedLife : {0}", (string)mo["ExpectedLife"]));
sb.AppendLine(string.Format("FullChargeCapacity: {0}", (string)mo["FullChargeCapacity"]));
sb.AppendLine(string.Format("LastErrorCode : {0}", (string)mo["LastErrorCode"]));
sb.AppendLine(string.Format("MaxRechargeTime: {0}", (string)mo["MaxRechargeTime"]));
sb.AppendLine(string.Format("Name : {0}", (string)mo["Name"]));
sb.AppendLine(string.Format("PNPDeviceID: {0}", (string)mo["PNPDeviceID"]));
sb.AppendLine(string.Format("PowerManagementSupported : {0}", mo["PowerManagementSupported"]).ToString());
sb.AppendLine(string.Format("SmartBatteryVersion: {0}", (string)mo["SmartBatteryVersion"]));
sb.AppendLine(string.Format("Status : {0}", (string)mo["Status"]));
sb.AppendLine(string.Format("SystemCreationClassName : {0}", (string)mo["SystemCreationClassName"]));
sb.AppendLine(string.Format("SystemName: {0}", (string)mo["SystemName"]));
sb.AppendLine(string.Format("TimeToFullCharge : {0}", (string)mo["TimeToFullCharge"]));
sb.AppendLine(string.Format("TimeOnBattery: {0}", (string)mo["TimeOnBattery"]));
              UInt16[] PowerManagement = (UInt16[])mo["PowerManagementCapabilities"];
  foreach (uint version in PowerManagement)
{
                    sb.AppendLine(string.Format("PowerManagementCapabilities: {0}", version.ToString()));
}
}
        MessageBox.Show(sb.ToString()); }

In the code above I am getting the information from Win32_Battery and showing it in a Message Box on a button click.

SelectQuery

It represents a WQL (WMI Query Language) SELECT data query.

ManagementObjectSearcher

It retrieves a collection of management objects based on a specified query.

This class is one of the more commonly used entry points to retrieving management information.

ManagementObjectCollection

It represents various collections of management objects retrieved using WMI.

Now build your application. Click on the button; it will show the Battery details in a Message box.

Click here to download Source

Thank you.

Get the Details of Your Windows Operating System in ASP.Net

2013-10-17T03:54:00.001-07:00

Introduction

This article describes how to get the details of your Windows Operating System. Here I will get the information from the Win32_OperatingSystem class.

Win32_OperatingSystem

The Win32_OperatingSystem WMI Class represents a Windows-based operating system installed on a computer. Any operating system that can be installed on a computer that can run a Windows-based operating system is a descendent or member of this class. Win32_OperatingSystem is a singleton class.

If a computer has multiple operating systems installed then this class only returns an instance for the currently active operating system. Design
Create a new ASP.Net Empty website.

Add one page in that website.

Write the following source code:

<head runat="server">
    <title></title>
    <style type="text/css">
        html
        {
            font-size: 1.5em;
            font-family: Calibri;
            color: Red;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    </div>
    </form>
</body>
</html>

Next add a reference for System.Management.

To add the reference use the following procedure.

Go to Solution Explorer, select the project and right-click on that and choose "Add Reference" from the menu.

A window will open; in that choose the .Net tab.

It will show a list. In that list, choose System.Management and click the "OK" button.

Now go to code view and write the following code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Management;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SelectQuery Sq = new SelectQuery("Win32_OperatingSystem");
        ManagementObjectSearcher objOSDetails = new ManagementObjectSearcher(Sq);
        ManagementObjectCollection osDetailsCollection = objOSDetails.Get();
        foreach (ManagementObject mo in osDetailsCollection)
        {
            Response.Write("Name : " + mo["name"].ToString() + "<br/>");
            Response.Write("Version : " + mo["version"].ToString() + "<br/>");
            Response.Write("Csname : " + mo["csname"].ToString() + "<br/>");
            Response.Write("Boot Device : " + mo["BootDevice"].ToString() + "<br/>");
            Response.Write("Build Number : " + mo["BuildNumber"].ToString() + "<br/>");
            Response.Write("BuildType : " + mo["BuildType"].ToString() + "<br/>");
            Response.Write("Caption : " + mo["Caption"].ToString() + "<br/>");
            Response.Write("CodeSet : " + mo["CodeSet"].ToString() + "<br/>");
            Response.Write("CountryCode : " + mo["CountryCode"].ToString() + "<br/>");
            Response.Write("CreationClassName : " + mo["CreationClassName"].ToString() + "<br/>");
            Response.Write("CSCreationClassName : " + mo["CSCreationClassName"].ToString() + "<br/>");
            Response.Write("CSDVersion : " + mo["CSDVersion"].ToString() + "<br/>");
            Response.Write("CurrentTimeZone : " + mo["CurrentTimeZone"].ToString() + "<br/>");
            Response.Write("DataExecutionPrevention_Available : " + mo["DataExecutionPrevention_Available"].ToString() + "<br/>");
            Response.Write("DataExecutionPrevention_32BitApplications : " + mo["DataExecutionPrevention_32BitApplications"].ToString() +
"<br/>");
            Response.Write("DataExecutionPrevention_Drivers : " + mo["DataExecutionPrevention_Drivers"].ToString() + "<br/>");
            Response.Write("DataExecutionPrevention_SupportPolicy : " + mo["DataExecutionPrevention_SupportPolicy"].ToString() + "<br/>");
            Response.Write("Debug : " + mo["Debug"].ToString() + "<br/>");
            Response.Write("Description : " + mo["Description"].ToString() + "<br/>");
            Response.Write("Distributed : " + mo["Distributed"].ToString() + "<br/>");
            Response.Write("EncryptionLevel : " + mo["EncryptionLevel"].ToString() + "<br/>");
            Response.Write("ForegroundApplicationBoost : " + mo["ForegroundApplicationBoost"].ToString() + "<br/>");
            Response.Write("FreePhysicalMemory : " + mo["FreePhysicalMemory"].ToString() + "<br/>");
            Response.Write("FreeSpaceInPagingFiles : " + mo["FreeSpaceInPagingFiles"].ToString() + "<br/>");
            Response.Write("FreeVirtualMemory : " + mo["FreeVirtualMemory"].ToString() + "<br/>");
            Response.Write("InstallDate : " + mo["InstallDate"].ToString() + "<br/>");
            Response.Write("LastBootUpTime : " + mo["LastBootUpTime"].ToString() + "<br/>");
            Response.Write("LocalDateTime : " + mo["LocalDateTime"].ToString() + "<br/>");
            Response.Write("Locale : " + mo["Locale"].ToString() + "<br/>");
            Response.Write("Manufacturer : " + mo["Manufacturer"].ToString() + "<br/>");
            Response.Write("MaxNumberOfProcesses : " + mo["MaxNumberOfProcesses"].ToString() + "<br/>");
            Response.Write("MaxProcessMemorySize : " + mo["MaxProcessMemorySize"].ToString() + "<br/>");
            Response.Write("NumberOfProcesses : " + mo["NumberOfProcesses"].ToString() + "<br/>");
            Response.Write("NumberOfUsers : " + mo["NumberOfUsers"].ToString() + "<br/>");
            Response.Write("OperatingSystemSKU : " + mo["OperatingSystemSKU"].ToString() + "<br/>");
            Response.Write("Organization : " + mo["Organization"].ToString() + "<br/>");
            Response.Write("OSArchitecture : " + mo["OSArchitecture"].ToString() + "<br/>");
            Response.Write("OSLanguage : " + mo["OSLanguage"].ToString() + "<br/>");
            Response.Write("OSType : " + mo["OSType"].ToString() + "<br/>");
            Response.Write("PAEEnabled : " + mo["PAEEnabled"].ToString() + "<br/>");
            Response.Write("Primary : " + mo["Primary"].ToString() + "<br/>");
            Response.Write("ProductType : " + mo["ProductType"].ToString() + "<br/>");
            Response.Write("RegisteredUser : " + mo["RegisteredUser"].ToString() + "<br/>");
            Response.Write("SerialNumber : " + mo["SerialNumber"].ToString() + "<br/>");
            Response.Write("ServicePackMajorVersion : " + mo["ServicePackMajorVersion"].ToString() + "<br/>");
            Response.Write("ServicePackMinorVersion : " + mo["ServicePackMinorVersion"].ToString() + "<br/>");
            Response.Write("SizeStoredInPagingFiles : " + mo["SizeStoredInPagingFiles"].ToString() + "<br/>");
            Response.Write("Status : " + mo["Status"].ToString() + "<br/>");
            Response.Write("SuiteMask : " + mo["SuiteMask"].ToString() + "<br/>");
            Response.Write("SystemDevice : " + mo["SystemDevice"].ToString() + "<br/>");
            Response.Write("SystemDirectory : " + mo["SystemDirectory"].ToString() + "<br/>");
            Response.Write("SystemDrive : " + mo["SystemDrive"].ToString() + "<br/>");
            Response.Write("TotalVirtualMemorySize : " + mo["TotalVirtualMemorySize"].ToString() + "<br/>");
            Response.Write("TotalVisibleMemorySize : " + mo["TotalVisibleMemorySize"].ToString() + "<br/>");
            Response.Write("Version : " + mo["Version"].ToString() + "<br/>");
            Response.Write("WindowsDirectory : " + mo["WindowsDirectory"].ToString() + "<br/>");
        }
    }
}In the code above I get the information from Win32_OperatingSystem and display that in the page.

SelectQueryIt represents a WMI Query Language (WQL) SELECT data query.

ManagementObjectSearcherIt retrieves a collection of management objects based on a specified query.

This class is one of the more commonly used entry points to retrieving management information.

ManagementObjectCollectionIt represents various collections of management objects retrieved using WMI.

Now build your application, it will show the details of your Windows OS in the page.

Click here to download source

Get All Intranet User Details in ASP.Net

2013-10-17T03:50:00.000-07:00

Introduction

This article describes how to get the details of users present in an intranet. Here I will get the information from the Win32_UserAccount class.

What is Win32_UserAccount

The Win32_UserAccount WMI class contains information about a user account on a computer system running Windows.

Design
Create a new ASP.Net Empty website.

Add one page in that website.

In that page drag and drop a GridView control.

Design your screen as in the following screen.

Or you can copy the following source code:

<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" >
            <AlternatingRowStyle BackColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
        </asp:GridView>
    </div>
    </form>
</body>

Next add a reference of System.Management.

To add the reference use the following procedure.

Go to Solution Explorer, select the project and right-click on that and choose "Add Reference" from the menu.

A window will open; in that choose the .Net tab.

It will show a list. In that list, choose System.Management and click the "OK" button.

Now go to code view and write following code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Management;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("User name", typeof(string)));
        dt.Columns.Add(new DataColumn("Account Type", typeof(string)));
        dt.Columns.Add(new DataColumn("Caption", typeof(string)));
        dt.Columns.Add(new DataColumn("Description", typeof(string)));
        dt.Columns.Add(new DataColumn("Disabled", typeof(string)));
        dt.Columns.Add(new DataColumn("Domain", typeof(string)));
        dt.Columns.Add(new DataColumn("Instal Date", typeof(string)));
        dt.Columns.Add(new DataColumn("Local Account", typeof(string)));
        dt.Columns.Add(new DataColumn("Lockout", typeof(string)));
        dt.Columns.Add(new DataColumn("Password Changeable", typeof(string)));
        dt.Columns.Add(new DataColumn("Password Expires", typeof(string)));
        dt.Columns.Add(new DataColumn("Password Required", typeof(string)));
        dt.Columns.Add(new DataColumn("SID", typeof(string)));
        dt.Columns.Add(new DataColumn("SID Type", typeof(string)));
        dt.Columns.Add(new DataColumn("Status", typeof(string)));
        SelectQuery Sq = new SelectQuery("Win32_UserAccount");
        ManagementObjectSearcher objOSDetails = new ManagementObjectSearcher(Sq);
        ManagementObjectCollection osDetailsCollection = objOSDetails.Get();
        foreach (ManagementObject MO in osDetailsCollection)
        {
            DataRow dr = dt.NewRow();
            dr["User name"] = MO["FullName"].ToString();
            dr["Account Type"] = MO["AccountType"].ToString();
            dr["Caption"] = MO["Caption"];
            dr["Description"] = MO["Description"];
            dr["Disabled"] = MO["Disabled"];
            dr["Domain"] = MO["Domain"];
            dr["Instal Date"] = MO["InstallDate"];
            dr["Local Account"] = MO["LocalAccount"];
            dr["Lockout"] = MO["Lockout"];
            dr["Password Changeable"] = MO["PasswordChangeable"];
            dr["Password Expires"] = MO["PasswordExpires"];
            dr["Password Required"] = MO["PasswordRequired"];
            dr["SID"] = MO["SID"];
            dr["SID Type"] = MO["SIDType"];
            dr["Status"] = MO["Status"];
            dt.Rows.Add(dr);
        }
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}In the code above I get the information from Win32_UserAccount and store it in a datatable and bind it to the grid.

SelectQueryIt Represents a WQL (WMI Query Language) SELECT data query.

ManagementObjectSearcherIt retrieves a collection of management objects based on a specified query.

This class is one of the more commonly used entry points to retrieving management information.

ManagementObjectCollectionIt represents various collections of management objects retrieved using WMI.

Now build your application, it will show all intranet userinfo in the grid.

To download the source click here

Important SQL Queries Every Developer Should Know in SQL Server

2013-07-23T04:19:00.000-07:00

Introduction

In this article I am sharing some SQL queries necessary for maintaining data in SQL Server for every developer.SQL

Get the related Stored Procedure to a table

SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%Yourtablename%'
Or you can use following query

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%yourtablename%'

Get the related table to a Stored Procedure

;WITH stored_procedures AS (
SELECT
o.name AS proc_name, oo.name AS table_name,
ROW_NUMBER() OVER(partition by o.name,oo.name ORDER BY o.name,oo.name) AS row
FROM sysdepends d
INNER JOIN sysobjects o ON o.id=d.id
INNER JOIN sysobjects oo ON oo.id=d.depid
WHERE o.xtype = 'P')
SELECT proc_name, table_name FROM stored_procedures
WHERE row = 1
AND proc_name LIKE '%YourStoredProcedureName%'
ORDER BY proc_name,table_name

Get the related trigger to a table

select so.name, text
from sysobjects so, syscomments sc
where type = 'TR'
and so.id = sc.id and text like '%YourTableName%'

Get the related views to a table

SELECT view_name, Table_Name
FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE
WHERE Table_Name= 'YourTableName'
ORDER BY view_name, table_name

Get the related table to a view

SELECT view_name, Table_Name
FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE
WHERE View_Name = 'YourViewName'
ORDER BY view_name, table_name

Get the tables that do not have an identity column

SELECT
TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
where
Table_NAME NOT IN
(
SELECT DISTINCT c.TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS c
INNER
JOIN sys.identity_columns ic
on
(c.COLUMN_NAME=ic.NAME))
AND
TABLE_TYPE ='BASE TABLE'

Get a list of tables with the number of records of each table

CREATE TABLE #counts
(
table_name varchar(255),
row_count int
)
EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?' SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC

If any modifications then please comment.

Thank you.

Retrieve Picasa Albums and View photos in Asp.Net

2013-06-11T00:29:00.000-07:00

Introduction

This article describes how to retrieve Picasa Albums with a photo in ASP.Net. Here I will describe how to communicate with Picasa using the Google API.

Description

Since it is a third party software, for this we require a third party DLL to be referenced by our application that will communicate with the Gmail server.

For this we must download the Google API setup from the following link:

http://code.google.com/p/google-gdata/

Or you can directly download it from this link:

https://google-gdata.googlecode.com/files/Google_Data_API_Setup_2.1.0.0.msi

When you install this setup you will get these DLL files in your PC:

Google.GData.Client.dll
Google.GData.Photos.dll
Google.GData.Extensions.dll

Collect these DLLs.

To view your retrieved photos in a gallery look we use the jQuery class libraries. So you must download these files and CSS:

1. jquery-1.10.1.js

2. jquery.galleriffic.js

3. jquery.opacityrollover.jsYou can also download it from the source code attached in the file.

Design

Now design your screen like the following screen.

Or you can copy the following source code:

// Comment


        

            
                    

                        
                        
                        
                        
                    

                        
                        
                        
                        
                    

                        
                            
                            
                        
                    

                        
                        
                    


        

            

                        
                            
                                
                                    
                                
                            
                            
                                
                                     
                                
                            
                        
                    
                

            
                    




                                Gallery by Sanjeeb

                                CopyRight by Sanjeeb

Next add the following JavaScript code in the head tag (it's used to design the gallery):

<head runat="server">    <title></title>    <link rel="stylesheet" href="css/basic.css" type="text/css" />    <link rel="stylesheet" href="css/galleriffic-2.css" type="text/css" />        <script type="text/javascript" src="js/jquery-1.10.1.js"></script>    <script type="text/javascript" src="js/jquery.galleriffic.js"></script>    <script type="text/javascript" src="js/jquery.opacityrollover.js"></script>    <script type="text/javascript">        document.write('');
    </script>    <script type="text/javascript">        jQuery(document).ready(function ($) {
            // We only want these styles applied when javascript is enabled            $('div.navigation').css({ 'width': '300px', 'float': 'left' });
            $('div.content').css('display', 'block');

            // Initially set opacity on thumbs and add            // additional styling for hover effect on thumbs            var onMouseOutOpacity = 0.67;
            $('#thumbs ul.thumbs li').opacityrollover({
                mouseOutOpacity: onMouseOutOpacity,
                mouseOverOpacity: 1.0,
                fadeSpeed: 'fast',
                exemptionSelector: '.selected'            });
            // Initialize Advanced Galleriffic Gallery            var gallery = $('#thumbs').galleriffic({
                delay: 2500,
                numThumbs: 15,
                preloadAhead: 10,
                enableTopPager: true,
                enableBottomPager: true,
                maxPagesToShow: 7,
                imageContainerSel: '#slideshow',
                controlsContainerSel: '#controls',
                captionContainerSel: '#caption',
                loadingContainerSel: '#loading',
                renderSSControls: true,
                renderNavControls: true,
                playLinkText: 'Play Slideshow',
                pauseLinkText: 'Pause Slideshow',
                prevLinkText: 'Previous Photo',
                nextLinkText: 'Next Photo,
                nextPageLinkText: 'Next ,
                prevPageLinkText: 'Prev',
                enableHistory: false,
                autoStart: false,
                syncTransitions: true,
                defaultTransitionDuration: 900,
                onSlideChange: function (prevIndex, nextIndex) {
                    // 'this' refers to the gallery, which is an extension of $('#thumbs')                    this.find('ul.thumbs').children()
                                                .eq(prevIndex).fadeTo('fast', onMouseOutOpacity).end()
                                                .eq(nextIndex).fadeTo('fast', 1.0);
                },
                onPageTransitionOut: function (callback) {
                    this.fadeTo('fast', 0.0, callback);
                },
                onPageTransitionIn: function () {
                    this.fadeTo('fast', 1.0);
                }
            });
        });
    </script></head>

Now go to the code view.

Next add a reference of the following Google gdata DLL to your website:

Google.GData.Client.dll
Google.GData.Extensions.dll
Google.GData.Photos.dll

And write the following code .cs file:

using System;
using System.Web.UI.WebControls;
using Google.GData.Photos;
using System.Data;
using System.Text;

public partial class _Default : System.Web.UI.Page{
    protected void Page_Load(object sender, EventArgs e)
    {
        lblMsg.Text = string.Empty;
    }
    /// <summary>    /// This method used to bind the albums to grid    /// </summary>    private void BindAlbum()
    {
        AlbumQuery query = new AlbumQuery(PicasaQuery.CreatePicasaUri(txtUserName.Text));
        PicasaService service = new PicasaService("sample");
        service.setUserCredentials(txtUserName.Text, txtpwd.Text);
        Session["token"] = service.QueryClientLoginToken();
        PicasaFeed feed = service.Query(query);
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("Album", typeof(string)));
        dt.Columns.Add(new DataColumn("NO of photo", typeof(string)));
        dt.Columns.Add(new DataColumn("url", typeof(string)));
        dt.Columns.Add(new DataColumn("id", typeof(string)));
        foreach (PicasaEntry entry in feed.Entries)
        {
            DataRow dr1 = dt.NewRow();
            AlbumAccessor ac = new AlbumAccessor(entry);
            dr1["Album"] = entry.Title.Text;
            dr1["NO of photo"] = ac.NumPhotos;
            dr1["id"] = ac.Id;
            dr1["url"] = entry.Media.Thumbnails[0].Url;
            dt.Rows.Add(dr1);
        }
        ds.Tables.Add(dt);
        ViewState["Album"] = ds;
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }

/// <summary> /// this event used to bind the photo to gallery using the albumid /// </summary>

      protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Download")
        {
            Panel1.Visible = true;
            PhotoQuery query = new PhotoQuery(PicasaQuery.CreatePicasaUri(txtUserName.Text, e.CommandArgument.ToString()));
            PicasaService service = new PicasaService("Picasa");
            service.setUserCredentials(hfUsername.Value, hfPwd.Value);
            PicasaFeed feed = service.Query(query);
            StringBuilder html = new StringBuilder();
            string title;
            html.Append("<ul class=\"thumbs noscript\">");
            foreach (PicasaEntry entry in feed.Entries)
            {
                if (entry.Title.Text.LastIndexOf(".") > -1)
                    title = entry.Title.Text.Substring(0, entry.Title.Text.LastIndexOf("."));
                else                    title = entry.Title.Text;

                html.Append(String.Format("<li><a class=\"thumb\" name={0} href=\"{1}\" title=\"{2}\"><img src=\"{3}\" alt=\"{4}\"/></a>",
                    title, entry.Media.Content.Url, title, entry.Media.Thumbnails[0].Url, title));
                html.Append(String.Format("<div class=\"caption\"><div class=\"image-title\">{0}</div><div class=\"image-desc\">{1}</div></div></li>",
                    title, entry.Summary.Text));

            }
            html.Append("</ul>");
            divSlider.InnerHtml = html.ToString();
        }
    }

    protected void GridView1_SelectedIndexChanging(object sender, GridViewPageEventArgs e)
    {
        DataSet ds = ViewState["Album"] as DataSet;
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void btnLogin_Click(object sender, EventArgs e)
    {
        if (txtUserName.Text != string.Empty && txtpwd.Text!=string.Empty)
        {
            hfUsername.Value = txtUserName.Text;
            hfPwd.Value = txtpwd.Text;
            tdlogin.Visible = false;
            BindAlbum();
        }
        else            lblMsg.Text = "Enter Your gmail id and pwd";
    }
}

Now build your application. And enter the Gmail id and password in the corresponding TextBox.

Click on the "Login" button. It will show all your Albums with names, number of photos and album cover photo in the grid.

Now click on any album cover photo to see all photos. It will show all photos in the gallery. In the gallery you can also see the slide show.

To download Code Click Here

Retrieve Gmail Contacts Name with Email in Asp.Net

2013-06-02T01:55:00.001-07:00

Introduction

This article I am going to describe how to retrieve Gmail contact with Name and Mail id in asp net. Here I will describe how to communicate with Gmail using Google API.

Description

As it is a third party software for this we required some third party dll to be referenced to our application which will communicate with Gmail server.

For this we have to download the Google API Set up from below link

http://code.google.com/p/google-gdata/

Or you can direct download from this link

https://google-gdata.googlecode.com/files/Google_Data_API_Setup_2.1.0.0.msi

Install this setup you will get these dll files in your Pc

Google.GData.Apps.dll
Google.GData.Client.dll
Google.GData.Contacts.dll
Google.GData.Extensions.dll

Collect these dll's.

Design

Now design your design the screen as below screen

Or Copy the source code below

Next add reference of Google gdata dll to your website.

Google.GData.Apps.dll
Google.GData.Client.dll
Google.GData.Contacts.dll
Google.GData.Extensions.dll

And write the below code .cs file

Now build your Application. And enter Gmail id and password in the corresponding textbox

Click on Get Contact button it will show all your gmail Contact Name with Email.

Any modification or problem Plz comment

How to Send Mail form Asp .Net Website

2013-05-29T23:15:00.003-07:00

Introduction:

Here i am describing how to Send mail from asp.net website

Description:

This is a common function Required for every website.
For this you have to add System.Web.Mail namespace

The System.Web.Mail namespace contains classes that enable you to construct and send messages using the CDOSYS (Collaboration Data Objects for Windows 2000) message component. The mail message is delivered either through the SMTP mail service built into Microsoft Windows 2000 or through an arbitrary SMTP server. The classes in this namespace can be used from ASP.NET or from any managed application.
For more info about System.Web.Mail click here.

Steps:-
-Create a website and design the Form like below screen

or copy this code in source code and paste within < form > tag

now go to code view and write below code

For validation just write the below javascript code in your head tag

Now you can send mail

This example is for sending mail from Gmail.

If you want any server mail just change the smtp server details with port number and use it.

Maintain Scroll Position On Postback

2013-05-29T23:10:00.002-07:00

Recently i faced problem to maintain scroll position in my page which having A grid with some radio button and check box with autopostback within a Updatepanel.
The main problem is when a postback occur the page is moving to top. i tried a lot and finally got the solution .
1.if you are using IE then its very simple just put the code in your page directive.
but it will not work in Firefox for that you have to add one browser file into your website
Right click on solution explorer > Add New Item
Select Browser File and add it to App_Browsers folder.
Add MaintainScrollPositionOnPostback capability to this browser file as written below.
Some times this also not work,
Then a simple solution just add a blank Update panel after the grid and onpostback just put the focus to that update panel
it will work in any browser.
in cs postbackevent
if any problem just feel free to ask or any modification reply.