Allow only numbers and single decimal into inputbox using jquery


  function onlyDecimal(element, decimals) {
                $(element).keypress(function (event) {
                    var num = $(this).val();
                    num = isNaN(num) || num === ” || num === null ? 0.00 : num;
                    if ((event.which != 46 || $(this).val().indexOf(‘.’) != -1) && (event.which < 48 || event.which > 57)) {
                        event.preventDefault();
                    }
                    if ($(this).val() == parseFloat(num).toFixed(decimals)) {
                        event.preventDefault();
                    }
                });
            }
            onlyDecimal($(‘.singledecimalandnumber’), 2);

how to bind dropdownlist for edit item template in gridview using c#


 protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                if ((e.Row.RowState & DataControlRowState.Edit) > 0)
                {
                    var ddl = (DropDownList)e.Row.Cells[1].FindControl("ddlCity");
                    ddl.DataSource = GetRecordsCities();
                    ddl.DataValueField = "ID";
                    ddl.DataTextField = "CityName";
                    ddl.DataBind();
                    var dr = e.Row.DataItem as DataRowView;
                    if (dr != null)
                    {
                        ddl.SelectedValue = dr[1].ToString();
                    }
                }
            }
        }

How To Insert from CSV to Xml Bank Statment Data into Tables and Matching/Unmatching of Records.


