( ⊙ o ⊙ )啊!数电实在看不下去,把之前看C#的一点总结贴出来吧,权当最简单的复习了,那时候还自己做了个小东西,也算是比较完整的后台了,感兴趣的话,可以翻到最下面,O(∩_∩)O~
---------------------------------------------这里是总结---------------------------------------------------
1、在aspx文件中添加namespace语句:
<%@ Import Namespace="System.Data" %>
2、foreach 语句示例
1: foreach(DataRow row in MsgDataSet.Tables["MsgDataSet"].Rows)
2:
3: {
4:
5: string id = row["id"].ToString();
6:
7: string name = row["name"].ToString();
8:
9: string posttime = row["posttime"].ToString();
10:
11: string postcontent = row["postcontent"].ToString();
12:
13: string replytime =row["replytime"].ToString();
14:
15: string replycontent =row["replycontent"].ToString();
16:
17: }
3、快捷单值绑定
由 <%=name %> 发布于 <%=posttime %><span class="reply_button"><a href="Default.aspx?id=<%=id %>">回复</a></span>
4、get、set访问器
1: DataSet msgDataSet = new DataSet();
2:
3: public DataSet MsgDataSet
4:
5: {
6:
7: set { this.msgDataSet=value; }
8:
9: get { return this.msgDataSet; }
10:
11: }
5、sql 语句表名列名等用[]括起
SqlCommand command = new SqlCommand("SELECT * FROM [msg]",cn);
6、时间格式国际化
1: string replytime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", DateTimeFormatInfo.InvariantInfo);
2:
3: //注意引入 using System.Globalization;
7、SQLServer连接字符串
1: string conn = @"uid=sa;pwd=123456;Server=MZULE-PC/MZULE;Database=msgol";
2:
3: SqlConnection cn = new SqlConnection(conn);
4:
5: //@表示此字符串不计转义字符。
8、Cookie 的使用
1: //新建 Cookie:
2:
3: HttpCookie errorMsgCookie = new HttpCookie("ErrorMsg");
4:
5: errorMsgCookie.Values.Add("msg",ex.Message);
6:
7: Response.Cookies.Add(errorMsgCookie);
8:
9: //获取 Cookie:
10:
11: HttpCookie cookie = Request.Cookies["ErrorMsg"];
12:
13: if (cookie != null)
14:
15: {
16:
17: string msg = cookie.Values["msg"];
18:
19: MsgInfo.Text = msg;
20:
21: }
9、SQLServer 中的分页查询
SELECT TOP 3 * FROM [msg] WHERE [id] NOT IN (SELECT TOP " + 3 * (pageNum - 1) + " [id] FROM [msg]
10、js 正则分析URL
1: var url = window.location.href;
2:
3: var es = /page=/;
4:
5: es.exec(url);
6:
7: var res = RegExp.rightContext;
11、利用js提交数据,是否就可以省去后台的验证?
12、避免点击超链接页面回滚
1: <a href="javascript:jumpPage(1)" id="firstPage" >第一页</a>
2:
3: <a href="javascript:prePageClick()" id="prePage" >上一页</a>
4:
5: <a href="javascript:nextPageClick()" id="nextPage" >下一页</a>
6:
7: <a href="javascript:jumpPage(<%=TotalPages %>)" id="lastPage" >最后一页</a>
8:
9: <a href="javascript:showReply()">我要留言</a>
13、C# 的Repeater 控件
1: <asp:Repeater ID="Repeater" runat="server" DataSourceID="LinQRe">
2:
3: <ItemTemplate>
4:
5: <div><%#Eval("name") %><br /><%#Eval("posttime") %></div>
6:
7: </ItemTemplate>
8:
9: </asp:Repeater>
10:
11: <asp:LinqDataSource ID="LinQRe" runat="server"
12:
13: ContextTypeName="HelloYourName.UserDataContext" EntityTypeName=""
14:
15: TableName="msg">
16:
17: </asp:LinqDataSource>
14、ASP.NET 内建验证机制
1: <asp:TextBox ID="TbCategory" runat="server" ValidationGroup="CategoryNotNull"></asp:TextBox>
2:
3: <asp:Button ID="BtnSubmitCategory" runat="server" Text="创建" ValidationGroup="CategoryNotNull" OnClick="BtnSubmitCategory_Click" />
4:
5: <asp:Button ID="BtnListAllCategory" runat="server" Text="显示所有分类" OnClick="BtnListAllCategory_Click" />
6:
7: <asp:RequiredFieldValidator ID="TbCategoryRequire" runat="server"
8:
9: ErrorMessage="新建类别不能为空" ControlToValidate="TbCategory" ValidationGroup="CategoryNotNull" >
10:
11: </asp:RequiredFieldValidator>
15、GridView 中的 HyperLinkField
1: <asp:HyperLinkField Text="查看该分类所有文章" DataNavigateUrlFields="id"
2:
3: DataNavigateUrlFormatString="NewsDetails.aspx?id={0}"/>
16、Repeater 空间的使用
1: <!--aspx 文件中:-->
2:
3: <asp:Repeater ID="RptNewsTitle" runat="server">
4:
5: <ItemTemplate>
6:
7: <div><a href="NewsDetails.aspx?id=<%# DataBinder.Eval(Container.DataItem,"id") %>"><%# DataBinder.Eval(Container.DataItem,"title")%></a></div>
8:
9: </ItemTemplate>
10:
11: </asp:Repeater>
1: //cs 文件中:
2:
3: NewsDataContext newsDtx = new NewsDataContext();
4:
5: var newstitles = from n in newsDtx.News where n.categoryid == cid select n;
6:
7: RptNewsTitle.DataSource = newstitles;
8:
9: RptNewsTitle.DataBind();
17、获取修改之后的TextBox 的内容
如果总是无法完成修改这一操作,可以再 protected void Page_Load(object sender, EventArgs e) 内容里面加上 if (!IsPostBack) 判断。
18、LINQ上一页、下一页
1: private int NextPageID()
2:
3: {
4:
5: NewsDataContext n = new NewsDataContext();
6:
7: var anew = (from m in n.News where m.id > GetId() select m.id).Take(1);
8:
9: foreach (var i in anew)
10:
11: {
12:
13: return i;
14:
15: }
16:
17: return -1;
18:
19: }
20:
21:
22:
23: private int PrePageID()
24:
25: {
26:
27: NewsDataContext n = new NewsDataContext();
28:
29: var anew = (from m in n.News where m.id < GetId() orderby m.id descending select m.id).Take(1);
30:
31: foreach (var i in anew)
32:
33: {
34:
35: return i;
36:
37: }
38:
39: return -1;
40:
41: }
---------------------------------看C#时候做的小后台--------------------------------------------
----------------------------即将过时的话语-----------------------------------------------------------------------
//等考完了,哈哈哈哈,哼哼,(*^__^*) 嘻嘻……