DataAdapter与DataSet示例演示
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.SqlClient"%><script runat="server" language="C#">
public void Page_load(object sender,EventArgs e)
{
string strConn = "server=LWF-SZAIC//IMPORTDATA;uid=sa;pwd=123;database=importdata";
SqlConnection Conn = new SqlConnection(strConn);
Conn.Open();
string strSel = "select * from usertable";
SqlDataAdapter Adapter = new SqlDataAdapter(strSel, Conn);
DataSet myDs = new DataSet();
Adapter.Fill(myDs, "usertable");
dgData.DataSource = myDs.Tables["usertable"].DefaultView;
dgData.DataBind();
}
</script>
<html xmlns=" http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DataGrid ID="dgData" runat="server"></asp:DataGrid></div>
</form>
</body>
</html>DataGrid控件:在VS2005工具箱中默认没有DataGrid控件,但有GridView控件,GridView比DataGrid控件功能更强大,如果想弄出DataGrid在工具箱中,则在工具箱中点右键"选择项",将WEBControl中的DataGrid加进去就可以了.另外:VS2005中还集成了连接(sqlconnection)、命令(sqlcommand)、数据源(Datasource)控件成新的SqlDataSource控件。更方便快捷!