.NET Corner

AngularJS caching issue for Internet Explorer for Ajax (GET) requests

noreply@blogger.com (Unknown) — Tue, 27 Oct 2015 07:06:00 +0000

Generally we face the cache issue for particularly internet explorer in angularJs when we use $http to get the data from the server.The reason for this problem is when we request the same call again to the server , IE fetches the response from the cache instead from updated result. This can be shown clearly from the network capture window of IE.
When we request the server for the first time the response code would be 200(OK) , if we make the same call again , we would get response code as 304 (Not Modified) .
To fix the above problem we can plug few settings to the main angular module or to each HTTP get request.
var myApp = angular.module('myApp', ['ngRoute']);

myApp.config(['$routeProvider', '$httpProvider', function($routeProvider, $httpProvider) {
$httpProvider.defaults.cache = false;
if (!$httpProvider.defaults.headers.get) {
$httpProvider.defaults.headers.get = {};
}
// disable IE ajax request caching
$httpProvider.defaults.headers.get['If-Modified-Since'] = '0';
//.....here proceed with your routes

}]);

Allow Video format to play in MediaPlayer

noreply@blogger.com (Unknown) — Fri, 25 Apr 2014 11:05:00 +0000

This is a common problem with video format type to play in the web site/web applications if we use the media player.

In this article, I would like to give a simple solution to allow the “*.mp4” format video files to play in the media player in our web application in the IIS.

This video file format is not allowed in the IIS under MIME type. The following steps are done in the Internet Information Server (IIS).

Step# 1

Start IIS Manager

Select the appropriate website to which we want to allow “mp4” format, then click MIME types

Step# 2

Click on Add

Step# 3

Enter the video format information

File name extension: .mp4
MIME type: video/mp4

Step# 4

Restart IIS.

Suppress the warning messages in Visual Studio

noreply@blogger.com (Unknown) — Thu, 24 Apr 2014 10:56:00 +0000

Sometimes we might have seen the warning message when we build the solution. These warning won't stop your application execution in fact these are most useful to preventing the defects.
In order to suppress this warning message we need to use the pre-processor directives i.e., "#pragma warning".
Example : As shown in the below image , the variable count is assigned and didn't used that value any where. When we build the project able to see a warning in the Error List window.

To overcome this warning we need to define the pragma warning pre-processor directive to the variable as shown below.

#pragma warning disable
int count = 1;
#pragma warning resotre

Hope this article helped you to supress the warnings in visual studio :-)

Column COLLATION can affect SQL Server query performance ?

noreply@blogger.com (Unknown) — Thu, 24 Apr 2014 10:18:00 +0000

I found an interesting article on column collation in SQL Server. Please refer this Column Collation article from SQL Server Tips site.

Exporting to excel from a custom class object using C#.NET

noreply@blogger.com (Unknown) — Mon, 10 Mar 2014 11:48:00 +0000

We may face a scenario to export the data of custom class object to excel using InterOp.You can get the property name's from the class object using Reflection.Create a work sheet header by reading the each propety of the class object.I have created a separate method to get the all properties into a list collection of string as given below

///

/// Get the list of Properties Name into a list collection.
///

        ///
        ///
        public List GetPropeties(Employee objEmployee)
        {
            Type myType = objEmployee.GetType();
            IList props = new List(myType.GetProperties());
            List lstPropertiesNames = new List();

            foreach (PropertyInfo prop in props)
            {
                lstPropertiesNames.Add(prop.Name);
            }
            return lstPropertiesNames;
        }
We need to call this method to create the worksheet header's as given beloe
                List lstProperties = GetPropeties(new Employee());
                Char x = 'A';
                foreach (String eachProperty in lstProperties)
                {
                    // ------------------------------------------------
                    // Creation of header cells
                    // ------------------------------------------------
                    workSheet.Cells[1, x.ToString()] = eachProperty;
                    x = (Char)(Convert.ToUInt32(x) + 1);
                }

The complete source code to export to excel is given below
        public void ExportToExcel(List objEmployee)
        {
            // Load Excel application
            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();

            // Create empty workbook
            excel.Workbooks.Add();

            // Create Worksheet from active sheet
            Microsoft.Office.Interop.Excel._Worksheet workSheet = excel.ActiveSheet;

            // I created Application and Worksheet objects before try/catch,
            // so that i can close them in finnaly block.
            // It's IMPORTANT to release these COM objects!!
            try
            {
                List lstProperties = GetPropeties(new Employee());
                Char x = 'A';
                foreach (String eachProperty in lstProperties)
                {
                    // ------------------------------------------------
                    // Creation of header cells
                    // ------------------------------------------------
                    workSheet.Cells[1, x.ToString()] = eachProperty;
                    x = (Char)(Convert.ToUInt32(x) + 1);
                }

                // ------------------------------------------------
                // Populate sheet with some real data from "employees" list
                // ------------------------------------------------
                int row = 2; // start row (in row 1 are header cells)
                foreach (BusinessModels.Employee emp in objEmployee)
                {
                    workSheet.Cells[row, "A"] = emp.ID;
                    workSheet.Cells[row, "B"] = emp.Name;
                    workSheet.Cells[row, "C"] = emp.Locality;
                    workSheet.Cells[row, "D"] = emp.City;
                    workSheet.Cells[row, "E"] = emp.Country;

                    row++;
                }

                // Apply some predefined styles for data to look nicely :)
                workSheet.Range["A1"].AutoFormat(Microsoft.Office.Interop.Excel.XlRangeAutoFormat.xlRangeAutoFormatColor1);

                // Define filename
                string fileName = string.Format(@"{0}\ExcelData.xlsx", Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory));

                if (File.Exists(fileName))
                {
                    File.Delete(fileName);
                }
                // Save this data as a file
                workSheet.SaveAs(fileName);

                // Display SUCCESS message
                ExcelMessages.ErrorMessage = (string.Format("The file '{0}' is saved successfully!", fileName));
            }
            catch (Exception exception)
            {
                throw new Exception("There was a PROBLEM saving Excel file!\n" + exception.Message);
            }
            finally
            {
                // Quit Excel application
                excel.Quit();

                // Release COM objects (very important!)
                if (excel != null)
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);

                if (workSheet != null)
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(workSheet);

                // Empty variables
                excel = null;
                workSheet = null;

                // Force garbage collector cleaning
                GC.Collect();
            }
        }

How to fix "Sys is undefined" error ?

noreply@blogger.com (Unknown) — Wed, 30 Oct 2013 11:35:00 +0000

Recently I have faced a strange issue in the process of developing a task using script manager for async post backs.

The error is "webresource.axd and scriptresource.axd 404 not found" whenever I do any async call I use to get this error "sys is not defined". I have tried a lot to fix this issue by following the below links.

1. http://blogs.msdn.com/b/carloc/archive/2008/12/04/webresource-axd-or-scriptresource-axd-not-working.aspx
2. http://imnettellect.blogspot.in/2010/12/iis-75-webresourceaxd-and.html
3. http://stackoverflow.com/questions/1433512/asp-net-web-application-webresource-axd-and-scriptresource-axd-files-loading

and so on ....

After spending 4 hours I found a new property on asp.net 4.0 called EnableCdn that basically, if it's set to "true", it loads the resources from the Microsoft content resource servers.

Refer this link for information about EnableCDN.

This worked like a charm and fixed my issue.

I hope this snippet can help many techies. :-)

How to hide bootStrap popover when user click(s) outside the popover?

noreply@blogger.com (Unknown) — Thu, 10 Oct 2013 09:31:00 +0000

Hiding bootStrap popover when user click(s) outside the popover

Recently I have experienced this problem i.e., hiding the popover when we click outsode the popover.I have worked on it and fixed the issue.So,I thought to share this fix.

For more detail(s) about the bootStrap please refer this link PopOver

popover plugin has a property called "trigger" of type String with default event as "click" and popover can be triggered by click/hover/focus/manual.

To show the popover we need to prepare the HTML mark-up as given below

<div class="btn-group">
        <div class="btn-group" id="ddlSelected" style="clear: both;">
            <button class=
            "btn btn-primary btnSelectedStyle selectedBorderStyle" type=
            "button">Your selected Items (<b id=
            "lblSelectedItemCount">0</b>)</button> <button class=
            "btn btn-primary dropdown-toggle selectedBorderCaratStyle"
            data-toggle="dropdown" type="button"><span class=
            "caret"></span></button>
        </div>

        <div class="popover-content" id="divContent" style=
        "display: none; white-space: nowrap"></div>
    </div>
 
 To Show the popover on click we need to write JS like this 
 
 $("#ddlSelected").popover({
        trigger: 'manual',
        placement: 'bottom',
        title: 'Selected Item(s)',
        container: 'body',
        animation: true,
        html: true,
        //delay: { show: 200 },
        content: function () {
            return $("#divContent").html();
        } //content that is displayed
    }).on("click", function (evt) {
        evt.stopPropagation();
        $("#ddlSelected").popover('show');        
    });

To hide the popover when user click other than popover Div

$('html').click(function () {
        if ($(".popover").length) {
            $("#ddlSelected").popover('hide');
        }
    });

I have seen in many forums developers are working hard to hide the popover when click outside the popover.I wish this article will be helpful and happy coding. :-)

Why Dispose() is preferred than Finalize() for Un-Managed Resources in .NET?

noreply@blogger.com (Unknown) — Thu, 15 Aug 2013 18:35:00 +0000

Memory management is very important in any application development.The Garbage collector of .NET does almost all clean up activity for your objects.For unmanaged resources (Ex:Windows API created objects, File, Database connection objects, COM objects, etc.) are outside the scope of .NET framework.

Why Dispose() is preferred than Finalize()

