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.093</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 = 'pUJlIqaxt8m1zZsXlrThOpgPjJy2JpPqeg83tHKw46YsafT3WI9LDFwTg5pOo2rwIbMOhGf8SIQTnfcA';
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>
