Translate

Fixed header and scrollable body

Tuesday, July 12, 2016 Category : 0



<div class="Top1 base">
    <table>
        <tr>
            <td>1
            </td>
            <td>2
            </td>
            <td>3
          ....
        </tr>
    </table>
</div>
<div class="Top2 base">
    <table>
        <tr>
            <td>1
            </td>
            <td>2
            </td>
            <td>3
            </td>
            <td>4
            </td>
            <td>5
            </td>
            <td>6
            </td>
            <td>7
          .....
        </tr>
        <tr>
            <td>1
            </td>
            <td>2
            </td>
            <td>3
            </td>
            <td>4
            </td>
          .....
        </tr>
        <tr>
            <td>1
            </td>
            <td>2
            </td>
            <td>3
            </td>
            <td>4
            </td>
          ...
        </tr>
        <tr>
            <td>1
            </td>
            <td>2
            </td>
            <td>3
            </td>
            <td>4
           ....
        </tr>
        <tr>
            <td>1
            </td>
            <td>2
            </td>
            <td>3
            </td>
            <td>4
            ........
        </tr>
        <tr>
            <td>1
            </td>
            <td>2
            </td>
            <td>3
            </td>
            <td>4
            </td>
            <td>5
           ...........
        </tr>
        <tr>
            <td>1
            </td>
            <td>2
            </td>
            <td>3
            </td>
            <td>4
            </td>
            .....
        </tr>
        <tr>
            <td>1
            </td>
            <td>2
            </td>
            <td>3
            </td>
            <td>4
            </td>
            <td>5
            </td>
            ......
        </tr>
    </table>
</div>




.base{
    width:250px;
    overflow:scroll;
    max-height:100px;
}

.Top1
{
    overflow:hidden;
    width: 230px;
 }


$('.Top2').bind('scroll', function(){
  $(".Top1").scrollLeft($(this).scrollLeft());
});




Source : http://jsfiddle.net/A79e2/10/

ASP.NET Expand grid view

Wednesday, May 4, 2016 Category : 0

Source :  http://www.aspsnippets.com/Articles/ASPNet-Nested-GridViews-GridView-inside-GridView-with-Expand-and-Collapse-feature.aspx


<asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false" CssClass="Grid"
    DataKeyNames="CustomerID" OnRowDataBound="OnRowDataBound">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <img alt = "" style="cursor: pointer" src="images/plus.png" />
                <asp:Panel ID="pnlOrders" runat="server" Style="display: none">
                    <asp:GridView ID="gvOrders" runat="server" AutoGenerateColumns="false" CssClass = "ChildGrid">
                        <Columns>
                            <asp:BoundField ItemStyle-Width="150px" DataField="OrderId" HeaderText="Order Id" />
                            <asp:BoundField ItemStyle-Width="150px" DataField="OrderDate" HeaderText="Date" />
                        </Columns>
                    </asp:GridView>
                </asp:Panel>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField ItemStyle-Width="150px" DataField="ContactName" HeaderText="Contact Name" />
        <asp:BoundField ItemStyle-Width="150px" DataField="City" HeaderText="City" />
    </Columns>
</asp:GridView>
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        gvCustomers.DataSource = GetData("select top 10 * from Customers");
        gvCustomers.DataBind();
    }
}


protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        string customerId = gvCustomers.DataKeys[e.Row.RowIndex].Value.ToString();
        GridView gvOrders = e.Row.FindControl("gvOrders") as GridView;
        gvOrders.DataSource = GetData(string.Format("select top 3 * from Orders where CustomerId='{0}'", customerId));
        gvOrders.DataBind();
    }
}
 
 
 
 
 
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
    $("[src*=plus]").live("click", function () {
        $(this).closest("tr").after("<tr><td></td><td colspan = '999'>" + $(this).next().html() + "</td></tr>")
        $(this).attr("src", "images/minus.png");
    });
    $("[src*=minus]").live("click", function () {
        $(this).attr("src", "images/plus.png");
        $(this).closest("tr").next().remove();
    });
</script>
 
 
 
 

ASP.NET C# Document Download from Database

Sunday, April 24, 2016 Category : , , 0


Load document byte from sql server database. save it to temporary storeage , and view in browser.

public void Download() {

string fileName = "abc.doc";
string _path = Request.PhysicalApplicationPath + "Temp/" + fileName;

byte[] filebyte = new byte[0]; // load from database

File.WriteAllBytes(_path, filebyte );

oR.showReportAjax(ResolveUrl("~/Temp/" + fileName), this.GetType(), this, UpdatePanel1);

}

public void showReportAjax(string pageUrl, Type cType, Page oPage, Control ctrl)
{
string url = ResolveClientUrl(pageUrl) ;

ScriptManager.RegisterStartupScript(ctrl, typeof(string), "redirect", "window.open('" + url + "');", true);

} 
 

Method 2


System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
        response.ClearContent();
        response.Clear();
        response.ContentType = "text/plain";
        response.AddHeader("Content-Disposition", 
                           "attachment; filename=" + fileName + ";");
        response.TransmitFile(Server.MapPath("FileDownload.csv"));
        response.Flush();    
        response.End();

 

ASP.NET Jquery Auto complete with selected value

