For and Foreach Statement Difference

string[] n = { "a", "b","c" };
foreach (string c in n)
{
string k = c;
}
for (int i = 0; i < n.Length; ++i)
{
string b = n[i];
}

To Store and Retrieval Image in Windows Application

****************************************************************
Upload the Image in SqlServer2005

SqlConnection con = new SqlConnection("server=vivek\\server2005;initial catalog=TESTIMAGE;integrated security=true");
con.Open();
SqlCommand cmd = new SqlCommand("IMG_INSERT", con);
cmd.Parameters.AddWithValue("@id", textBox2.Text);
//////////////////////
MemoryStream stream = new MemoryStream();
pictureBox1.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] pic = stream.ToArray();
cmd.Parameters.AddWithValue("@img", pic);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
MessageBox.Show("Sucessfully Saved");


*************************************************************************
Download and Display in to Picture using Timer

//Global Declaration

private string s = ConfigurationSettings.AppSettings["conn"];
DataSet ds = new DataSet();
static int cnt = 0;

//Form Load Coding

private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(s);
con.Open();
SqlDataAdapter ada = new SqlDataAdapter("SELECT studid,PHOTO FROM studentregistration", con);
ada.Fill(ds);
}

//Timer Coding


private void timer1_Tick(object sender, EventArgs e)
{
Bitmap map ;
if (cnt < ds.Tables[0].Rows.Count)
{
byte[] bytes = (byte[])ds.Tables[0].Rows[cnt][1];
MemoryStream mem = new MemoryStream(bytes);
map = new Bitmap(mem);
pictureBox1.Image = map;
cnt += 1;

}
else
{
cnt = 0;
}
}

To add controls dynamically in Web Application

Steps:

i)To add ContentHolder control in Webpage

ii) Create an object for Label

Label l = new Label();
l.Text="Hai"

iii) PlaceHolder1.Controls.Add(l);

To Load All Country Names in DropDownList

private void PopulateCountryName(DropDownList dropDown)
{
Dictionary<string, string> objDic = new Dictionary<string, string>();

foreach (CultureInfo ObjCultureInfo in CultureInfo.GetCultures(CultureTypes.SpecificCultures))
{

RegionInfo objRegionInfo = new RegionInfo(ObjCultureInfo.Name);

if (!objDic.ContainsKey(objRegionInfo.EnglishName))
{
objDic.Add(objRegionInfo.EnglishName, objRegionInfo.TwoLetterISORegionName.ToLower());
}
}
List<KeyValuePair<string, string>> myList = new List<KeyValuePair<string, string>>(objDic);
myList.Sort(

delegate(KeyValuePair<string, string> firstPair,

KeyValuePair<string, string> nextPair)
{
return firstPair.Value.CompareTo(nextPair.Value);
}
);
foreach (KeyValuePair<string, string> val in myList)
{
dropDown.Items.Add(new ListItem(val.Key, val.Value));
}
}

SQL Queries

*****************************************************************

To Set column values as empty which contains zeros

SELECT (case when quantity = 0 then '' else quantity end) AS 'quantity'
FROM stock

Abstract Class And Interface

Main Program:

namespace abstractandinterface
{
class Program
{
static void Main(string[] args)
{
////////////////////////////////////////////abstract class inheritance
abstractclass inheritabstract;
inheritabstract = new inheritabstractclass();
string rd = Convert.ToString(Console.ReadLine());
Console.WriteLine("\n");
inheritabstract.Custid = rd;
rd = inheritabstract.commondetails();
Console.WriteLine("Abstract Output\n");
Console.WriteLine(rd);
Console.WriteLine("\n");
Console.Read();

///////////////////////////////////////interface implementation
interfaceclass inheritinterface;
implementinheritance implement = new implementinheritance();
inheritinterface = (interfaceclass)implement;
string rd1 = Convert.ToString(Console.ReadLine());
Console.WriteLine("\n");
implement.custname = rd1;
Console.WriteLine("Interface Ouptput\n");
Console.WriteLine(rd1);
Console.WriteLine("\n");
Console.Read();
}
}
}

Abstract Class:

namespace abstractandinterface
{
abstract class abstractclass
{
string custid;

public string Custid
{
get { return custid; }
set { custid = value; }
}
static string custname;
public static string Custname
{
get { return abstractclass.custname; }
set { abstractclass.custname = value; }
}
public string commondetails( )
{
return custid;

}
public abstract string account();
}
}


Interface Class

namespace abstractandinterface
{
interface interfaceclass
{
string account();
}
}


Inherit Abstract Class


namespace abstractandinterface
{
class inheritabstractclass:abstractclass
{
public override string account()
{
return "";

}
}
}


Implement Interface