ALTER PROCEDURE spImportBankStatement
(
@xmlStatements  NVARCHAR(MAX),
–declare @xmlStatements as NVARCHAR(MAX)
–set @xmlStatements=N'<DocumentElement>  <BankStatements>    <TransDate>2014-04-01T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PATHMEADS HSG GNRL</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>1928.34</TransCredit>    <TransBalance>52898.63</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-01T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>BANK OF SCOTLAND . A/32512624-9</TransDescription>    <TransDebit>247.2</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>52651.43</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-01T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>C&amp;G . 5000003469538500</TransDescription>    <TransDebit>340.1</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>52311.33</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-01T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PALMER GF . NO REF . RP4671262632218100</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>390</TransCredit>    <TransBalance>52701.33</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-01T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ROSE SE . G I STACY . RP4671163082788400</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>60</TransCredit>    <TransBalance>52761.33</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-01T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>DOUGLAS R . 16A BURLEIGH PARAD . RP4679969725651800</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>150</TransCredit>    <TransBalance>52911.33</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-01T00:00:00+05:30</TransDate>    <TransType />    <TransAccount>61477868</TransAccount>    <TransDescription>INTEREST (NET)</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>18.03</TransCredit>    <TransBalance>52929.36</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-06T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PLUS- HISCOX . ISMAIO590/  1-U</TransDescription>    <TransDebit>69.63</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>52859.73</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-06T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2355</TransDescription>    <TransDebit>758.58</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>52101.15</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-07T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SCHUMANN T</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>325</TransCredit>    <TransBalance>52426.15</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-07T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SIMON J H FRASER</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>390</TransCredit>    <TransBalance>52816.15</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-07T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>MR NICHOLAS RICHAR</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>710</TransCredit>    <TransBalance>53526.15</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-07T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>NAGENDRAN R R T/</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>4666.67</TransCredit>    <TransBalance>58192.82</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-07T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>AXA INSURANCE . 719138A</TransDescription>    <TransDebit>1889.89</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>56302.93</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-12T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>K KOENTOPP</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>2100</TransCredit>    <TransBalance>58402.93</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-12T00:00:00+05:30</TransDate>    <TransType>SO</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>WILLIAM ELSON</TransDescription>    <TransDebit>30</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>58372.93</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-12T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>4</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>325</TransCredit>    <TransBalance>58697.93</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-12T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>5</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>170</TransCredit>    <TransBalance>58867.93</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-12T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>6</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>149.31</TransCredit>    <TransBalance>59017.24</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-15T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>AL HAMRA FORT HOTE . AE         5809.20 . XR          5.4716 . CD 9922</TransDescription>    <TransDebit>1061.7</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>57955.54</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-15T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>OVERSEAS TRANSACTI . CD 9922</TransDescription>    <TransDebit>1</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>57954.54</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-15T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>MIRACLE COFFEE SHO . CD 9922</TransDescription>    <TransDebit>47.5</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>57907.04</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-16T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>7</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>325</TransCredit>    <TransBalance>58232.04</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-19T00:00:00+05:30</TransDate>    <TransType>SO</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>CRUZ LA5 1 . 46 BRUNSWICK</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>867</TransCredit>    <TransBalance>59099.04</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-19T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2359</TransDescription>    <TransDebit>253.46</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>58845.58</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-20T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PC WORLD . CD 9922</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>229</TransCredit>    <TransBalance>59074.58</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-20T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>WWW.EASYSPACE.COM . CD 9922</TransDescription>    <TransDebit>135.13</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>58939.45</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-21T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ZEGAOULA M . DEPOSITMUS10A . 646050623461124001</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>543</TransCredit>    <TransBalance>59482.45</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-23T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>APCOA PARKING (UK) . CD 9922</TransDescription>    <TransDebit>6</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>59476.45</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-26T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>FIRST CAPITAL CONN . CD 9922</TransDescription>    <TransDebit>7.5</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>59468.95</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-26T00:00:00+05:30</TransDate>    <TransType>SO</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>O M ISMAIL</TransDescription>    <TransDebit>1601</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>57867.95</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-26T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2358</TransDescription>    <TransDebit>290.23</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>57577.72</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-26T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2361</TransDescription>    <TransDebit>2296.88</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>55280.84</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-26T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>8</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>40</TransCredit>    <TransBalance>55320.84</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-27T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>WWW.BCF.NHS.UK . CD 9922</TransDescription>    <TransDebit>4</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>55316.84</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-27T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ASDA SUPERSTORE . CD 9922</TransDescription>    <TransDebit>6.88</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>55309.96</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-27T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>TFL MFM . CD 9922</TransDescription>    <TransDebit>7.5</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>55302.46</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-27T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>DIXONS . CD 9922</TransDescription>    <TransDebit>149.99</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>55152.47</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-27T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>EN HICK . HICK . 002010042700129529</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>270</TransCredit>    <TransBalance>55422.47</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-28T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>VELASCO PETE</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>953.33</TransCredit>    <TransBalance>56375.8</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-28T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SKY DIGITAL . 00621050862583</TransDescription>    <TransDebit>47.48</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>56328.32</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-28T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>NELSON M A . THE BROOKS 4 . 22023849446621000N</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>1050</TransCredit>    <TransBalance>57378.32</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-29T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PEREIRA VA</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>270</TransCredit>    <TransBalance>57648.32</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-29T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2362</TransDescription>    <TransDebit>234</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>57414.32</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-29T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>TERENCE CHARLES LE . TCL 16B BURLEIGH P . 64144530644301000N</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>899.4</TransCredit>    <TransBalance>58313.72</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-04-30T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>HIGH HOLBORN</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>1958</TransCredit>    <TransBalance>60271.72</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-04T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>MR SAM BIRCH</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>300</TransCredit>    <TransBalance>60571.72</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-04T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PATHMEADS HSG GNRL</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>1928.34</TransCredit>    <TransBalance>62500.06</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-04T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>TIMES SUBSCRIPTION . 1907573/0026302427</TransDescription>    <TransDebit>24</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>62476.06</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-04T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>BANK OF SCOTLAND . A/32512624-9</TransDescription>    <TransDebit>247.2</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>62228.86</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-04T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>C&amp;G . 5000003469538500</TransDescription>    <TransDebit>340.1</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>61888.76</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-04T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ROSE SE . G I STACY . RP4671163097542700</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>60</TransCredit>    <TransBalance>61948.76</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-04T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PALMER GF . NO REF . RP4671262645803500</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>390</TransCredit>    <TransBalance>62338.76</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-04T00:00:00+05:30</TransDate>    <TransType />    <TransAccount>61477868</TransAccount>    <TransDescription>INTEREST (NET)</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>23.56</TransCredit>    <TransBalance>62362.32</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-05T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ASDA SUPERSTORE . CD 9922</TransDescription>    <TransDebit>13</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>62349.32</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-05T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PLUS- HISCOX . ISMAIO590/  1-U</TransDescription>    <TransDebit>69.63</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>62279.69</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-06T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ZEGAOULA M</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>325</TransCredit>    <TransBalance>62604.69</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-06T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SCHUMANN T</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>325</TransCredit>    <TransBalance>62929.69</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-06T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SIMON J H FRASER</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>390</TransCredit>    <TransBalance>63319.69</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-06T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>MR NICHOLAS RICHAR</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>710</TransCredit>    <TransBalance>64029.69</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-06T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>NAGENDRAN R R T/</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>4666.67</TransCredit>    <TransBalance>68696.36</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-06T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2364</TransDescription>    <TransDebit>780</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>67916.36</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-07T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>FIRST CAPITAL CONN . CD 9922</TransDescription>    <TransDebit>14.8</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>67901.56</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-07T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>AXA INSURANCE . 719138A</TransDescription>    <TransDebit>1995.9</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>65905.66</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-10T00:00:00+05:30</TransDate>    <TransType>SO</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>CRUZ LA5 1 . 46 BRUNSWICK</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>867</TransCredit>    <TransBalance>66772.66</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-10T00:00:00+05:30</TransDate>    <TransType>SO</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>WILLIAM ELSON</TransDescription>    <TransDebit>30</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>66742.66</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-10T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2367</TransDescription>    <TransDebit>117.5</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>66625.16</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-10T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2363</TransDescription>    <TransDebit>822.5</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>65802.66</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-11T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>TFL MFM . CD 9922</TransDescription>    <TransDebit>15</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>65787.66</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-11T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2366</TransDescription>    <TransDebit>136.56</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>65651.1</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-12T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>K KOENTOPP</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>2100</TransCredit>    <TransBalance>67751.1</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-12T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2365</TransDescription>    <TransDebit>587.5</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>67163.6</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-17T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>TOYS R US 3646 . CD 9922</TransDescription>    <TransDebit>153.98</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>67009.62</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-17T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>9</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>30</TransCredit>    <TransBalance>67039.62</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-17T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>10</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>8106.07</TransCredit>    <TransBalance>75145.69</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-17T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>11</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>75</TransCredit>    <TransBalance>75220.69</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-20T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SCREWFIX BOREHAMWO . CD 9922</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>7.15</TransCredit>    <TransBalance>75227.84</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-20T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SCREWFIX BOREHAMWO . CD 9922</TransDescription>    <TransDebit>15.23</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>75212.61</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-20T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>WWWAMERICAN EXPRES . CD 9922</TransDescription>    <TransDebit>486.92</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>74725.69</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-20T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2369</TransDescription>    <TransDebit>1128</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>73597.69</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-20T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>12</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>150.36</TransCredit>    <TransBalance>73748.05</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-21T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2370</TransDescription>    <TransDebit>87.99</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>73660.06</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-21T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2360</TransDescription>    <TransDebit>120</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>73540.06</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-24T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>MR LUIS M T COELHO . 2A LUIS . 34120244707840000N</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>750</TransCredit>    <TransBalance>74290.06</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-25T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>HOLLYWOOD BOWL FIN . CD 9922</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>11.25</TransCredit>    <TransBalance>74301.31</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-25T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>REGENCY RESTAURANT . CD 9922</TransDescription>    <TransDebit>16.8</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>74284.51</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-25T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>HOLLYWOOD BOWL FIN . CD 9922</TransDescription>    <TransDebit>52.5</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>74232.01</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-25T00:00:00+05:30</TransDate>    <TransType>SO</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>O M ISMAIL</TransDescription>    <TransDebit>1601</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>72631.01</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-25T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ORTIZ C . 10A ORTIZ . 121962459210525001</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>325</TransCredit>    <TransBalance>72956.01</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-25T00:00:00+05:30</TransDate>    <TransType>DEP</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>HIGH HOLBORN</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>1958</TransCredit>    <TransBalance>74914.01</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-26T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PIZZA HUT 481 . CD 9922</TransDescription>    <TransDebit>77.58</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>74836.43</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-26T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2373</TransDescription>    <TransDebit>612.37</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>74224.06</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-26T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>TERENCE CHARLES LE . TCL 16B BURLEIGH P . 61144616880119000N</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>899.4</TransCredit>    <TransBalance>75123.46</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-27T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>B&amp; Q . CD 9922</TransDescription>    <TransDebit>4.39</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>75119.07</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-27T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>THE PAINTBALL CENT . CD 9922</TransDescription>    <TransDebit>80</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>75039.07</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-27T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>VELASCO PETE</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>953.33</TransCredit>    <TransBalance>75992.4</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-27T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SKY DIGITAL . 00621050862583</TransDescription>    <TransDebit>43.89</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>75948.51</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-27T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2368</TransDescription>    <TransDebit>290.23</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>75658.28</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-27T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>EN HICK . HICK . 002010052700127270</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>300</TransCredit>    <TransBalance>75958.28</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-05-28T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>NELSON M A . THE BROOKS 4 . 28024102946908000N</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>1050</TransCredit>    <TransBalance>77008.28</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PEREIRA VA</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>300</TransCredit>    <TransBalance>77308.28</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>MR SAM BIRCH</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>300</TransCredit>    <TransBalance>77608.28</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PATHMEADS HSG GNRL</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>1928.34</TransCredit>    <TransBalance>79536.62</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>TIMES SUBSCRIPTION . 1907573/002630241X</TransDescription>    <TransDebit>24</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>79512.62</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PLUS- HISCOX . 1189253</TransDescription>    <TransDebit>87.11</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>79425.51</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>BANK OF SCOTLAND . A/32512624-9</TransDescription>    <TransDebit>247.2</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>79178.31</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>DD</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>C&amp;G . 5000003469538500</TransDescription>    <TransDebit>340.1</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>78838.21</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PALMER GF . NO REF . RP4671262658486800</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>390</TransCredit>    <TransBalance>79228.21</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>NICHOLAS HUGHES . N HUGHES WD23 3HJ . 00151664632BBBBXCH</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>710</TransCredit>    <TransBalance>79938.21</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType>FPI</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ROSE SE . G I STACY . RP4671163112094800</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>60</TransCredit>    <TransBalance>79998.21</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-01T00:00:00+05:30</TransDate>    <TransType />    <TransAccount>61477868</TransAccount>    <TransDescription>INTEREST (NET)</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>20.82</TransCredit>    <TransBalance>80019.03</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-02T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>REGENCY RESTAURANT . CD 9922</TransDescription>    <TransDebit>25.4</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>79993.63</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-02T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>TESCO STORE 3050 . CD 9922</TransDescription>    <TransDebit>44.02</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>79949.61</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-02T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>TESCO STORE 2126 . CD 9922</TransDescription>    <TransDebit>71.48</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>79878.13</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-02T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2374</TransDescription>    <TransDebit>120</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>79758.13</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-03T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>JACRO CINEMA SALES . CD 9922</TransDescription>    <TransDebit>48.88</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>79709.25</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-03T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ZEGAOULA M</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>325</TransCredit>    <TransBalance>80034.25</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-03T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SCHUMANN T</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>325</TransCredit>    <TransBalance>80359.25</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-03T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>SIMON J H FRASER</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>390</TransCredit>    <TransBalance>80749.25</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-03T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>NAGENDRAN R R T/</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>4666.67</TransCredit>    <TransBalance>85415.92</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-03T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2372</TransDescription>    <TransDebit>793.02</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>84622.9</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-07T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>PROTYRE ENFIELD . CD 9922</TransDescription>    <TransDebit>147.27</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>84475.63</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-07T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2375</TransDescription>    <TransDebit>179.78</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>84295.85</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-08T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>LA-VITA . CD 9922</TransDescription>    <TransDebit>231.8</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>84064.05</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-08T00:00:00+05:30</TransDate>    <TransType>SO</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>CRUZ LA5 1 . 46 BRUNSWICK</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>867</TransCredit>    <TransBalance>84931.05</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-08T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2377</TransDescription>    <TransDebit>775.5</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>84155.55</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-09T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2376</TransDescription>    <TransDebit>323.12</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>83832.43</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-10T00:00:00+05:30</TransDate>    <TransType>BGC</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>K KOENTOPP</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>2100</TransCredit>    <TransBalance>85932.43</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-10T00:00:00+05:30</TransDate>    <TransType>SO</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>WILLIAM ELSON</TransDescription>    <TransDebit>30</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>85902.43</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-10T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2380</TransDescription>    <TransDebit>290.23</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>85612.2</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-11T00:00:00+05:30</TransDate>    <TransType>DEB</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>WYCOMBE DISTRICT COUNC . CD 9922</TransDescription>    <TransDebit>2</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>85610.2</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-11T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2382</TransDescription>    <TransDebit>183.46</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>85426.74</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-14T00:00:00+05:30</TransDate>    <TransType>SO</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>ORI H ORG F</TransDescription>    <TransDebit>0</TransDebit>    <TransCredit>325</TransCredit>    <TransBalance>85751.74</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-14T00:00:00+05:30</TransDate>    <TransType>CHQ</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>2379</TransDescription>    <TransDebit>1881</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>83870.74</TransBalance>  </BankStatements>  <BankStatements>    <TransDate>2010-06-14T00:00:00+05:30</TransDate>    <TransType>TFR</TransType>    <TransAccount>61477868</TransAccount>    <TransDescription>V DJEMAL</TransDescription>    <TransDebit>6000</TransDebit>    <TransCredit>0</TransCredit>    <TransBalance>77870.74</TransBalance>  </BankStatements></DocumentElement>’
–declare @message as NVARCHAR(MAX)
@message NVARCHAR(MAX) output
)
AS
BEGIN TRANSACTION
SET NOCOUNT ON;
BEGIN TRY
DECLARE @XMLDocPointer INT  
IF(@xmlStatements!=”)
        BEGIN    
        IF(OBJECT_ID(‘tempdb..#BankStatement’) Is Not NULL)
                        Begin
                        TRUNCATE TABLE #BankStatement
                        DROP TABLE #BankStatement
                        End

            
            EXEC sp_xml_preparedocument @XMLDocPointer OUTPUT, @xmlStatements
            SELECT TransDate,TransType,TransAccount ,TransDescription,TransDebit,TransCredit,TransBalance     INTO #BankStatement     
                FROM OPENXML(@XMLDocPointer,’/DocumentElement/BankStatements’,2)    
                WITH  (TransDate DATETIME,TransType NVARCHAR(MAX),TransAccount INT,TransDescription VARCHAR(max),
                TransDebit  DECIMAL(10,2),TransCredit DECIMAL(10,2),TransBalance DECIMAL(10,2))                            
                EXEC sp_xml_removedocument @XMLDocPointer
                    
                    ;WITH Ignored AS(
                                SELECT TransDate, TransType, TransDescription, TransDebit, TransCredit,TransBalance FROM #BankStatement
                                            INTERSECT
                                SELECT Date,ChqNo, Description,Debit,Credit,Balance FROM Transactions
                                )
                        SELECT * FROM Ignored                        
                    
                    ;WITH Added AS(
                                SELECT TransDate, TransType, TransDescription, TransDebit, TransCredit,TransBalance FROM #BankStatement
                                            EXCEPT
                                SELECT Date,ChqNo, Description,Debit,Credit,Balance FROM Transactions
                                )                    
                        SELECT *FROM Added

                        ;WITH Inserted AS(
                                SELECT TransDate, TransType, TransDescription, TransDebit, TransCredit,TransBalance FROM #BankStatement
                                            EXCEPT
                                SELECT Date,ChqNo, Description,Debit,Credit,Balance FROM Transactions
                                )                    
                        INSERT INTO Transactions(Date,ChqNo,Description,Debit,Credit,Balance)  SELECT TransDate,TransType,TransDescription,TransDebit,TransCredit,TransBalance  FROM Inserted
                        
                        IF(OBJECT_ID(‘tempdb..#BankStatement’) Is Not NULL)
                        Begin
                        TRUNCATE TABLE #BankStatement
                        DROP TABLE #BankStatement
                        End
        
        END
SET @message=’Done’
COMMIT    
END TRY
BEGIN CATCH
ROLLBACK
SET @message=ERROR_MESSAGE()
END CATCH

–TRUNCATE TABLE Transactions
–SELECT *FROM Transactions
–SELECT COUNT(*) FROM Transactions

How to Read CSV Into DataTable Using asp.net c#


public DataTable CsvFileToDatatable(string path, bool IsFirstRowHeader)
{
string header = "No";
string sql = string.Empty;
DataTable dataTable = null;
string pathOnly = string.Empty;
string fileName = string.Empty;
try
{
pathOnly = Path.GetDirectoryName(path);
fileName = Path.GetFileName(path);
sql = @"SELECT * FROM [" + fileName + "]";
if (IsFirstRowHeader)
{
header = "Yes";
}
using (OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathOnly +
		 ";Extended Properties=\"Text;HDR=" + header + "\""))
{
using (OleDbCommand command = new OleDbCommand(sql, connection))
{
using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
{
dataTable = new DataTable();
dataTable.Locale = CultureInfo.CurrentCulture;
adapter.Fill(dataTable);
}
}
}
}
finally
{
}
return dataTable;
}

Filter Gridview Using Ajax Scroll


Introduction

This is very simple example of use Ajax Slide Control to filter data in a grid view.  Sometimes we need to filter the gridview data based on some range value. On that case we can use AJAX Slider control to provide scrollable Filter functionality with gridview control.

To discuss about the implementation,  lets break down the project into three part

  1. Data Source
  2. ASPX Page
  3. Use of Codebehind

 

Data Source

Data source is used to bind the data with grid view.  It may be an XML, or Data Set or From Database. In this example I have used XML as data source.  Which loads as a dataset to bind with grid view.  Below is the structure of the XML File that I have used for this application.

<students>

  <student>

    <roll>1</roll>

    <name>A</name>

    <address>Kolkata</address>

    <marks>88</marks>

  </student>

  <student>

    <roll>2</roll>

    <name>B</name>

    <address>Pune</address>

    <marks>77</marks>

  </student>

     .

     .

     .

</students>

we can use some different data source also like  Database or anything else as per the requirements.

ASPX Page Implementation

In the aspx page we have used on Update Panel that contain the gridview. Data source of the gridview has been defined from Codebehind code as Data going to be chage while filtering. We have also used one AJAX Slider control to filter the data on slider change.

        <asp:UpdatePanel ID="UpdatePanel1" runat="server">

            <ContentTemplate>

                <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None"

                    Width="222px">

                    <RowStyle BackColor="#EFF3FB" />

                    <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

                    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

                    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                    <EditRowStyle BackColor="#2461BF" />

                    <AlternatingRowStyle BackColor="White" />

                </asp:GridView>

            </ContentTemplate>

        </asp:UpdatePanel>

    </div>

    <cc1:SliderExtender ID="SliderExtender1" runat="server" BoundControlID="lbl"

        Decimals="0" Minimum="1" Maximum="9"  TargetControlID="TextBox1"

        EnableHandleAnimation="true" TooltipText="{0}">

    </cc1:SliderExtender>


    <p>

        <asp:TextBox ID="TextBox1" AutoPostBack="true"
runat="server"
OnTextChanged="txtSlider_TextChanged"></asp:TextBox>

        <asp:Label ID="lbl"></asp:Label>

    </p>

We have one textBox that sets as TargetControlID of SilderControl. So, what ever the value will change in Slider will reflect in textbox and whenever we have change value in textbox, txtSlider_TextChanged event will fire which will do the filter from codebehind.

Lets have a look what we have to do in Server side code.

Use of Codebehind

During the page load, first we need to load all the data from XML File, like below

protected void Page_Load(object sender, EventArgs e)
    {
       //Check For Post back or not
        if (!Page.IsPostBack)
        {
           Ds.ReadXml(Server.MapPath("Result.xml"));
           GridView1.DataSource = Ds;
           GridView1.DataBind();
        }
    }

This will load all the data form XML To Gridview.

Now, lets have look into the txtSlider_TextChanged which will call automatically on slider change.

protected void txtSlider_TextChanged(object sender, EventArgs e)
    {
        // Filter based on Rool
        string query = "roll >= " + TextBox1.Text;
        Ds.ReadXml(Server.MapPath("Result.xml"));
        DataTable dt1 = Ds.Tables[0];
        //Apply Select Query
        var v =dt1.Select(query);
        DataTable dt = new DataTable("Customers");
        // Add columns in DataTable
        dt.Columns.Add("Roll", typeof(string));
        dt.Columns.Add("Name", typeof(string));
        dt.Columns.Add("Address", typeof(string));
        dt.Columns.Add("Marks", typeof(string));
        foreach (DataRow dRow in v)
        {
           DataRow dr = dt.NewRow();
            dr["Roll"] = dRow["roll"];
            dr["Name"] = dRow["name"];
            dr["Address"] = dRow["address"];
           dr["Marks"] = dRow["marks"];
            dt.Rows.Add(dr);
        }
        GridView1.DataSource = dt;
            GridView1.DataBind();
    }

Some Filtered Records

Here you can check we have filter the data based on Roll Number.

        string query = "roll >= " + TextBox1.Text;
        var v =dt1.Select(query);

You can change the condition of filter as per your requirement.

Conclusion

This is a very simple article which shows you how to use Slider Control to Filter Data in GridView. You can use any data source like database or XML for the same. Please feel free to download the sample from above and use it wherever you like. I will write one more article on how to filter data using AJAX MultiSlider soon.  Please provide your valuable suggestion and feedback.

How to Freeze GridView Header While Scrolling ?


 This is very common problem in Web development that we need to freeze the GridView header at the time of scrolling, Here is one simple tips:

Step 1 : Create a CSS class as following

.HeaderFreez
{
position:relative ;
top:expression(this.offsetParent.scrollTop);
z-index: 10
}

Step 2 Set Gridview’s HeaderStyle CssClass as follows

CssClass="HeaderFreez" 

Using a Webgrid that can sort, page, and filter in Asp.Net MVC3


Getting the MvcWebGrid app setup

To begin, create a new MVC3 application called MvcWebGrid.  Make sure you select Empty for the template, and that the view engine is set to Razor.  Next, right click on the Controllers folder and select add->New Controller.  Name the controller HomeControler, and leave the checkbox to create the CRUD methods unchecked.

For simplicity sake, we will not connect to a real database in this sample.  Instead, I have created a class that returns a lists of music albums (generated from the MvcMusicStore tutorial at mvcmusicstore.codeplex.com).  You can find this class in the code download (linked at the end of this article), or here on github.  This is a simple static class with a single method called GetAlbums, which returns an IEnumerable<Album>.  Add this class to your models folder.

In your home controller, modify your Index action method to like like so:

  public ActionResult Index()
        {
            var obj = new AlbumRepo();
            var albums = obj.GetAlbums();
            return View(albums);
        }

In _LayouPage write down below given code
 <div id="header">
        Welcome to my awesome music site where a deep dish of awesome stew is served up
        daily
        <p />
        <p />
        <p />
        <ul>
            <li>@Html.ActionLink("Index", "Index", "Grid")</li>
            <li>@Html.ActionLink("Ajax2", "IndexWithAjax","Grid",new { ajax = "this is ajax sample" },null)</li>
        </ul>
    </div>
    @RenderBody()
    <div id="footer">
        <p />
        You have reached the bottom of this page, now what?
    </div>

Adding the WebGrid to the app

Now that we have a basic layout for our site, lets create the index view.  Go back to the home controller, right click anywhere within the index action method, and select add view.  Keep all the defaults and click Add.

Change the new view to look like the following:

   1:  @model IEnumerable<Album>
   2:   
   3:  @{
   4:      ViewBag.Title = "MVC Music Store Grid";
   5:  }
   6:   
   7:  @using (Html.BeginForm())
   8:  {
   9:      <fieldset>
  10:          <legend>Search</legend>
  11:   
  12:          <div>
  13:              Album Id:
  14:          </div>
  15:          <div>
  16:              <input type="text" id="albumid" name="albumid" />
  17:          </div>
  18:   
  19:          <div>
  20:              Album Name:
  21:          </div>
  22:          <div>
  23:              <input type="text" id="albumName" name="albumName" />
  24:          </div>
  25:   
  26:          <p>
  27:              <input type="submit" value="Search" />
  28:          </p>
  29:      </fieldset>
  30:  }
  31:   
  32:  <div id="myGrid">
  33:      @Html.Partial("_grid", Model)
  34:  </div>

We will be separating the WebGrid into its own partial view, so right click on the Views/Home folder, select add, and then view.  Name the view _grid, and check the “Create as a partial view” checkbox, then click add.  Prepending the name of our Razor view with a underscore tells Asp.Net that this file should not be served if requested directly, which is perfect for our partial views.

In our grid partial view, we will now be using the new WebGrid helper.  We start off creating an instance of the WebGrid (passing in our model into the constructor), and then call the GetHtml method which generates the html for the grid and outputs it to the screen:

   1:  @model IEnumerable<Album>
   2:   
   3:  @{
   4:      var grid = new WebGrid(Model);
   5:      @grid.GetHtml();
   6:  }

When we run the app, we get a web page that looks like so:

image

If you inspect the html for the new grid, you will see that it is clean markup, with no added styles or nasty viewstate that we have seen in the past with WebForms.  You might also notice that the table html is semantically correct, where the header is in the thead section, the content in the tbody section, and the paging in the tfoot section.  Having your tables formatted properly will go a long ways if you want to try to extend your table functionality using JavaScript libraries such as jQuery, where it was often difficult to achieve this in WebForms.

Another bonus is that the paging and sorting already work!  Out of the box, the WebGrid provides these functions by doing Get requests and passing in a few values over the query string.  The WebGrid will see these values in the new request, and adjust the output accordingly.  This means that the WebGrid expects the entire set of data in each view in order to generate the paging properly.  For small sets of data this is not a problem, but even in our sample app you can notice a lag when hitting the links.  Fixing this issue is out of the scope of this article, but just be aware that you will need to come up with a different solution if your data sets are large.

The WebGrid provides a lot of options for configuration.  These options are provided by passing in parameters to the WebGrid’s constructor, as well as the GetHtml method.

image

image

We will modify some of these options to add some Ajax functionality to the screen (so that paging and sorting don’t refresh the entire screen), as well as change how some of the columns appear.  Modify _grid.cshtml to look like so:

   1:  @model IEnumerable<Album>
   2:   
   3:  @{
   4:      var grid = new WebGrid(Model, rowsPerPage: 15, ajaxUpdateContainerId: "myGrid");
   5:      @grid.GetHtml(columns: grid.Columns(
   6:                          grid.Column("AlbumId", "Album Id"),
   7:                          grid.Column("Title", "Title"),
   8:                          grid.Column("Artist", "Artist")
   9:                          ));
  10:  }

In the constructor, we setting the size of the page to handle 15 albums at a time, as well as setting the container id of the div in the index.cshtml page that holds our grid.  The simple act of setting the ajaxUpdateContainerId will automatically enable our screen to use Ajax to update the screen on pages and sorts.  All we need to do is make sure jQuery is included in the project, which it is by default in the _Layout.cshtml page.

The GetHtml method take a columns param, where we pass in a list of column objects we want to use on the grid.

One thing I don’t particularly care for is how the Ajax is inserted into the page.  If you take a look at the source, all of the links now have onclick methods inserted into them.  This gets away from the unobtrusive JavaScript theme the rest of MVC3 strived so hard to achieve.  We will talk some more about unobtrusive JavaScript in the next section.

Filtering the grid

You probably noticed that our index.cshtml page has had a form in it that we will be using to filter the data in the grid.  This form is simple by design, and will allow us to filter the form either by the Album Id, or the Album Name.  Before we do anything with the form, lets add a new action method in our home controller that will let us filter the data:

   1:  [HttpPost]
   2:  public ActionResult Index(int? albumId, string albumName)
   3:  {
   4:      var albums = AlbumRepo.GetAlbums();
   5:   
   6:      if (!string.IsNullOrEmpty(albumName))
   7:          albums = albums.Where(a => a.Title.Contains(albumName)).ToList();
   8:   
   9:      if (albumId.HasValue)
  10:          albums = albums.Where(a => a.AlbumId == albumId).ToList();
  11:   
  12:      return View(albums);
  13:  }
 
This new action method has the same name as our other action method, but has the HttpPost attribute which tells MVC that this method will only respond to post requests.  We accept two params into the method that will be used to filter the data. (Note: the code in this action method is not a good way to filter data, it is just demo code, so don’t reuse it in production).
Now when we run the app, we can filter the data.  However, our site is doing a complete post and refresh of the page every time we do a search.  We will now add Ajax to the form.
We will use the new unobtrusive Ajax support that is in MVC3 to accomplish this, and do it without having to write a single line of JavaScript.  The Ajax.BeginForm has been around for awhile in MVC, but it has been changed to now use jQuery and not the Microsoft Ajax library.  Also, there is no more JavaScript inserted into the screen on your behalf (unlike the WebGrid Ajax support shown above).  Instead, MVC3 uses HTML5 data attributes to mark the form, and a special script that is used to wire the Ajax functionality up at runtime.
In index.cshtml, change the Html.BeginForm line to the following:
   1:  @using (Ajax.BeginForm(new AjaxOptions 
   2:      { InsertionMode = InsertionMode.Replace, UpdateTargetId = "myGrid" }))
   3:  {
The AjaxOptions parameter tells our form how to handle the Ajax reqeuest.  In this case, we are telling it we want the InsertionMode to replace the current contents in the myGrid div tag (much like we did with the paging and sorting on the grid).  All that is left to do is add the JavaScript file that will make this magic happen.  In the _Layout.cshtml file, add the following line directly below the line that includes jQuery:
   1:  <script type="text/javascript" src="../../Scripts/jquery.unobtrusive-ajax.min.js">
   2:  </script>  

Make sure you don’t include any of the JavaScript files that start with Microsoft, as those are just included for backwards compatibility.  In MVC3, you want to be using the scripts who’s filenames start with jQuery.

If you run the app now, you might notice a strange oddity when filtering the data.  The entire response is copied into the myDiv tag, meaning that we get another copy of the form, along with the WebGrid table again.  When using Ajax.BeginForm, the response that is sent is expected to only be the content that changes, not the entire page.  We can easily fix this and return just the updated grid by changing the index action method that accepts the HttpPost to return a partial view of only the grid and not the entire index view (this is why we separated the grid out from the index view in the first place).

Update the index action method for the filtering to return a partial view by modifying the last line as such:

   1:  return PartialView("_grid", albums);

Now when you enter an a AlbumId or a partial Album name, the grid will filter and display properly.

Download Source Code : https://docs.google.com/file/d/0B-sDsBkcsM1YVUJwSUN0YWJFTU0/edit?usp=sharing