aspx Tutorial

Difference Temp Table and Table Variable

Thu, 06 Jun 2013 18:04:00 -1200

Table Variables:

Table Variables was introduced in MS SQL Server 2000, the syntax for creating a Table Variables is @.

There are some characteristic of Table variable

Table variable will generally use less resource
Table variables cannot have Non-Clustered Indexes
Can’t create constraints in table variables
Can’t create default values on table variable columns
The table variables exist only in the same scope as variables.
Table variables are good in performance as compared to temporary tables.

Step 1:

First, Declare a table named @EMP

DECLARE @EMP TABLE(
EMP_ID INTPRIMARYKEY,
EMPNAME VARCHAR(150),
DEPARMENT VARCHAR(150))

Step 2:

Insert some values in @EMP Table variable

INSERT INTO @EMP VALUES ( 1, 'HASEEB','COMPUTER-SCIENCE');
INSERT INTO @EMP VALUES ( 2, 'AAMIR','PHYSICS');
INSERT INTO @EMP VALUES ( 3, 'MOHIB','BUSINESS ADMINISTRATION');

Step 3:

SELECT * FROM @EMP

Output

Temporary Tables

It acts as physical tables, indexes (Non-Clustered/ clustered) and statistics are also created on temporary tables. It has (DDL) statements which acts as temp tables to add constraints, referential integrity, and defaults such as PK and FK.

There are some characteristic of Temporary Tables

Temporary table will generally use higher resource
Temporary table can have Non-Clustered Indexes
Can create constraints in Temporary table
Can create default values on Temporary table
Temporary tables are not visible in inner stored procedures and in EXEC statements.
Temporary table are bad in performance as compared to Table variables.

Let’s, Create a Temporary table named as #EMP.

CREATE TABLE #EMP (
EMP_ID INTPRIMARYKEY,
EMPNAME VARCHAR(50),
DEPARMENT VARCHAR(50)

)

Step 2:

Insert some values in #EMP Table variable

INSERT INTO #EMP VALUES ( 1, 'HASEEB','COMPUTER-SCIENCE');
INSERT INTO #EMP VALUES ( 2, 'AAMIR','PHYSICS');
INSERT INTO #EMP VALUES ( 3, 'MOHIB','BUSINESS ADMINISTRATION');

Step 3:

SELECT * FROM #EMP

Output

Note: You must have to drop temporary table otherwise you cannot create a temporary with same name again

Hide/ Show tabs in Dynamic CRM 2011 using JavaScript

Tue, 04 Jun 2013 00:00:00 -1200

This example demonstrate how to hide/show tabs in Dynamic CRM 2011 using JavaScript. By using Xrm.Page.ui.tabs you can get all tabs in the current page.

Syntax

Xrm.Page.ui.tabs.get("TAB NAME").setVisible(false/true);

setVisible method will hide/ show tab by entering Boolean value

Hide Tab

Xrm.Page.ui.tabs.get("TAB NAME").setVisible(false);

Show Tab

Xrm.Page.ui.tabs.get("TAB NAME").setVisible(true);

Note: You will get error when you will run tabObj.setVisible(false) twice.

Sign in as a Different User in SharePoint 2013

Thu, 02 May 2013 22:20:00 -1200

In Sharepoint 2013,Sign in as a different user is missing from dropdown menu, I got this problem when i was working on Sharepoint 2013 web site to sign in as different user to check the rights. This problem occurs for developers those are testing the application with different users. When user authentication session is created and redirect to Sharepoint 2013 site. Next time this will automatically redirected to Sharepoint 2013 site. But if user is using form based Authentication the default sign in page will be display for credentials.

Solution 1:

You can directly past the following link in your browser to login as different user.

http://<site url>:port/_layouts/closeConnection.aspx?loginasanotheruser=true

You will see the authentication dialog box as shown

Note: You can also add a hyperlink url

Solution 2:

You can directly add “Sign in as different user” option in drop down menu. to add "Sign In different User " item in drop down menu. Let’s start.

Locate the Welcome.ascx user control and Open in a text editor.

Add the following element before sign out element item.

If you have alternative solution, Please comments here to share with us.

Microsoft Dynamics CRM 2011 SDK Now Available

Mon, 29 Apr 2013 19:13:00 -1200

Microsoft has released the latest SDK 5.0.15 for CRM 2011 on date March 27, 2013.The documentation in the SDK contains information for developers server side code, custom business logic, integration modules, workflow assemblies, and plug-ins.

Download the Microsoft Dynamics 2011 CRM SDK.

Microsoft Dynamics CRM 2011 Unleashed Book

Tue, 02 Apr 2013 06:35:00 -1200

I have found Microsoft Dynamic CRM 2011 unleashed book for those people who started working on it. This book will guide you Planning, customizing, deployment, integration. This book also covered integration with azure cloud services.

This book contains following table of contents.

Chapter 1. New Features of Microsoft Dynamics CRM 2011
Chapter 2. Why Business Needs a CRM System
Chapter 3. Requirements for CRM 2011
Chapter 4. Setting Up CRM 2011
Chapter 5. Working with the Ribbon Menu
Chapter 6. Working with Customers
Chapter 7. Working with the Workplace
Chapter 8. Working with Sales
Chapter 9. Working with Marketing
Chapter 10. Working with Service
Chapter 11. Reporting
Chapter 12. Settings and Configuration
Chapter 13. Client Configuration Options
Chapter 14. E-Mail Configuration
Chapter 15. Mobility
Chapter 16. Solution Concepts
Chapter 17. CRM 2011 SharePoint Integration
Chapter 18. Azure Extensions
Chapter 19. Advanced Views and Connections
Chapter 20. Filtered Lookups
Chapter 21. Reporting and Dashboards
Chapter 22. Forms Authentication
Chapter 23. Customizing Entities
Chapter 24. Processes Development
Chapter 25. Plug-Ins
Chapter 26. Web Services
Chapter 27. Advanced Solution Management
Chapter 28. Interacting with Custom Web Applications
Chapter 29. Data Management
Chapter 30. CRM 2011 and Scribe Online Services

Buy Microsoft Dynamics CRM 2011 Unleashed Book

How to change TCP/IP port for SQL Server 2008 and 2012

Mon, 05 Nov 2012 22:23:00 -1200

By Default, SQL Server listens on port 1433. You can change TCP/IP by applying simple steps mentioned below.
Open SQL Server Configuration Manager.
Expand SQL Server Network Configuration
Click on Protocols for MSSQLSERVER (<instance name>)
Right click on TCP IP Protocol and select Properties

Click on IP Addresses tag and change TCP Port for IP listening.

Restart your SQL Server (<instance name>)

How to handle runtime exceptions in java script

Thu, 18 Oct 2012 02:52:00 -1200

In this example, you will see how to handle runtime error on client side using java script. Why we need to add try catch in our java script function because to avoid syntax error, a logical error, a read/write error and client error.

<!DOCTYPE html>

<html>

