RRB ALP Syllabus 2018

NCVT MIS Result 2017 NCVT MIS ITI Results 2017, Semester 1st, 2nd, 3rd and 4th marks available  At ncvtmis.gov.in:

NCVT MIS Sem Wise Result 2017: National Council for Vocational Training has arranged examinations. They have issued NCVT MIS ITI Results 2017. So those who have registered and appeared in examinations they will able to check results or mark sheet of ITI Trade Semester Exam 2016 Results. Get rrb alp syllabus 2018 Every year lot's of student are waiting for this results but now all wait is over as higher authority have updated exam results details here. ncvtmis.gov.in is web portal where you can check all vital details about it.

Grid,Comboe Bind...?

1) How to bind GridVIew ?
protected void Page_Load(object sender, EventArgs e)
{
BindUttarDetail();
}
private void BindUttarDetail()
{
gvUttaraDetail.DataSource = Emp.FillUttaraDetail();
gvUttaraDetail.DataBind();
}
protected void lbtnEdit_Click(object sender, EventArgs e)
{

}

2) Row DataBound Event
protected void gvUttaraDetail_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lbl = (Label)e.Row.FindControl("lblDate");
DateTime dt = Convert.ToDateTime(lbl.Text);
lbl.Text = "AMit";
}
}

3)Bind Combo

public void BindMillCombo()
{
ddlMill.DataTextField = "MName";
ddlMill.DataValueField = "MID";
ddlMill.DataSource = Emp.FillCombo();
ddlMill.DataBind();
}

4) Connection String in Web.Config



providerName="System.Data.SqlClient" />



5) Delete Command or Edit Command

protected void lbtnDelete_Click(object sender, EventArgs e)
{
LinkButton lbtn = (LinkButton)sender;
int Eid = Int32.Parse(lbtn.CommandArgument.ToString());
Emp.Delete(Eid, "Emp_Master", "Eid");
MultiView1.ActiveViewIndex = 1;
GridBind();
}

6) Grid Row Deleting Event

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = GridView1.DataKeys[e.RowIndex].Values["EId"].ToString();
Response.Write(id);
}

7) Grid View in aspx side

ForeColor="#333333" GridLines="None" Width="100%">

Jounral CS Class

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

///

/// Summary description for Employees
///