If we use the "Finalize()" method,the Garbage collector has to make two round in order to remove the objects.

For an instance ,let me explain clearly if we have two objects as Object1 and Object2 and we finalize the Object2 as given in the below image.The GC has to categorize the two objects and put the Finalize objects into Finalization Queue.The GC will clean the object1 which doesn't use the Finalize() method and process the second round of cleaning the Finalization Queue.

Now at this the "Dispose()" method will come into picture.This method belongs to IDisposable() interface .So the best practise to release the unmanaged code,implement IDisposable() and override the Dispose() method.If we write any re-usable component for client we need to expose the Dispose method so that client can use that method.In a worst scenario if the client forgets to call this method ,then How do we force the Dispose method to be called automatically?

Implement as given below

public class CleanClass : IDisposable
    {
        public void Dispose()
        {
            GC.SuppressFinalize(this);
        }
        protected override void Finalize()
        {
            Dispose();
        }
    }

Detailed Table using jQuery

noreply@blogger.com (Unknown) — Fri, 22 Mar 2013 10:38:00 +0000

We have seen in many sites regarding detailed information of products below the row when we click on the downwards arrow and collapse when click on upwards arrow.

We have many plugin's for this type of functionality we can also do with jQuery simple logic also.

I have done some R&D regarding this and want to share information of detailed table using jQuery.

We need to download the latest jQuery File from this link http://jquery.com/download/

We have many CDN links also available for directly accessing the jQuery library files.

Google :

https://developers.google.com/speed/libraries/devguide#jquery

Micro-soft :

http://www.asp.net/ajaxlibrary/cdn.ashx

Git-hub:

https://github.com/jquery/jquery

We have few utility files used for this functionality .I have attached the folder structure to maintain .Please see the below image

I have taken a student statistics as input to show the data in HTML Table format.

We need to write in jQuery to show the details of a student in detailed Table

       $(document).ready(function () {
            $("#htmlTable tr:odd").addClass("odd");
            $("#htmlTable tr:not(.odd)").hide();
            $("#htmlTable tr:first-child").show();

            $("#htmlTable tr.odd").click(function () {
                $(this).next("tr").toggle();
                $(this).find(".arrow").toggleClass("up");
            });           
        });

The end output of this script with the markup language is given below

Hope this example  has given a basic implementation in jQuery  :-)

Source Code

How to use constants in .NET?

noreply@blogger.com (Unknown) — Fri, 15 Mar 2013 18:18:00 +0000

I have a written this Dev tip for the new folk who entered in this Dev World.

Normally in the development we use some of the success message's or failure messages in general common message's.We do have a habit of writing the messages as given below

MessageBox.Show("Successfully created a record!");

MessageBox.Show("Successfully deleted a record!");

We can make use of Constants in .NET which will be declared using the keyword "const".For the above scenario we can create a class like "Messages.cs" and define constants as given below

 public class Messages

    {

        public const string strUserExist = "User Name already exists.";

        public const string strUserSaved = "User information saved successfully.";

        public const string strUserDeleted = "User deleted successfully.";

    

    }

Advantage :We can change the message text only in the Message.cs class which will be applicable through out the project where ever we have used this constant.

Usage :

MessageBox.Show(Message.strUserExist);

The above scenario is one of the example I have explained.Guys! There are many scenario's where we use like this according to the purpose.

We can do this either in Windows or Web Development also.

I hope this will give a basic idea about constants in .NET to the newbies.

Happy Coding :-)

Difference between Debug and Release Modes in Visual Studio

noreply@blogger.com (Unknown) — Fri, 15 Mar 2013 12:57:00 +0000

Difference between Debug and Release Modes in Visual Studio

We have two options to build a application in production or development stage.Both have their own importance's and characteristics .

Debug:Developer use debug mode for debugging the web application on live/local server.Debug mode stores debug information so it takes time to execute.We can use F10,F11 function keys as well keep tracking the break point.In debug mode the *.pdb (Program debug database) file will be created which contains the debug steps in the binary format.Less optimized code.

Release: We can't do the debug in this mode ,hence no chance of creating *.pdb file.Scripts & images downloaded by webresource.axd are cached.It has small size, and runs fast.More optimized code.

I hope this information could help folks.

Happy coding :-)

Get the SQL Server Information from Query

noreply@blogger.com (Unknown) — Fri, 08 Mar 2013 10:30:00 +0000

Some times we need to get the information of the SQL Server where it is installed. Simply we can get the info from Query also

-- Get the version info

select @@version
We have a in-built stored procedure called 'xp_msver' to the Server information.
-- Get the Server Information
exec xp_msver

This is a basic information provided but may be useful to the SQL Server learners .

Good day :-)

How to update Row which is not having Primary Key?

noreply@blogger.com (Unknown) — Fri, 15 Feb 2013 09:48:00 +0000

We all find some different scenario where the table has no primary key column and need to update the records having same data.

