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

Pagination in DatGridView C# from sql.

public void FillDataGridView1(string search,int page) { txtPage.Text = (page+1).ToString(); txtInfo.Text = (page+1).ToString() + " of " +((numberOfSubscriber()/1000)+1).ToString(); search = "%"+search+"%"; string query = @"SELECT Top 1000 * FROM Table where [TableID] like '" + search + "'and [ID] NOT IN (SELECT TOP "+page*1000+" id FROM [Table])"; try {...
Continue reading


Join 901 other subscribers