Mukund's Ideas

How to connect to a ESRI Geodatabase and return workspace.

2012-02-15T07:28:00.000-08:00

Initialize Product License with License Initializer

Connecting to GeoDB is the first step of querying the GeoDB. Inorder to work with the ArcObjects, the ArcGIS license has to be initialized. ESRI provides a License initializer project downloaded from the below link.

http://edn.esri.com/index.cfm?fa=codeExch.sampleDetail&pg=/arcobjects/9.1/Samples/Licensing_and_Extension_Checking/InitializeProductLicenseWithLicenseInitializer/InitializeProducLicenseWithLicenseInitializer.htm

Download the Project and add it to your solution which uses arcObjects. Set the Project InitializeProductLicense as the startup and run the project. Debug and see what is the license status returned.

below are the different cases returned

//esriLicenseAvailable                 
//esriLicenseNotLicensed
//esriLicenseFailure                   
//esriLicenseAlreadyInitialized                  
//esriLicenseNotInitialized
//esriLicenseCheckedOut                    
//esriLicenseCheckedIn

IF the return value is isriLicenseCheckedOut, then license is intialized.

Below is the method that get path of the geoDB say C:\\test\\Test.gdb and returns the workspace that can be queried for different scenarios.

Namespace Used:

using ESRI.ArcGIS.Geodatabase;
using ESRI.ArcGIS.DataSourcesFile;
using ESRI.ArcGIS.esriSystem;
using ESRI.ArcGIS.DataSourcesGDB;
using ESRI.ArcGIS.Geometry;

public static IWorkspace FileGdbWorkspaceFromPropertySet(String path)
{
//Initialize the application.
esriLicenseStatus licenseStatus = esriLicenseStatus.esriLicenseUnavailable;
IAoInitialize m_AoInitialize = new AoInitializeClass();
licenseStatus = m_AoInitialize.Initialize(esriLicenseProductCode.esriLicenseProductCodeArcView);

Type factoryType = Type.GetTypeFromProgID(
"esriDataSourcesGDB.FileGDBWorkspaceFactory");
IWorkspaceFactory2 workspaceFactory = (IWorkspaceFactory2)Activator.CreateInstance
(factoryType);
return workspaceFactory.OpenFromFile(path, 0);
}

In the next post will see how to query parcels intersecting a envelope in the GeoDB.

How to set html link visible false depending on Eval function in grid view

2011-12-08T00:33:00.000-08:00

Below is the html link in the grid view item template that sets visibility depending on the IsOnline values.

<a href = "www.google.com" style='<%# Eval("IsOnline").ToString() == "True" ? "display:block" : "display:none" %>' >link</a>

How to convert DateTime to Date in Linq to Entity + C#

2011-12-07T10:13:00.000-08:00

Use EntityFunction to truncate the time part from a DateTime String.

grid.DataSource = (from user in context.Users where ISActive = True select new
{
user.UserId,
user.UserName,
FirstName = (user.FirstName + " " + user.LastName),
CreatedDate = System.Data.Objects.EntityFunctions.TruncateTime(user.CreatedDate)
}).ToList();)

Clipboard operations in javascript

2011-06-19T11:12:00.000-07:00

Copy TO and Copy FROM CLIPBOARD :


<body>
    <textarea id='clipText'>
Enter Text And Click Button To Copy Text To ClipBoard</textarea><br />
    <input type="button" id='bt' onclick="clipboardData.setData('Text',document.getElementById('clipText').value);"
        value="Copy" />
    <input type="button" onclick="clipboardData.clearData('Text');" value="Clear" />
    <input type="button" onclick="alert(clipboardData.getData('Text'));" value="Paste" />
</body>

How to insert a Guid or UniqueIdentifier and return it as a OUTPUT parameter + StoredProcedure. + SQL

2011-05-26T11:21:00.000-07:00

CREATE PROCEDURE [test]
    @name as varchar(50),
    @id as uniqueidentifier OUTPUTAS
BEGIN
    declare @returnid table (id uniqueidentifier)

    INSERT INTO test(
        name
    )
    output inserted.id into @returnid
    VALUES(
        @name
    )

    select @id = r.id from @returnid rEND

Above SP returns the newly inserted GUID as the OUT parameter.

How to use double coute in string + C#

2011-05-20T12:28:00.000-07:00

This usage of double coutes in a string can be easily done using @.
For eg:
To show the below text
"This is a "Test"

Code:
TextBox1.text = @"""This is a " + @"""Test""";

The logic is that if you use @ in front of the sting variable then using e double coute(""")
throughout the string will give you one double coute(").

How to create a text file and save it on client machine using Save File Dialog + Asp.Net + C#

2011-05-20T12:11:00.000-07:00

Method to Create text file:
Using System.IO;
Using SystemsText;

private void CreatetxtFile()
{
StringBuilder sb = new StringBuilder();

sb.AppendLine("test");
sb.AppendLine("= = = = = =");
sb.AppendLine();
sb.Append("test2");
sb.AppendLine();
sb.AppendLine();

using (StreamWriter outfile = new StreamWriter("c:" + @"\AllTxtFiles.txt"))
{
outfile.Write(sb.ToString());
}

}

Code to Save the file as dialog :

Response.ContentType = "text/plain";
Response.AppendHeader("Content-Disposition", "attachment; filename=AllTxtFiles.txt");

// specify the path of the file that has to be saved in client machine.
Response.TransmitFile("c://AllTxtFiles.txt");
Response.End();

The above code will show a save file dialog to save the file.

How to update data from excel sheet to the sql data base. + How to compare two date time columns and find the later values

2011-04-25T10:09:00.000-07:00

// Copies the excel sheet values to the table sTemp.
SELECT * INTO dbo.sTemp
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test.xls;IMEX=1',
'SELECT * FROM [Sheet_Name2$]')

GO

// Compares two columns of the excel and updates the table with the later values.
UPDATE INV
SET
INV.EndDate = TMP.RecentDate
FROM
dbo.Inventory as INV
INNER JOIN
(
SELECT
Inventoryid,
CASE
WHEN ISNULL([WEDate],'') >= ISNULL([MEDate],'')
THEN
[WEDate]
ELSE
[MEDate]
END
AS MostRecentDate,
[WEDate],
[MEDate]
FROM sTemp
) TMP
ON
TMP.TestID = INV.TestID

GO

DROP TAble stemp

GO

How to find First non repeated character in a string + c#

2010-10-04T01:54:00.000-07:00

This is really a mind twisting question. But if you dint give a try to solve this , you may think that its so simple.
This was asked in one of my interview.
now lets see how to solve this
Method call : GetFirstNonRepeatedChar("abcdab");

private char GetFirstNonRepeatedChar(string value)
   {
   // declare a character array.
   char[] cArr = null;
   try
   {
   // load the string to char array.
   cArr = value.ToCharArray();

   for (int i = 0; i < cArr.Length; i++)
   {
   // count to track all comparison has over
   int count = 0;
for (int j = 0; j < cArr.Length; j++)
   {
   // avoids to comparison for same character
   if (i != j)
   {
   // if repeated then come out of the inner loop
   if (cArr[i] == cArr[j])
   {
   break;
   }
   else
   {
   // increament the count for each non repeatable comparison
   count = count + 1;
   // if the count reaches the char array length - 1
   // and you are inside the for loop then the current value
   // is the first non repeated character.
   if (count == cArr.Length -1)
   {
   return cArr[i];
   }
   }
   }
   }
}
   return '0'; // if no non repeated char is fount
   }
   catch (Exception)
   {

   throw;
   }
   }

