Download Image from URL

public System.Drawing.Image DownloadImageFromUrl(string imageUrl)
{
System.Drawing.Image image = null;
try
{
System.Net.HttpWebRequest webRequest = (System.Net.HttpWebRequest)System.Net.HttpWebRequest.Create(imageUrl);
webRequest.AllowWriteStreamBuffering = true;
webRequest.Timeout = 30000;
System.Net.WebResponse webResponse = webRequest.GetResponse();
System.IO.Stream stream = webResponse.GetResponseStream();
image = System.Drawing.Image.FromStream(stream);
webResponse.Close();
}
catch (Exception ex)
{
return null;
}
return image;
}




protected void btnSave_Click(object sender, EventArgs e)
{
System.Drawing.Image image = DownloadImageFromUrl(txtUrl.Text.Trim());
string rootPath = @"C:\DownloadedImageFromUrl";
string fileName = System.IO.Path.Combine(rootPath, "test.gif");
image.Save(fileName);
}

Shutdown, Restart and LogOff windows using C#

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Runtime.InteropServices;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e) { }
[DllImport("user32.dll")]
public static extern int ExitEx(int operationFlag, int operationReason);
protected void btnRestart_Click(object sender, EventArgs e)
{ ExitEx(2, 0); }
protected void btnLogOff_Click(object sender, EventArgs e)
{ ExitWindowsEx(0, 0); }
protected void btnShutDown_Click(object sender, EventArgs e)
{ ExitEx(1, 0); }
}

Mobile Number Validation Javascript

function ValidateMobileNumber()
{
var InputText = document.getElementById('TextBox1').value;
var Expression = /^[0-9]{10}$/
if (InputText.search(Expression) == -1)
{
alert("Invalid Mobile Number. Must Contain Exactly 10 Numbers");
return false;
}
}

Working program that uses SqlParameter objects

using System;
using System.Data;
using System.Data.SqlClient;

class ParamDemo
{
static void Main()
{
// conn and reader declared outside try
// block for visibility in finally block
SqlConnection conn = null;
SqlDataReader reader = null;

string inputCity = "London";
try
{
// instantiate and open connection
conn = new
SqlConnection("Server=(local);DataBase=Northwind;Integrated Security=SSPI");
conn.Open();

// don't ever do this!
// SqlCommand cmd = new SqlCommand(
// "select * from Customers where city = '" + inputCity + "'";

// 1. declare command object with parameter
SqlCommand cmd = new SqlCommand(
"select * from Customers where city = @City", conn);

// 2. define parameters used in command object
SqlParameter param = new SqlParameter();
param.ParameterName = "@City";
param.Value = inputCity;

// 3. add new parameter to command object
cmd.Parameters.Add(param);

// get data stream
reader = cmd.ExecuteReader();

// write each record
while(reader.Read())
{
Console.WriteLine("{0}, {1}",
reader["CompanyName"],
reader["ContactName"]);
}
}
finally
{
// close reader
if (reader != null)
{
reader.Close();
}

// close connection
if (conn != null)
{
conn.Close();
}
}
}
}
The code simply retrieves records for each customer that lives in London

Rememberme in Login Control

protected void Page_init(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.Cookies["UserCookie"] != null)
{
HttpCookie cookie = Request.Cookies.Get("UserCookie");
Login1.UserName = cookie.Values["username"];
TextBox txtPassword = Login1.FindControl("Password") as TextBox;
txtPassword.Attributes.Add("value", Request.Cookies["UserCookie"]["Password"]);
CheckBox checkMe = (CheckBox)Login1.FindControl("RememberMe");
checkMe.Checked = true;
}
TextBox txtUser = Login1.FindControl("UserName") as TextBox;
if (txtUser != null)
this.SetFocus(txtUser);
}
}

protected void Login1_Authenticate(object sender, System.Web.UI.WebControls.AuthenticateEventArgs e)
{
//your login code
//if login is sucess
HttpCookie UserCookie = new HttpCookie("UserCookie ");
Boolean remember = Login1.RememberMeSet;

if (remember)
{
Int32 persistTime = 5;
UserCookie .Values.Add("username", Login1.UserName);
UserCookie .Values.Add("password", Login1.Password);
UserCookie .Expires = DateTime.Now.AddYears(persistTime);
}
else
{
UserCookie .Values.Add("username", string.Empty);
UserCookie .Values.Add("password", string.Empty);
UserCookie .Expires = DateTime.Now.AddMinutes(1);
}
Response.Cookies.Add(UserCookie );
}

Return last date of the current month using sql

SELECT datepart(dd,DateAdd(day, -1, DateAdd(month, DateDiff(month, 0, getdate())+1, 0))) AS Dateval