Both get data from server using HTTP request. But $.Ajax has more control and $.get is a shorthand of $.Ajax.So if you simply want to do simple stuff use $.get.
$.Ajax
jQuery.ajax({
url: ‘test.txt’,
dataType: ‘text’,
type: “GET”,
success: function(data) {
console.log(data);
}
});
$.get
jQuery.get(‘test.txt’,function(data){
console.log(data)
},’text’);
There is no onclick event in jquery but there is .on eventinterviewer asks sometime
.click(handler): Bind an event handler to the “click” JavaScript event, or trigger that event on an element.
.on( events [, selector ] [, data ], handler ) : Attach an event handler function for one or more events to the selected element. they can process events from descendant elements that are added to the document at a later time.
So if you are adding an element on page dynamically and want to fire an event use .on .
This is one of common interview question,well we can find our answer using below Methods…
Method 1 : Using cte as below supoose we need 3rd highest salary
WITH CTE AS ( SELECT Salary, RNo = DENSE_RANK() OVER (ORDER BY Salary DESC) FROM dbo.Employee ) SELECT Salary FROM CTE WHERE RNo = 3
Method 2 : Using SubQuery finfing nth salary here (n-1 will be 2)
SELECT distinct Salary FROM Empoyee e1 where (n-1) = (SELECT count(distinct salary) from Employee e2 WHERE e1.salary <= e2.salary);
Method 3 :
SELECT TOP 1 Salary FROM (SELECT DISTINCT TOP 3 Salary FROM Employee ORDER BY Salary DESC ) AS temp ORDER BY Salary
In most of the interviews this question is asked,we have many ways to find the nth highest salary.
Suppose we have below data. And finding 3rd highest salary
Salary 90000 80000 60000 60000
Method 1 :
Select Top 1 salary from
(
Select distinct top 3 salary from employee
order by salary desc
) Result
order by salary
Output : 60000
Method 2 :
With result as
(
Select salary,dense_rank() over (order by salary desc) drank from employee
)
Select salary from result
Where result.drank=3
Output : 6000
Method 3 :
SELECT *
FROM Employee Emp1
WHERE (N-1) = (
SELECT COUNT(DISTINCT(Emp2.Salary))
FROM Employee Emp2
WHERE Emp2.Salary > Emp1.Salary
)
public static MemoryStream ConvertPDFtoMemoryStream(string pdfUrl)
{
MemoryStream pdfMemoryStream;
WebClient client = new WebClient();
try
{
pdfMemoryStream =
new MemoryStream(client.DownloadData(HttpUtility.UrlDecode(pdfUrl)));
}
finally
{
client.Dispose();
}
return pdfMemoryStream;
}
When you publish your code in release mode on Server and you want to print a line number.You have to follow following steps to achieve this
Step-1 Right click You Project > Property > Package/Publish Web> Uncheck Exclude generated Debug Symbol
Step-2
Save and publish you code You will see PDB file will be generated over there which will track you published code Error.
$(“form”).submit(function () {
// do your stuff here
});
Pass value in Your Partial view as below
@Html.Partial(“~/PathToYourView.cshtml”, null, new ViewDataDictionary { { “VariableName”, “some value” } })
Retrieve the passed in values inside partial view:
@{ string valuePassedIn = this.ViewData.ContainsKey(“VariableName”) ? this.ViewData[“VariableName”].ToString() : string.Empty; }
If you are getting ERROR as below
Solution :
Start the World Wide Web Publishing Service
Click Start, click Run, type services.msc, and then click OK.
In Services, locate the World Wide Web Publishing Service service in the details pane.
Right-click the service, and then click Start.
Hopefully it will work.
Dot Net Tricks 