Answer : c

Difference between exec and sp_executesql + SQL SERVER

2010-10-02T05:00:00.000-07:00

If we are using Direct T-SQL (not dynamic) in stored procedure, SQL Server reuses execution plan from the cache. i.e. SQL Server will not compile the Stored Procedure again.

If we are using dynamic sql in stored procedure, SQL Server may not use the execution plan. It will recreate the execution plan every time with different string of SQL.So, we have to think about the performance while using dynamic sql.

To execute the dynamic SQL in stored procedure, we have to use the following way.

1. EXEC (Non- parameterized)
2. sp_executesql (Parameterized)

There will be performance difference between above two.

Execution plan will not be created until you execute the dynamic sql. If you execute the dynamic sql using EXEC, execution plan will be created for every execution even values only changing. If you use sp_executesql, SQL Server Optimizer will try to use same execution plan. Because dynamic sql string will be the same, values only going to change. So it will be treated as Stored Procedure having input parameters.

Stored Procedure(SP) Vs User Defined Functions(UDF) + SQL SERVER

2010-09-30T03:16:00.000-07:00

Differences:
1. Procedure can return zero or n values whereas function can return one value which is mandatory.

2. Procedures can have input,output parameters for it whereas functions can have only input parameters.
3. Procedure allow select as well as DML statement in it whereas function allow only select statement in it.
4. Functions can be called from procedure whereas procedures cannot be called from function.
5. Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.
6. We can go for transaction management in procedure whereas we can't go in function.
7. Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.

How to specify table name dynamically in a SQL statement + SQL SERVER 2008

2010-09-09T03:24:00.000-07:00

Dynamic SQL :
Using a dynamic sql is quite comman in sql statement. I had a situation where
i have to pass the table file as a argument to a Stored Procudure and depending
upon the argument i have to execute the Select statement.

Say for eg.
argument @Table = dbo.Customers
then
SELECT * FROM @Table
But this doesnt work.
So when you are in a need to specify any of the objects like table or column etc
we need to use dynamic SQL using exec method. Below is an example

DECLARE @TableName varchar(50)
SET @TableName ='dbo.Customers'
DECLARE @SQL varchar(max)
SET @SQL = 'SELECT * FROM ' +@TableName // dynamic table name
EXEC(@SQL)

How to find the intersected rows of a spatial Index using POLYGON object + Spatial Queries

2010-09-08T01:14:00.000-07:00

Below is the sample stored procedure used to find the
rows that are intersected with the POLYGON object
[Created using Coordinates list].

CREATE PROCEDURE [dbo].[GetIntersectingRows]
-- Add the parameters for the stored procedure here
@Coordinates varchar(max)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

Declare @AOIPolygon geography
set @AOIPolygon = geography::STPolyFromText('POLYGON(('+@Coordinates+'))', 4326);

SELECT ID,Quad_Name,State from dbo.USCollared250K_Index
WITH (INDEX(geom_sidx)) WHERE
@AOIPolygon.STIntersects(geom) = 1;
END

Note:
@Coordinates - comma separated pairs of coordinates like
eg. -104.864472 39.764004,-104.864472 39.853945,-105.057976 39.853945,
-105.057976 39.764004,-104.864472 39.764004

How to open a pop up window with specified properties[height,width,position and no menubar,no resizable]. + Javascript

2010-09-08T00:50:00.000-07:00

Below is the javascript method that opens a popup without scrolbar or menubar or resizable etc

function openQuadPopup(val) {
   var width = screen.width - 100;
   var height = screen.height - 100;
   var leftPos = (screen.width - width - 30) / 2;
   var topPos = (screen.height - height - 30) / 2;
   myWindow = window.open('TestPage.aspx?ImagePath=' + val, 'NameForPopup', 'menubar=0,resizable=0,width=' + width + ',height=' + height + "'");

   myWindow.moveTo(leftPos, topPos);
   }

To include scroll bars use

window.open('TestPage.aspx', '','scrollbars=yes,width=300,height=300')

How to find Country's Name using IP Address in Asp.Net

2010-08-26T04:14:00.000-07:00

Use the below free web-service to get the country name using IP Address.
http://www.webservicex.net/geoipservice.asmx?wsdl

Add the service to your web or windows application and name the service
as say for eg. locationFinder
Now access it in your code as
// Create instance for the service

LocationFinder.GeoIPService service = new LocationFinder.GeoIPService();
// Gets the country name.
string country = service.GetGeoIP("216.241.xxx.xx").CountryName;

To get the ipAddress of the Client machine use
String ipAddress = Request.UserHostAddress.ToString();

Simple login page using Forms's Authentication + Asp.Net + C#

2010-08-11T05:12:00.000-07:00

Login Page Implementation[Forms Authentication] :
Login page implementation is a basic need in most applications.
Now lets see a simple implementation of the Login Page in asp.net.
Create a page named Login.aspx and add a table like

Login:

<table align="center">
   <tr>
   <td>
   UserName :</td>
   <td> 
   <asp:TextBox ID="txtUserName" runat="server" /></td>
   <td>
   <asp:RequiredFieldValidator ID="RequiredFieldValidator1"
   ControlToValidate="txtUserName"
   Display="Dynamic"
   ErrorMessage="Please Enter User Name"
   runat="server" />
   </td>
   </tr>
   <tr>
   <td>
   Password :</td>
   <td>
   <asp:TextBox ID="txtPassword" TextMode="Password"
   runat="server" />
   </td>
   <td>
   <asp:RequiredFieldValidator ID="RequiredFieldValidator2"
   ControlToValidate="txtPassword"
   ErrorMessage="Please Enter Password."
   runat="server" />
   </td>
   </tr>
   <tr>
   <td colspan="3" align="left">
   <asp:Button ID="Submit1" OnClick="Logon_Click" Text="Log On"
   runat="server" />
   </td>
   </tr>
   <tr>
   <td colspan="3">
   <p>
   <asp:Label ID="Msg" ForeColor="red" runat="server" />
   </p>
   </td>
   </tr>
   </table>

Now add the code-behind for login page like

   // if you have more users then store the username and
   // password in back-end database and perform the check

   if ((txtUserName.Text == "mukunda") && (txtPassword.Text == "easyone1"))
   {
   // This statement will redirect to start page automatically.
   FormsAuthentication.RedirectFromLoginPage
   (txtUserName.Text, false);
   }
   else
   {
   // to show error message for invalid login.
   Msg.Text = "Invalid credentials. Please try again.";
   }

To make the above code work we need to add the following to web config

   <authentication mode="Forms">
   <forms loginUrl="Login.aspx" name=".ASPXFORMSAUTH">
  </forms>
  </authentication>
  <authorization>
<deny users="?"/>
  </authorization>
   inside <system.web> tag.

And in the Main page you can access the logged user name and
show it in a label like
lblEmpID.Text = Context.User.Identity.Name;

LogOut :
To log out the current user you need to add a link button in main page
<asp:LinkButton ID="Submit1" runat="server"
OnClick="Signout_Click">Sign Out</asp:LinkButton>

Code-Behind:

   /// <summary>
   /// event for signingout the current page & redirect to Login page
   /// </summary>
   protected void Signout_Click(object sender, EventArgs e)
   {
   FormsAuthentication.SignOut();
   Response.Redirect("Login.aspx");
   }

Now a simple login implementation using Forms Authentication is done!

Simple Add,Edit,Update and Delete operations in GridView + Asp.net 3.5

2010-08-10T06:23:00.000-07:00

Lets first create a table in MSAccess like below named Customer

Customer Table

Aspx Page:

Drag a gridview and fields and event as given below

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
   DataKeyNames="ID" onrowcommand="GridView1_RowCommand"
   onrowdeleting="GridView1_RowDeleting"
   onrowediting="GridView1_RowEditing"
   onrowdatabound="GridView1_RowDataBound"
   onrowupdating="GridView1_RowUpdating">
   <Columns>
   <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="true"/>
   <asp:TemplateField HeaderText="Name">
   <EditItemTemplate>
   <asp:TextBox ID="txtTName" runat="server"
   Text='<%# Bind("Name") %>'></asp:TextBox>
   </EditItemTemplate>
   <ItemTemplate>
   <asp:Label ID="Label1" runat="server" Text='<%# Bind("Name") %>'>
   </asp:Label>
   </ItemTemplate>
   </asp:TemplateField>
   <asp:TemplateField HeaderText="Age">
   <EditItemTemplate>
   <asp:TextBox ID="txtTAge" runat="server"
   Text='<%# Bind("Age") %>'></asp:TextBox>
   </EditItemTemplate>
   <ItemTemplate>
   <asp:Label ID="Label2" runat="server" Text='<%# Bind("Age") %>'>
   </asp:Label>
   </ItemTemplate>
   </asp:TemplateField>
   <asp:CommandField ShowDeleteButton="True" />
   <asp:CommandField ShowEditButton="True" />
   </Columns>
   </asp:GridView>

.cs page:
// Create a connection to Access Database.
OleDbConnection aConnection = new OleDbConnection
("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\CustomerInfo.mdb");

// Binds grid on page load.

protected void Page_Load(object sender, EventArgs e)
   {
   if (!Page.IsPostBack)
   {
   bindGrid();
   }
   }

// Method to bind grid

private void bindGrid()
   {
   string query = string.Empty;
   OleDbCommand cmd = null;
   OleDbDataAdapter adap = null;
   DataSet ds = new DataSet();
   try
   {
   aConnection.Open();
   query = "SELECT * FROM Customer";
   cmd = new OleDbCommand(query, aConnection);
   adap = new OleDbDataAdapter(cmd);
   adap.Fill(ds);
   GridView1.DataSource = ds;
   GridView1.DataBind();
   }
   catch (Exception)
   {

   throw;
   }
   finally
   {
   aConnection.Close();
   }

// To make the grid editable when edit button clicked

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
   {
   GridView1.EditIndex = e.NewEditIndex;
   bindGrid();
   }

// Performs Delete and Update operations

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
   {
   int cusID = 0;
   GridView gv = (GridView)sender;
   // to find the Current ID selected.
   cusID = Convert.ToInt32(
   gv.Rows[Convert.ToInt32(e.CommandArgument)].Cells[0].Text);
   if (e.CommandName == "Delete")
   {
   DeleteCustomer(cusID);
   }
   if (e.CommandName == "Update")
   {
   // to find the edit text box value.
   TextBox txtname = GridView1.Rows[Convert.ToInt32(e.CommandArgument)]
   .FindControl("txtTName") as TextBox;
   TextBox txtage = GridView1.Rows[Convert.ToInt32(e.CommandArgument)].
   FindControl("txtTAge") as TextBox;
   updateCustomer(txtname.Text, txtage.Text, cusID);
   }
   }

//To create an Alert before deleting the row in gridview.

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
   {
   foreach (Control control in e.Row.Cells[3].Controls)
   {
   LinkButton DeleteButton = control as LinkButton;
   if (DeleteButton != null && DeleteButton.Text == "Delete")
   {
   DeleteButton.OnClientClick =
   "return(confirm('Are you sure you want to delete this record?'))";
   }
   }
   }

// Method to Delete Customer Information

private void DeleteCustomer(int ID)
   {
   string query = string.Empty;
   OleDbCommand cmd = null;
   try
   {
   query = "DELETE FROM Customer WHERE ID=" + ID;
   cmd = new OleDbCommand(query, aConnection);
   aConnection.Open();
   cmd.ExecuteNonQuery();
   aConnection.Close();
   bindGrid();

   }
   catch (Exception)
   {

   throw;
   }
   finally
   {

   }
   }

// Method to update customer with edit values.

private void updateCustomer(string name, string age, int ID)
   {
   string query = string.Empty;
   OleDbCommand cmd = null;
   try
   {
   query = "UPDATE Customer SET Name='" + name + "',Age='" +
   age + "' WHERE ID=" + ID;
   cmd = new OleDbCommand(query, aConnection);
   aConnection.Open();
   cmd.ExecuteNonQuery();
   aConnection.Close();
   GridView1.EditIndex = -1;
   bindGrid();
   }
   catch (Exception)
   {

   throw;
   }
   }

Above given is the code used to perform Edit,Update
and delete operations in a gridview.

How to open Visual Studio 2010 project in Visual Studio 2008

2010-08-06T05:58:00.000-07:00

Steps to Open VS2010 project using VS2008:

· Open the .sln file corresponding to the Project to be converted with Notepad

· Locate the following line: Microsoft Visual Studio Solution File, Format Version 11.00

· Replace 11.00 with 10.00

· Locate the following line: # Visual Studio 10

· Replace 10 with 2008

· Save the File

· Delete the .cache files existing in the following paths:

o obj/debug

o obj/release

· Open the project with Visual Studio 2008

· Build the project with Visual Studio 2008

Reference: http://dougortiz.blogspot.com/2009/05/converting-visual-studio-2010-project.html

How to use dynamic column name in update query + SQL SERVER

2010-08-05T01:22:00.000-07:00

This is a General Requirement that we may be in a need to update
the table using a dynamic column name.

Say for Eg:

Here my case is ,

I need to update a table, when user reaches different stage of the Ordering Proces.

So i have columns as name, age, stage1,stage2,stage3 etc upto 8 stages.

When user enter each stage i will be calling this procedure with stage
as parameter like 1,2,3 etc.. up to 8.

CREATE PROCEDURE [dbo].[UserTracking_usp]

(

@TrackID int

@Stage varchar(10)

)

BEGIN

// to store dynamic column name

DECLARE @CurrentStage varchar(50)

DECLARE @UpdateSQL varchar(200)

SET @CurrentStage =

CASE

WHEN @Stage='2' THEN 'Stage2'

WHEN @Stage='3' THEN 'Stage3'

WHEN @Stage='4' THEN 'Stage4'

WHEN @Stage='5' THEN 'Stage5'

WHEN @Stage='6' THEN 'Stage6'

WHEN @Stage='7' THEN 'Stage7'

WHEN @Stage='8' THEN 'Stage8'

END

SET @UpdateSQL =
'UPDATE User_Tracking SET ' + convert(varchar, @CurrentStage) + '= 1

WHERE

User_Tracking_ID = ' + convert(varchar, @TrackID);

EXEC (@UpdateSQL)

END

So this procedure will examine which column name should be updated
using a case statement and substitute as a dynamic column name for
update query as shown above.

In the same way one can use for select,delete statements etc..

How to show date alone in GridView BoundField when using DateTime as DataType in DataBase.

2010-07-12T05:51:00.000-07:00

DateTime Formatting in GridView:

Usually we create a field with DataType DateTime in Database

say for eg. MSAccess database.

Now when you show this in the GridView it shows Date along with

time like 7/6/2010 8:10:12 PM

But you may be in situation to show only the Date alone.

like 7/6/2010

To do so, simple specify the format in the GridView BoundField like

<Columns>
    <asp:BoundField 
              DataField="Date1" 
              HeaderText="Date" 
              DataFormatString="{0:d}" />
</Columns>

Refer the below link for different other formats

http://msdn.microsoft.com/en-us/library/

system.web.ui.webcontrols.boundfield.dataformatstring.aspx

How to show a alert message or confirmation when deleting row from GridView without postback + Asp.Net

2010-07-10T23:37:00.000-07:00

This is a basic logic needed in Grid-view while deleting a data. By mistake people may click
on the delete button and if there is no alert or confirmation, some valuable data may be lost.
Let's go for implementation, below is the grid-view

<asp:GridView ID="GridView2" runat="server" AutoGenerateSelectButton="true"
   DataKeyNames="ID" AutoGenerateDeleteButton="true"
   onrowdatabound="GridView2_RowDataBound" >
   <Columns>
   <asp:BoundField DataField="ID" HeaderText="SL.No" Visible="false"/>
   <asp:BoundField DataField="Project" HeaderText="Project" Visible="false"/>
   </Columns>
</asp:GridView>

In the above grid the two properties namely AutoGenerateSelectButton,
and AutoGenerateDeleteButton let you show the Select and
Delete button on the GridView.
Now on onrowdatabound event of the GridView we implement the logic like

  protected void GridView2_RowDataBound(object sender,
   GridViewRowEventArgs e)
   {
   // Gets the Delete command column, which is the first column
   foreach (Control control in e.Row.Cells[0].Controls)
   {
   // Gets the Delete link button
   LinkButton DeleteButton = control as LinkButton;
   if (DeleteButton != null && DeleteButton.Text == "Delete")
   {
   DeleteButton.OnClientClick =
   "return(confirm('Are you sure you want to delete this record?'))";
   }
   }
   }
The above code will show you an alert message before deleting a row.

How to access ServerSide method from GridView's ItemTemplate

2010-07-10T00:16:00.000-07:00

Calling a CodeBehind Method From GridView's ItemTemplate:

While working with GridView, there may be a case where
we actually need to do some operations in serverside for
which we may be in a need to call a server side
method from ItemTemplate of a GridView.

Say for example,
I had a situation where i need to call a server side
method (which return a string value) from ItemTemplate.
So i used a label in the ItemTemplate like

<asp:TemplateField HeaderText="Testing">
<ItemTemplate>
<asp:Label ID="lblCustomerAge" Text='<%# GetCategory() %>' runat="server">
</asp:Label>
</ItemTemplate>
</asp:TemplateField>

Here GetCategory is the server side method.Code-behind is given below

  protected string GetCategory()
   {
   // Do whatever you want here
   return "TestCategory"; // For eg. passing a string
   }

How to split a sentence into word using C# + Regular Expressions

2010-07-06T00:28:00.000-07:00

using System;
using System.Text.RegularExpressions;

class Program
{
    static void Main()
    {
        string[] w = SplitWords("This is a Sample, Test");
        foreach (string s in w)
        {
            Console.WriteLine(s);
        }
        Console.ReadLine();
    }

    /// <summary>
    /// Get all the words in the input string and separate them.
    /// </summary>
    static string[] SplitWords(string s)
    {
        //
        // Split on all non-word characters.
        // ... Returns an array of all the words.
        //
        return Regex.Split(s, @"\W+");
        // @      special verbatim string syntax
        // \W+    one or more non-word characters together
    }
}

Output:

This

is

Sample

Test

How to find the System Name in C#

2010-07-03T04:27:00.000-07:00

Lets make use of the Namespace
using System.Security.Principal; to find the System name.

Below is the code:
lblSysNo.Text = WindowsIdentity.GetCurrent().Name.ToString();

How to pass double couted paramaters to Command line utilities programatically + c#

2010-07-01T04:37:00.000-07:00

Invoking a Command Line Utility From C#:

For eg. let's consider FWTools which has a command line utility named

ogr2ogr for converting tab to kml

Below is the code to invoke the command line utility ogr2ogr

Invoking Command Line without parameters:

// Create an instance for System.Diagnostic.Process

Process proc = new Process();

// Provide the utility name with location

proc.StartInfo.FileName = @"C:\FWTools2.4.7\bin\ogr2ogr.exe";

// Start the process

proc.Start();

Invoking Command Line with normal parameters:

Note: -f, KML, sourcepath, destpath are arguments separted by space

Process proc = new Process();
string driver = @"-f KML C:\FWTools2.4.7\bin\zeeee.kml
C:\FWTools2.4.7\bin\Morocco.tab"
proc.StartInfo.FileName = @"C:\FWTools2.4.7\bin\ogr2ogr.exe";
proc.StartInfo.UseShellExecute = false;
proc.StartInfo.RedirectStandardOutput = true;
proc.StartInfo.RedirectStandardError = true;
proc.StartInfo.Arguments = driver;
proc.Start();
proc.WaitForExit(); // use if you want your program to wait for the process to complete.
proc.Close();

Invoking Command Line with Double couted parameters:

Usually space in the arguments list denote that each are separate

argument separated by space.

In the above code KML is the name of the driver used to convert

Tab to KML.

And to convert ESRI's shape file to MapInfo's Tab file the driver

used is "MapInfo File", which itself has a space.

so by default command line arguments will consider it as a

two parameter one is "MapInfo" and other is "File".

so the program goes wrong.

Below is the solution, how to pass the double couted paremeter

string driver = "-f " + @"""" + "MapInfo File" + @"""" +

@" C:\FWTools2.4.7\bin\test.tab C:\FWTools2.4.7\bin\test.shp";

By using this methodology, we can pass "MapInfo File" as a
single argument to a command line utility.

How to find the GridView RowID on SelectedIndexChanged Event of DropDownList inside ItemTemplate of GridView

2010-06-30T05:22:00.000-07:00

Once there is a case where i need to bind a dropdownlist depending
on the selection of other dropdownlist.
The above case is a usual one which we can do in a selectedIndexChanged Event.
But here the twist is,
I have both the dropdownlist inside a GridView as ItemTemplate.
So when i write a selectedIndexChanged how do i identify the actual row id of the GridView where the current DropDownList is present.
Here we go for the solution..
Write the below code to the selectedIndexChanged Event of the DropDownList

// First Identify the row in which the dropdown value has been changed
   GridViewRow gr = (GridViewRow)
   ((DataControlFieldCell)((DropDownList)sender).Parent).Parent;
//find the control in the current row
   // selected dropdownlist
   DropDownList Projectddl = (DropDownList)gr.FindControl("ddlTest");
   // Dropdownlist to bind
   DropDownList Datumddl =
   (DropDownList)(gr.FindControl("ddlSamp"));
   if (Projectddl.SelectedItem.Value == "SomeSelectedValue")
   {
   // bind the second dropdownlist here
   Datumddl .DataSource = dTable;

   Datumddl .DataTextField = member;
   Datumddl .DataValueField = member;
   Datumddl .DataBind();
   }

How to find expandedPaneId of Rad Sliding Pane and collapse + Client side

2010-06-26T01:20:00.003-07:00

While using more sliding panes in my project , there was a need to expand and collapse panes manually and programatically.

When doing so, i noticed a problem with Sliding Pane that when we try to expand a pane when already other pane is expanded , there was a mesh.

Both the panes are expanded but the Close[x] button is not working in the panes.
i.e we are unable to close the pane using the Close[x] button on the pane.

so here we go how to solve this problem?
The solution is " Lets find the expanded pane id for the SlidingZone and collapse it first before opening a new pane. Below is the code.

// finds the Rad sliding zone first in which the pane resides
var slidingZone = $find("SlidingZone1");
(or)
var slidingZone = $find("<%= SlidingZone1.ClientID %>"); // for Master Page Scenerio

// find the expanded pane id of the zone and collapse it
var expandedPaneId = slidingZone.get_expandedPaneId();

// To collapse the pane
slidingZone.collapsePane(expandedPaneId );

After this, one can perform expand collapse pane operations as shown in my previous post without mesh.

How to Add a Water mark text to an image using C#.

2010-05-17T07:36:00.000-07:00

Below is the method which will add a text as a water marked text to an image.

public Bitmap WaterMarkToImage(string ImagePath, string watermark)
   {
   Bitmap bmp;
   bmp = new Bitmap(ImagePath);
   Graphics graphicsObject;
   int x, y;
   try
   {
   //create graphics object from bitmap
   graphicsObject = Graphics.FromImage(bmp);
   }
   catch (Exception e)
   {
   Bitmap bmpNew = new Bitmap(bmp.Width, bmp.Height);
   graphicsObject = Graphics.FromImage(bmpNew);

   graphicsObject.DrawImage(bmp, new Rectangle(0, 0,
   bmpNew.Width, bmpNew.Height), 0, 0, bmp.Width,
   bmp.Height, GraphicsUnit.Pixel);
   bmp = bmpNew;
   }

   int startsize = (bmp.Width / watermark.Length);
   //get the font size with respect to length of the string

   //x and y cordinates to draw a string
   x = 0;
   y = bmp.Height / 2;

   System.Drawing.StringFormat drawFormat =
   new System.Drawing.StringFormat(StringFormatFlags.NoWrap);
   //drawing string on Image
   graphicsObject.DrawString(watermark, new Font("Verdana",
   startsize, FontStyle.Bold),
   new SolidBrush(Color.FromArgb(100, 255, 255, 255)), x, y, drawFormat);

   //return a water marked image
   return (bmp);
   }

Method Call:

   System.Drawing.Bitmap bmp =
   WaterMarkToImage(@"D:\images\IMG_2933.jpg", "Intraspatial Softech");
   bmp.Save(@"D:\images\c1.jpg");

Problem calling Java-script method from codebehind with master-page and update panel

2010-05-14T23:51:00.000-07:00

we normally use
Page.ClientScript.RegisterStartupScript(this.GetType(), "key", "Sys.Application.add_load(method_Name);", true);
to call a javascript on runtime form code behind.
Placing the above code on page load or a button click makes the script to fire on the start up of subsequent postback.

But this make not work in the case where we give a
ajax post back intead of normal postback.

so to call a javascript method on ajax postback , here we go

ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "Key", "ServiceDownAlert();", true);