namespace abstractandinterface
{
class implementinheritance:interfaceclass
{
static string custid;

public static string Custid
{
get { return implementinheritance.custid; }
set { implementinheritance.custid = value; }
}

public string custname;

private string Custname
{
get { return custname; }
set { custname = value; }
}
private string custaddress;

public string Custaddress
{
get { return custaddress; }
set { custaddress = value; }
}

#region interfaceclass Members

public string account()
{
return custid;
}

#endregion
}
}

javascript for validation

function FilterNumberInput()
{

if(57<48) returnvalue="false;" keycode="=" returnvalue =" true;"><97)><65) returnvalue =" false;" keycode="=" keycode="=" keycode="=" returnvalue =" true;" keycode ="=" returnvalue =" false;" emailpat="/^(.+)@(.+)$/" specialchars="">@,;:\\\\\\\"\\.\\[\\]"
var validChars="\[^\\s" + specialChars + "\]"
var quotedUser="(\"[^\"]*\")"
var ipDomainPat=/^\[(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})\]$/
var atom=validChars + '+'
var word="(" + atom + "|" + quotedUser + ")"
var userPat=new RegExp("^" + word + "(\\." + word + ")*$")
var domainPat=new RegExp("^" + atom + "(\\." + atom +")*$")
var matchArray=emailStr.match(emailPat)
if (matchArray==null)
{
alert("Your Email Address must be valid!")
return false
}
var user=matchArray[1]
var domain=matchArray[2]
if (user.match(userPat)==null)
{
alert("Your Email Address must be valid!")
return false;
}

var IPArray=domain.match(ipDomainPat)
if (IPArray!=null)
{
for (var i=1;i<=4;i++) { if (IPArray[i]>255)
{
alert("Your Email Address must be valid!")
return false
}
}
return true
}
var domainArray=domain.match(domainPat)
if (domainArray==null)
{
alert("Your Email Address must be valid!")

return false
}
var atomPat=new RegExp(atom,"g")
var domArr=domain.match(atomPat)
var len=domArr.length
if (domArr[domArr.length-1].length<2>3)
{
alert("The Email Address must end in a three-letter domain, or two letter country.")
return false
}
if (len<2) regexp =" /(ftp|http|https):\/\/(\w+:{0,1}\w*@)?(\S+)(:[0-9]+)?(\/|\/([\w#!:.?+=" retvalue =" inputString;" ch =" retValue.substring(0," ch ="=" retvalue =" retValue.substring(1," ch =" retValue.substring(0," ch =" retValue.substring(retValue.length-1," ch ="=" retvalue =" retValue.substring(0," ch =" retValue.substring(retValue.length-1," retvalue =" retValue.substring(0," ndecimal =" 0;" xtxt="textValue.value;" xtxt =" document.getElementById(" txtlen=" xTxt.length;" i =" 0;" x =" xTxt.substr(i," x ="=" ndecimal =" nDecimal"> 1)
{
alert("You have entered more than one decimal point!\nPlease only enter one!");
textValue.value="";
textValue.focus();
return false;
}
}
}

function IgnoreDecimal(textValue)

{
var nDecimal = 0;
var i;
var x;
var xTxt=textValue.value;
//var xTxt = document.getElementById("ctl00_ContentPlaceHolder1_txtBasicDuty").value;
var txtLen= xTxt.length;
for(i = 0; i < x =" xTxt.substr(i," x ="=" ndecimal =" nDecimal"> 0)
{
alert("You have entered decimal point!\nPlease ignore decimal point!");
textValue.value="";
textValue.focus();
return false;
}
}
}

CreditCard validation
---------------------------

public bool IsCreditCardValid(string cardNumber)
{
const string allowed = "0123456789";
int i;

StringBuilder cleanNumber = new StringBuilder();
for (i = 0; i <>= 0)
      cleanNumber.Append(cardNumber.Substring(i, 1));
}
if (cleanNumber.Length <> 16)
   return false;

for (i = cleanNumber.Length + 1; i <= 16; i++)      cleanNumber.Insert(0, "0");    int multiplier, digit, sum, total = 0;   string number = cleanNumber.ToString();    for (i = 1; i <= 16; i++)   {      multiplier = 1 + (i % 2);      digit = int.Parse(number.Substring(i - 1, 1));      sum = digit * multiplier;      if (sum > 9)
      sum -= 9;
   total += sum;
}
return (total % 10 == 0);
}

--------------
public static bool IsDate(string strdt)
      {
          try
          {
              if (strdt.Trim() != "")
              {
                  DateTime dt = Convert.ToDateTime(strdt);
              }
              return true;
          }
          catch
          {
              return false;
          }
      }


public static bool IsNumeric(string numberString)
      {
          try
          {
              if (numberString.Trim() != "")
              {
                  double num = Convert.ToDouble(numberString);
              }
              return true;
          }
          catch
          {
              return false;
          }
      }