0. Use session to determine whether to log in
if(Session["login"] == null)
{
Response.Redirect("error.aspx");
}
1. Open a new window and transfer parameters:
Transmission parameters:
response.write("<script>window.open('*.aspx?id="+this.DropDownList1.SelectIndex+"&id1="+...+"')</script>")
Receive parameters:
string a = Request.QueryString("id");
string b = Request.QueryString("id1");
2. Add a dialog box to the button
Button1.Attributes.Add("onclick","return confirm('Confirm?')");
button.attributes.add("onclick","if(confirm('are you sure...?')){return true;}else{return false;}")
3. Delete selected records in the table
int intEmpID = (int)MyDataGrid.DataKeys[e.Item.ItemIndex];
string deleteCmd = "DELETE from Employee where emp_id = " + intEmpID.ToString()
4. Delete form record warning
private void DataGrid_ItemCreated(Object sender,DataGridItemEventArgs e)
{
switch(e.Item.ItemType)
{
case ListItemType.Item :
case ListItemType.AlternatingItem :
case ListItemType.EditItem:
TableCell myTableCell;
myTableCell = e.Item.Cells[14];
LinkButton myDeleteButton;
myDeleteButton = (LinkButton)myTableCell.Controls[0];
myDeleteButton.Attributes.Add("onclick","return confirm('Are you sure you want to delete this message');");
break;
default:
break;
}
}
5. Click a table row to link to another page
private void grdCustomer_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
//Click the form to open
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
e.Item.Attributes.Add("onclick","window.open('Default.aspx?id=" + e.Item.Cells[0].Text + "');");
}
Double-click the table to connect to another page in the itemDataBind event
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
string OrderItemID =e.item.cells[1].Text;
...
e.item.Attributes.Add("ondblclick", "location.href='../ShippedGrid.aspx?id=" + OrderItemID + "'");
}
Double-click the table to open a new page
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
string OrderItemID =e.item.cells[1].Text;
...
e.item.Attributes.Add("ondblclick", "open('../ShippedGrid.aspx?id=" + OrderItemID + "')");
}
★Special note: [?id=] cannot be [?id =]
6. Pass parameters in table hyperlink columns
<asp:HyperLinkColumn Target="_blank" headertext="ID number" DataTextField="id" NavigateUrl="aaa.aspx?id='<%# DataBinder.Eval(Container.DataItem, "Data Field 1")%>' & name='<%# DataBinder.Eval(Container.DataItem, "Data Field 2")%>' />
7. Click on the table to change the color
if (e.Item.ItemType == ListItemType.Item ||e.Item.ItemType == ListItemType.AlternatingItem)
{
e.Item.Attributes.Add("onclick","this.style.backgroundColor='#99cc00';this.style.color='buttontext';this.style.cursor='default';");
}
Written in _ItemDataBound of DataGrid
if (e.Item.ItemType == ListItemType.Item ||e.Item.ItemType == ListItemType.AlternatingItem)
{
e.Item.Attributes.Add("onmouseover","this.style.backgroundColor='#99cc00';this.style.color='buttontext';
this.style.cursor='default';");
e.Item.Attributes.Add("onmouseout","this.style.backgroundColor='';this.style.color='';");
}
8. About date format
Date format setting
DataFormatString="{0:yyyy-MM-dd}"
I think it should be in the itembound event
e.items.cell["your column"].text=DateTime.Parse(e.items.cell["your column"].text.ToString("yyyy-MM-dd"))
9. To obtain error information and go to the specified page, do not use Response.Redirect, but use Server.Transfer.
e.g.
// in global.asax
protected void Application_Error(Object sender, EventArgs e) {
if (Server.GetLastError() is HttpUnhandledException)
Server.Transfer("MyErrorPage.aspx");
//It's okay to leave the rest of the non-HttpUnhandledException exceptions to ASP.NET itself:)
}
Redirect will cause post-back to be generated and error information will be lost, so the page guidance should be executed directly on the server side, so that the error information can be obtained on the error handling page and processed accordingly.
10.Clear Cookies
Cookie.Expires=[DateTime];
Response.Cookies("UserName").Expires = 0
11. Custom exception handling
//Custom exception handling class
using System;
using System.Diagnostics;
namespace MyAppException
{
/// <summary>
/// Application exception handling class inherited from the system exception class ApplicationException.
/// Automatically record exception content to the application log of Windows NT/2000
/// </summary>
public class AppException:System.ApplicationException
{
publicAppException()
{
if (ApplicationConfiguration.EventLogEnabled)
LogEvent("An unknown error occurred.");
}
publicAppException(string message)
{
LogEvent(message);
}
public AppException(string message,Exception innerException)
{
LogEvent(message);
if (innerException != null)
{
LogEvent(innerException.Message);
}
}
//Logging class
using System;
using System.Configuration;
using System.Diagnostics;
using System.IO;
using System.Text;
using System.Threading;
namespace MyEventLog
{
/// <summary>
/// Event logging class, providing event logging support
/// <remarks>
/// Defines 4 logging methods (error, warning, info, trace)
/// </remarks>
/// </summary>
public class ApplicationLog
{
/// <summary>
/// Record error information to the Win2000/NT event log
/// <param name="message">Text information to be recorded</param>
/// </summary>
public static void WriteError(String message)
{
WriteLog(TraceLevel.Error, message);
}
/// <summary>
/// Record warning information to the Win2000/NT event log
/// <param name="message">Text information to be recorded</param>
/// </summary>
public static void WriteWarning(String message)
{
WriteLog(TraceLevel.Warning, message);
}
/// <summary>
/// Record the prompt information into the Win2000/NT event log
/// <param name="message">Text information to be recorded</param>
/// </summary>
public static void WriteInfo(String message)
{
WriteLog(TraceLevel.Info, message);
}
/// <summary>
/// Record tracing information to the Win2000/NT event log
/// <param name="message">Text information to be recorded</param>
/// </summary>
public static void WriteTrace(String message)
{
WriteLog(TraceLevel.Verbose, message);
}
/// <summary>
/// Format the text information format recorded to the event log
/// <param name="ex">Exception object that needs to be formatted</param>
/// <param name="catchInfo">Exception information title string.</param>
/// <retvalue>
/// <para>Formatted exception information string, including exception content and trace stack.</para>
/// </retvalue>
/// </summary>
public static String FormatException(Exception ex, String catchInfo)
{
StringBuilder strBuilder = new StringBuilder();
if (catchInfo != String.Empty)
{
strBuilder.Append(catchInfo).Append("rn");
}
strBuilder.Append(ex.Message).Append("rn").Append(ex.StackTrace);
return strBuilder.ToString();
}
/// <summary>
/// Actual event log writing method
/// <param name="level">The level of information to be recorded (error, warning, info, trace).</param>
/// <param name="messageText">Text to be recorded.</param>
/// </summary>
private static void WriteLog(TraceLevel level, String messageText)
{
try
{
EventLogEntryType LogEntryType;
switch (level)
{
case TraceLevel.Error:
LogEntryType = EventLogEntryType.Error;
break;
case TraceLevel.Warning:
LogEntryType = EventLogEntryType.Warning;
break;
case TraceLevel.Info:
LogEntryType = EventLogEntryType.Information;
break;
case TraceLevel.Verbose:
LogEntryType = EventLogEntryType.SuccessAudit;
break;
default:
LogEntryType = EventLogEntryType.SuccessAudit;
break;
}
EventLog eventLog = new EventLog("Application", ApplicationConfiguration.EventLogMachineName, ApplicationConfiguration.EventLogSourceName );
//write event log
eventLog.WriteEntry(messageText, LogEntryType);
}
catch {} //Ignore any exceptions
}
} //class ApplicationLog
}
12.Panel scrolls horizontally and automatically expands vertically
<asp:panel style="overflow-x:scroll;overflow-y:auto;"></asp:panel>
13. Convert Enter to Tab
<script language="javascript" for="document" event="onkeydown">
if(event.keyCode==13 && event.srcElement.type!='button' && event.srcElement.type!='submit' && event.srcElement.type!='reset' && event.srcElement.type!=' '&& event.srcElement.type!='textarea');
event.keyCode=9;
</script>
onkeydown="if(event.keyCode==13) event.keyCode=9"
14.DataGrid super connection column
DataNavigateUrlField="Field name" DataNavigateUrlFormatString="}"
15.DataGrid rows change color with the mouse
private void DGzf_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemType!=ListItemType.Header)
{
e.Item.Attributes.Add( "onmouseout","this.style.backgroundColor=""+e.Item.Style["BACKGROUND-COLOR"]+""");
e.Item.Attributes.Add( "onmouseover","this.style.backgroundColor=""+ "#EFF3F7"+""");
}
}
16. Template column
<ASP:TEMPLATECOLUMN visible="False" sortexpression="demo" headertext="ID">
<ITEMTEMPLATE>
<ASP:LABEL text='<%# DataBinder.Eval(Container.DataItem, "ArticleID")%>' runat="server" width="80%" id="lblColumn" />
</ITEMTEMPLATE>
</ASP:TEMPLATECOLUMN>
<ASP:TEMPLATECOLUMN headertext="check">
<HEADERSTYLE wrap="False" horizontalalign="Center"></HEADERSTYLE>
<ITEMTEMPLATE>
<ASP:CHECKBOX id="chkExport" runat="server" />
</ITEMTEMPLATE>
<EDITITEMTEMPLATE>
<ASP:CHECKBOX id="chkExportON" runat="server" enabled="true" />
</EDITITEMTEMPLATE>
</ASP:TEMPLATECOLUMN>
code behind
protected void CheckAll_CheckedChanged(object sender, System.EventArgs e)
{
//Change the selection of columns to select all or none.
CheckBox chkExport;
if(CheckAll.Checked)
{
foreach(DataGridItem oDataGridItem in MyDataGrid.Items)
{
chkExport = (CheckBox)oDataGridItem.FindControl("chkExport");
chkExport.Checked = true;
}
}
else
{
foreach(DataGridItem oDataGridItem in MyDataGrid.Items)
{
chkExport = (CheckBox)oDataGridItem.FindControl("chkExport");
chkExport.Checked = false;
}
}
}
17. Number formatting [The result of <%#Container.DataItem("price")%> is 500.0000, how to format it to 500.00?]
<%#Container.DataItem("price","{0:¥#,##0.00}")%>
int i=123456;
string s=i.ToString("###,###.00");
18.Date formatting
[In the aspx page: <%# DataBinder.Eval(Container.DataItem, "Company_Ureg_Date")%>
Displayed as: 2004-8-11 19:44:28
I just want: 2004-8-11】
<%# DataBinder.Eval(Container.DataItem,"Company_Ureg_Date","{0:yyyy-Md}")%>
How should it be changed?
[Format date]
Take it out, usually object
((DateTime)objectFromDB).ToString("yyyy-MM-dd");
[Validation expression for date]
A. The following correct input format: [2004-2-29], [2004-02-29 10:29:39 pm], [2004/12/31]
^((d{2}(([02468][048])|([13579][26]))[-/s]?((((0?[13578])|(1[ 02]))[-/s]?((0?[1-9])|([1-2][0-9])|
(3[01])))|(((0?[469])|(11))[-/s]?((0?[1-9])|([1-2][ 0-9])|(30)))|(0?2[-/s]?((0?[1-9])|([1-2][0-9]))) ))
|(d{2}(([02468][1235679])|([13579][01345789]))[-/s]?((((0?[13578])|(1[02 ]))[-/s]?((0?[1-9])|([1-2][0-9])
|(3[01])))|(((0?[469])|(11))[-/s]?((0?[1-9])|([1-2] [0-9])|(30)))|(0?2[-/s]?((0?[1-9])|(1[0-9])|(2[0 -8]))))))(s(((0?[1-9])|(1[0-2])):([0-5][0-9])(( s)|(:([0-5][0-9])s))([AM|PM|am|pm]{2,2})))?$
B. The following correct input format: [0001-12-31], [9999 09 30], [2002/03/03]
^d{4}[-/s]?((((0[13578])|(1[02]))[-/s]?(([0-2][0 -9])|(3[01])))|(((0[469])|(11))[-/s]?(([0-2][0-9])| (30)))|(02[-/s]?[0-2][0-9]))$
[Case conversion]
HttpUtility.HtmlEncode(string);
HttpUtility.HtmlDecode(string)
19. How to set global variables
Global.asax
In the Application_Start() event
Add Application[property name] = xxx;
It's your global variable
20. How to open a new window after clicking the connection generated by HyperLinkColumn?
HyperLinkColumn has an attribute Target, just set the value to "_blank". (Target="_blank")
[ASPNETMENU] Click on the menu item to pop up a new window. Add URLTarget="_blank" to the menu item in your menuData.xml file.
like:
<?xml version="1.0" encoding="GB2312"?>
<MenuData ImagesBaseURL="images/">
<MenuGroup>
<MenuItem Label="Internal parameter information" URL="Infomation.aspx" >
<MenuGroup ID="BBC">
<MenuItem Label="Announcement Information" URL="Infomation.aspx" URLTarget="_blank" LeftIcon="file.gif"/>
<MenuItem Label="Prepare information briefing" URL="NewInfo.aspx" LeftIcon="file.gif" />
...
It is best to upgrade your aspnetmenu to version 1.2
21. Commission discussion
22. Read the DataGrid control TextBox value
foreach(DataGrid dgi in yourDataGrid.Items)
{
TextBox tb = (TextBox)dgi.FindControl("yourTextBoxId");
tb.Text....
}
23. There are three template columns in the DataGrid that contain Textboxes: DG_ShuLiang (quantity), DG_DanJian (unit price), and DG_JinE (amount). They are in column 5.6.7. It is required to automatically calculate the amount when entering the quantity and unit price, that is: quantity * unit price = The amount is also required to be limited to numerical values when entered. How can I use client script to implement this function?
〖Thinking about returning〗
<asp:TemplateColumn HeaderText="Quantity">
<ItemTemplate>
<asp:TextBox id="ShuLiang" runat='server' Text='<%# DataBinder.Eval(Container.DataItem,"DG_ShuLiang")%>'
onkeyup="javascript:DoCal()"
/>
<asp:RegularExpressionValidator id="revS" runat="server" ControlToValidate="ShuLiang" ErrorMessage="must be integer" ValidationExpression="^d+$" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Unit price">
<ItemTemplate>
<asp:TextBox id="DanJian" runat='server' Text='<%# DataBinder.Eval(Container.DataItem,"DG_DanJian")%>'
onkeyup="javascript:DoCal()"
/>
<asp:RegularExpressionValidator id="revS2" runat="server" ControlToValidate="DanJian" ErrorMessage="must be numeric" ValidationExpression="^d+(.d*)?$" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Amount">
<ItemTemplate>
<asp:TextBox id="JinE" runat='server' Text='<%# DataBinder.Eval(Container.DataItem,"DG_JinE")%>' />
</ItemTemplate>
</asp:TemplateColumn>
<script language="javascript">
functionDoCal()
{
var e = event.srcElement;
var row = e.parentNode.parentNode;
var txts = row.all.tags("INPUT");
if (!txts.length || txts.length < 3)
return;
var q = txts[txts.length-3].value;
var p = txts[txts.length-2].value;
if (isNaN(q) || isNaN(p))
return;
q = parseInt(q);
p = parseFloat(p);
txts[txts.length-1].value = (q * p).toFixed(2);
}
</script>
24.When the rows at the bottom of the datagrid are selected for comparison, why does it always refresh and then scroll to the top? The rows just selected cannot be seen due to the screen.
page_load
page.smartNavigation=true
25. When modifying data in Datagrid, when the edit key is clicked, the data appears in the text box. How to control the size of the text box?
private void DataGrid1_ItemDataBound(obj sender,DataGridItemEventArgs e)
{
for(int i=0;i<e.Item.Cells.Count-1;i++)
if(e.Item.ItemType==ListItemType.EditType)
{
e.Item.Cells.Attributes.Add("Width", "80px")
}
}
26. Dialog box
private static string ScriptBegin = "<script language="JavaScript">";
private static string ScriptEnd = "</script>";
public static void ConfirmMessageBox(string PageTarget,string Content)
{
string ConfirmContent="var retvalue="/blog/window.confirm('"+Content+"');"+"if(retValue){window.location="'"+PageTarget+"';}";
ConfirmContent=ScriptBegin + ConfirmContent + ScriptEnd;
Page ParameterPage = (Page)System.Web.HttpContext.Current.Handler;
ParameterPage.RegisterStartupScript("confirm",ConfirmContent);
//Response.Write(strScript);