For this type of scenario's we need to update the particular column based on some Unique value.In SQL Server we have a option called "ROW_NUMBER()" .Every one know about Row_Number() I will present a brief intro about this.

ROW_NUMBER():

ROW_NUMBER to find the Row number of a particular column if its specified in orderby Clause.It has the following syntax

Syntax:

select row_number() over (order by name) as ROWNumber, Name from sys.all_objects order by name

For more details about the ROW_NUMBER() refer this MSDN.

Here I will present a example query to update a table which has no primary key and having same data for few rows.

WITH Record AS (select row_number() over (order by [columnName]) as ROWNumber, Name from sys.all_objects order by name )
UPDATE Record set [col1]=@col1,[col2]=@col2,[col3]=@col3 where Record.rownum=@rownum

columnName --> Column Name in which column you want to order by.

Pass the column values

1. @col1 --> column1 value e.t.c

In C#.Net we need to frame the query as above and pass the parameters.

Any quesry feel free to ask :_)
Hope this will help you :-)

Programmatically Zip and UnZip the files in .NET

noreply@blogger.com (Unknown) — Thu, 06 Dec 2012 12:44:00 +0000

Normally we may find the functionality to Zip and Unzip the file pro grammatically.We have many third party components to do this operation.Here I am going to present Zip and Unzip files using "CGZipLibrary.dll" in C#.NET.

To do this we need to download the CGLibrary.dll from this link and register this dll.

The zip file contains 3 DLL's:

CGZipLibrary.dll
zip32.dll
Unzip32.dll

Open the command prompt in administrator mode.Now we need to register this CGZipLibrary.dll as given below

regsvr32 filepath\filename

Ex: regsvr32 D:\Download\CGLibrary.dll

After registering the dll and Copy zip32.dll and unzip32.dll to

c:\windows\system32 directory or c:\winnt\system32.

Unzip the file you need to do like this

string SrcPath = @"D:\StudentReports.zip";

string DestPath = @"D:\ZippedFiles";

try

{

CGUnzipFiles oUnzip = new CGUnzipFiles();

oUnzip.ZipFileName = SrcPath;

oUnzip.ExtractDir = DestPath;

int result = oUnzip.Unzip();

}

catch (Exception ex)

{

throw ex;

}

Zip the file you need to do like this

CGZipFiles oZip = new CGZipFiles();

oZip.AddFile(@"D\Test1.txt");

oZip.AddFile(@"D\Test2.txt");

oZip.AddFile(@"D\Test3.txt");

oZip.ZipFileName = @"D:\ZippedFiles";

int result= oZip.MakeZipFile();

Like this we can do Zip and Unzip the files programmatically.

Happy coding :-)

Bind the Events to the Dynamically Created Rows in a HTML Table

noreply@blogger.com (Unknown) — Thu, 15 Nov 2012 12:55:00 +0000

I found a solution to bind the events to the dynamically created buttons in a HTML.Some times we need to add a row to the existing HTML table with some inputs.That dynamically created row is not visible in the page source.Try It !

So to attach the events also we need to do like this

var newRow = "<tr> <td></td> <td><input type='text' 
id='tbNameDyn'/></td> <td> <input type='text' id='tbAgeDyn'/><

/td> <td><input type='checkbox' 
id='tbResultDyn'/></td>

<td><input type='submit' name='submitButton' value='Save Row' id='btnSaveRowDyn' 
onclick='DynButtonClick();'> </td></tr>";
            //  $('#webgrid > tbody:last').
            $('#webgrid tbody:last').append(newRow);

Here I have binded the button with the event "onClick" function "DynButtonClick".See the Code too

function DynButtonClick() {
        var rows = $('#webgrid tr').length;
        var name = $('#tbNameDyn').val();
        var age = $('#tbAgeDyn').val();
        var checked = $('#tbResultDyn').val() == "on" ? true : false;
        $('#hdnFldRowDyn').val(name + ":" + age + ":" + checked);
    }

Now when we click on the dynamically created button the event associated to the button click will fire. Try this let me know if you have Queries :-)

Make the Textbox as Label using CSS

noreply@blogger.com (Unknown) — Thu, 15 Nov 2012 07:11:00 +0000

This is a simple tip to make the textbox as label in the Web Pages.We need to just add a simple CSS to the input text.See code snippet

.textboxAslabel {
border:none;
background-color:#FFF;
border-color:#FFF;
}

Here I have mentioned the background-color and border-color as "white".In my application the background-color is white.So according to your background-color change it.Now Apply that to the textbox.See this Image

Single to handle multiple "Submit" button Clicks in MVC3 Razor View

noreply@blogger.com (Unknown) — Mon, 12 Nov 2012 11:05:00 +0000

Last week, I have faced a problem on handling the multiple "Submit" buttons clicks in a View.I am not very good at MVC3 but I want to share my experience so that others can find some solution regarding this problem.

Suppose we have many Submit buttons in a View where we want to handle the different functions. In the Controller of the We need to write the Code for different submit buttons as given below

