Reseed allocated incremental id in sql

Select * from dbo.SpExecutionAuditContorl Where iStep>21 

delete from dbo.SpExecutionAuditContorl  Where iStep>21 

DBCC CHECKIDENT('dbo.SpExecutionAuditContorl', RESEED, 21)

Where Condition on XML column in sql

Suppose UserObject is XML Type column

 

Select ID,

   UserObject.value('(/UserDetail/UserName)[1]','nvarchar(250)') as UserName,

   UserObject.value('(/UserDetail/MailID)[1]','nvarchar(250)') as MailID,

   UserObject.value('(/UserDetail/City)[1]','nvarchar(250)') as City

 From [UserTable]

 

And

 

Select * From [UserTable] Where UserObject.exist('/UserDetail[City="London"]')=1

jquery validation Rules depends on another field

 $('#fu_ImageUpload').rules('add', {
                required: {
                    depends: function () {
                        if ($("#chk_Upload").is(':checked')) {
                            return true;
                        }
                        else {
                            return false;
                         }
                    }
                },
                ImageFormat: {
                    depends: function () {
                        if ($("#chk_PRP").is(':checked')) {
                            return true;
                        }
                        else {
                            return false;
                        }
                    }
                },
messages: {
                    required: "Please  Page.",
                    ImageFormat: "Invalid Image Format"
                }
            });

 jQuery.validator.addMethod("ImageFormat", function (value, element) {
                var ext = value.split('.').pop().toLowerCase();
                switch (ext) {
                    case 'jpg':
                        return true;
                    case 'jpeg':
                        return true;
                    case 'gif':
                        return true;
                        break;
                    default:
                        return false;
                }
            }, "Invalid Image Format.");

Validation using Jquery Validator

Plugins:
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js" type="text/javascript"> </script>
        <script src="//ajax.aspnetcdn.com/ajax/jquery.validate/1.8.1/jquery.validate.min.js" type="text/javascript"> </script>   
              <script type="text/javascript" src="jQueryPlugins/date.js"></script>


// Must use validate method before creating and using rules.
 $("#Form_ID").validate({
                errorElement: "em",   //This is a css class for showing error messege
            });


//Rules for File upload  control
$('#fu_PassportFront').rules('add', {
                required: true,
                messages: {
                    required: "Please Upload Passport Front Page."
                }
            });

 //Rule for each text box with classname passportNo                    
            $('.passportNo').each(function () {
                $(this).rules('add', {
                    required: true,
                    lettersAndNumbers: true,
                    messages: {
                        required: "Please enter Passport Number.",
                        lettersAndNumbers: "Only alphanumeric for passport."
                    }
                });
            });
//Rules for Date
            $('.passIssueDay').each(function () {
                $(this).rules('add', {
                    required: true,                   
                    validateDate: true,
                    MaxDate: true,
                    messages: {
                        required: "Please enter Date",                       
                        validateDate: "Please enter a valid date dd/mm/yyyy.",
                        MaxDate: "Invalid Issue date"
                    }
                });
            });

            $('.passExpDay').each(function () {
                $(this).rules('add', {
                    required: true,
                    validateDate: true,
                    MinDate: true,
                    messages: {
                        required: "Please enter Date",
                        validateDate: "Please enter a valid date dd/mm/yyyy.",
                        MinDate: "Invalid Expiry date"
                    }
                });
            });
//Register methods.
            jQuery.validator.addMethod("lettersAndNumbers", function (value, element) {
                return this.optional(element) || /^[a-zA-Z0-9]*$/i.test(value);
            }, "Please enter alphabets and numbers only.");

            jQuery.validator.addMethod("MinDate",function(value,element){
            try{
            var minDate= new Date()
            var d = Date.parseExact(value, "d/M/yyyy");
            if(d==null){return false;}
            else if(d<minDate){return false;}
            else{return true;}
            }
            catch(e){return fals;}           
            },"Date Shoule be greater than current date"); 

             jQuery.validator.addMethod("MaxDate",function(value,element){
            try{
            var maxDate= new Date()
            var d = Date.parseExact(value, "d/M/yyyy");
            if(d==null){return false;}
            else if(d>maxDate){return false;}
            else{return true;}
            }
            catch(e){return fals;}           
            },"Date Shoule be less than current date");

            jQuery.validator.addMethod("validateDate", function (value, element) {
                try {
                    var d = Date.parseExact(value, "d/M/yyyy");
                    if (d == null) {
                        return false;
                    } else {
                        return true;
                    }
                }
                catch (e) {
                    return false;
                }
            }, "Please enter a valid UK date dd/mm/yyyy");

Read runtime generated controls using classname with JQuery

 $('.ClassName').live('click', function (e) {
        e.preventDefault();
        //  blockScreen(this.id);
        var indexid = this.id.split('-');
        var name = this.name;
         $('ID').html("<image style=' margin-top:35px; padding-bottom:40px' src='images/loaderNew.gif' alt='Loading' ></image>");
        $.ajax({
            type: "POST",
            url: "ABC.aspx",
            data: { cIndex: indexid[1], Details: details },
            success: ShowPopup,
            error: function (XMLHttpRequest, textStatus, errorThrown) {
                //error message
            }
        });
    });

