Mukund's Ideas

How to disable kwizcom cascading lookup field using jquery

2016-03-04T22:25:00.001-08:00

Since kwizcom is 3rd party tool, it creates multiple controls like input, span etc in its html . Also we will be not be able to find the field id as its all html control without id. so we can find the td of the control and make it disable . This would be the better option.

I am identifying the td by searching for its label name in the SharePoint list form and then abviously the next td will be the container of the cascading lookup control. So the below code works fine.

$(document).ready(function() {

$('nobr:contains("Label")').closest('td').next().find("*").attr("disabled", "disabled"); // IE

$('nobr:contains("Label")').closest('td').next().css("pointer-events" , "none"); // Chrome

});</script>

Asp.Net Websites and IE10 Issue - (Checkbox not posting back in IE10, javascript not working in IE10 etc)

2013-05-01T10:50:00.000-07:00

After IE 10 was published, many users had issues like postback/Ajax/javascript not working etc.. with the Asp.net websites. My sites were developed in .Net Framework 2.0

I downloaded the browser update file for ie from below link

www.hanselman.com/blog/content/binary/App_BrowsersUpdate.zip

and created a App_Browsers Asp.net folder in my website project and published.

The sites started working without issue.

There were options to update the browser definition file on the server, but not sure that might break something else, so i downloaded and updated the browser update file to the applications by adding them to the App_Browsers folder that solved my issue.

For more details
Refer
http://www.hanselman.com/blog/BugAndFixASPNETFailsToDetectIE10CausingDoPostBackIsUndefinedJavaScriptErrorOrMaintainFF5ScrollbarPosition.aspx

How to pass argument from Rad popup window to parent window

2013-02-20T07:38:00.003-08:00

Below is an example that demonstrates how to pass an argument from the rad pop window to parent window and based on the argument we should refresh the page.

On the pop up window call the pageload method like

<body onload="pageload();">

and call the close popup method from button click.

then use the script as below
var oWnd;
        function closePopup(URL) {

            oWnd.argument = "Refresh"; // Set the updated value in button click
            oWnd.close();
                }

        function pageLoad() {
            oWnd = GetRadWindow();
        }

        function GetRadWindow() {
            var oWindow = null;
            if (window.radWindow)
                oWindow = window.radWindow;
            else if (window.frameElement.radWindow)
                oWindow = window.frameElement.radWindow;
            return oWindow;
        }

On the parent window onclientclose method get the argument and based on the argument i am reloading the page.

          function OnClientClose(oWnd) {
              var arg = oWnd.argument;

            oWnd.setUrl("about:blank"); // Sets url to blank
              oWnd.remove_close(OnClientClose);
              if(arg.toString() == 'Refresh')
                window.location.reload();
               //remove the close handler - it will be set again on the next opening
          }

How to set css for asp.net server controls globally.

2012-11-05T06:03:00.000-08:00

Usually Asp.Net controls like textbox, button ,radio button, checkbox are seen as input controls with different types like text,submit,radio etc...

So to set the CSS for the server controls

/* Global font for server controls */

textbox

input[type="text"]

{

font-family: Verdana;

font-size: 10px;

width:160px;

}

textbox with textmode = password

input[type="password"]

{

width:160px;

}

Multiline text box

textarea

{

font-family: Verdana;

font-size: 10px;

width:165px;

}

// for radio button/ check boxes

label

{

font-family: Verdana;

font-size: 10px;

}

For list boxes

select {

/*font-family:Arial,Verdana,sans-serif; */

font-family: Verdana;

font-size:10px;

font-weight:500;

/* Global font for server controls */

Unable to update the EntitySet because it has a DefiningQuery and no element exists in the element to support the current operation.

2012-11-01T08:18:00.001-07:00

This is the error occurs when there is no primary key set in the table for which you are trying to do some update operation.

Set the primary key for the table and update the Entity model and then try.

How to pass Eval value to javascript function from GridView ItemTemplate

2012-10-26T11:02:00.000-07:00

Passing the Eval value to a javascript method is bit tricky.

You cannot pass directly as shown below.

<asp:LinkButton id='lnk' runat='server' OnClientClick='<%#Eval("columnname",
"javascript:testfun({0});")%>' />