Javascript Method:

function ServiceDownAlert() {
alert("Image Not Available ! Please Try Later !");
}

How to set a Navigation tool as active tool on page load in MaxExtrem 6.8.0

2010-04-19T05:25:00.000-07:00

Set Zoom-In Tool as Active Tool on Page Load:
Usually the sample applications that map extreme provide have no tools set as a default active tool.
We need to select the tool(say ZoomIn tool or Zoom out etc as per our requirements). But while developing applications for customer requirement we may need to set some tool as active tool so as to simply the customer process.

Below is the method used to set the Zoom-In tool as the Active tool on page load.
private void SetActiveTool(string toolName)
   {
   string activateCode = String.Format("{0}Tool.Activate();", "ctl00$ContentPlaceHolder1$" + toolName);
   string activateScript = String.Format("<script type='text/javascript'>AppendScriptToForm('{0}');</script>", activateCode);
   Page.RegisterStartupScript("Key1", activateScript);
   }

The above code applies for the Master Pages. You can directly provide the tool name in normal page scenario.

How to Expand and Collapse a rad Sliding pane from client side while using Master Pages.

2010-04-19T05:04:00.000-07:00

Below is the code used to Expand the Rad Sliding Pane:

   // finds the Rad sliding zone first in which the pane resides
   var slidingZone = $find("<%= SlidingZone1.ClientID %>");
   // finds the Rad sliding pane need to be expanded.
   var pane = $find("<%= SlidingPane1.ClientID %>");
   // Expands the pane
   slidingZone.expandPane(pane.get_id());

   // To collapse the pane
   slidingZone.collapsePane(pane.get_id());

How to stretch the contents of the web page to its full extent without margin?

2010-04-05T23:42:00.000-07:00

This is because the default margin has some values set when we create a web page. so set the margin to 0 to
stretch your page content to the full extent of the web page using the CSS.

<style type="text/css">
body {
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
margin-left: 0px
}
</style>

Or even simplied as

body {

margin : 0px;

}

how to make the server side button click event firing depend on javascript return?

2010-03-02T03:42:00.000-08:00

Using OnClick and OnClientClick:
Usually we have situations where we have to check for something in the client side and decide whether to fire the server side event or not.
Say for eg.
some client side validations. Lets see how to do this
Now in the sever side OnClick event i have certain operation to be performed,
before that i need to make some client side validations.
Say for eg. To check for GridView's count and decide whether to allow or stop the servide side event firing.

<asp:Button ID="btnSubmit" runat="server"
OnClientClick="javascript:return CheckGridCount();" OnClick="btnSubmit_Click" />
Above is the way we call the javascript method CheckGridCount() to perform the check.

function CheckGridCount()
{
   var gv = document.getElementById('gridView1');
   var count = gv.rows.length;
   if(count >0)
  {
   return true;
  }
  else
  {
   alert("Please select Atleast one item");
   return false;
  }
}

If the above method return true then the server side event fires and postback occurs
else an alert is shown and nothing happens thus avoiding an unnecessary postback.

Unit Testing - An Overview

2010-02-15T04:47:00.000-08:00

UNIT TESTING:
As soon as we think of testing , as a developer the first thing comes to mind is the Developer level Unit Testing. Now lets see some definitions and examples of the Developer level Testing.

UNIT TEST – THE CLASSIC DEFINITION :

A unit test is a piece of a code (usually a method) that invokes another piece of code and checks the correctness of some assumptions afterward. If the assumptions turn out to be wrong, the unit test has failed. A “unit” is a method or function.

Black Box vs. White Box Test

Black box testing is different from white box testing. The kind of testing that you can perform on the code determines, among other things, the complexity of the unit test.

Black Box Testing

A black box test (also known as a "functional test") is one in which you feed it inputs and verify the outputs without being able to inspect the internal workings. Furthermore, one doesn't usually have information regarding:

how the box handles errors
whether your inputs are executing all code pathways
how to modify your inputs so that all code pathways are executed
dependencies on other resources

Black box testing limits your ability to thoroughly test the code, primarily because the you don't know if you're testing all the code pathways. Typically, a black box test only verifies that good inputs result in good outputs (hence the term "functional test").

Classes are often implemented as black boxes, giving the "user" of the class access only to the public methods and properties that the implementer selected.

White Box Testing

A white box provides the information necessary to test all the possible pathways. This includes not only correct inputs, but incorrect inputs, so that error handlers can be verified as well. This provides several advantages:

you know how the box handles errors
you can usually write tests that verify all code pathways
the unit test, being more complete, is a kind of documentation guideline that the implementer can use when actually writing the code in the box
resource dependencies are known
internal workings can be inspected

