private void loadTable()
{
string strAlpha=Request.QueryString["alpha"];//get the alphabets
int intPageValue=Convert.ToInt16(Request.QueryString["Pager"]);//get the page value
string[] strDetails;
string strData;
int i;
int intRowCount;
//get the data from database
if (strAlpha==null || strAlpha == "ALL")
{
strData=iGeneral.RetrieveRecords("b.bank_code,b.ba nk_name,b.address1,b.address2,c.city_name,b.zip_co de,s.state_name,b.country,b.phone1,b.phone2,b.cont act_person,b.fax1,b.fax2,b.email,b.website","city_ master c,bank_master b,state_master s","b.city_code=c.city_code and b.state_code=s.state_code");
}
else
{
strData=iGeneral.RetrieveRecords("b.bank_code,b.ba nk_name,b.address1,b.address2,c.city_name,b.zip_co de,s.state_name,b.country,b.phone1,b.phone2,b.cont act_person,b.fax1,b.fax2,b.email,b.website","city_ master c,bank_master b,state_master s","b.city_code=c.city_code and b.state_code=s.state_code and b.bank_name like '" + strAlpha + "%'");
}
strDetails=strData.Split('|');
intRowCount = strDetails.Length;
Response.Write("<table width=50% border=0 cellpadding=3 cellspacing=0 class=tbox1 id=results>");
Response.Write("<tr class=headbggrey color=grey>");
Response.Write("<td align=center valign=top class=formleftheading>");
Response.Write("<span class=formleftheading></span>");
Response.Write("<td valign=top class=formleftheading>BANK NAME</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>ADDRESS1</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>ADDRESS2</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>CITY</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>ZIP-CODE</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>STATE</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>COUNTRY</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>PHONE1</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>PHONE2</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>REFERENCE</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>FAX1</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>FAX2</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>EMAIL</td>");
Response.Write("</td>");
Response.Write("<td valign=top class=formleftheading>WEBSITE</td>");
Response.Write("</td>");
Response.Write("</tr>");
string[] strArrCol;//to set Column Value
strArrCol=strDetails[i].Split('^');
Response.Write("<tr>");
Response.Write("<td width=25 align=left valign=top class=formleftheading><input name=optBank id = optBank type = radio onclick=RadioClick('"+ strArrCol[1] +"','"+strArrCol[0]+"','"+strArrCol[2]+"','"+strArrCol[3]+"','"+strArrCol[4]+"','"+strArrCol[5]+"','"+strArrCol[6]+"','"+strArrCol[7]+"','"+strArrCol[8]+"','"+strArrCol[9]+"','"+strArrCol[10]+"','"+strArrCol[11]+"','"+strArrCol[12]+"','"+strArrCol[13]+"','"+strArrCol[14]+"','Modify')></td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[1] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[2] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[3] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[4] + " </td>");
string demo= strArrCol[4];
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[5] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[6] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[7] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[8] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[9] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[10] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[11] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[12] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[13] + " </td>");
Response.Write("<td align=left valign=middle class=formleftheading> " + strArrCol[14] + " </td>");
Response.Write("</tr>");
Response.Write("</table>");
}