SQL Server - Get Stored Procedure Last Modified Date or Updated Date in SQL Server

Introduction:

Here I will explain how to get stored procedure last modified date in SQL server or SQL server check last updated date stored procedure or query to check stored procedure modified date in SQL server 2008.

Description:

In previous articles I explained Query to get database size in SQL Server, show time difference in minute ago hour ago etc in SQL Server, get list of procedures where table name used in sql, difference b/w view and stored procedure in sql, add row items as string with comma separated values in sql server and many articles relating to SQL server. Now I will explain how to check stored procedure modified date in SQL server.

jQuery Add Span Tag to Anchor or inside Hyperlink or href

Introduction:

Here I will explain how to add span tag to anchor or href or hyperlink using jQuery or jQuery add span tag inside of hyperlink or href.

Description:

In previous articles I explained jQuery set maxlength for multiline textbox, jQuery stop form being submit on keypress, jQuery check undefined or empty value and many articles relating to jQuery, JavaScript, Asp.net, SQL server. Now I will explain how to add span tag in href using jQuery.

C# - Could not Load File or Assembly or One of its Dependencies the System Cannot Find the File Specified

Introduction:

Here I will explain how to solve problem of “Could not load file or assembly'xxxxxx’ or one of its dependencies. The system cannot find the file specified” in asp.net, wcf using c#, vb.net.

Description:

In previous articles I explained can function return multiple values in sql,  Query to get database size in SQL Server, Exception handling in SQL Server with try catch, SQL Query to get first & last day of month, difference b/w view and stored procedure in sql and many articles relating to SQL server. Now I will explain how to solve problem of “Could not load file or assembly'xxxxxx’ or one of its dependencies. The system cannot find the file specified” in asp.net, wcf using c#, vb.net.

jQuery Set Maxlength for Multiline Textbox in Asp.net

Introduction: 

Here I will explain how to set maxlength for multiline textbox in asp.net using jQuery or set of maxlength for asp.net multiline textbox in jQuery.

                                                                                   

Description:
  
In previous articles I explained jQuery disable right click on images, jQuery expand textbox on focus , jQuery slideup slidedown slidetoggle example, jQuery fadein or fadeout example, jQuery create rounded corners for textbox, jQuery show time in webpage and many articles relating to JQuery. Now I will explain how to set maxlength for multiline textbox in asp.net using jQuery.

jQuery Set Maximum Length to Textarea or jQuery Check Textarea Maxlength

Introduction: 

Here I will explain how to set maximum length of textarea in jQuery or check maximum length of textarea in jQuery.

                                                                                   

Description:
  
In previous articles I explained jQuery disable right click on images, jQuery expand textbox on focus , jQuery slideup slidedown slidetoggle example, jQuery fadein or fadeout example, jQuery create rounded corners for textbox, jQuery show time in webpage and many articles relating to JQuery. Now I will explain how to check maxmimum length of textarea in jQuery.

Call WCF Service from jQuery Ajax JSON Example in Asp.net using C#

Introduction:

Here I will explain how to call WCF service in jQuery Ajax or JSON example in asp.net using C#, VB.NET.

Description:

In previous articles explained clearly what WCF (windows communication foundation) is and how to create and consume WCF service in c#(windows application) and I also explained clearly uses of WCF Service. Now I will explain how to call WCF service in jQuery Ajax or JSON example in asp.net using C#, VB.NET.

jQuery Slide DIV Content from Left to Right or Move DIV from Right to Left in jQuery

Introduction: 

Here I will explain how to move or slide div content from left to right in jQuery or move div content right to left in jQuery.

                                                                                   

Description:
  
In previous articles I explained jQuery slideup slidedown slidetoggle example, jQuery fadein or fadeout example, jQuery create rounded corners for textbox, jQuery show time in webpage and many articles relating to JQuery. Now I will explain how to move div from left to right or right to left in jQuery.

jQuery Ajax JSON Example in Asp.net

Introduction: 

Here I will explain simple jQuery ajax json example in asp.net or submit a form without page refresh using jQuery ajax json with example in asp.net using c#, vb.net.

Description:
  
In previous articles I explained integrate Facebook login authentication, integrate twitter login authentication, jQuery randomly change color of div and many articles relating to jQuery, asp.net, c#, vb.net. Now I will explain simple jQuery ajax json example in asp.net.

SQL Server - Query to Get List of Tables in Database in SQL Server 2008

Introduction:

Here I will explain SQL server query to get list of all tables in database or get list of all the tables in SQL server 2008 database.

Description:

In previous articles I explained can function return multiple values in sql,  Query to get database size in SQL Server, Exception handling in SQL Server with try catch, SQL Query to get first & last day of month, difference b/w view and stored procedure in sql and many articles relating to SQL server. Now I will explain how to get all the tables in SQL server 2008 database.

Get Table Size in SQL Server | Query to Get Table Size in SQL Server 2008

Introduction:

Here I will explain how to get table size in SQL server or query to get table size in SQL server 2008.

Description:

In previous articles I explained Query to get database size in SQL Server, show time difference in minute ago hour ago etc in SQL Server, get list of procedures where table name used in sql, difference b/w view and stored procedure in sql, add row items as string with comma separated values in sql server and many articles relating to SQL server. Now I will explain how to get table size in SQL server.