public class Emp
{
public Emp()
{
//
// TODO: Add constructor logic here
//
}
public static int Employee_Insert(string Fname, string Lname, string Mname, string Mobile, int EType, int Salary)
{
string SQL = "Employee_Insert";
SqlParameter[] par = new SqlParameter[7];
par[0] = new SqlParameter("@Fname", Fname);
par[1] = new SqlParameter("@Lname", Lname);
par[2] = new SqlParameter("@Mname", Mname);
par[3] = new SqlParameter("@Mobile", Mobile);
par[4] = new SqlParameter("@EType", EType);
par[5] = new SqlParameter("@Salary", Salary);
par[6] = new SqlParameter("@IsActive", "1");
return SQLHelper.excute(SQL, par);
}
public static int Salary_Insert(int EID, int Day, int Month, int Year, int Present, double OT, DateTime date)
{
string SQL = "Salary_Insert";
SqlParameter[] par = new SqlParameter[8];
par[0] = new SqlParameter("@EID", EID);
par[1] = new SqlParameter("@Day", Day);
par[2] = new SqlParameter("@Month", Month);
par[3] = new SqlParameter("@Year", Year);
par[4] = new SqlParameter("@Present", Present);
par[5] = new SqlParameter("@date", date);
par[6] = new SqlParameter("@OT", OT);
par[7] = new SqlParameter("@IsActive", "1");
return SQLHelper.excute(SQL, par);
}
public static int Uppad_Insert(int EID, int Day, int Month, int Year, DateTime date, int Rs)
{
string SQL = "Uppad_Insert";
SqlParameter[] par = new SqlParameter[7];
par[0] = new SqlParameter("@EID", EID);
par[1] = new SqlParameter("@Day", Day);
par[2] = new SqlParameter("@Month", Month);
par[3] = new SqlParameter("@Year", Year);
par[4] = new SqlParameter("@Date", date);
par[5] = new SqlParameter("@Rs", Rs);
par[6] = new SqlParameter("@Type", "1");
return SQLHelper.excute(SQL, par);
}
public static int Loan_Insert(int EID, int Day, int Month, int Year, DateTime date, int Rs)
{
string SQL = "Loan_Insert";
SqlParameter[] par = new SqlParameter[7];
par[0] = new SqlParameter("@EID", EID);
par[1] = new SqlParameter("@Day", Day);
par[2] = new SqlParameter("@Month", Month);
par[3] = new SqlParameter("@Year", Year);
par[4] = new SqlParameter("@Date", date);
par[5] = new SqlParameter("@Rs", Rs);
par[6] = new SqlParameter("@Type", "2");
return SQLHelper.excute(SQL, par);
}
public static int SalSlip_Insert(string name, int Pday, int ADay,int Loan,double salary,int uppad,int month,int year,float OT,int Tid)
{
string SQL = "SalSlip_Insert";
SqlParameter[] par = new SqlParameter[10];
par[0] = new SqlParameter("@name",name);
par[1] = new SqlParameter("@Pday", Pday);
par[2] = new SqlParameter("@Aday", ADay);
par[3] = new SqlParameter("@Loan", Loan);
par[4] = new SqlParameter("@salary", salary);
par[5] = new SqlParameter("@uppad",uppad);
par[6] = new SqlParameter("@month",month);
par[7] = new SqlParameter("@year", year);
par[8] = new SqlParameter("@OT", OT);
par[9] = new SqlParameter("@Tempid",Tid);
return SQLHelper.excute(SQL, par);
}


public static DataTable FillEmployee()
{
string SQL = "Select * from Emp_Master";
return SQLHelper.GetData(SQL);
}
public static DataTable FillSal()
{
string SQL = "Select * from SalSlip";
return SQLHelper.GetData(SQL);
}
public static DataTable FillSal(int month)
{
string SQL = "Select * from SalSlip where month="+month;
return SQLHelper.GetData(SQL);
}
public static DataTable FillUppdad()
{
string SQL = "SELECT Emp_Master.Fname, SUM(Emp_UppadLoan.Rs) AS Total "+
"FROM Emp_Master INNER JOIN Emp_UppadLoan ON Emp_Master.Eid = Emp_UppadLoan.Eid "+
"GROUP BY Emp_Master.Fname, Emp_UppadLoan.Type HAVING (Emp_UppadLoan.Type = 1)";
return SQLHelper.GetData(SQL);
}
public static DataTable FillLoan()
{
string SQL = "SELECT Emp_Master.Fname , SUM(Emp_UppadLoan.Rs) AS Total " +
"FROM Emp_Master INNER JOIN Emp_UppadLoan ON Emp_Master.Eid = Emp_UppadLoan.Eid " +
"GROUP BY Emp_Master.Fname, Emp_UppadLoan.Type HAVING (Emp_UppadLoan.Type = 2)";
return SQLHelper.GetData(SQL);
}
public static DataTable FillEmployeeWiseUppad(string Ename)
{
//string SQL = "SELECT Emp_UppadLoan.Date, Emp_UppadLoan.Rs FROM Emp_Master INNER JOIN " +
// " Emp_UppadLoan ON Emp_Master.Eid = Emp_UppadLoan.Eid WHERE (Emp_Master.Fname = '"+Ename+"') AND (Emp_UppadLoan.Type = 1) ";
string SQL = "SELECT Emp_UppadLoan.Year, Emp_UppadLoan.Date as Date,Emp_UppadLoan.id ,Emp_UppadLoan.Rs as Rs, Emp_UppadLoan.Month "+
"FROM Emp_Master INNER JOIN Emp_UppadLoan ON Emp_Master.Eid = Emp_UppadLoan.Eid "+
"WHERE (Emp_Master.Fname = '"+Ename+"') AND (Emp_UppadLoan.Type = 1)";
return SQLHelper.GetData(SQL);
}
public static DataTable FillEmployeeWiseLoan(string Ename)
{
//"SELECT Emp_UppadLoan.Date, Emp_UppadLoan.id,Emp_UppadLoan.Rs,Emp_UppadLoan.Month FROM Emp_Master INNER JOIN " +
// " Emp_UppadLoan ON Emp_Master.Eid = Emp_UppadLoan.Eid WHERE (Emp_Master.Fname = '"+Ename+"') AND (Emp_UppadLoan.Type = 2) ";
string SQL = "SELECT Emp_UppadLoan.Year, Emp_UppadLoan.Date as Date,Emp_UppadLoan.id ,Emp_UppadLoan.Rs as Rs, Emp_UppadLoan.Month " +
"FROM Emp_Master INNER JOIN Emp_UppadLoan ON Emp_Master.Eid = Emp_UppadLoan.Eid " +
"WHERE (Emp_Master.Fname = '" + Ename + "') AND (Emp_UppadLoan.Type = 2)";
return SQLHelper.GetData(SQL);
}

public static void Delete(int ID, string Tabel, string Column)
{
string SQL = "Delete from " + Tabel + " where " + Column + " =" + ID;
SQLHelper.ExcuteRecord(SQL);
}
public static DataTable select_update(int Eid)
{
string SQL = "select * from Emp_Master where Eid=" + Eid;
return SQLHelper.selected_update(SQL);
}
public static DataTable GetPresent(int Month)
{
string SQL = "SELECT Salary_Master.Day, Salary_Master.id, Emp_Master.Fname, Salary_Master.Present, Salary_Master.OT " +
"FROM Emp_Master INNER JOIN Salary_Master ON Emp_Master.Eid = Salary_Master.EID " +
"WHERE (Salary_Master.Month ="+Month+") order by Salary_Master.Day";
return SQLHelper.selected_update(SQL);
}
public static DataTable GetPresent_Name(int EID)
{
string SQL = "SELECT Salary_Master.Day, Salary_Master.id, Emp_Master.Fname, Salary_Master.Present, Salary_Master.OT " +
"FROM Emp_Master INNER JOIN Salary_Master ON Emp_Master.Eid = Salary_Master.EID " +
"WHERE (Salary_Master.EID =" + EID + ") order by Salary_Master.Day";
return SQLHelper.selected_update(SQL);
}
public static DataTable GetPresent_year(int Year)
{
string SQL = "SELECT Salary_Master.Day, Salary_Master.id, Emp_Master.Fname, Salary_Master.Present, Salary_Master.OT " +
"FROM Emp_Master INNER JOIN Salary_Master ON Emp_Master.Eid = Salary_Master.EID " +
"WHERE (Salary_Master.Year =" + Year + ") order by Salary_Master.Day";
return SQLHelper.selected_update(SQL);
}
public static DataTable GetPresent_MonthAndYear(int Month,int Year)
{
string SQL = "SELECT Salary_Master.Day, Salary_Master.id, Emp_Master.Fname, Salary_Master.Present, Salary_Master.OT " +
"FROM Emp_Master INNER JOIN Salary_Master ON Emp_Master.Eid = Salary_Master.EID " +
"WHERE (Salary_Master.Month =" + Month + " and Salary_Master.Year =" + Year +") order by Salary_Master.Day ";
return SQLHelper.selected_update(SQL);
}
public static DataTable GetPresent_EmpAndYear(int EID, int Year)
{
string SQL = "SELECT Salary_Master.Day, Salary_Master.id, Emp_Master.Fname, Salary_Master.Present, Salary_Master.OT " +
"FROM Emp_Master INNER JOIN Salary_Master ON Emp_Master.Eid = Salary_Master.EID " +
"WHERE (Salary_Master.Eid =" + EID + " and Salary_Master.Year =" + Year + ") order by Salary_Master.Day ";
return SQLHelper.selected_update(SQL);
}
public static DataTable GetPresent(int Month,int Eid)
{
string SQL = "SELECT Salary_Master.Day, Salary_Master.id, Emp_Master.Fname, Salary_Master.Present, Salary_Master.OT " +
"FROM Emp_Master INNER JOIN Salary_Master ON Emp_Master.Eid = Salary_Master.EID " +
"WHERE (Salary_Master.Month =" + Month + " and Salary_Master.Eid =" + Eid + ") order by Salary_Master.Day ";
return SQLHelper.selected_update(SQL);
}
public static DataTable GetPresent(int Month, int Eid,int Year)
{
string SQL = "SELECT Salary_Master.Day, Salary_Master.id, Emp_Master.Fname, Salary_Master.Present, Salary_Master.OT " +
"FROM Emp_Master INNER JOIN Salary_Master ON Emp_Master.Eid = Salary_Master.EID " +
"WHERE (Salary_Master.Month =" + Month + " and Salary_Master.Year ="+Year+" and Salary_Master.Eid =" + Eid + ") order by Salary_Master.Day ";
return SQLHelper.selected_update(SQL);
}
public static void Emp_Update(int Eid, string Fname, string Lname, string Mname, string Mobile, int EType, int Salary)
{
string SQL = "Update Emp_Master SET Fname='" + Fname + "',Lname='" + Lname + "',Mname='" + Mname + "',Mobile='" + Mobile + "',EType='" + EType + "',Salary='" + Salary + "' where Eid=" + Eid;
SQLHelper.ExcuteRecord(SQL);
}
public static void Present_Update(int id, double ot,int present)
{
string SQL = "Update Salary_Master SET ot="+ot+ ",Present="+present+ " where id="+id;
SQLHelper.ExcuteRecord(SQL);
}

public static void Uppad_Update(int id,int Rs)
{
string SQL = "Update Emp_UppadLoan SET Rs="+Rs+ " where id=" +id;
SQLHelper.ExcuteRecord(SQL);
}
public static void Insert_Day(string Day)
{
string SQL = "Update Days Set HoliDay='"+Day+"' where id=1";
SQLHelper.ExcuteRecord(SQL);
}
public static DataTable FillCombo()
{
string SQL = "select Eid,Fname from Emp_Master";
return SQLHelper.GetData(SQL);
}
public static DataTable GetSalary(int Month)
{
string SQL = "SELECT Emp_Master.Fname, SUM(Salary_Master.Present) AS Present, SUM(Salary_Master.OT) AS OT, " +
" Salary_Master.EID FROM Emp_Master INNER JOIN Salary_Master ON Emp_Master.Eid = Salary_Master.EID AND Salary_Master.Month = "+Month+" " +
"GROUP BY Emp_Master.Fname, Salary_Master.EID";
return SQLHelper.GetData(SQL);
}
}

