DataGrid example

xiaoxiao2021-03-06  70

Webform1.aspx The following is the program code:

code:

<% @ Page language = "c #" codebehind = "Webform1.aspx.cs" autoeventwireup = "false" inherits = "tayesample.webform1"%>%>

<% @ Register tagprefix = "cc1" namespace = "WebControllibrary1" assembly = "WebControlLibrary1"%>

Webform1 </ Title></p> <p><meta content = "Microsoft Visual Studio .NET 7.1" Name = "Generator"></p> <p><meta content = "c #" Name = "code_language"></p> <p><meta content = "javascript" name = "vs_defaultclientscript"></p> <p><meta content = "</p> <p>http://schemas.microsoft.com/intellisense/ie5 "name =" vs_targetschema "></p> <p></ HEAD></p> <p><body></p> <p><form id = "form1" method = "post" runat = "server"></p> <p><ask: DATAGRID ID = "DataGrid1" runat = "server" bordercolor = "# e7e7ff" borderstyle = "none" borderwidth = "1px"</p> <p>Backcolor = "white" cellpadding = "3" gridlines = "horizontal" autogeneratecolumns = "false" datakeyfield = "job_id"</p> <p>PageSize = "5" allowpaging = "true"></p> <p><Selecteditemstyle font-bold = "true" forcolor = "# f7f7f7" backcolor = "# 738a9c"> </ selecteditedItemStyle></p> <p><AlternatingItemStyle BackColor = "# f7f7f7"> </ alternatingItemStyle></p> <p><ItemStyle Forecolor = "# 4a3c8c" backcolor = "# e7e7ff"> </ itemstyle></p> <p><Headerstyle font-bold = "true" forcolor = "# f7f7f7" backcolor = "# 4a3c8c"> </ headerstyle> <footerStyle Forecolor = "# 4a3c8c" backcolor = "# b5c7de"> </ footerStyle></p> <p><Columns></p> <p><asp: templatecolumn headerText = "Serial number"></p> <p><Itemtemplate></p> <p><% # (DataGrid1.pageSize * DataGrid1.currentPageIndex) Container.Index 1%></p> <p></ Itemtemplate></p> <p></ asp: templateColumn></p> <p><ask: boundcolumn datafield = "job_id" readonly = "true" Headertext = "job_id"> </ asp: boundcolumn></p> <p><asp: boundcolumn datafield = "job_desc" Headertext = "job_desc"> </ asp: boundcolumn></p> <p><asp: boundcolumn datafield = "max_lvl" Headertext = "max_lvl"> </ asp: boundcolumn></p> <p><asp: boundcolumn datafield = "min_lvl" Headertext = "min_lvl"> </ asp: boundcolumn></p> <p><asp: editcommandcolumn buttonType = "LinkButton" UpdateText = "update" HeaderText = "Edit" CancelText = "Cancel" EditText = "Edit"> </ asp: editcommandcolumn></p> <p><asp: buttoncolumn text = "Remove" Headertext = "COMMANDNAME =" Delete "> </ asp: buttoncolumn></p> <p><asp: hyperlinkcolumn text = "Details" Headertext = "Details"> </ asp: hyperlinkcolumn></p> <p></ Columns></p> <p><Pagerstyle Horizontalalign = "Right" Forecolor = "# 4a3c8c" backcolor = "# e7e7ff" mode = "numersticpages"> </ pageerstyle></p> <p></ asp: datagrid> </ form></p> <p></ body></p> <p></ Html></p> <p>Postcod Webform1.aspx.cs</p> <p>code:</p> <p>Using system;</p> <p>Using system.collections;</p> <p>Using system.componentmodel; using system.data;</p> <p>Using system.drawing;</p> <p>Using system.Web;</p> <p>Using system.Web.SessionState;</p> <p>Using system.Web.ui;</p> <p>Using system.Web.ui.webcontrols;</p> <p>Using system.Web.ui.htmlcontrols;</p> <p>Using system.data.sqlclient;</p> <p>Namespace Tayesample</p> <p>{</p> <p>/// <summary></p> <p>/// WebForm1 summary description.</p> <p>/// </ summary></p> <p>Public class Webform1: System.Web.ui.page</p> <p>{</p> <p>Protected system.web.ui.webcontrols.dataGrid DataGrid1;</p> <p>Private SqlConnection CN = New SqlConnection ("Server = (local); Database = Pubs; UID = SA; PWD =");</p> <p>Private Void Page_Load (Object Sender, System.EventArgs E)</p> <p>{</p> <p>/ / Place the user code here to initialize the page</p> <p>IF (! ispostback)</p> <p>{</p> <p>Bind ();</p> <p>}</p> <p>}</p> <p>#Region web form designer generated code</p> <p>Override protected void oninit (Eventargs E)</p> <p>{</p> <p>//</p> <p>// Codegen: This call is necessary for the ASP.NET Web Form Designer.</p> <p>//</p> <p>InitializationComponent ();</p> <p>Base.onit (E);</p> <p>}</p> <p>/// <summary></p> <p>/// Designer supports the required method - do not use the code editor to modify</p> <p>/// This method is content.</p> <p>/// </ summary></p> <p>Private vidinitiRizeComponent ()</p> <p>{</p> <p>This.DataGrid1.pageIndexchanged = new system.web.ui.WebControls.DataGridPageChangeDeventhandler (this.DataGrid1_pageIndexchanged);</p> <p>This.DataGrid1.cancelcommand = new system.Web.ui.WebControls.DataGridCommandeventHandler (this.DataGrid1_cancelcommand);</p> <p>This.DataGrid1.editcommand = new system.web.ui.webcontrols.dataGridCommandeventHandler (this.DataGrid1_editCommand);</p> <p>This.DataGrid1.updateCommand = new system.web.ui.webcontrols.dataGridCommandeventHandler (this.DataGrid1_updateCommand);</p> <p>This.DataGrid1.deleteCommand = new system.web.ui.webcontrols.DataGridCommandeventHandler (this.DataGrid1_deleteCommand);</p> <p>This.DataGrid1.itemdatabase.DataGriditeMeventHndler (THISDATAGRID1_ITEMDATABOUND);</p> <p>This.Load = new system.eventhandler (this.page_load);</p> <p>#ndregion</p> <p>//</p> <p>// data binding</p> <p>//</p> <p>Private void bind ()</p> <p>{</p> <p>String selstr = "SELECT * from Jobs";</p> <p>SqldataAdapter Sqlda = New SqldataAdapter (Selstr, CN);</p> <p>DataSet DS = New DataSet ();</p> <p>Sqlda.fill (DS);</p> <p>THIS.DATAGRID1.DATASOURCE = DS;</p> <p>THIS.DATAGRID1.DATABIND ();</p> <p>}</p> <p>//</p> <p>// Add confirm and onmouseout onmouseover event</p> <p>//</p> <p>Private void DataGrid1_itemdatabase (Object Sender, DataGriditeMeventArgs E)</p> <p>{</p> <p>IF (E.Item.ItemType == ListItemType.Item || E.Item.ItemType == ListItemType.alternatingItem)</p> <p>{</p> <p>LinkButton Delbttn = (LinkButton) E.Item.cells [6] .controls [0];</p> <p>Delbttn.attributes.add ("onclick", "JavaScript: Return Confirm ('OK Delete" E.Item.cells [0] .Text ");");</p> <p>E.Item.attributes.add ("onmouseover", "this.style.BackgroundColor = '# f3f3f3'");</p> <p>IF (E.Item.ItemType == ListItemType.Item)</p> <p>{</p> <p>E.Item.attributes.add ("onmouseout", "this.style.BackgroundColor = '# e7e7ff'");</p> <p>}</p> <p>IF (E.Item.ItemType == ListItemType.alternatingItem)</p> <p>{</p> <p>E.Item.attributes.add ("onmouseout", "this.style.BackgroundColor = '# f7f7f7');</p> <p>}</p> <p>}</p> <p>}</p> <p>//</p> <p>// Edit</p> <p>//</p> <p>Private void DataGrid1_EditCommand (Object Source, DataGridCommandeventArgs E)</p> <p>{</p> <p>This.dataGrid1.edititeMindex = E.Item.itemindex;</p> <p>THIS.BIND ();</p> <p>}</p> <p>//</p> <p>// cancel</p> <p>//</p> <p>Private void DataGrid1_cancelcommand (Object Source, DataGridCommandeventArgs E)</p> <p>{</p> <p>THIS.DATAGRID1.EDITITEMINDEX = -1;</p> <p>THIS.BIND ();</p> <p>}</p> <p>//</p> <p>// Delete</p> <p>//</p> <p>Private void DataGrid1_DeleteCommand (Object Source, DataGridCommandeventArgs E)</p> <p>{</p> <p>String delstr = "delete from jobs where job_id = @ Job_ID";</p> <p>Sqlcommand sqlcmd = new SQLCOMMAND (DELSTR, CN); Sqlcmd.Parameters.Add ("@ Job_ID", SqldbType.smallint, 2);</p> <p>Sqlcmd.parameters ["@ Job_ID"]. value = this.dataGrid1.datakeys [E.Item.ItemIndex];</p> <p>Try</p> <p>{</p> <p>Cn.open ();</p> <p>Sqlcmd.executenon query ();</p> <p>Cn.close ();</p> <p>IF (! page.isstartupscriptregistered ("delasert")))</p> <p>{</p> <p>Page.RegisterStartupScript ("delelert", @ "<script language = 'javascript'> Alert ('Delete Success'); </ script>");</p> <p>}</p> <p>Bind ();</p> <p>}</p> <p>Catch (Exception Err)</p> <p>{</p> <p>Response.write (Err.Message);</p> <p>}</p> <p>Finally</p> <p>{</p> <p>IF (cn.state == connectionState.Open)</p> <p>{</p> <p>Cn.close ();</p> <p>}</p> <p>}</p> <p>}</p> <p>//</p> <p>// Page</p> <p>//</p> <p>Private Void DataGrid1_pageIndexchanged (Object Source, DataGridPageChangeDeventargs E)</p> <p>{</p> <p>This.DataGrid1.currentpageIndex = E.NewpageIndex;</p> <p>Bind ();</p> <p>}</p> <p>//</p> <p>// Update</p> <p>//</p> <p>Private void DataGrid1_UpdateCommand (Object Source, DataGridCommandeventArgs E)</p> <p>{</p> <p>String UpStr = "Update Jobs Set Job_DESC = @ Job_Desc, Max_LVL = @ MAX_LVL, Min_LVL = @ min_lvl where job_id = @ Job_ID";</p> <p>SQLCommand Upcmd = New SQLCOMMAND (UpStr, CN);</p> <p>Upcmd.Parameters.Add ("@ Job_Desc", SqldbType.varchar, 50);</p> <p>Upcmd.Parameters.Add ("@ max_lvl", sqldbtype.tinyint, 1);</p> <p>Upcmd.Parameters.Add ("@ min_lvl", sqldbtype.tinyint, 1);</p> <p>Upcmd.Parameters.Add ("@ Job_ID", SqldbType.smallint, 2);</p> <p>Upcmd.parameters [0] .Value = ((TextBox) E.Item.cells [2] .controls [0]). Text;</p> <p>Upcmd.parameters [1] .Value = ((TextBox) E.Item.cells [3] .controls [0]).</p> <p>Upcmd.parameters [2] .value = ((TextBox) E.Item.cells [4] .controls [0]).</p> <p>Upcmd.Parameters [3] .value = this.dataGrid1.datakeys [E.Item.itemindex];</p> <p>Try</p> <p>{</p> <p>Cn.open ();</p> <p>Upcmd.executenonquery ();</p> <p>Cn.close (); if (! Page.isstartupscriptregister ("uPalert"))</p> <p>{</p> <p>Page.RegisterStartupScript ("Upalert", @ "<script language = 'javascript'> Alert ('Update Success') </ script>");</p> <p>}</p> <p>THIS.DATAGRID1.EDITITEMINDEX = -1;</p> <p>Bind ();</p> <p>}</p> <p>Catch (Exception Err)</p> <p>{</p> <p>Response.write (Err.Message);</p> <p>}</p> <p>Finally</p> <p>{</p> <p>IF (cn.state == connectionState.Open)</p> <p>{</p> <p>Cn.close ();</p> <p>}</p> <p>}</p> <p>}</p> <p>}</p> <p>}</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-119991.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="119991" 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.033</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 = 'z1248_2ByiILKt6CyqtUrxh7QvQW7_2F_2BbMZUlGH5OgLk90XbBDmBLzdrJW6aunOEaAKEey3V9KOd7a9ZO7z'; 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>