Web Development

 "aoColumns" : [

 { "mDataProp": "RequestID", "sWidth": "50px", sSortable: true,
   "bSearchable": false,
   "bSortable": false,
   "fnRender": function (oObj)
    {
     // oObj.aData[0] returns the RequestID
        return "<a target='tab' data-tab-name='#RequestDetails' data-tab-index='2' href='viewdetails.php?requestID="
                        + oObj.aData["RequestID"] + "'> " + oObj.aData["RequestID"] + " </a>";
                }
               },
  { mDataProp: "RequestDate",  "sWidth": "100px", sSortable: true },
  { mDataProp: "RequestorFullName",  "sWidth": "150px", sSortable: true },
  { mDataProp: "PrimarySiteContactDisplay",  "sWidth": "250px", sSortable: true },
  { mDataProp: "RequestLocation",  "sWidth": "150px", sSortable: true },
  { mDataProp: "RequestDescription",  "sWidth": "200px", sSortable: true },
  { mDataProp: "RequestStatus",  "sWidth": "100px", sSortable: true },

],

$("#exmple").on("click", "a[target='tab']", function(){
  var me = $(this);
  var url = me.attr("href");
  var tabName = me.data("tabName");
  var tabIndex = parseInt(me.data("tabIndex"), 10);
  $.get( url, function( data ) {
var table = $( '<table cellpadding="4" cellspacing="0" border="1"/>' ),
    tr = $( '<tr/>' ),
    td = $( '<td/>' ),
    th = $( '<th/>' );
tr.clone().html( th.text( 'Time' ) )
.append( th.clone().text( 'Room' ) )
.append( th.clone().text( '???' ) )
.append( th.clone().text( '???' ) )
.appendTo( table );
$.each( data.aaData, function(i,v) {
    tr.clone().html( td.clone().html( v[0] ) )
    .append( td.clone().html( v[1] ) )
    .append( td.clone().html( v[2] ) )
    .append( td.clone().html( v[3] ) )
    .appendTo( table );
    });
    $( tabName ).html( table );
    $("#tabs").tabs("option", "active", tabIndex);
    }, 'json' );
    return false;
});

Imports System.Windows.Forms

Partial Class ExisitingApplication
    Inherits System.Web.UI.Page

   Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click
      If Me.txtLastN.Text = "" Then

         Dim erMsg As Windows.Forms.DialogResult = MessageBox.Show("Must enter Last Name.", "Search", MessageBoxButtons.OK)

      End If

      'Define connection string with datasource
      Dim str As String = ConfigurationManager.ConnectionStrings("SqlDataSource1").ToString

      'Define sql statement to be used
      Dim strUSRACCESS As String = "SELECT FirstName, LastName, SSN from tblMAGIapplications where (FirstName = @FirstName and LastName = @LastName) or (SSN = @SSN)  "

      'Define sql connection using connection string defined above
      Dim USRconn1 As New Data.SqlClient.SqlConnection(str)

      'Define the compelete sql statement with connection and sql string
      Dim CMD As New Data.SqlClient.SqlCommand(strUSRACCESS, USRconn1)

      'Define reader for sql information returned
      Dim drUSR As Data.SqlClient.SqlDataReader = (0)

      'Open SQL Connection
      USRconn1.Open()

      'Dim number As Integer
      'If Int32.TryParse(Me.txtSS.Text, number) = True Then
      'CMD.Parameters.AddWithValue("@SSN", number)
      'Else
      'CMD.Parameters.AddWithValue("@SSN", 0)
      'End If

      'Add parameters
      CMD.Parameters.AddWithValue("@FirstName", Me.txtFirstN.Text)
      CMD.Parameters.AddWithValue("@LastName", Me.txtLastN.Text)
      'CMD.Parameters.AddWithValue("@SSN", Int32.TryParse(Me.TextBox1.Text, number))
      ''SqlDataSource1.DataBind()
      ''Me.GridView1.DataSourceID = SqlDataSource1
      GridView1.DataSourceID = String.Empty
      GridView1.DataBind()
      USRconn1.Close()


   End Sub
End Class

<div id="tabs">
  <ul>
    <li><a href="#NewRequest">New Request</a></li>
    <li><a href="#ExistingRequest">Existing Request</a></li>
    <li><a href="#RequestDetails">Request Details</a></li>
  </ul>
  ...
  ...
  </div>

<script type="text/javascript" charset="utf-8">
$(document).ready(function() {
    /* Init DataTables */
$("#example").dataTable( {
	"sProcessing" : true,
"sDom":'T<"clear">',
"sJQueryUI": true,
"sPaginationType": "full_numbers",
"sDom": 'T<"clear"><"fg-toolbar ui-widget-header ui-corner-tl ui-corner-tr ui-helper-clearfix"lfr>t<"fg-toolbar ui-widget-header ui-corner-bl ui-corner-br ui-helper-clearfix"ip>',
    "sAjaxSource" : "userDetails.php?loginName=<?php echo $user; ?>",
    "sAjaxDataProp" : "",
    "sDestroy" : false,
        "sScrollXInner": "110%",
    "fnServerData" : function(sSource, aoData, fnCallback) {
        request = $.ajax({
            "dataType" : "json",
            "type" : "GET",
            "url" : sSource,
            "data" : aoData,
            "success" : fnCallback
        });
    },
         "aoColumns" : [

         { "mDataProp": "RequestID", "sWidth": "50px", sSortable: true,
           "bSearchable": false,
           "bSortable": false,
           "fnRender": function (oObj)
            {
             // oObj.aData[0] returns the RequestID
                return "<a href='viewdetails.php?RequestID="
                                + oObj.aData["RequestID"] + "'> " + oObj.aData["RequestID"] + " </a>";
                        }
                       },
          { mDataProp: "RequestDate",  "sWidth": "100px", sSortable: true },
          { mDataProp: "RequestorFullName",  "sWidth": "150px", sSortable: true },
          { mDataProp: "PrimarySiteContactDisplay",  "sWidth": "250px", sSortable: true },
          { mDataProp: "RequestLocation",  "sWidth": "150px", sSortable: true },
          { mDataProp: "RequestDescription",  "sWidth": "200px", sSortable: true },
          { mDataProp: "RequestStatus",  "sWidth": "100px", sSortable: true },

        ],
      })
$('#cityworks tbody tr').click(function () {
    if ($(this).hasClass('selected')) $(this).removeClass('selected');
    else
    {
        $(this).siblings('.selected').removeClass('selected');
        $(this).addClass('selected');
    }
  });
  $(window).bind('resize', function () {
 oTable.fnAdjustColumnSizing();
 });
   jQuery('.dataTable').wrap('<div class="scrollStyle" />');
   });
</script>

// oObj.aData[0] returns the RequestID
   return "<a href='viewdetails.php?RequestID="
                   + oObj.aData["RequestID"] + "'> " + oObj.aData["RequestID"] + " </a>";