SqlHelper Class

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

///

/// Summary description for SQLHelper
///

public class SQLHelper
{
SqlConnection conn;
DataTable t;
DataSet ds = new DataSet();
DataSet DsMain = new DataSet();
public SQLHelper()
{
//
// TODO: Add constructor logic here
//
}
#region // Connection string
public static string Connect
{
get { return ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString; }
}
#endregion

#region // Excute Insert Command
public static int excute(string sql,SqlParameter[] par)
{
SqlConnection conn = new SqlConnection(SQLHelper.Connect);
SqlCommand cmd = new SqlCommand(sql);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < par.Length; i++)
{
// if (par[i] != null)
{
cmd.Parameters.Add(par[i]);
}
}
conn.Open();
int affected = cmd.ExecuteNonQuery();
conn.Close();
cmd.Dispose();
return affected;
}
#endregion

#region // Fetch The Data
public static DataTable GetData(string sql)
{
SqlDataAdapter adpt = new SqlDataAdapter(sql, SQLHelper.Connect);
DataTable dt = new DataTable();
adpt.Fill(dt);
return dt;
}
#endregion

public static string ExcuteScaler(string sql)
{
SqlConnection conn = new SqlConnection(SQLHelper.Connect);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
try
{
string dy = (string)cmd.ExecuteScalar();
return dy;
}
catch
{
return "";
}
conn.Close();
}