Instead , the below way should work

<asp:LinkButton id='lnk' runat='server' OnClientClick='<%#Eval("columnname",
"javascript:testfun({0});")%>' />

How to alter all columns of a table in SQL SERVER

2012-10-09T07:54:00.001-07:00

To alter all columns of a table :

DECLARE @SQL VARCHAR(MAX)

SET @SQL = (

SELECT '

ALTER TABLE dbo.yourtablename ALTER COLUMN [' + c.name + '] NVARCHAR(MAX) NULL;

FROM sys.columns c WHERE OBJECT_NAME(object_id) = 'yourtablename'

FOR XML PATH(''), TYPE

).value('text()[1]', 'VARCHAR(MAX)')

--PRINT @SQL

EXEC(@SQL)

MultiSelect ListBox seach using Jquery

2012-09-16T06:46:00.000-07:00

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

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

</head>

<body>

<table>

<tr>

<td>

<asp:TextBox ID="TextBox1" runat="server" Width="217px"></asp:TextBox>

</td>

</tr>

<tr>

<td>

<asp:ListBox ID="ListBox1" runat="server" Width="220px" Font-Bold="True"

Font-Size="Small" Height="165px">

<asp:ListItem Text="krishna" Value="krishna"></asp:ListItem>

<asp:ListItem Text="daya" Value="daya"></asp:ListItem>

<asp:ListItem Text="bansi" Value="bansi"></asp:ListItem>

<asp:ListItem Text="hetal" Value="hetal"></asp:ListItem>

<asp:ListItem Text="kavita" Value="kavita"></asp:ListItem>

<asp:ListItem Text="poonam" Value="poonam"></asp:ListItem>

<asp:ListItem Text="janki" Value="janki"></asp:ListItem>

<asp:ListItem Text="niyati" Value="niyati"></asp:ListItem>

<asp:ListItem Text="bhumika" Value="bhumika"></asp:ListItem>

<asp:ListItem Text="bindi" Value="bindi"></asp:ListItem>

<asp:ListItem Text="nayana" Value="nayana"></asp:ListItem>

<asp:ListItem Text="nita" Value="nita"></asp:ListItem>

<asp:ListItem Text="kajal" Value="kajal"></asp:ListItem>

<asp:ListItem Text="jashoda" Value="jashoda"></asp:ListItem>

<asp:ListItem Text="shilpa" Value="shilpa"></asp:ListItem>

<asp:ListItem Text="ridhi" Value="ridhi"></asp:ListItem>

<asp:ListItem Text="rachana" Value="rachana"></asp:ListItem>

<asp:ListItem Text="rakshita" Value="rakshita"></asp:ListItem>

<asp:ListItem Text="parul" Value="parul"></asp:ListItem>

<asp:ListItem Text="twinkle" Value="twinkle"></asp:ListItem>

</asp:ListBox>

</td>

</tr>

</table>

</form>

