看C#的笔记----一般网站还是C#简单

( ⊙ 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#时候做的小后台--------------------------------------------

----------------------------即将过时的话语-----------------------------------------------------------------------

//等考完了，哈哈哈哈，哼哼，(*^__^*) 嘻嘻……