grid.aspx

来自「visual studio.net学习资料」· ASPX 代码 · 共 48 行

ASPX
48 行
字号 
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<HTML>
<body>
<SCRIPT language="C#" runat="Server"> 
void Page_Load(object src , EventArgs E) 
{
   DataSet ds;
   SqlConnection conn;
   SqlDataAdapter cmdAuthors;
   DataView dv;

   //create a connection to the Pubs database    
   //conn = new SqlConnection("data source=(local);uid=sa;pwd=;initial catalog=pubs;integrated security=SSPI;persist security info=True");
   //data source=SHA-SHIGAO-VS7\\NETSDK;initial catalog=Northwind;
   conn = new SqlConnection("data source=(local);initial catalog=pubs;integrated security=SSPI;persist security info=True");

   //create a dataset with information from the authors table
   cmdAuthors = new SqlDataAdapter("select * from Authors", conn);
   ds = new DataSet();
   cmdAuthors.Fill(ds, "Authors");

   //bind the first datagrid to the DefaultView of the dataset
   dv = ds.Tables["Authors"].DefaultView;
   dgAuthors.DataSource = dv;
   dgAuthors.DataBind();

   //create a new DataView that is authors from California
   //and bind the second datagrid to it
   dv = new DataView(ds.Tables["Authors"]);
   dv.RowFilter = "state = 'CA'";
   dgCAAuthors.DataSource = dv;
   dgCAAuthors.DataBind();

}
		</SCRIPT>
		<h2>
			All Authors
		</h2>
		<ASP:DataGrid id="dgAuthors" runat="server" Width="700" BackColor="#ccccff" BorderColor="black" ShowFooter="false" CellPadding="3" CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" />
		<H2>
			California Authors
		</H2>
		<ASP:DataGrid id="dgCAAuthors" runat="server" />
	</body>
</HTML>

grid.aspx - 源码说明

本页面展示了「visual studio.net学习资料」中的 grid.aspx 源码文件，采用 ASPX 编程语言编写，共 48 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与Visual Studio.NET相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?