In the "write the test first" scenario, the ability to write complete tests is vital information to the person that ultimately implements the code, therefore a good white box unit test must ensure that, at least conceptually, all the different pathways are exercised.

Another benefit of white box testing is the ability for the unit test to inspect the internal state of the box after the test has been run. This can be useful to ensure that internal information is in the correct state, regardless of whether the output was correct. Even though classes are often implemented with many private methods and accessors. with C# and reflection, unit tests can be written which provide you the ability to invoke private methods and set/inspect private properties.

1.5 A simple unit test example

Assume we have a SimpleParser class in our project that we’d like to test as shown in listing 1.1. It takes in a string of 0 or more numbers with a comma between them. If there are no numbers it returns zero. For a single number it returns that number as an int. For multiple numbers it sums them all up and returns the sum (right now it can only handle zero or one number though):

Listing 1.1: A simple parser class we’d like to test

public class SimpleParser

{

public int ParseAndSum(string numbers)

{

if(numbers.Length==0)

{

return 0;

}

if(!numbers.Contains(","))

{

return int.Parse(numbers);

}

else

{

throw new InvalidOperationException("I can only handle 0 or 1 numbers for

now!");

}

We can add a simple console application project that has a reference to the assembly containing this class, and

write a method like this in a class called SimpleParserTests, as shown in listing 1.2.

The test is simply a method, which invokes the production class (production: the actual product you’re building

and would like to test) and then checks the returned value. If it’s not what is expected to be, it writes to the

console. It also catches any exception and writes it to the console.

Listing 1.2:A simple coded method that tests our SimpleParser class.

class SimpleParserTests

{

public static void TestReturnsZeroWhenEmptyString()

{

try

{

SimpleParser p = new SimpleParser();

int result = p.ParseAndSum(string.Empty);

if(result!=0)

{

Console.WriteLine(@"***

SimpleParserTests.TestReturnsZeroWhenEmptyString:

-------

Parse and sum should have returned 0 on an empty string");

}

catch (Exception e)

{

Console.WriteLine(e);

}

Next, we can simply invoke the tests we’ve written using a simple Main method run inside a console

application in this project, as seen in listing 1.3. The main method is used here as a simple test runner, which

invokes the tests one by one, letting them write out to the console for any problem. Since it’s an executable, this

can be run without human intervention (assuming no test pops up any interactive user dialogs).

Listing 1.3: Running our coded tests via a simple console application

public static void Main(string[] args)

{

try

{

SimpleParserTests.TestReturnsZeroWhenEmptyString();

}

catch (Exception e)

{

Console.WriteLine(e);

}

The test also catches any exception that might occur and writes it to the console output.

INTEGRATION TESTING:

Testing two or more dependent software modules as a group.

An integration test would exercise many units of code that work together to evaluate one or more results, while a unit test would usually exercise and test only a single unit in isolation.

What Is NUnit?

NUnit is an application designed to facilitate unit testing. It consists of both a command line and Window's interface, allowing it to be used both interactively and in automated test batches or integrated with the build process. The following sections discuss NUnit as it applies to C# programming.

How Does NUnit Work?

NUnit utilizes attributes to designate the different aspects of a unit test class.

TestFixture

The TestFixture attribute designates that a class is a test fixture. Classes thus designated contain setup, teardown, and unit tests.

SetUp

The SetUp attribute is associated with a specific method inside the test fixture class. It instructs the unit test engine that this method should be called prior to invoking each unit test. A test fixture can only have one SetUp method.

TearDown

The TearDown attribute is associated with a specific method inside the test fixture class. It instructs the unit test engine that this method should be called after invoking each unit test. A test fixture can only have one TearDownmethod.

Test

The Test attribute indicates that a method in the test fixture is a unit test. The unit test engine invokes all the methods indicated with this attribute once per test fixture, invoking the set up method prior to the test method and the tear down method after the test method, if they have been defined.

The test method signature must be specific: public void xxx(), where "xxx" is a descriptive name of the test. In other words, a public method taking no parameters and returning no parameters.

Upon return from the method being tested, the unit test typically performs an assertion to ensure that the method worked correctly.

ExpectedException

The ExpectedException attribute is an optional attribute that can be added to a unit test method (designated using the Test attribute). As unit testing should in part verify that the method under test throws the appropriate exceptions, this attribute causes the unit test engine to catch the exception and pass the test if the correct exception is thrown.

Methods that instead return an error status need to be tested using the Assertion class provided with NUnit.

Ignore

The Ignore attribute is an optional attribute that can be added to a unit test method. This attribute instructs the unit test engine to ignore the associated method. A requires string indicating the reason for ignoring the test must be provided.

Suite

The Suite attribute is being deprecated. The original intent was to specify test subsets.

An Example

[TestFixture]

public class ATestFixtureClass

    private ClassBeingTested cbt;

    [SetUp]

    public void Initialize()

        cbt=new ClassBeingTested();

    [TearDown]

    public void Terminate()

        cbt.Dispose();

    [Test]

    public void DoATest()

        cbt.LoadImage("fish.jpg");

    [Test, Ignore("Test to be implemented")]

    public void IgnoreThisTest()

    [Test, ExpectedException(typeof(ArithmeticException))]

    public void ThrowAnException()

        throw new ArithmeticException("an exception");

How to draw a Geometry on the Map + ArcGIS + .Net Web ADF

2010-02-08T03:06:00.000-08:00

This is a common requirement in the Mapping Applications to Draw the People's Area of Interest(AOI) in different geometry forms like Rectangle, Polygon etc.

Below is the method that allow you draw the AOI on the map and zoom to it, when you pass the bounds as inputs.

public void DrawRectangleOnMap(double minX,double minY,double maxX,double maxY)
{
ESRI.ArcGIS.ADF.Web.DataSources.Graphics.MapFunctionality adfGraphicsMapFunctionality = null;
ElementGraphicsLayer elementGraphicsLayer = null;
GraphicsDataSet graphicsDataSet = null;

try
{
foreach (IMapFunctionality mapFunctionality in Map1.GetFunctionalities())
{
// If multiple graphics resources are available, use the resource name to distinguish
if (mapFunctionality.Resource.Name == "ADFGraphicsResource")
{
adfGraphicsMapFunctionality = mapFunctionality as ESRI.ArcGIS.ADF.Web.DataSources.Graphics.MapFunctionality;
break;
}
}

// Return if there is no Graphic Resource.
if (adfGraphicsMapFunctionality == null)
return;
elementGraphicsLayer = new ElementGraphicsLayer();
elementGraphicsLayer.TableName = Guid.NewGuid().ToString();

// Add graphics layer to map functionality graphics dataset
graphicsDataSet = adfGraphicsMapFunctionality.GraphicsDataSet;
graphicsDataSet.Tables.Add(elementGraphicsLayer);

// Create a Geometry using the bound values from the QueryString .
ESRI.ArcGIS.ADF.Web.Geometry.Polygon adfPolygon = new ESRI.ArcGIS.ADF.Web.Geometry.Polygon();
adfPolygon.Rings.Add(new ESRI.ArcGIS.ADF.Web.Geometry.Ring
(new ESRI.ArcGIS.ADF.Web.Geometry.Envelope(minX, minY, maxX, maxY)));

// Fill the Geometry with color and style.
ESRI.ArcGIS.ADF.Web.Display.Symbol.SimpleFillSymbol simpleFillSymbol =
new ESRI.ArcGIS.ADF.Web.Display.Symbol.SimpleFillSymbol();
simpleFillSymbol.Transparency = 100;
simpleFillSymbol.BoundaryColor = System.Drawing.Color.Red;

// Loads the Geometry to the GraphicElement.
ESRI.ArcGIS.ADF.Web.Display.Graphics.GraphicElement graphicElement =
new ESRI.ArcGIS.ADF.Web.Display.Graphics.GraphicElement(adfPolygon, simpleFillSymbol);

// Add the GraphicElement to the GraphicsLayer.
elementGraphicsLayer.Add(graphicElement);

// Zooms to the AOI
Map1.Zoom(adfPolygon);
}
catch (Exception)
{
throw;
}
finally
{
elementGraphicsLayer = null;
graphicsDataSet = null;
adfGraphicsMapFunctionality = null;
}
}

How to access queryStrings in client side + JavaScript

2010-02-08T01:25:00.000-08:00

This question is mostly asked by people because there may be situations where we could make use of QueryStrings in the clientside.
So how to proceed with this?

There are two options to do this
1. Make use of HiddenField and store the queryString in a hidden field in the Page_Load and access it from the client side.
But this is an indirect way where we have to use more server controls to store and retrive the data which may have some performance impact. So lets find some other way to access the queryString from the Clienside directly.
2. Make use of the JavaScript Magic to Access the QueryString directly like
Say For eg.
We are passing a querysting named customerID in a url.
eg. http://www.xxx.com/test.aspx?customerID=007
Then the CustomerID is the key which we could pass to the below method to get the value(007) of the querystring.

function getQuerystring(key, default_)
{

if (default_==null) default_="";

key = key.replace(/[\[]/,"\\\[").replace(/[\]]/,\\\]);

var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");

var qs = regex.exec(window.location.href);
if(qs == null)

return default_;

else

return qs[1];

}

The output is 007.

How to find the layers that intersect with an envelope or geometry + ArcGIS .Net web ADF

2010-01-23T03:35:00.000-08:00

Layers Intersection with an Envelope:
As we know Layers intersection is a common task in GIS, here we achieve this using Identity method.
Below is the code used to find the layers in the mapresource which are being intersected
with an envelope.

Method Call:
DataTable dt = GetIntersectionLayers(Map1.GetFunctionalities(0),x1,y1,x2,y2);

Method Definition:
public DataTable[] GetIntersectionLayers(
ESRI.ArcGIS.ADF.Web.DataSources.IMapFunctionality gisFunctionality, double minX,
double minY, double maxX, double maxY)
   {
   int pixelTolerance = 1;
   DataTable[] dt = null;
   ESRI.ArcGIS.ADF.Web.DataSources.IGISResource gisResource = gisFunctionality.Resource;

   ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality queryFunctionality =
   (ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality)gisResource.CreateFunctionality
   (typeof(ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality), null);

   string[] layerIDs = null;
   string[] layerNames = null;
   queryFunctionality.GetQueryableLayers(null, out layerIDs, out layerNames);

   ESRI.ArcGIS.ADF.Web.Geometry.Envelope adfEnvelope =
   new ESRI.ArcGIS.ADF.Web.Geometry.Envelope(minX, minY, maxX, maxY);

   dt = queryFunctionality.Identify(gisFunctionality.Name, adfEnvelope,
   pixelTolerance, ESRI.ArcGIS.ADF.Web.IdentifyOption.AllLayers, layerIDs);
   return dt;
   }

The method returns the data table with a collection of intersected layers.

how to zoom to a particular coordinate location in ArcGIS .Net webADF

2010-01-02T02:30:00.000-08:00

Below is the method used to zoom in to a particular location using the coordinates. Unlike MapExtreme, ArcGIS uses ZoomFactor to zoom in and zoom out instead of ZoomWidth in MapExtreme.
Method:
private void ZoomToCoordinates()
   {
   ESRI.ArcGIS.ADF.Web.Geometry.Point center = null;
   try
   {
   center = new ESRI.ArcGIS.ADF.Web.Geometry.Point(17.7244, 1.1883);
   // Numeric value is the Zoom factor(1-10 ZoomsIn & 0 to 1 ZoomsOut)
   Map1.Zoom(2, center);
   }
   catch (Exception)
   {
   throw;
   }
   finally
   {
   center = null;
   }
   }

How to add map resource dynamically to MapResourceManager + ArcGIS 9.3 and 9.3.1 .Net WebADF

2010-01-02T01:09:00.000-08:00

In ArcGIS webADF, After publishing the services using ArcGIS SERVER(say map service), we can just add a map resource to the MapResourceManager manually in design time.

Now lets see how to add the map resource dynamically through code. Because mostly we may have multiple map resource that has to be shown only on request.

Below is the code through which we can achieve this.

Method call:
AddMapResourceDynamically("GlobalService", "Layers@GlobalService", false);
- GlobalService is the service name.
- Layers@GlobalService is the service definition(i.e Layers@Service_Name is the format)
- true or false to list the resource in the TOC Control.

Method Definition:
private void AddMapResourceDynamically(string resName, string resDefinition, bool IsTOC)
   {
   string m_ResourceName = string.Empty;
   MapResourceItem mapResourceItem = null;
   GISResourceItemDefinition resDef = null;
   DisplaySettings displaySettings = null;
   try
   {
   mapResourceItem = new MapResourceItem();
   resDef = new GISResourceItemDefinition();
   mapResourceItem.Name = resName;

   // The services url which we use to fetch the services.
   resDef.DataSourceDefinition = @"http://hostname/arcgis/services";
   resDef.DataSourceType = "ArcGIS Server Internet";
   resDef.ResourceDefinition = resDefinition;
   resDef.DataSourceShared = true;
   mapResourceItem.Parent = MapResourceManager1;
   mapResourceItem.Definition = resDef;

   displaySettings = new DisplaySettings();
   displaySettings.Transparency = 0;
   displaySettings.Visible = true;
   displaySettings.DisplayInTableOfContents = IsTOC;
   displaySettings.ImageDescriptor.TransparentColor = System.Drawing.Color.White;
   displaySettings.ImageDescriptor.TransparentBackground = true;
   mapResourceItem.DisplaySettings = displaySettings;

   // Insert the new resource item at the beginning (top).    MapResourceManager1.ResourceItems.Insert(MapResourceManager1.ResourceItems.Count, mapResourceItem);

   // Create the map resource and return a reference in case it will be the
   // primary map resource.
   IMapResource mapResource = MapResourceManager1.CreateResource(mapResourceItem);

   // If no other resource items are present, set the new map resource item as the
   // primary map resource.
   if (MapResourceManager1.ResourceItems.Count < 1)
   {
   Map1.PrimaryMapResource = mapResourceItem.Name;
   Map1.Focus();
   Map1.InitializeFunctionalities();
   Map1.InitializeTileFunctionalities();
   }
   Toc1.Refresh();
   }
   catch (Exception)
   {
   throw;
   }
   finally
   {
   mapResourceItem = null;
   resDef = null;
   displaySettings = null;
   }
   }

The above code will add the map resource dynamically to the MapResourceManager and display it on the map on runtime.

How to select the First midde and last word in a phrase + SQL SERVER 2008

2009-11-12T21:29:00.000-08:00

No Doubt "SQL SERVER" is a great utility that makes various operation more simple.
"Nothing is Impossible with SQL SERVER"

Now lets see how to select a last word from a phrase.

1. Selecting the first word in a pharse is simple as we trace for the first space in the phrase and get the charindex of the first space and we can make it done using the Left function.
like
SELECT LEFT('Be Always Happy',CHARINDEX(' ','Be Always Happy')-1)

Output:
Be

2. Now how to select the last word of the pharse ?
How we gonna trace for the last space in the phrase? let see
One method is like

SELECT PARSENAME(REPLACE('Be Always Happy', ' ', '.'), 1)

Output:
Happy

3.we can also select the second word form the right like

SELECT PARSENAME(REPLACE('Be Always Happy', ' ', '.'), 2)

Output:
Always

Replacing the 2 by 3 would select the third word from the phrase namely 'Be'
and go on as many word we have.

But this wont work at all the time say for example when there is dot at the end of the phrase like

SELECT PARSENAME(REPLACE('Be Always Happy.', ' ', '.'), 1)

Now the output is NULL for the above query.

So i found the method which can handle all possible situations. Lets see how?

Finding Last word of a phrase:

SELECT RIGHT('Be Always Happy.', CHARINDEX(' ', REVERSE('Be Always Happy.')) - 1)

Output:
Happy.

With the above query its done. There may be many way to achieve this but this is one simple idea.

How the change the First letter of each word in a string to caps + SQL SERVER 2008

2009-11-11T04:21:00.000-08:00

The Following is the way to achieve this:

DECLARE @Name VarChar(25), @SpaceIndex TinyInt

SET @Name = 'be happy' // is the input string

-- Determines whether the string has more than one word:

SET @SpaceIndex = CHARINDEX(' ', @Name)

IF @SpaceIndex <> 0

-- Space: Capitalize first & substring

SELECT UPPER(LEFT(@Name, 1))

+ LOWER(SUBSTRING(@Name, 2, @SpaceIndex - 1))

+ UPPER(SUBSTRING(@Name, @SpaceIndex + 1, 1))

+ LOWER(SUBSTRING(@Name, @SpaceIndex + 2, LEN(@Name)))

ELSE

-- No space: Cap only first char.

SELECT UPPER(LEFT(@Name, 1))

+ LOWER(SUBSTRING(@Name, 2, LEN(@Name)))

OUTPUT:
Be Happy

How to read a MS Access file from SQL SERVER using OPENDATASOURCE

2009-10-14T02:02:00.000-07:00

Reading an MS Access database from SQL SERVER is possible and quite simple.

SELECT * FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'Data Source=\\server1\C\TEMP\orderDB.mdb')...[orders]

Here the above SQL Query uses OPENDATASOURCE method to read the MS Access file .

Note:
1. 'Orders' is the name of the table in MS Access mdb file.
2. The 3 dots (...) should be there before specifiying the table name.
3. “Ad hoc distributed queries” has to be enabled to used the OPENDATASOURCE method.

how to execute a SP or table query every 5secs + SQL SERVER

2009-10-13T00:19:00.000-07:00

The below query would make a delay of 5secs in calling he SP.

While 1 = 1

BEGIN

EXEC dbo.UpdateCustomer // executes the SP named UpdateCustomer

waitfor delay '00:00:05'

END

Here the delay notification is in hrs:Mins:secs

how to make javascript operation wait for some time without doing any process

2009-09-30T01:56:00.000-07:00

Below is the function that halts the javascript process for specified number of milliseconds

function wait(msecs)
{
var start = new Date().getTime();

var cur = start

while(cur - start < msecs)

{

cur = new Date().getTime();

}

}

In Client side this can be called as wait(5000) will make the process wait for 5 seconds.
Note: you cannot execute anyother process at this time.

Javascript validation for numeric or decimal value

2009-09-22T06:34:00.000-07:00

How to make a textbox wont even allow user to type a invalid text :

// To check whether the value entered is a numeric or decimal value.

// This method will wont even allow the user to type the invalid value.

function isNumber(field) {

var re = /^[0-9.]*$/;

if (!re.test(field.value)) {

field.value = field.value.replace(/[^0-9.]/g, "");

}

}

The above method will wont even allow you to type any text or * or $ symbol in textbox.

// To make a call to the method on onkeyup event.

<asp:TextBox ID="txtRadNZoomValue" Runat="server" Width="65px" ForeColor="Black" onkeyup="isNumber(this)">
</asp:TextBox>

This is also tested in master pages scenerio .

How to raise a button click event on Enter keypress

2009-09-22T06:19:00.000-07:00

Button click on Enter :

On client side:

// To perform button click operation on enter.

function doClick(buttonName, e) {

//the purpose of this function is to allow the enter key to

//point to the correct button to click.

var key;

if (window.event)

key = window.event.keyCode; //IE

else

key = e.which; //firefox

if (key == 13) {

//Get the button the user wants to have clicked

var btn = document.getElementById(buttonName);

if (btn != null) { //If we find the button click it

btn.click();

event.keyCode = 0

}

}

}

On server side :

on server side we have to specify that the click should happen only when the cursor is on certain text box.

txtRadNZoomValue.Attributes.Add("onKeyPress", "doClick('" + btnZoomValue.ClientID + "',event)");

How to convert Miles to KM in javascript

2009-09-22T00:05:00.000-07:00

Below is the simple method to convert Miles to KM.

function ConvertMileToKM(dist)
{
var distC = dist * 1; // to make the value as integer
var distKM = dist * 1.609344; // to convert into km
var distMile = distC.toFixed(2); // to round it to 2 decimal places.
}

To convert a string value to integer we can simply multiply with 1
stringvalue * 1 will give you a integer value

How to check for postback in clientside javascript

2009-09-21T23:35:00.000-07:00

Javascript Ispostback Method :

Normally we use IsPostback method in the server side to check for postback. But there may be some situations where we really need this on clientside.
So lets see how to do this

// Client side postback Identification

function IsPostBack() {

return < %= IsPostBack.ToString().ToLower() % >;

}

The above method will return the boolean value indicating whether it is a postback or not. we can use like below

if(!IsPostBack())
{
// To do
}
else
{
// To do
}

So Checking for postback in clientside javacript is possible.

How to call a javascript method on Keypress or Keydown

2009-09-21T03:38:00.000-07:00

How to call method on keypress :

we can use
document.onkeypress = KeyCheck; or

document.onKeydown = KeyCheck;

// to perform operation on esc key press
function KeyCheck(e) {
var KeyID = (window.event) ? event.keyCode : e.keyCode;
if (KeyID == '27') // 27 is the key code for ESC key

{
// To do

}
}

Note : onKeypress wont work for safari browser so we can use onkeydown

Passing arguments to javascript’s setTimeout() method

2009-09-17T23:42:00.000-07:00

Javascript's setTimeout - A detailed look :
Normal set time out method which will call the method test() after 2 seconds.

setTimeout(test(), 2000 );
function test()
{
alert("Its done ! Be Happy");
}
Now the above will work fine but what happens when we want to call a method
with a delay which has arguments ? so we may go for

setTimeout(test('Enjoy'), 2000 );
function test(value)
{
alert(value);
}

Even the above method will work fine but then if we want to call a method which
may have dynamic argument then see what happens

function dynamicArgument(value)
{
setTimeout(test(value), 2000 );
}

function test(value)
{
alert(value);
}
The above is wrong and wont work so we have to follow some other way to make it work.
Lets see
function dynamicArgument(value)
{
var delay = function() { test(value); };
setTimeout(delay,2000 );
}
function test(value)
{
alert(value);
}
- here the method with argument is assigned to a var delay and used in the settimeout method.
The above will work or else we can do it still simpler like

function dynamicArgument(value){
setTimeout(test,2000,[value] );
}

function test(value)
{
alert(value);
}

Thanks
Mukunda