[AcceptVerbs(HttpVerbs.Post)]
        public ActionResult FormActions(string submitButton)
        {
            switch (submitButton.ToLower())
            {
                case "click to know date":
                    this.SetNotification(DateTime.Now.Date.ToString("dd-MMM-yyyy"),

                     NotificationEnumeration.Success, true);
                    return View("index");
                    break;
                case "click to know time":
                    this.SetNotification(DateTime.Now.ToString ("T"),

                         NotificationEnumeration.Success, true);
                    return View("index");
                    break;
                default:
                    return View("index");
                    break;
            }
        }

The View Code is given below

@using (Html.BeginForm("FormActions", "Test", FormMethod.Post))
{
    
    <table border="0" cellpadding="0" cellspacing="0">
        <tr>
            <td>
                <input type="submit" name="submitButton" value="Click to Know Time" />
            </td>
        </tr>
        <tr>
            <td>
                <input type="submit" name="submitButton" value="Click to Know Date" />
            </td>
        </tr>
    </table>
    
}

When we click on the "Click to Know Time" we will get the Time and we click on the "Click to Know Date ".
Hope this article is helpful :-)

Difference between the SCOPE_IDENTITY(),@@IDENTITY and IDENT_CURRENT in Sql Server

noreply@blogger.com (Unknown) — Tue, 02 Oct 2012 12:26:00 +0000

SCOPE_IDENTITY(),@@IDENTITY and IDENT_CURRENT('table_name') are the SQL SERVER Functions which will return the last inserted record Identity Value.

Normally in the development stage we need to get the last inserted row information using SQL Query.

Lets go in deep to understand the differences between these three functions.

@@IDENTITY :

@@IDENTITY will return the Identity value generated in a table irrespective of the scope.The main advantage lies here when we have a trigger on a table that causes anidentity to be created in another table,you will get the identity that was created last since it gets the identity regardless of the table.

Syntax :SELECT @@IDENTITY;

SCOPE_IDENTITY():

SCOPE_IDENTITY() also returns the Identity Value generated in a table with in the same scope regardless of the table that produced the value.

Syntax:SELECT SCOPE_IDENTITY();

IDENT_CURRENT('table_name'):

It will returns the last Identity value produced in a table regardless of the connection that created the value and regardless of the scope of the statement that produced the value.Simplye IDENT_CURRENT is not limited to any scope or session.

Syntax: SELECT IDENT_CURRENT('table_name') ;

Note: It always better to use the SCOPE_IDENTITY() to return the idenitty of the recently added row in our T-SQL Statement or Stored Procedure.

Set the Default Value to the Column Of a Table Programmaticaly

noreply@blogger.com (Unknown) — Thu, 13 Sep 2012 13:22:00 +0000

Normally we face this type of problem when we want to set the column default value pro-grammatically.

To Solve this problem we need to first get the table column information using this Query.

"SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='person'".

Here the table name may vary.

when we execute this Query we will get the each column information .So based on this we can Iterate the each column and get the each column Information as given below

