Creating a scrollable datagrid ...

xiaoxiao2021-03-06  69

Place a DataGrid, or Any Other Control Or Set of Controls, WITHIN A SCROLLABLE REGON YOUR .NET Web Forms.

By: John Kilgo Date: November 23, 2003 Download The Code.

Printer Friendly Version

There are many times when it is inconvenient or unattractive to have a datagrid or other set of controls longer than the displayable page in the browser. I would prefer the user not to have to scroll the entire page if possible.

THERE IS A WAY OF ANYTHING THIS Does NOTHIN ANETHING AT All to do with .net. It actually has to do with using a style attribute within a

tag. While this is not a .Net Technique, IT May Prove To be very useful to you in your .NET programming The tag takes the form:
. The Width and Height styles allow you to determine the size of the . scrollable region The 760px and 570px shown above are just what I used for the example program you can make them whatever you need them to be The OVERFLOW-Y:.. scroll tells the browser to scroll the div vertically All you have to do. is place a table of objects, or a single object such as a datagrid within the DIV and it will be scrollable. you will be able to see this for yourself if you run the example program available at the bottom of this page, and / or Download The Sample Code.

The Example .aspx file (ScrollingGrid.aspx), Which Demonstrates The Technique Is Shown Below.

! <% @ Page Language = "vb" AutoEventWireup = "false" Codebehind = "ScrollingGrid.aspx.vb" Inherits = "DotNetJohn.ScrollingGrid"%> scrollinggrid </ title> <meta name =" generator "content =" Microsoft Visual Studio .NET 7.1> <meta name = "code_language" content = "Visual Basic .NET 7.1 "> <meta name = vs_defaultClientScript content =" JavaScript "> <meta name = vs_targetSchema content =" http://schemas.microsoft.com/intellisense/ie5 "> </ HEAD> <body MS_POSITIONING =" GridLayout "> <form ID = "form1" method = "post" runat = "server"> <table border = "1" bgcolor = "# eeeeee" style = "width: 780px; height: 580px"> <tr> <TD align = "Center ""> Northwind Customers </ TD> <TD> <TD> <div sty = "overflow-y: scroll; width: 760px; height: 570px"> <table bgcolor = "# ffffff"> <tr> <td> < ASP: DATAGRID ID = "DTGCUSTS" runat = "server" bordercolor = "# 999999" BorderStyle = "none" borderwidth = "1px" backc Olor = "white" Cellpadding = "3" Gridlines = "Vertical"> <AlternatingItemStyle BackColor = "# DCDCDC"> </ alternatingItemStyle> <itemStyle Forecolor = "Black" backcolor =</p> <p>"#Eeeeee"> </ itemStyle> <headerstyle font-bold = "true" forcolor = "white" backcolor = "# 000084> </ headerstyle> </ asp: datagrid> </ td> </ tr> </ Table> </ div> </ td> </ tr> </ table> </ form> </ body> </ html> The .aspx.vb file, Which Just Binds The DataGrid to a DataReader from The Northwind Customers Table IS Shown Below.</p> <p>Imports System.DataImports System.Data.SqlClientImports System.ConfigurationPublic Class ScrollingGrid Inherits System.Web.UI.Page '- Web Form Designer Generated Code Omitted - Private Sub Page_Load (ByVal sender As System.Object, ByVal e As System.EventArgs ) Handles MyBase.Load Dim strSql As String = "Select CustomerID, CompanyName, ContactName, Phone, Fax From Customers" Dim objConn As New SqlConnection (ConfigurationSettings.AppSettings ( "NorthwindConnection")) Dim objCmd As New SqlCommand (strSql, objConn) Try objConn.Open () dtgCusts.DataSource = objCmd.ExecuteReader () dtgCusts.DataBind () Catch ex As SqlException Response.Write (ex.ToString) Finally objCmd.Dispose () objConn.Dispose () End Try End SubEnd Class</p> <p>I Hope You Will Find this Technique Useful in Your .Net Programming.You May Run The Program Here.you May Download The Code Here.</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-110040.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>) </div><div></div></div></div><ul class="postlist list-unstyled"> </ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="110040" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved </div><div class="col text-right">Processed: <b>0.050</b>, SQL: <b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script> var debug = DEBUG = 0; var url_rewrite_on = 1; var url_path = './'; var forumarr = {"1":"Tech"}; var fid = 1; var uid = 0; var gid = 0; xn.options.water_image_url = 'view/img/water-small.png'; </script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script> var forum_url = 'list-1.html'; var safe_token = 'RsfpCmypKmM_2Bxfct3aGW6C670Loxok0NR6LAg3JrUkfDyliZDXoh5Fzj0yFTLjQHtjbPpjZvCVviqx1L'; var body = $('body'); body.on('submit', '#form', function() { var jthis = $(this); var jsubmit = jthis.find('#submit'); jthis.reset(); jsubmit.button('loading'); var postdata = jthis.serializeObject(); $.xpost(jthis.attr('action'), postdata, function(code, message) { if(code == 0) { location.reload(); } else { $.alert(message); jsubmit.button('reset'); } }); return false; }); function resize_image() { var jmessagelist = $('div.message'); var first_width = jmessagelist.width(); jmessagelist.each(function() { var jdiv = $(this); var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width(); var jmessage_width = Math.min(jdiv.width(), maxwidth); jdiv.find('img, embed, iframe, video').each(function() { var jimg = $(this); var img_width = this.org_width; var img_height = this.org_height; if(!img_width) { var img_width = jimg.attr('width'); var img_height = jimg.attr('height'); this.org_width = img_width; this.org_height = img_height; } if(img_width > jmessage_width) { if(this.tagName == 'IMG') { jimg.width(jmessage_width); jimg.css('height', 'auto'); jimg.css('cursor', 'pointer'); jimg.on('click', function() { }); } else { jimg.width(jmessage_width); var height = (img_height / img_width) * jimg.width(); jimg.height(height); } } }); }); } function resize_table() { $('div.message').each(function() { var jdiv = $(this); jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>'); }); } $(function() { resize_image(); resize_table(); $(window).on('resize', resize_image); }); var jmessage = $('#message'); jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); }); jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); }); $('#nav li[data-active="fid-1"]').addClass('active'); </script>