#region // Count no of Records
public static int CountData(string sql)
{
SqlConnection conn = new SqlConnection(SQLHelper.Connect);
SqlCommand cmd = new SqlCommand(sql,conn);
conn.Open();
int count = (int)cmd.ExecuteScalar();
conn.Close();
return count;
}
#endregion

#region // Excute Query For Delete Update
public static void ExcuteRecord(string sql)
{
SqlConnection conn = new SqlConnection(SQLHelper.Connect);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
#endregion

public static int AffectedRows(string sql)
{
SqlConnection conn = new SqlConnection(SQLHelper.Connect);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
try
{
int rs = (int)cmd.ExecuteScalar();
return rs;
}
catch
{
return 0;
}
conn.Close();

}


#region // For Update Query Excuate
public static DataTable selected_update(string sql)
{
SqlDataAdapter adpt = new SqlDataAdapter(sql, SQLHelper.Connect);
DataTable dt = new DataTable();
adpt.Fill(dt);
return dt;
}
#endregion

#region // Fetch Data in Format Like TreeView

public DataTable yet()
{
t = new DataTable("Total_List");
DsMain.Tables.Add(t);
DataColumn c1 = new DataColumn("CategoryID", Type.GetType("System.String"), "");
DataColumn c2 = new DataColumn("CategoryDesc", Type.GetType("System.String"), "");
DataColumn c3 = new DataColumn("Sub ID", Type.GetType("System.String"), "");
DataColumn c4 = new DataColumn("CategoryLevel", Type.GetType("System.String"), "");
DataColumn c5 = new DataColumn("IsActive", Type.GetType("System.Boolean"), "");
t.Columns.Add(c1);
t.Columns.Add(c2);
t.Columns.Add(c3);
t.Columns.Add(c4);
t.Columns.Add(c5);
LoadResults(0);
return DsMain.Tables["Total_List"];
}
int SubID = 0;
private void LoadResults(int inParentID)
{
if (inParentID == 0)
{
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM CMSForumPCCategory Where SubID=0 order by linkorder asc" , SQLHelper.Connect);
conn = new SqlConnection(SQLHelper.Connect);
conn.Open();
da.Fill(ds, "Search_List" + inParentID);
conn.Close();
}
else
{
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM CMSForumPCCategory Where SubID = " + inParentID, SQLHelper.Connect);
//SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM CMSForumPCCategory Where SubID = " + inParentID, SQLHelper.Connect);
conn.Open();
da.Fill(ds, "Search_List" + inParentID);
conn.Close();
}
DataTable ParentTable;
ParentTable = ds.Tables["Search_List" + inParentID];
foreach (DataRow parentrow in ParentTable.Rows)
{
DataRow newRow;
newRow = t.NewRow();

String ID = Convert.ToString(parentrow.ItemArray[0]);
newRow["CategoryID"] = ID;

String CategoryLevel = Convert.ToString(parentrow.ItemArray[4]);
newRow["CategoryLevel"] = CategoryLevel;

Boolean IsActive = Convert.ToBoolean(parentrow.ItemArray[3]);
newRow["IsActive"] = IsActive;

String Name = String.Concat(Convert.ToString(parentrow.ItemArray[1]));
newRow["CategoryDesc"] = (string)Name;

if (inParentID == 0)
{
newRow["Sub ID"] = (string)SubID.ToString();
}
else
{
SubID = Convert.ToInt32(parentrow.ItemArray[2]);
newRow["Sub ID"] = (string)SubID.ToString();
}
t.Rows.Add(newRow);
LoadResults(Convert.ToInt32(parentrow.ItemArray[0]));
}
}
#endregion
}

