📄 dataserviceclient.aspx

📁 asp做的新闻系统

💻 ASPX

字号:

<%@ Import Namespace="DataService" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
    protected void Page_Load(Object Src, EventArgs E)
    {
        DataService d = new DataService();
        DataSet myData = d.GetTitleAuthors();

        if (!Page.IsPostBack)
        {
            Authors_DataGrid.DataSource=myData.Tables["Authors"].DefaultView;
            Authors_DataGrid.DataBind();
        }
        Message.InnerHtml = "行数为：" + 
myData.Tables["Authors"].Rows.Count.ToString();
    }
    protected void Submit_DataSet(Object Src, EventArgs E)
    {
       DataService d = new DataService();
       DataSet myData = d.GetTitleAuthors();
        myData.Tables["Authors"].Rows.RemoveAt(0);
        myData.Tables["Authors"].Rows.RemoveAt(1);
        myData.Tables["Authors"].Rows.RemoveAt(2);
        int rowCount = d.PutTitleAuthors(myData);
        Message.InnerHtml = "修改的行数为：" + rowCount.ToString();

        Authors_DataGrid.DataSource=myData.Tables["Authors"].DefaultView;
        Authors_DataGrid.DataBind();
    }
</script>
<body style="font: 10.5pt 宋体">
  <h4>对 Web 服务使用数据访问</h4>
  <form runat="server">
      <input type="submit" OnServerclick="Submit_DataSet" value="从数据集中移除三行" runat="server"/>
      <p>
      <span id="Message" runat="server"/>
      <p>
      <ASP:DataGrid id="Authors_DataGrid" runat="server"
        Width="700"
        BackColor="#ccccff"
        BorderColor="black"
        ShowFooter="false"
        CellPadding=3
        CellSpacing="0"
        Font-Name="Verdana"
        Font-Size="8pt"
        HeaderStyle-BackColor="#aaaadd"
        EnableViewState="false"
      />
    </form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -