Trim() function for IE

  String.prototype.trim = function () {

            return this.replace(/^\s+|\s+$/g, "");

        };

  var SelectedClient = $("#SelectedClient").val();

    var Data= SelectedClient.trim()

Asp.Net MVC and Report Viewer Control

public ActionResult GetActiveRecordReports()

        {

            List<PE_getActiveCaseListResult> myResult = new List<PE_getActiveCaseListResult>();

            try

            {

                // myResult = (List<PE_getActiveCaseListResult>)Session["GETACTIVEREPORTDATA"];

                myResult = (List<PE_getActiveCaseListResult>)WebserviceHelper.GetReportData("GETACTIVEREPORTDATA"); //List

                CasesModel model = new CasesModel();

                LocalReport localReport = new LocalReport();

                localReport.ReportPath = Server.MapPath("~/Reports/ActiveCaseReport.rdlc"); //Report Path

                String[] dateFrom = Request.QueryString[1].ToString().Split('K'); //Date

                String[] dateTo = Request.QueryString[2].ToString().Split('K');

                DateTime DateBegin = new DateTime(Convert.ToInt32(dateFrom[2]), Convert.ToInt32(dateFrom[0]), Convert.ToInt32(dateFrom[1]));

                DateTime DateEnd = new DateTime(Convert.ToInt32(dateTo[2]), Convert.ToInt32(dateTo[0]), Convert.ToInt32(dateTo[1]));

                string FileType = Request.QueryString[3].ToString();// File Type "PDF,Excel,TIF

                ReportDataSource reportDataSource = new ReportDataSource("AciveDataSet", myResult); //Dateset

                ReportParameter pFrom = new ReportParameter("DateFrom", DateBegin.ToString("MM/dd/yyyy")); //Parameter

                ReportParameter pTo = new ReportParameter("DateTo", DateEnd.ToString("MM/dd/yyyy"));

                localReport.SetParameters(new ReportParameter[] { pFrom, pTo });

                localReport.DataSources.Add(reportDataSource);

                string reportType = FileType;

                string mimeType;

                string encoding;

                string fileNameExtension;

                string deviceInfo = string.Empty;

                Warning[] warnings;

                string[] streams;

                byte[] renderedBytes;

                //The DeviceInfo settings should be changed based on the reportType

                //http://msdn2.microsoft.com/en-us/library/ms155397.aspx

                //Render the report

                renderedBytes = localReport.Render(

                    reportType,

                    null,

                    out mimeType,

                    out encoding,

                    out fileNameExtension,

                    out streams,

                    out warnings);

                Response.AddHeader("content-disposition", "attachment; filename=ActiveCaseReport." + fileNameExtension);

                return File(renderedBytes, mimeType);

            }

            catch (Exception ex)

            {

                employment.CommonClasses.PeErrorLog.InsertErrorLog("User Name:-" + employment.CommonClasses.ControlHelper.GetPeSessionUserName(),

                                                                "GetActiveRecordReports():- " + ex.Message.ToString(), " Address:-" + Request.Path);

            }

            return null;

        }

Select Dropdownlist Selected text through Value in JQuery

function ddlSelectedValue(obj,value) {

            $(obj).each(function () {

                $('option', this).each(function () {

                    if ($(this).val() == value) {

                        $(this).attr('selected', 'selected')

                    };

                });

            });

Add and Remove Style Sheet at Runtime in Javascript

function AddstyleSheets () {

 var cssNode = document.createElement('link');

            cssNode.type = 'text/css';

            cssNode.rel = 'stylesheet';

            cssNode.href = '<%: Url.Content("~/Content/css/index.css")%>';

            cssNode.media = 'screen';

            cssNode.title = 'dynamicLoadedSheet';

            document.getElementsByTagName("head")[0].appendChild(cssNode);

}

function RemovestyleSheets () {

            var styleSheets = document.styleSheets;

            var href = '<%: Url.Content("~/Content/css/index.css")%>';

          

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

               if (styleSheets[i].href == href) {

                  styleSheets[i].disabled = true;

                    break;

                }

            }

        }

Remove all item from Dropdown list using Jquery

Try this..

$('#DayEnd >option').remove();

 

Data Get From Query String int JavaScript

function getQuerystring(key, default_, getUser) {

            if (default_ == null) default_ = "";

            key = key.replace(/[\[]/, "\\\[").replace(/[\]]/, "\\\]");

            var regex = new RegExp("[\\?&]" + key + "=([^&#]*)");

            var qs = regex.exec(window.location.href);

            if (qs == null)

                return default_;

            else

                return qs[1];

        }

var getUser = getQuerystring('name');

                var getResetCode = getQuerystring('resetpassword');

Table Date Column Sort with Jquery

Some time we want to sort date filed in a Table with Jquery.

Here I add a parser in ready function.

$(document).ready(function () {

            $.tablesorter.addParser({

                id: 'dateMS',

                is: function (s) {// return false so this parser is not auto detected

                    return false;

                },

                format: function (s) {

                    var mydate = s; // here my date Formate is yyyy-MM-dd we know that javaScript default format is MM/dd/yyyy so I am converting date filed in a (MM/dd/yyyy) format.

                    var datecal = mydate.split('-')[1].toString() + "/" + mydate.split('-')[2].toString() + "/" + mydate.split('-')[0].toString();

                    var d = Date.parse(datecal);

                    if (isNaN(d)) {

                        return -1;

                    }

                    return d;

                },

                // set type, either numeric or text

                type: 'numeric'

            });

            $("#TblActiveCases").tablesorter({ sortList: [[0, 0]], textExtraction: "complex", widthFixed: false, dateFormat: 'YYYY-mm-dd',

                headers: { 1: { sorter: 'dateMS' }, 2: { sorter: false} }

            })

        });

sql update from select statement

try this

Create Table Lion1

(

    Id   int  identity(1,1)

    ,Name nvarchar(100)

)

Create Table Lion2

(

    Id   int  identity(1,1)

    ,Name nvarchar(100)

)

insert into Lion1 values('A1')

insert into Lion1 values('A2')

insert into Lion1 values('A3')

insert into Lion1 values('A4')

insert into Lion1 values('A5')

insert into Lion1 values('A6')

insert into Lion2 values('B1')

insert into Lion2 values('B2')

insert into Lion2 values('B3')

insert into Lion2 values('B4')

insert into Lion2 values('B5')

insert into Lion2 values('B6')

Select * from Lion1

Select * from Lion2

UPDATE

    Lion2

SET

    Lion2.Name   = Lion1.Name   --Copy Data From Lion1 to Lion2

  

FROM

    Lion2

INNER JOIN

    Lion1

ON

    Lion2.ID  = Lion1.ID

   

   

    Select * from Lion1

Select * from Lion2