DATALIST

function foo()
{
var len = document.getElementById("DataList1").getElementsByTagName("span").length;
var lens = document.getElementById("DataList1").getElementsByTagName("INPUT").length;
var lenss = document.getElementById("DataList1").getElementsByTagName("I").length;
var j=-1;
var v=1;
// function for getting value
function bar()
{
var a=0;
for(var x=0;x {
var idsss = document.getElementById("DataList1").getElementsByTagName("I")[x].innerText;
a += "," + idsss;
}
return a.substring(2);
}
for(var x=1;x {
var ids = document.getElementById("DataList1").getElementsByTagName("INPUT")[x].value;
j++;
for(var y=j;y {
var ary = bar();
var arys = ary.split(",");
var idss = document.getElementById("DataList1").getElementsByTagName("span")[y].id;
document.getElementById(idss).setAttribute("innerHTML",ids * arys[y]+".00");
}
}
tot = 0;
for(var y=0;y {
var idss = document.getElementById("DataList1").getElementsByTagName("span")[y].innerHTML;
tot = parseInt(tot) + parseInt(idss);
}
document.getElementById('<%= Label2.ClientID%>').innerHTML = tot;
}

Javascript within datalist

Javascript in asp.net

1. For Email- Validation.
   function email()
   {
   src = document.form1.Email.value;
   var emailReg = "^[\\w-_\.]*[\\w-_\.]\@[\\w]\.+[\\w]+[\\w]$";
   var regex = new RegExp(emailReg);
   var c = regex.test(src);
   if(c == false && src !="" )
   {
   alert("Please Enter valid email address");
   document.form1.Email.select();
   }
   }
2. For Postalcode validation.
   function PostalCodes()
   {
   var poscod =document.form1.PostalCode.value;
   var lenpcod = poscod.length;
   if(isNaN(poscod) lenpcod!=6 && poscod!="")
   {
   alert("Enter valid Postal Code");
   document.form1.PostalCode.select();
   }
   }
3. For All Field should not be Blank.
   function chkerr(f,chkval){
   var chkvalarr = chkval.split(",");
   var totform = document.forms.length;
   for(var fm=0;fmfor(var i=0;ifor(var j=0;j<=chkvalarr.length;j++){
   if(document.forms[fm].elements[i].value == "" && document.forms[fm].elements[i].name == chkvalarr[j]){
   alert(document.forms[fm].elements[i].name +" Should not blank");
   document.forms[fm].elements[i].focus();
   document.forms[fm].elements[i].style.background="lightyellow";
   return false;
   }
   }
   }
   }
   }
4. For Year Validation .
   function yr()
   {
   var flag = 0;
   var yea = document.form1.Year.value;
   var mnth = document.form1.Month.value;
   var dt = document.form1.Day.value;
   var len = yea.length;
   if(yea!="")
   {
   if(yea%400==0 yea%100==0 yea%4==0)
   {
   flag=1;
   }
   if((!isNaN(yea) && len ==4))
   {
   if(mnth==2)
   {
   if(flag==1)
   {
   if(dt>29)
   {
   alert("Invalid Day");
   document.form1.Day.select();
   return false;
   }
   }
   else
   {
   if(dt>28)
   {
   alert("Invalid Day");
   document.form1.Day.select();
   }
   }
   }
   }
   else
   {
   alert("Invalid Year");
   document.form1.Year.select();
   }
   }
   }
5. For Date Validation.
   function dt()
   {
   var day = document.form1.Day.value;
   var mnth = document.form1.Month.value;
   var len = day.length;
   var flag=0;
   if(mnth == 1 mnth == 3 mnth == 5 mnth == 7 mnth == 8 mnth == 10 mnth == 12)
   {
   flag = 1;
   }
   else
   {
   flag = 0;
   }
   if(flag==1)
   {
   if((isNaN(day) && day!="") ( len>2 && day!="") ( day >31 && day!="") (mnth==2 && day >29 && day!="" ) )
   {
   alert("Enter Valid Day");
   document.form1.Day.select();
   return false;
   }
   }
   else if(flag==0)
   {
   if((isNaN(day) && day!="") ( len>2 && day!="") ( day >30 && day!="") (mnth==2 && day >29 && day!="" ) )
   {
   alert("Enter Valid Day");
   document.form1.Day.select();
   return false;
   }
   }
   }
   function PostalCodes()
   {
   var poscod =document.form1.PostalCode.value;
   var lenpcod = poscod.length;
   if(isNaN(poscod) lenpcod!=6 && poscod!="")
   {
   alert("Enter valid Postal Code");
   document.form1.PostalCode.select();
   }
   }
6. For Chaking From DB Whether Email is aveleble or not.
   function emailavil()
   {
   var ema = document.form1.Email.value;
   sndUserCheck(ema);
   }

// Include Followin js file for checking from db;
// JScript File
var ajax;
function MyObject(){
if(window.XMLHttpRequest)
{
ajax = new XMLHttpRequest();
}
else if(window.ActiveXObject)
{
ajax = new ActiveXObject("Microsoft.XMLHTTP");
}else {
ajax = new ActiveXObject("MSXML2.XMLHTTP");
}
return ajax;
}
function handelResponse(){
var serverres;
if (ajax.readyState== 4) {
if (ajax.status== 200) {
serverres = ajax.responseText;
alert(serverres.substr(0,15));
}
}
}
function sndUserCheck(action)
{
MyObject();
ajax.open("GET","Default.aspx?t1="+action,true);
ajax.onreadystatechange = handelResponse;
ajax.send(null);
}

// c# part.

SqlConnection conn;
SqlCommand cmd;
string email = Request.QueryString.Get("t1");
if (email != null)
{
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ExamConnectionString"].ConnectionString);
cmd = new SqlCommand("select count(*) from UserMaster where EmailID='" + email + "'",conn);
conn.Open();
int count = (int)cmd.ExecuteScalar();
if (count > 0)
{
Response.Write("Not Availeble");
}
else
{
Response.Write("Availeble");
}
conn.Close();
}

}