function DoListBoxFilter(listBoxSelector, filter, keys, values) {

var list = $(listBoxSelector);

var selectBase = '<option value="{0}">{1}</option>';

list.empty();

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

var value = values[i];

if (value == "" || value.toLowerCase().indexOf(filter.toLowerCase()) >= 0) {

var temp = '<option value="' + keys[i] + '">' + value + '</option>';

list.append(temp);

}

var keys = [];

var values = [];

var options = $('#<% = ListBox1.ClientID %> option');

$.each(options, function(index, item) {

keys.push(item.value);

values.push(item.innerHTML);

});

$('#<% = TextBox1.ClientID %>').keyup(function() {

var filter = $(this).val();

DoListBoxFilter('#<% = ListBox1.ClientID %>', filter, keys, values);

});

</script>

How to open Rad Window on page load from Code Behind.

2012-07-23T08:31:00.002-07:00

Rad Window on PageLoad:

using Telerik.Web.UI;

     RadWindow newWindow = new RadWindow();
     newWindow.NavigateUrl = "Test.aspx";
     newWindow.VisibleOnPageLoad = true;
     newWindow.Modal = true;
     newWindow.Width = 750;
     newWindow.Height = 480;
     RadWindowManager1.Windows.Add(newWindow);

How to set Identity column value start from certain value + SQL

2012-04-16T07:56:00.000-07:00

Below is the SQL query to get the to set Identity column value start from certain value

DBCC CHECKIDENT ( 'TestDB.dbo.TestTable',RESEED, 1000000)

How to get fields & assigned domains of FeatureClass + ESRI + C#

2012-03-07T07:51:00.000-08:00

here is the code to get fields of a featureclass and check for the assigned domain

IFields fields = featureClass.Fields;
string domainName = string.Empty;
for (int i = 0; i < fields.FieldCount; i++)
{
if (fields.get_Field(i).DomainFixed)
domainName = fields.get_Field(i).Domain.Name;
}

Thanks
Mukund

How to get feature class from the shape file on Disk.

2012-03-06T09:58:00.004-08:00

Below is the method that gets the feature class from the shape file
/// Get the FeatureClass from a Shapefile on disk (hard drive).
/// A System.String that is the directory where the shapefile is located.
Example: "C:\data\USA"

/// A System.String that is the shapefile name.
Note: the shapefile extension's
///(.shp, .shx, .dbf, etc.) is not provided! Example: "States"</param>

public ESRI.ArcGIS.Geodatabase.IFeatureClass GetFeatureClassFromShapefileOnDisk
(System.String string_ShapefileDirectory, System.String string_ShapefileName)
{
     System.IO.DirectoryInfo directoryInfo_check = new System.IO.DirectoryInfo(
                                                                                 string_ShapefileDirectory);
      if (directoryInfo_check.Exists)
    {
        //We have a valid directory, proceed
        System.IO.FileInfo fileInfo_check = new System.IO.FileInfo(string_ShapefileDirectory + "\\" +
                                                                     string_ShapefileName + ".shp");
    if (fileInfo_check.Exists)
   {
        //We have a valid shapefile, proceed

         ESRI.ArcGIS.Geodatabase.IWorkspaceFactory workspaceFactory =
                                                 new ESRI.ArcGIS.DataSourcesFile.ShapefileWorkspaceFactoryClass();
   ESRI.ArcGIS.Geodatabase.IWorkspace workspace =
                                                 workspaceFactory.OpenFromFile(string_ShapefileDirectory, 0);
         ESRI.ArcGIS.Geodatabase.IFeatureWorkspace featureWorkspace =
                                                  (ESRI.ArcGIS.Geodatabase.IFeatureWorkspace)workspace;
       // Explict Cast

        ESRI.ArcGIS.Geodatabase.IFeatureClass featureClass =
                                                featureWorkspace.OpenFeatureClass(string_ShapefileName);
        return featureClass;
}
else
{
   //Not valid shapefile
      return null;
}
}
else
{
    // Not valid directory
   return null;
}
}

How to find feature count that intersect an envelope in Geodatabase + C#

2012-03-06T09:46:00.000-08:00

In our previous post, we discussed about connecting the File GeoDB and returning the Workspace.

Now will see how to find feature count that intersect an envelope in the File GeoDB

// The method FileGdbWorkspaceFromPropertySet definition is present in our previous post

IWorkspace featureWorkspace = FileGdbWorkspaceFromPropertySet(gdbPath);
IFeatureWorkspace fws = (IFeatureWorkspace)featureWorkspace;

// Method that Gets Features Count From a FeatureClass

private static int GetCountFromFeatureClass(IFeatureWorkspace fws, string parcelName, IEnvelope envelope)
{
// Open the feature classes used by the queries.
IFeatureClass parcelsFeatureClass = fws.OpenFeatureClass(parcelName);

//// Create the spatial filter. Note that the SubFields property specifies that only
//// the Shape field is retrieved, since the features' attributes aren't being inspected.
ISpatialFilter spatialFilter = new SpatialFilterClass();
spatialFilter.Geometry = envelope;
spatialFilter.GeometryField = parcelsFeatureClass.ShapeFieldName;
spatialFilter.SpatialRel = esriSpatialRelEnum.esriSpatialRelContains;
spatialFilter.SubFields = "Shape";

// Use IFeatureClass.FeatureCount to get a parcel count.
return parcelsFeatureClass.FeatureCount(spatialFilter);

}

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)