. Net jobs

   private KDLModel.RateShop Rate(RateShopLoadML rateShop)         {             KDLModel.RateShop rate = new KDLModel.RateShop();             Uri InitUrl = new Uri("https://webservices.averittexpress.com/LTLRateQuoteService");             System.Xml.XmlNodeList xmlList = null;             RateShop.RateShopBAL rateShopBAL = new RateShop.RateShopBAL();             try             {                 CarrierUserML carrierUser = new RateShop.RateShopBAL().GetIndividualUserByCarrier(rateShop.CarrierId, rateShop.userCarriers); // Carrier Markup                 #region Authentication                 CarrierUserML cUser = new CarrierUserML();     ...

Get data of Restful Service (URL)    public List TrackByPRONumber(string PRONumber)         {             string URL = "http://works.pittohio.com/mypittohio/pbetrace2.asp?pronumber=";             List list = new List ();             try             {                 WebRequest request = WebRequest.Create(URL + PRONumber + "&all=yes");                 HttpWebResponse response = (HttpWebResponse)request.GetResponse();                 Stream dataStream = response.GetResponseStream();                 StreamReader reader = new StreamReader(dataStream);                 var pittOhioTrackResponse = XDocument.Parse(reader.Read...

You should have schema of request like below   private string CreateXMLRequestGetAvailableImages(string ProNumber)         {             string XMLRequest = string.Empty;             XMLRequest = @"                                                 xmlns:xsd=""http://www.w3.org/2001/XMLSchema""                                 xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"">                                             Progressp                         Edward42                 ...

http://stackoverflow.com/questions/8517071/send-json-data-via-post-ajax-and-receive-json-response-from-controller-mvc

 public String ReplaceWholeWord(String s, String word, String bywhat)         {             char firstLetter = word[0];             StringBuilder sb = new StringBuilder();             bool previousWasLetterOrDigit = false;             int i = 0;             s = s + " ";             while (i < s.Length - word.Length + 1)             {                 char ch = '~';                 if (!string.IsNullOrEmpty(Convert.ToStr...

--EXEC [SearchProcedure] '835_FinancialInformation' --EXEC sp_depends [835_FinancialInformation] DECLARE @SearchStr NvarChar(100) SELECT @SearchStr = 'Missing/incomplete/invalid upgrade' CREATE TABLE #Results ( ColumnName nvarchar(370),ColumnValue nvarchar(3630) ) SET NOCOUNT ON DECLARE @TableName NvarChar(256), @ColumnName NvarChar(128),@SearchStr2 NvarChar(110) SET @TableName = '' SET @SearchStr2 = QuoteName('%' + @SearchStr + '%','''') WHILE @TableName Is Not Null BEGIN SET @ColumnName = '' SET @TableName = ( SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName AND OBJECTPROPERTY( OBJECT_ID( QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) ), 'IsMSShipped' ...

---------Using Sub Query 3rd Highest Salary All Employees--------- SELECT * FROM Emp WHERE Salary IN( SELECT TOP 1   salary FROM ( SELECT TOP 3 salary FROM Emp e ORDER BY Salary DESC ) a ORDER BY a.Salary ) ------------------- 3rd highest salary----------- -----3rd Hightest salary---------- DECLARE @n INT=3 SELECT DISTINCT(Salary) from emp e1 where @n=( SELECT COUNT(DISTINCT(salary))  from emp e2 where  e2.salary>=e1.salary ) --------------3rd Highest Salary-----------  ;WITH cte AS  (      SELECT Id,Name,e.Salary, DENSE_RANK() OVER (PARTITION BY e.Salary ORDER BY e.Salary) AS sal      FROM Emp e  )  SELECT *  FROM cte WHERE sal=2 ----------------------- DECLARE @N int SET @N = 3  -- Change the value here to pick a different salary rank SELECT Salary FROM (     SELECT row_number() OVER (ORDER BY Salary DESC) as SalaryRank, Salary     FROM Emp e ) as SalaryCTE WHERE...