ASP.NET database programming fast entry technology

xiaoxiao2021-03-30  193

ASP.NET 2.0 and data Access ASP.NET 2.0 provides us with improved data access modes, which reduces the amount of code required to perform data binding in ASP.NET 1.x. First, there is no need to program the implementation of an instance, setting attribute, and a method of calling the ADO object in the aforementioned list. What you need to do is simply adding a server-side control on the page and sets the properties. When presenting the page, ASP.NET 2.0 will automatically perform all object instantiations, and call methods to create and display data. Contrast the following ASP.NET 2.0 code with the above code: demo </ title> </ head> <body> <form id = "form1" runat = "server"> <asp: SqlDataSource ID = "SqlDataSource1" Runat = "server" SelectCommand = "SELECT au_lname FROM authors WHERE (state = @state)" ConnectionString = "Server = HPSERV; Integrated Security = True; Database = pubs"> <SelectParameters> <asp: Parameter Type = "String" DefaultValue = "CA" Name = "state" /> </ SelectParameters> </ asp: SqlDataSource> <asp: BulletedList ID = "BulletedList1" runat = "server" DataSourceID = "SqlDataSource1" DATEXTFIELD = "AU_LNAME"> </ asp: bulletEDList> </ form> </ body> </ html> second improvement comes from server-side controls that are sensitive to events in page survival. ASP.NET 2.0 server-side control can make the correct action at the correct time. Note Any reference to events in the page survival in the ASP.NET 2.0 page. Students with early versions of ASP generally feel confused, especially data bindings. Therefore, many ASP.NET 1.x pages will have this to make programmers to write code, that is, call DATABIND in the wrong event, or call DataBind multiple times in multiple events. These timing operations can now be powered by server-side data controls from ASP.NET 2.0. Note that two server-side controls are used in the previous ASP.NET 2.0 code. The first is a data source control, and this example is a SqlDataSource control.</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-130610.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="130610" 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.035</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 = 'EwZbTY3PuWQYQJnDIftifxONxcPYd50Ng7nJsyG1kqDap_2FfNSKvRSHMt5LfxahkkGy6GFGRczEO3WXtnI5pP2w_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>