SQL Server - How to Get Database Size in SQL Server 2008

Introduction:

Here I will explain how to get database size in SQL server or query to get database size in SQL server 2008.

Description:

In previous articles I explained show time difference in minute ago hour ago etc in SQL Server, get list of procedures where table name used in sql, difference b/w view and stored procedure in sql, add row items as string with comma separated values in sql server and many articles relating to SQL server. Now I will explain how to get database size in SQL server.

what is authorization in asp.net | authorization rules in web.config to allow or deny resources to particular user or role in asp.net.

Introduction:

In this article I will explain what is authorization in asp.net, uses of authorization and I will explain setting authorization rules in web.config to allow or deny resources for particular user or role in asp.net.

Description:

Today I am writing this post to explain about authorization concept in asp.net. In one of the interview interviewer has asked question like what is authorization in asp.net and how we can use authorization concept to allow or deny resources to particular user or role in asp.net.

C# - Difference between String and Stringbuilder in C#, Asp.net

Introduction

Here I will explain what is difference between string and stringbuilder in c# using asp.net.

Description

In previous articles I explained different types of constructors in c#, difference between overloading and overriding in c#, Delegates in c# with example, difference between datareader, dataset and dataadapter in c# and many articles relating to interview questions . Now I will explain difference between string and stringbuilder in c# using asp.net.

C# - Difference between Throw and Throw ex in C# Asp.Net

Introduction

Here I will explain what is the difference between throw and throw ex in c# using asp.net.

Description

In previous articles I explained Different types of polymorphism in c#, Difference between array and arraylist in c#, can function return multiple values in sql server, Difference between char varchar and nvarchar in SQL Server, Joins in SQL Server and many articles relating to interview questions, SQL Server. Now I will explain difference between throw and throw ex in c# using asp.net.

C# - Insert Data into Database using WCF Service in Asp.net

Introduction

Here I will explain how to insert data into SQL Server database using wcf service in asp.net using C# and VB.NET.

Description

In previous articles I explained Show tooltip for gridview header columns, jQuery change tooltip style in asp.net, Add tooltip to dropdownlist items in asp.net, Create simple tooltip with jQuery UI plugin, Asp.net Interview questions, Highlight Gridview records based on search and many articles relating to Gridview, SQL, jQuery,asp.net, C#,VB.NET. Now I will explain how to insert data into SQL Server database using wcf service in asp.net using C# and VB.NET.

jQuery Ajax Submit Form without Page Refresh using JSON in Asp.Net

Introduction: 

Here I will explain how to use jQuery to submit form without page refresh using ajax in asp.net or jQuery submit form without page reload using jQuery ajax  in asp.net  using c#, vb.net.

Description:
  
In previous articles I explained integrate Facebook login authentication, integrate twitter login authentication, jQuery randomly change color of div and many articles relating to jQuery, asp.net, c#, vb.net. Now I will explain how to submit form without refresh or reload page using jQuery in asp.net.

C# - How to Count Number of Online Users in Asp.Net Using C#, VB.NET

Introduction

Here I will explain how to count number of online users of website in asp.net using C# and VB.NET or how to get number of online visitors of website in asp.net using C# and VB.NET.

Description

In previous articles I explained get count of visitors website in asp.net, jQuery cascading dropdown list example in asp.net, jQuery show progressbar in button click in asp.net, Asp.net Interview questions, Joins in SQL Server and many articles relating to Gridview, SQL, jQuery,asp.net, C#,VB.NET. Now I will explain how to count number of online visitors of website in asp.net using C# and VB.NET.

C# - Count Number of Visitors in Website using Asp.net in C#, VB.NET

Introduction

Here I will explain how to count number of visitors to website in asp.net using C# and VB.NET or find or get number of visitors for a website in asp.net using C# and VB.NET.

Description

In previous articles I explained Asp.net Interview questions, Export Gridview data to PDF, Send values from one page to another page using QueryString, Joins in SQL Server, Highlight Gridview records based on search and many articles relating to Gridview, SQL, jQuery,asp.net, C#,VB.NET. Now I will explain how to count number of visitors to website in asp.net using C# and VB.NET.

To get number of visits for website we need to use methods in Global.asax file for that first add Global.asax file in your application

SQL Server Add Auto Increment Column or Set Auto Increment Column SQL Server Management Studio

Introduction:

Here I will explain how to set or add auto increment column in SQL server or create auto increment column in SQL server 2008 using management studio.

Description:

In many situations we will insert records in table during that time we need to set unique value for that record if we use auto increment column then automatically generate unique number for newly insert record in table (Like generate EmployeeID of each employee whenever employee record inserted).

To set auto increment column in table we have different methods

SQL Server - Reset Identity Column Value to 1 in SQL Database

Introduction:

Here I will explain how to reset identity column value in SQL server or change or rest identity column value to 1 in SQL server. or reseed identity column value in SQL server.

Description:

In previous post I explained how set identity or auto incrementcolumn in SQL server. After set identity property on particular column I inserted few records in table and that value automatically increase whenever I inserted data that would be like this