ASP and ASP.NET (DataGrid) to implement data lists [source code]

zhaozj2021-02-16  152

Photo Simple list </ title> < Meta http-equiv = "content-type" content = "text / html; charSet = GB2312"> <style> td {font-size: 14px; font-family: coier new} </ style> </ head></p> <p><Body bgcolor = "# f7f7f7"></p> <p><table align = center cellspacing = "1" cellpadding = "1" border = "0" style = "background-color: # 7b7f7c; width: 90%;"> <tr sty = "CURSOR: Default; color: white; Height: 22px; "> <TD> Photo Description [<font color = # ffcc00> Double click on a row Open photo </ font>] </ td> <td> Upload </ td> <td> time </ td> < / TR> <% set conn = server.createObject ("adoDb.connection") connStr = "........" conn.open connStrdim Descriptionsql = "Select Description, Addtime, IMGTYPE, IMGMAINNAME, UPLOADER from Photo Order BY ID DESC "SET RS = Server.createObject (" AdoDb.Recordset ") RS.Open SQL, CONN, 0, 1WHILE NOT RS.EOF Description = RS (" Description) = "" "" "" "" " "NO File Description" end if img = rs ("imgmainname") & "." & Rs ("IMGTYPE") response.write "<tr sty =" "CURSOR: HAND; Background-Color: # f5f5f3; height: 22px ; "" οnmοuseοver = "" javascript: this.style.backgroundColor = '# DADBD6' "" οnmοuseοut = "" javascript: this.style.backgroundColor = '# F5F5F3' "" οndblclick = "" window.open ( 'photo / "& img &"); ""> <TD> "& Description &" </ TD> <TD> "&" "UPLoader") & "</ td> <TD>" & _ RS ("Addtime") & "</ td> </ tr>" rs.movenextwendrs.closset = nothingconn.closset conn = Nothing%> </ table> </ body> </ html></p> <p><! - asp.net page simpleshow.aspx -> <% @ page language = "c #" codebehind = "simpleshow.aspx.cs" autoeventwireup = "false" inherits = "imgshow.simpleshow" codepage = "936"%% > <! DOCTYPE HTML PUBLIC "- // W3C // DTD HTML 4.0 Transitional // En"> <html> <head> <title> Photo Simple list </ title> <form runat = "server"> <meta http- Equiv = "Content-Type" Content = "text / html; charSet = GB2312"> <style> TD {font-size: 14px; font-family: coier new}. Headstyle {Cursor: default; color: white; height: h 22px} .Istyle {Cursor: Hand; Height: 22px; Background-Color: # f5f5f3} .dataGrid1 {Width: 90%; Background-Color: # 7b7f7c} </ stop> </ head> <body bgcolor = #f7f7f7 "> <ASP: DATAGRID id =" DataGrid1 "runat =" server "cellpadding =" 1 "cellspacing =" 1 "cssclass =" DataGrid1 "borderwidth =" 0px "horizontalalign =" Center "autogeneratecolumns =" ​​False "enableviewstate =" False > <ItemStyle CssClass = "ItemStyle"> </ itemStyle> <headerstyle cssclass = "headstyle"> </ headersty> <footerstyle forecolor = "black" backcolor = "# c6c3c6"> </ footerStyle> <col Umns> <ask: BoundColumn> <asp: boundcolumn> <asp: boundcolumn> <asp: boundcolumn> <asp: boundcolumn> </ ask: BoundColumn> </ columns> </ asp: datagrid> </ form> < / Body> </ html></p> <p><-! ASP.NET page simpleshow.aspx.cs -> using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState Using system.Web.ui; use system.web.ui.webcontrols; using system.web.ui.htmlcontrols; Namespace Imgshow {//// <summary> /// simpleshow summary description. /// </ summary> public class simpleshow: System.Web.UI.Page {protected System.Data.OleDb.OleDbConnection conn; protected System.Data.OleDb.OleDbCommand cmd; protected System.Web.UI.WebControls.DataGrid DataGrid1 Private void page_load (object sender, system.eventargs e) {// Place the user code here to initialize the page if (! Ispostback) {conn.connectionstring = "User ID =; data source = /" / "; initial Catalog =; Provider = / "SQLOLEDB.1 /"; PassWord = "; conn.Open (); System.Data.OleDb.OleDbDataReader Reader; Reader = cmd.ExecuteReader (); DataGrid1.DataSource = Reader; DataGrid1.AutoGenerateColumns = false DataGrid1.columns [0] .Headertext = "Photo Description [<font color = /" # ffcc00 / "> Double click on a row to open the photo </ font>]"; DataGrid1.columns [1] .Headertext = "Upload"; DataGrid1.columns [2] .Headertext = "Time"; DataGrid1.Database (); Reader.close (); Conn.Close ();}</p> <p>#Region Web Form Designer Generated Code Override Protected Void OnNit (Eventargs E) {// // Codegen: This call is required for the ASP.NET Web Form Designer. // InitializeComponent (); base.onit (e);} /// <summary> /// Designer Supports the required method - Do not use the code editor to modify the // / this method. /// </ summary> private void initializecomponent () {this.conn = new system.data.oledb.oledbconnection (); this.cmd = new system.data.oledb.oledbcommand (); // // cmd // this.cmd.CommandText = "SELECT description, addtime, imgType, imgmainName, uploader FROM photo ORDER BY i" "d DESC"; this.cmd.Connection = this.conn; this.DataGrid1.ItemDataBound = new System.Web .Ui.WebControls.DataGriditeMeventhandler (this.DataGrid1_itemdatabase; this.Load = new system.eventhandler (this.page_load);} #ENDREGION</p> <p>private void DataGrid1_ItemDataBound (object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) {ListItemType itemType = e.Item.ItemType; if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType .Alternating design = DataBinder.eval (E.Item.DataItem, "description"). TOSTRING (). Trim (); if (description == ") {description =" no file description ";} string IMG = DataBinder.eval (E.Item.DataItem, "ImgmainName"). TOSTRING (). Trim () "." DataBinder.eval (E.Item.DataItem, "IMGTYPE"). Tostring (). Trim () E.Item.attributes.add ("onmouseover", "this.style.backroundcolor = '# DADBD6'"); E.Item.ttributes.add ("onmouseout", "this.style.backgroundcolor = '# f5f5f3' "); E.Item.attributes.add (" OnDBLClick "," Window.Open ('PHOTO / " IMG "); "); E.Item.cells [0] .Text = Server.htmlencode (Description) E.Item.cells [1] .Text = Server.htmlencode (DataM.DataItem, "UPLoader"). Tostring (). Trim ()); E.Item.cells [2] .text = DataBinder.eval (E.Item.DataItem, "Addtime", "{0: YYYY-MM-DD HH: MM}"). TOSTRING (). Trim ();}}}}</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-8598.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="8598" 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.039</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 = 'q0jF_2B_2B_2Bb72l1EJcEYL1eMNepA1RFWKanaQZzoJQ_2BG1cA7oHbeTP1nw24h3rZckTPMGOwovMiZkxBRVVi60nZlg_3D_3D'; 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>