VB.NET

 Private Sub Initialise_The_Table(ByVal ReqTab As String)  
      On Error GoTo handle_error  
      Dim eachTableAdapter As SqlDataAdapter  
      Dim tableDataset As New DataSet  
      Dim adoHelper As SQLHelper = SQLHelper.GetInstance  
      eachTableAdapter = adoHelper.GetAdapter("SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + ReqTab + "'")  
      eachTableAdapter.FillSchema(tableDataset, SchemaType.Source, ReqTab)  
      eachTableAdapter.Fill(tableDataset, ReqTab)  
      For ii As Integer = 0 To tableDataset.Tables(ReqTab).Rows.Count - 1  
        If Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = (SqlDbType.NVarChar.ToString.ToLower) _  
        Or Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = SqlDbType.NText.ToString.ToLower _  
        Or Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = SqlDbType.Int.ToString.ToLower _  
        Or Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = SqlDbType.Real.ToString.ToLower _  
        Or Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = SqlDbType.Float.ToString.ToLower _  
        Or Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = SqlDbType.SmallInt.ToString.ToLower _  
        Or Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = SqlDbType.TinyInt.ToString.ToLower _  
        Or Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = SqlDbType.Money.ToString.ToLower Then  
          If Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = SqlDbType.NVarChar.ToString.ToLower _  
          Or Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("DATA_TYPE")).ToLower = SqlDbType.NText.ToString.ToLower Then  
            If Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("IS_NULLABLE")).ToLower = "yes" Then ''''Checking the column IS_NULLABLE   
              If Convert.IsDBNull(tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_DEFAULT")) Or _  
              String.IsNullOrEmpty(tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_DEFAULT").ToString) = False Then  
                Errorlog.WriteLog(Information.Err().Number, "Field Defaults set on ", ReqTab, _  
                         tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_NAME"))  
                adoHelper.ExecNonQuery("ALTER TABLE [dbo].[" + ReqTab + "] ADD CONSTRAINT [DF_" + ReqTab + "__" + _  
                         tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_NAME") + "] DEFAULT '' FOR " + _  
                         tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_NAME") + "")  
                GoTo Next_Field  
              End If  
            End If  
          Else  
            If Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("IS_NULLABLE")).ToLower = "yes" Then ''''Checking the column IS_NULLABLE   
              If Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_DEFAULT")) &amp;lt;&amp;gt; "((0))" Then  
                If Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_DEFAULT")).ToLower() &amp;lt;&amp;gt; "genuniqueid()" _  
                And Strings.Mid(Convert.ToString(tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_NAME")), 1, 2).ToLower() &amp;lt;&amp;gt; "s_" Then  
                  Errorlog.WriteLog(Information.Err().Number, "Field Defaults set on ", ReqTab, _  
    tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_NAME"))  
                  adoHelper.ExecNonQuery("ALTER TABLE [dbo].[" + ReqTab + "] ADD CONSTRAINT [DF_" + ReqTab + "__" + _  
                             tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_NAME") + "] DEFAULT 0 FOR " + _  
                             tableDataset.Tables(ReqTab).Rows(ii)("COLUMN_NAME") + "")  
                End If  
                GoTo Next_Field  
              End If  
            End If  
          End If  
        End If  
  Next_Field:  
      Next ii  
      Exit Sub  
  handle_error:  
      If Information.Err().Number = 3078 Then  
        MessageBox.Show("No such table in database", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error)  
        Exit Sub  
      Else  
        If Do_All = 1 And Not Init_Phase Then  
          MessageBox.Show(Information.Err().Description, "System Error: " &amp;amp; Information.Err().Number &amp;amp; " table = " &amp;amp; Public_db.TableDefs(i).Name, _         MessageBoxButtons.OK, MessageBoxIcon.Error)  
        Else  
          MessageBox.Show(Information.Err().Description, "System Error: " &amp;amp; Information.Err().Number, MessageBoxButtons.OK, MessageBoxIcon.Error)  
        End If  
      End If  
      Resume  
    End Sub

I think solution will be helpful to many guys :-)
Happy meaningful day :-)

Context Menu in ASP.NET

noreply@blogger.com (Unknown) — Tue, 03 Jul 2012 13:09:00 +0000

We normally face a task like to show Menu when we right click the gridview or treeview e.t.c.

Many third party controls are providing this right click context Menu to the controls like one of the best third party control like Telerik.

But we can do this type of requirements using jQuery also.

To do this in ASP.NET we need to download the jQuery Context Menu plugin.

We need frame the menu div based on our requirement.See this example to do

<div> <ul id="myMenu" class="contextMenu"> <li class="edit"><a href="#edit">Edit Node</a> </li> <li class="delete"><a href="#delete">Delete Node</a> </li> </ul> </div> * This source code was highlighted with Source Code Highlighter.

After downloading the plugin you need to add this lines in your .aspx page

<script src="jquery.contextMenu-1.01/jquery.contextMenu.js" type="text/javascript"></script> <link href="jquery.contextMenu-1.01/jquery.contextMenu.css" rel="stylesheet" type="text/css" /> * This source code was highlighted with Source Code Highlighter.

You can customize the "jquery.contextMenu.css" file according to our requirement.

Here I have taken a tree view control and binded th two data tables as the data source .Please see the below code

protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Can call From Database also DataTable dt = RootNodes(); TreeNode headnode = new TreeNode(); headnode.Text = "Head Node"; tv1.Nodes.Add(headnode); //Loop for binding Parent Values for (int i = 0; i < dt.Rows.Count; i++) { TreeNode firstchild = new TreeNode(); firstchild.Text = dt.Rows[i][1].ToString(); headnode.ChildNodes.Add(firstchild); //Can call from Database on the basis of value of firstchild //Here you can pass argument. DataTable dt1 = ChildNodes(); //Loop for binding Child Values. for (int j = 0; j < dt1.Rows.Count; j++) { TreeNode childnode = new TreeNode(); childnode.Text = dt1.Rows[j][1].ToString(); firstchild.ChildNodes.Add(childnode); //more over can expand the list. } } } } public DataTable RootNodes() { DataTable dt = new DataTable("Root"); dt.Columns.Add("RootId", typeof(int)); dt.Columns.Add("RootDesc", typeof(String)); DataRow dr = dt.NewRow(); dr[0] = "10"; dr[1] = "Root Node One"; dt.Rows.Add(dr); DataRow dr1 = dt.NewRow(); dr1[0] = "20"; dr1[1] = "Root Node Two"; dt.Rows.Add(dr1); return dt; } public DataTable ChildNodes() { DataTable dt = new DataTable("Child"); dt.Columns.Add("ChildId", typeof(int)); dt.Columns.Add("ChildDesc", typeof(string)); DataRow dr = dt.NewRow(); dr[0] = "10"; dr[1] = "Child Node One"; dt.Rows.Add(dr); DataRow dr1 = dt.NewRow(); dr1[0] = "20"; dr1[1] = "Child Node Two"; dt.Rows.Add(dr1); return dt; } * This source code was highlighted with Source Code Highlighter.