function ShowBookNowPopup(resp) {
        $(blockId).html(resp);
        $(blockId).show();

    }

Load result on scroll using jquery.

JAVASCRIPT : 

var sIndex = 10, offSet = <%=offSet %>, isPreviousEventComplete = true, isDataAvailable = true;
$(document).scroll(function () {
        if ($(document).height() - 50 <= $(window).scrollTop() + $(window).height()) {
            $('#loadMsg').hide();
            if (isPreviousEventComplete && isDataAvailable) {
                isPreviousEventComplete = false;
                $('#loadMsg').show();              
                $.ajax({
                    type: "GET",
                    url: 'ResultAjax.aspx?startIndex=' + sIndex + '&offset=' + offSet + '',
                    success: function (result) {
                        $("#result").append(result);
                        $('#loadMsg').hide();
                        sIndex = sIndex + offSet;
                        showFltrdResult();
                        isPreviousEventComplete = true;

                        if (result == '') { //When data is not available
                            isDataAvailable = false;
                            $('#loadMsg').hide();
                        }
                    },
                    error: function (error) {
                        $('#loadMsg').hide();
                        alert(error);
                    }
                });

            }
        }
    });  

Write required html in ResultAjax.aspx page.

Upload File without using server control in asp.net

.Aspx Page or .master Page

 <form action="Default.aspx" method="post" enctype="multipart/form-data">
    <input type="file" name="UploadedFile" />
    <input type="submit" value="OK" />
  </form>

Default.aspx.cs Page

protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.Files["UploadedFile"] != null)
        {
            HttpPostedFile MyFile = Request.Files["UploadedFile"];
            //Setting location to upload files
            string TargetLocation = Server.MapPath("~/Files/");
            try
            {
                if (MyFile.ContentLength > 0)
                {
                    //Determining file name. You can format it as you wish.
                    string FileName = Path.GetFileName(MyFile.FileName);
                    //Determining file size.
                    //int FileSize = Dosya.ContentLength;
                    //Creating a byte array corresponding to file size.
                    //byte[] FileByteArray = new byte[FileSize];
                    //Posted file is being pushed into byte array.
                   // MyFile.InputStream.Read(FileByteArray, 0, FileSize);
                    //Uploading properly formatted file to server.
                    MyFile.SaveAs(TargetLocation + FileName);
                    }
            }
            catch (Exception BlueScreen)
            {
                //Handle errors
            }
        }

Read XML Using SQL

Select  1 as number,transactionid,AgencyId  as AgencyId,ResponseXML,
'asdfadf asdfsdf asdf sdf asfasdfasd asdfasd sdfasfas sdfasfasf asdfasdfasd asdfasf' as error,
ROW_NUMBER() over(order by transactionid) AS Row
into #temp 
from wsaudit
where wseventtype = 10 and producttypeid = 1 and  createdon between '2014-01-02' and '2014-01-03'
and transactionid is not null and transactionid <> '' and status=0
declare @Error varchar(100)
DECLARE @Names VARCHAR(max)  
Declare @hotels XML 
declare @max int
declare @count int
select @max = max(Row) from #temp
set @count=1;
if @max is not null and @max>0
BEGIN
     while @count < =@max
         begin
          select @Names=ResponseXML from #temp where Row=@count          
   if @Names is not null
    begin
set @Names = '<newData>' + @Names  +'</newData>' 
set @hotels = @Names
DECLARE @docHandle1 int 
EXEC sp_xml_preparedocument @docHandle1 OUTPUT, @hotels
select  @Error=Error
FROM OPENXML (@docHandle1,'/newData/ResponseDetails',2) 
with 
(Error varchar(100) './ErrorMessage'  
)        
if @Error is not null
begin
    update #temp set error= @Error where row=@count
end          
  end
set @count=@count+1;
      end
end
select * from #temp
drop table #temp


-----------------------------------------------------------------------------

<EncryptedResponseDetails>
<mtrixID>4OWUfYETzsRsRre2A9OcXw==</mtrixID>
<status>3ALh/V  Zoy46548c8BSlw==</status>
<ErrorMessage>UxqyxjlVomSZljJJGwYHHbRCw OC6 swGCt2qdoS3q0tNU5W5n5SHtNc/DNStVGu</ErrorMessage>
<TransactionId>X8YAxOxAh6HhdCite7ySCg==</TransactionId>
<paidamt>0Ad9/RiDxHh4K9ELPD5x/Q==</paidamt>
</EncryptedResponseDetails>
<ResponseDetails>
<mtrixID>1109944</mtrixID>
<status>1</status>
<ErrorMessage>Transaction failed due to mtrxid is duplicate</ErrorMessage>
<TransactionId>0</TransactionId>
<paidamt>9825</paidamt>
</ResponseDetails>