Host mongodb in Cloud for free

There are several hosting provider capable of host mongodb database. I like mongolab.com and is very nice ,free and Fully managed. It give 500MB Space for free. Web-based admin tools. Management of any cloud MongoDB. DB to API 🙂 which i like most.For detail about mongo data to...
Continue reading

Overload Webservice.

TO workout the error when we overload the [WebMethod] like the following you must change webservice code as follows However, we may also get errors if which is the auto generated while adding webservice in visual studio So we need to remove or comment the above line
Continue reading

Use Session Enabled Webservice in WindowsForm.

public class MyService : System.Web.Services.WebService { [WebMethod(EnableSession=true)] public void setMethod(bool value) { Session["myBoolVariable"] = value; } [WebMethod(EnableSession=true)] public bool getMethod() { return (bool)Session["myBoolVariable"]; } }   In above Webservice Session is used but in windows form application there is no any logic to use session so detect session...
Continue reading

Using Background worker in c#

private void InitTimer3() { tmrBack = new System.Windows.Forms.Timer(); tmrBack.Tick += new EventHandler(tmrBack_Tick); tmrBack.Interval = 1000; // in miliseconds tmrBack.Start(); } private void tmrBack_Tick(object sender, EventArgs e) { BackgroundWorker bw2 = new BackgroundWorker(); bw2.DoWork += new DoWorkEventHandler(bw2_DoWork); bw2.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bw2_RunWorkerCompleted); if (bw2.IsBusy != true) { bw2.RunWorkerAsync(); } }...
Continue reading

Checking website is online or offline in c#

public bool WebSiteIsAvailable(string Url) { string Message = string.Empty; HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(Url); // Set the credentials to the current user account request.Credentials = System.Net.CredentialCache.DefaultCredentials; request.Method = "GET"; try { using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { return true;// Do nothing; we're only testing to see if we can...
Continue reading

MS SQL server Function to read response from Http

CREATE FUNCTION [dbo].[GetHttp] (@url VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN DECLARE @win INT DECLARE @hr INT DECLARE @text VARCHAR(8000) EXEC @hr = sp_OACreate 'WinHttp.WinHttpRequest.5.1' ,@win OUT IF @hr 0 EXEC sp_OAGetErrorInfo @win EXEC @hr = sp_OAMethod @win ,'Open' ,NULL ,'GET' ,@url ,'false' IF @hr 0 EXEC sp_OAGetErrorInfo @win EXEC...
Continue reading