Asp.net,C#.net,Sql Srver problems and solutions Blog

How to fetch database records dynamically on browser page scroll down using jQuery AJAX and ASP.Net.                Source from : http://aspsnippets.com/Articles/Load-data-while-Scrolling-Page-down-with-jQuery-AJAX-and-ASPNet.aspx http://www.codeproject.com/Tips/345388/Load-data-dynamically-on-page-scroll-using-jQuery http://code.msdn.microsoft.com/Load-large-dataset-with-2fc4ab56 http://aspsnippets.com/demos/382/ http://forums.asp.net/p/1891071/5334891.aspx?Re+In+webmatrix+Load+DB+Data+while+page+Scrolling+Page+Down http://aspsnippets.com/Articles/Load-on-demand-data-in-GridView-on-scroll-using-ASPNet-and-jQuery-AJAX.aspx

Here is the nice article explain how to highlight gridview rows when checkbox is checked or selected in asp.net using JQuery . Previous Post  I was Explained about the    jQuery - Allow Alphanumeric (Alphabets & Numbers) Characters in Textbox using JavaScript  ,  Fileupload show selected file in label when file selected  ,  Check for file size with JavaScript before uploading ,   Show jQuery UI Dialog Popup Window from Server Side ( Code Behind ) in ASP.Net ,   How to use the window.open()  method  ,   CONFIRMATION BOX WITH YES NO BUTTONS USING AJAX MODAL POPUP EXTENDER IN ASP.NET Refer source from :  http://www.aspdotnet-suresh.com/2012/09/highlight-aspnet-gridview-row-when.html

To implement context menu in asp.net Gridview row , add this code on rowdatabound. Please copy this code and paste in code behind class: Previously I was Explained about the   How to remove rows from GridView using jQuery in asp.net , Nested GridView in ASP.NET Using c# with show/hide ,  How to Add a Locked Header Row to an ASP.NET GridView Control ,  How to remove rows from GridView using jQuery in asp.net   Protected Sub Grd_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles Grd.RowDataBound If e.Row.RowType = DataControlRowType.DataRow Then e.Row.Attributes.Add("oncontextmenu", "return ShowMenu(" + e.Row.RowIndex.ToString() + ")") RowIndex = e.Row.RowIndex End If End Sub To popup the context menu, paste this code in header <script language="javascript" type="text/javascript"> var Div = document.getElementById("DivContextMenu"); function...

Repeater Vs. DataList vs. ListView Vs. GridView Previously I was Explained about the  Difference between Convert.tostring and .tostring() method Example  ,   Reasons to use Twitter Bootstrap   If you look under Data tab on Visual Studio Toolbox, you can see several controls that could be used to display data from some data source, like database or XML file. Standard ASP.NET data presentation controls are:   - DataList,   - DetailsView,   - FormView,   - GridView,   - ListView and   - Repeater. Every of these controls could be used to display data. Logical question is, why ASP.NET offers so many controls for same task? What are differences between these controls and most important, when to use each of them?   We can divide data presentation controls into two main groups. First group consists of DetailsView and FormView control. These two controls can only show individual record a...

How to Add a Locked Header Row to an ASP.NET GridView Control : The GridView control is often used to display tabular data, much like an Excel spreadsheet. However, unlike Excel, the GridView control doesn't have any automatic way of locking the header row so that it doesn't scroll out of view. Previously I was Explained about the  How to remove rows from GridView using jQuery in asp.net , Nested GridView in ASP.NET Using c# with show/hide  . Check out this example of a GridView within a DIV with the overflow-Y property set to scroll . Notice that as you scroll the GridView, the header row scrolls out of view. It would be more convenient to have a locked header row so that the header row is always visible regardless of the scoll position of the GridView. It would also be nice to have a header row that dynamically configured itself as per the data source so that if we add a new field to the GridView, a corresponding column automatically gets added to the l...

Hovermenuextender not working in google chrome with Inside Gridview I faced problem with  Hovermenuextender not showing in Google chrome  with inside the gridview  but it was working in firefox . Problem : When working Hovermenuextender with two gridviews please maintain the distinct ids for Hovermenuextender . If the two Hovermenuextender have the same ids it will appear .

In this post, I will show you how to remove any row in gridview using jQuery. The task is pretty simple. One need to bind the click event with every tr which has only td not th and on click of event remove the clicked row.  Previous Post  I was Explained about the    jQuery - Allow Alphanumeric (Alphabets & Numbers) Characters in Textbox using JavaScript  ,  Fileupload show selected file in label when file selected  ,  Check for file size with JavaScript before uploading ,   Show jQuery UI Dialog Popup Window from Server Side ( Code Behind ) in ASP.Net ,   How to use the window.open()  method  ,   CONFIRMATION BOX WITH YES NO BUTTONS USING AJAX MODAL POPUP EXTENDER IN ASP.NET See below jQuery code. $(document).ready( function () {    $( "#<%=gdRows.ClientID%> tr:has(td)" ).click( function () {       $( this ).remove();    }); }); ...

In this post I will explain about How  to open in new tab or window in Asp.net gridview This is the simplest way to add hyperlink to gridview Previous Post  I was Explained about the   Nested GridView in ASP.NET Using c# with show/hide     jQuery - Allow Alphanumeric (Alphabets & Numbers) Characters in Textbox using JavaScript  ,  Fileupload show selected file in label when file selected  ,  Check for file size with JavaScript before uploading  ,   Asp.Net AjaxFileUpload Control With Drag Drop And Progress Bar . Sample Gridview  <asp:gridview ID="bookslist" runat="server"> <Columns> <asp:TemplateField  ItemStyle- horizontalAlign="Center"> <ItemTemplate> <asp:HyperLink id="lnkDetails" runat="server" Target="_blank" NavigateUrl="~/BookDetail.aspx">Details</asp:HyperLink> </ItemTemplate> <asp:TemplateField> </Columns> </asp:gridview > <a href...

In This example shows how to create Nested GridView In Asp.Net Using C# And VB.NET With Expand Collapse Functionality. Previous post I was Explained about the   ASP.NET e-Commerce website GridView with Product Listing  ,  How To Export gridview data to Excel/PDF , CSV Formates in asp.net C# , Sending Email from Asp.net With Dynamic Content  ,  SQL Server- Case Sensitive Search in SQL Server I have used JavaScript to Create Expandable Collapsible Effect by displaying Plus Minus image buttons. Customers and Orders Table of Northwind Database are used to populate nested GridViews. Drag and place SqlDataSource from toolbox on aspx page and configure and choose it as datasource from smart tags Go to HTML source of page and add 2 TemplateField in <Columns>, one as first column and one as last column of gridview. Place another grid in last templateField column. Markup of page after adding both templatefields will like as shown below. HT...

Introduction: Here I will explain how to export Gridview to Word or Excel ,PDF ,CSV Formats using asp.net in c#. Description: I have one gridview that has filled with user details now I need to export gridview data to word or excel document based on selection. To implement this functionality first we need to design aspx page like this  In Previous Post I was Explained about the How To- Search records or data in gridview using jQuery  , Sqldatasource Filterexpression example in asp.net, Asp.net GridView Sorting example: How to sort GridView Data Categories: Asp.net   , Gridview   <% @   Page   Language ="C#"   AspCompat ="true"   AutoEventWireup ="true"   CodeFile ="TestWebPage.aspx.cs" ValidateRequest ="false"   Inherits ="TestWebPage"   %> DOCTYPE   html   PUBLIC   "-//W3C//DTD XHTML 1.0 Transitiona...