Skip to content

Monthly Archives: September 2013

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 = […]

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 { […]

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 […]

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 […]

C# – Read, Insert, Update, Delete From SQL Database

static void Read() { try { string connectionString = “server=.;” + “initial catalog=employee;” + “user id=sa;” + “password=sa123”; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = […]