<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication70._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body>
<h2>初次使用dataset viewsonic</h2>
<form id="form1" runat="server">
<div>
UK Employee:4
<asp:Label id="lb1" Text ="" runat ="server" ></asp:Label>
<br />
<asp:DataGrid ID ="dguk" runat ="server" ></asp:DataGrid>
UK Employee:5
<asp:Label id="lb2" Text ="" runat ="server" ></asp:Label>
<br />
<asp:DataGrid ID ="dgusa" runat ="server" ></asp:DataGrid>
</div>
</form>
</body>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
namespace WebApplication70
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
String strconnection = "Server=.;database=class;integrated security=true;";
SqlConnection objconnection = new SqlConnection(strconnection);
String sqlstr = "SELECT * FROM student";
SqlDataAdapter objadapter = new SqlDataAdapter(sqlstr ,strconnection );
DataSet objdataset = new DataSet();
objadapter.Fill(objdataset ,"dgclass");
DataTable dgclass = objdataset.Tables["dgclass"];
DataView uk = new DataView(dgclass );
uk.RowFilter = "number=5";
DataView USA = new DataView(dgclass);
USA.RowFilter = "number=6";
lb1.Text = uk.Count.ToString();
dguk.DataSource = uk;
lb2.Text = USA.Count.ToString();
dgusa.DataSource = USA;
Page.DataBind();
}
}
}