Now we need to invoke the jQuery Context Menu when we right click on any tree view node.See the below logic to invoke using jQuery

<script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script> <script src="jquery.contextMenu-1.01/jquery.contextMenu.js" type="text/javascript"></script> <link href="jquery.contextMenu-1.01/jquery.contextMenu.css" rel="stylesheet" type="text/css" /> <script type="text/javascript"> $(document).ready(function () { $('#divTV a[class$=tv1_0]').contextMenu({ menu: "myMenu" }, function (action, el, pos) { alert( "Action: " + action + "\n\n" + "Element ID: " + $(el).attr("id") + "\n\n" + "X: " + pos.x + " Y:" + pos.y + " (relative to element)\n\n" + "X: " + pos.docX + "Y: " + pos.docY + " (relative to document)" ); switch (action) { case "edit": alert("You have clicked Edit ! "); break; case "delete": alert("You have clicked Delete ! "); break; default: break; } }) }); </script> * This source code was highlighted with Source Code Highlighter.

The output is show in the below

When we click on any Menu Item we will get the Item Details like the Client ID ,Position,Value e.t.c. See the below Image too

Any Suggestions regarding this article are welcome :-)

Decide Cursor Type and Lock Type based on CRUD Operation

noreply@blogger.com (Unknown) — Thu, 28 Jun 2012 10:50:00 +0000

Normally when we do the addition and deletion of record in the ADODB,cursor type and lock type will be changed.So we need to be very careful while adding and deleting a record using the record set object.So for this I have done a sample on addition only.
1. When we want to add using the record set object we need to pass the Cursor Type and Lock Type as
ADODB.CursorTypeEnum.adOpenDynamic
ADODB.LockTypeEnum.adLockOptimistic

2. By default, ADO record sets are opened with a lock type of adLockReadOnly, which does not allow additions and deletions.
3. To allow additions and deletions, open the record set with a lock type of either adLockOptimistic or adLockPessimistic
To Solve this we need change the code like this

Dim recordSetObj As New ADODB.RecordSet 
recordSetObj .Open("select * from students", "Your Connection Object", 
ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
 If Not recordSetObj .EOF Then 
recordSetObj .AddNew() 
End If
''Suppose If We want delete a record then we need to Give the 
''LockType as ADODB.LockTypeEnum.adLockPessimistic

Get the Clicked Cell Value and Column Name of GridView in ASP.NET

noreply@blogger.com (Unknown) — Tue, 26 Jun 2012 11:53:00 +0000

Normally we find the requirement to get the selected Cell Clicked Value .In rare cases we need to find the Column Name and Index of the Cell clicked in the GridView.

This is some how tricky work to get the Column name and index also.We can do this in many ways .

We must be very much thankful to the jQuery contributors for such beautiful lightweight,fast and concise Library.

Really this is very good we can't iterate the table loop to the clicked cell value.
With a Single we can get the clicked Value.Look at this line of Code
$('#gv>tbody>tr>td').text();

For this requirement I have taken a grid which i have given a static datasource.

  protected void Page_Load(object sender, EventArgs e)  
     {  
       if (!IsPostBack)  
       {  
         AddData();  
       }  
     }  
     public void AddData()  
     {  
       try  
       {  
         DataTable dt = new DataTable();  
         dt.Columns.Add("ID", typeof(Int32));  
         dt.Columns.Add("Name", typeof(String));  
         dt.Columns.Add("Salary", typeof(Decimal));  
         dt.Columns.Add("Place", typeof(String));  
         DataRow dr = dt.NewRow();  
         dr["ID"] = 1;  
         dr["Name"] = "Varun";  
         dr["Salary"] = 15.06;  
         dr["Place"] = "GUNTUR";  
         dt.Rows.Add(dr);  
         dr = null;  
         dr = dt.NewRow();  
         dr["ID"] = 2;  
         dr["Name"] = "Sainath";  
         dr["Salary"] = 34545;  
         dr["Place"] = "VIJAYAWADA";  
         dt.Rows.Add(dr);  
         dr = null;  
         dr = dt.NewRow();  
         dr["ID"] = 3;  
         dr["Name"] = "Mohan";  
         dr["Salary"] = 4005;  
         dr["Place"] = "ELURU";  
         dt.Rows.Add(dr);  
         dr = null;  
         dr = dt.NewRow();  
         dr["ID"] = 4;  
         dr["Name"] = "Rohit";  
         dr["Salary"] = 34545;  
         dr["Place"] = "KAKINADA";  
         dt.Rows.Add(dr);  
         gv.DataSource = dt;  
         gv.DataBind();  
       }  
       catch (Exception ex)  
       {  
         throw ex;  
       }  
     }

To Do task with jQuery we need to add the jQuery Supporting file.You can download the updated one from here ---> http://jquery.com/

Using the below Script we can get the Clicked Text ,Column Name and Index too.

  <script type="text/javascript" src="http://code.jquery.com/jquery-1.4.1.js"></script>  
   <script type="text/javascript">  
     $(document).ready(function () {  
       $('#gv>tbody>tr>td').dblclick(function () {  
         var col = $(this).parent().children().index($(this));  
         var title = $(this).closest("table").find("th").eq(col).text();  
         $('p').html("Cell Clicked Text ---> " + $(this).text() + "<br/>" + "Column Name  ---> " + title + "<br/>" + " Column Index ---> " + col + "<br/>");  
         $('p').css('border-style', 'dotted');  
         $('p').css('border-color', 'purple');  
       });  
     });  
   </script>

By doing this we can get the Clicked Cell Text,Column Name and Column Index in asp.net using jQuery.
The Screen Shot is given below

Any suggestion on this are welcome :-)

Convert DataSet or DataTable to XML

noreply@blogger.com (Unknown) — Mon, 18 Jun 2012 13:31:00 +0000

Normally we face this problem where we have lots of data to convert into XML file from DataSet or DatTable .Because XML file is readable by all languages.

Here I have some sample Snippet for Writing the DataSet or DataTable to XML format.

   DataSet ds = new DataSet();
   using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CON"].ConnectionString))
            {
                con.Open();
                string Query = "select col1,col2 from table ";
                SqlDataAdapter da = new SqlDataAdapter(Query, con);
                da.Fill(ds,"TableName");
                ds.Tables["TableName"].WriteXml("XML File Path");
            }

Hope this help you :-)

Any Suggestion s on this article are welcome :-)

jQuery to Validate password and confirm password

noreply@blogger.com (Unknown) — Wed, 06 Jun 2012 14:18:00 +0000

This article is mainly focused on the validating the password and Confirm password using Client Side Scripting "jQuery".

Normally we have password and confirm password in the regsitration page where we need to validate the password and confirm password.

This can also be done using the compare validator also in Asp.Net.

In this demo I have taken two textboxes where i set the textmode as "password".Now in the button click I am validating the both fields has same value or not.

HTML Markup:

Code :

Here I have written like if both the values are same then excute the server code as "return 1==1" :-) which means execute the server code.

Any suggestion on this article are welcome .
Hope this may help :-)

Swapping of ListBox Items using jQuery

noreply@blogger.com (Unknown) — Mon, 04 Jun 2012 13:23:00 +0000

The interchanging of Items of one list-box to other list-box is done in this Swapping of List-box Items.Here the swapping is done in the Client Side using jQuery.For Swapping the Items I took two Array lists .

Initially I have filled the two array lists with the list boxes data.Now I have written a Common Method to swap the Items from one list box to other.

HTML Markup:

<div>
        <asp:ListBox runat="server" ID="lstbx1">
            <asp:ListItem Text="text1" />
            <asp:ListItem Text="text2" />
            <asp:ListItem Text="text3" />
            <asp:ListItem Text="text4" />
        </asp:ListBox>
        <br />
        <asp:ListBox runat="server" ID="lstbx2">
            <asp:ListItem Text="text5" />
            <asp:ListItem Text="text6" />
            <asp:ListItem Text="text7" />
            <asp:ListItem Text="text8" />
        </asp:ListBox>
        <asp:Button Text="Swap Items " ID="btnSwap" runat="server" 
            onclick="btnSwap_Click" />
    </div>

In the button click I have Swapping of Items in the button click.The jQuery Code is given below

<script type="text/javascript" src="http://code.jquery.com/jquery-1.4.1.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $('input[id$=btnSwap]').click(function () {
                var listbox1 = new Array();
                var listbox2 = new Array();
                for (var i = 0; i < $('select[id$=lstbx1]')[0].length; i++) {
                    listbox1.push($('select[id$=lstbx1]')[0][i].text);
                }
                for (var i = 0; i < $('select[id$=lstbx2]')[0].length; i++) {
                    listbox2.push($('select[id$=lstbx2]')[0][i].text);
                }
                $('select[id$=lstbx1]').empty(); $('select[id$=lstbx2]').empty();
                SwapListBoxItems(listbox2, $('select[id$=lstbx1]')[0].id);
                SwapListBoxItems(listbox1, $('select[id$=lstbx2]')[0].id);
                alert('Swapping done !');
                return 4 == 2;
            });
        });

        function SwapListBoxItems(lstbx, lstbxID) {
            for (var j = 0; j < lstbx.length; j++) {
                $("select[id$=" + lstbxID + "]").append("<option>" + lstbx[j] + "</option>");
            }
        }

    </script>

Now the items in the first listbox will be swapped to the Second listbox and vice versa.This is how we can swap the items using Client Side Scripting .

Below is the output of the above executed code