function calc() {

try {

var i = 1 / 0;

document.getElementById('msg').innerHTML = i;

} catch (e) {

document.getElementById('msg').innerHTML = "Error" + e.message;

}

</script>

</head>

<body>

i/0 = <div id="msg"></div>

</form>

</body>

</html>

In above example, divided by zero will always give exception undefined. I have put the operation in try catch which will throw exception.

Output

Download

See live demo

Drag and drop items from one list to another using jQuery UI plugin

Wed, 19 Sep 2012 22:30:00 -1200

In this example, you will see how to drag and drop items from one list to another list using jQuery UI plugin. Jquery UI plugin provides Sortable method, by using this method you can drag and drop items from one list to another. Let’s start. Add the following jquery and jquery UI plugin reference inside the head section of HTML page.

type="text/javascript"></script>

I have written some css classes to apply some design on the lists and table. You can add your own CSS.

Add the following jquery script which will sort the two connected list and click method which will display all list one items (index no, list id and link text) inside the table on click on submit button.

$(function () {

$("#contentLeft ul, #contentright ul").sortable({

connectWith: ".connectedSortable",

placeholder: "ui-state-highlight"

}).disableSelection();

$("#idsubmit").click(function () {

var msg = $("#table1 > tbody");

var list = $("#contentLeft ul li");

$(msg).html("");

$(list).each(function (index) {

                    $(msg).append("<tr><td>" + index + "</td><td> " +
                           $(this).closest("li").prop("id") + "</td><td> " +
                                  $(this).text() + "</td></tr>");

});

</script>

The following are HTML tags.

</div>

<strong>Remove</strong>

</ul>

</div>

<p>

</p>

<thead>

<th>Index</th>

</thead>

</table>

</div>

Output

Download

Drag-and-drop-items-List.rar (2.36 kb)

See live demo

Disable right click on HTML div

Thu, 06 Sep 2012 19:03:00 -1200

In this example, you will see how to disable right click on HTML div. To prevent user by right click on HTML div, we can disable right on HTML div by using oncontextmenu event provide to disable right click.

Example

<!DOCTYPE html>

<html>

<title>Disable right click on HTML div</title>

<style>

html, body

{

font-family: Arial;

font-size: 90%;

color: #888;

line-height: 1.5em;

background-color: #FFF5FF;

}

.secret

{

border: 1pxsolid#aaa;

display: block;

width: 200px;

height: 100px;

padding: 10px;

background-color: #FFFFCF;

margin: 10px;

}

</style>

</head>

<body>

<div class="secret" oncontextmenu="return false;">Your ASP.NET Control</div>

<p>

<asp:HyperLink ID="HyperLink1" NavigateUrl="http://www.aspxtutorial.com"

runat="server" Target="_blank">jquery with asp.net</asp:HyperLink>

<asp:HyperLink ID="HyperLink2" NavigateUrl="http://www.aspxtutorial.com"

runat="server" Target="_blank">asp.net examples</asp:HyperLink>

</p>

</div>

</form>

</body>

</html>

Output

Download

Disable-Right-ClickonControl.aspx (888.00 bytes)

Demo

See live demo

How to add textboxes and button control to asp.net page at runtime

Sat, 25 Aug 2012 00:59:00 -1200

In this example, you will see how to add textboxes and button control to asp.net page at runtime and fetch all values of dynamic created textboxes and display it on a label by attaching the Click event handler with button.

Desgin script

<html>

<title>How to add textboxes and button control to asp.net page at runtime</title>

body, html

{

font-family: Verdana. Arial;

font-size: 12px;

color: #444;

background-color: #fff;

}

#pan span

{

padding: 5px 10px;

}

#pan input

{

padding: 3px;

margin: 5px;

color: #ccc;

}

#pan input:hover

{

color: #ccc;

background-color: #fafafa;

}

</style>

</head>

<body>

<asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>

<asp:Label ID="lbMsg" runat="server" Text=""></asp:Label>

</div>

</form>

</body>

</html>

Code behind script

protected void Page_Load(object sender, EventArgs e)

{

this.CreateControl();

}

protected void CreateControl()

{

for (int i = 0; i < 5; i++)

{

var lab = new Label {

Text = String.Format("TextBox value {0}", i),

ID = String.Format("lb_{0}", i)

};

var tbox = new TextBox

{

Text = String.Format("TextBox value {0}", i),

ID = String.Format("TextBox_{0}", i)

};

this.PlaceHolder1.Controls.Add(lab);

this.PlaceHolder1.Controls.Add(tbox);

this.PlaceHolder1.Controls.Add(new LiteralControl("<br>"));

}

Button btn = new Button();

btn.Text = "Submit";

btn.Click += new EventHandler(btn_Click);

this.form1.Controls.Add(btn);

}

void btn_Click(object sender, EventArgs e)

{

lbMsg.Text = "";

foreach (Control control in PlaceHolder1.Controls)

if (control is TextBox)

lbMsg.Text += (control as TextBox).Text+"<br>";

}

Note: If you have alternative solution, please comments here to share with us.