1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class Manager_Message : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if (!Page.IsPostBack) ...{
18
19            BindMessage();
20        
21        }
22    }
23    protected void BindMessage() ...{
24
25        MessageDataList.DataSource = SqlHelper.ExcuteReadApdater("sys_SelectMessage", CommandType.StoredProcedure, null);
26        MessageDataList.DataKeyField = "Id";
27        MessageDataList.DataBind();
28    
29    }
30    protected string SubInput(string strInput) ...{
31
32        if (strInput.Length > 6)
33        ...{
34            strInput = strInput.Substring(0, 6);
35
36        }
37        return strInput;
38
39    }
40    protected void MessageDataList_DeleteCommand(object source, DataListCommandEventArgs e)
41    ...{
42        int nId = int.Parse(MessageDataList.DataKeys[e.Item.ItemIndex].ToString());
43        SqlParameter[] paras =...{ new SqlParameter("Id", SqlDbType.Int, 4) };
44        paras[0].Value = nId;
45        SqlHelper.ExcuteNonQurey("DELETE FROM [Message] WHERE Id=@Id", CommandType.StoredProcedure, paras);
46        BindMessage();
47    }
48}
49