C#编程之绑定数据到DataGrid控件

发布时间:2020-10-10编辑:脚本学堂
本文分享一例asp.net代码(c#版),实现绑定数据到DataGrid控件,有需要的朋友参考下吧。

asp.net绑定数据到DataGrid控件。
代码:
 

复制代码 代码示例:

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="C#" runat="server">
void Page_Load(object sender, EventArgs e)
{
  OleDbConnection objConnection;
  OleDbDataAdapter objCommand; 
  string strConnect;
  string strCommand;
  DataSet DataSet1 = new DataSet();
 
  strConnect =  @"Provider=Microsoft.Jet.OLEDB.4.0;";
  //If you don't have the EmployeeDatabase.mdb database, then you will have to
  //change the following three lines to a different database
 
  strConnect += @"Data Source=" + MapPath("EmployeeDatabase.mdb;");
 
  strConnect += "Persist Security Info=False";

  strCommand = "SELECT FirstName, LastName FROM Employee";
  objConnection = new OleDbConnection(strConnect);
  objCommand = new OleDbDataAdapter(strCommand, objConnection);
  objCommand.Fill(DataSet1, "Employee");
  DataGrid1.DataSource=DataSet1.Tables["Employee"].DefaultView;
  DataGrid1.DataBind();
}
</script>
<html>
<head>
<title>Data Grid Control控件的例子-www.jb200.com</title>
</head>
<body>
<asp:DataGrid id="DataGrid1" runat="server"  />
</body>
</html>