Friday, March 25, 2016 Category : 0


 function InitAutoCompl3() {

                                         
                                             $("#<%=txtAccountName.ClientID %>").autocomplete({
                                                 source: function (request, response) {
                                                     $.ajax({
                                                         url: '<%=ResolveUrl("~/DataWebService.asmx/GetAccounts2") %>',
                                                         data: "{ 'prefixText': '" + request.term + "'}",
                                                         dataType: "json",
                                                         type: "POST",
                                                         contentType: "application/json; charset=utf-8",
                                                         success: function (data) {

                                                             response($.map(data.d, function (item) {
                                                                 return {
                                                                     label: item.split('~')[1],
                                                                     val: item.split('~')[0]
                                                                 }
                                                             }))
                                                         },
                                                         error: function (response) {
                                                             alert(response.responseText);
                                                         },
                                                         failure: function (response) {
                                                             alert(response.responseText);
                                                         }
                                                     });
                                                 },
                                                 select: function (e, i) {
                                                     $("#<%=HFAcId2.ClientID %>").val(i.item.val);
                                                 },
                                                 minLength: 1
                                             });
                                     };


ASP.NET call Java function in every async postback

Category : , 0

 $(document).ready(function () {
                                         var prm = Sys.WebForms.PageRequestManager.getInstance();
                                         prm.add_initializeRequest(InitializeRequest);
                                         prm.add_endRequest(EndRequest);

                                         // Place here the first init of the autocomplete
                                         InitAutoCompl3();  // in web user control
                                     });

                                     function InitializeRequest(sender, args) {
                                     }

                                     function EndRequest(sender, args) {
                                         // after update occur on UpdatePanel re-init the Autocomplete
                                         InitAutoCompl3();
                                     }

Quick Book 2014 C# Voucher Posting And Get

Monday, March 14, 2016 Category : 0

Required : SDK 13.0
Download link : https://developer.intuit.com/docs/0250_qb/0020_get_set_up/sdk_downloads
https://developer.intuit.com/Downloads/Restricted?filename=qbsdk130.exe

Sample Experimental Project :
https://onedrive.live.com/redir?resid=7D3B49FB4453E77A!1431&authkey=!AANhtiemRiGCDwk&ithint=file%2crar


Reference Guide: 

http://www.nullskull.com/a/1568/c-net-application-with-quickbooks-desktop-edition.aspx
https://mukarrammukhtar.wordpress.com/quickbooks-with-net/
http://qbblog.ccrsoftware.info/2010/03/quickbooks-add-on-programs-sdk/

HTML FileBrowser Image Preview

Wednesday, February 3, 2016 Category : , , 0


HTML



<div class="form-group">
                                <label class="control-label col-md-3" for="inputWarning"> Image 1 </label>
                                <div class="col-md-4">
                                    <input id="exampleInputFile1" name="ImagePath" type="file">
                                    <b>Live Preview</b>
                                    <br />
                                    <div id="dvPreview1">
                                    </div>
                                </div>
                            </div>



Java Script




  window.onload = function () {

        LoadTempData();

        var fileBrowser = document.getElementById("exampleInputFile1");
        fileBrowser.onchange = function () {
            LoadImage('1', fileBrowser);
        }


        var fileBrowser2 = document.getElementById("exampleInputFile2");
        fileBrowser2.onchange = function () {
            LoadImage('2', fileBrowser2);
        }


        var fileBrowser3 = document.getElementById("exampleInputFile3");
        fileBrowser3.onchange = function () {
            LoadImage('3', fileBrowser3);
        }

        var fileBrowser4 = document.getElementById("exampleInputFile4");
        fileBrowser4.onchange = function () {
            LoadImage('4', fileBrowser4);
        }


        var fileBrowser5 = document.getElementById("exampleInputFile5");
        fileBrowser5.onchange = function () {
            LoadImage('5', fileBrowser5);
        }

    };





function LoadImage(idNo, fileBrowser)
    {

        if (typeof (FileReader) != "undefined") {
            var dvPreview = document.getElementById("dvPreview" + idNo);
            dvPreview.innerHTML = "";
            var regex = /^([a-zA-Z0-9\s_\\.\-:])+(.jpg|.jpeg|.gif|.png|.bmp)$/;
            for (var i = 0; i < fileBrowser.files.length; i++) {
                var file = fileBrowser.files[i];
                if (regex.test(file.name.toLowerCase())) {
                    var reader = new FileReader();
                    reader.onload = function (e) {

                        //var img = document.createElement("IMG");
                        //img.height = "100";
                        //img.width = "100";
                        //img.src = e.target.result;
                        //dvPreview.appendChild(img);

                        var image = new Image();
                        image.src = e.target.result;
                        image.onload = function () {
                            if(image.width != 680 || image.height!=850)
                            {
                                alert('Image size not valid');

                                //debugger;
                                //fileBrowser.outerHTML = fileBrowser.outerHTML;
                                //$('#' + id).html($('#' + id).html());
                                fileBrowser.value = "";

                            } else {
                                image.height = "100";
                                image.width = "150";
                                //img.src = e.target.result;
                                dvPreview.appendChild(image);
                            }
                        };

                    }
                    reader.readAsDataURL(file);
                } else {
                    alert(file.name + " is not a valid image file.");
                    dvPreview.innerHTML = "";
                    return false;
                }
            }
        } else {
            alert("This browser does not support HTML10 FileReader.");
        }
    }


Powered by Blogger.