ObjectDataSource + GridView 使用方法

 
ObjectDataSource + GridView 使用方法
 

   AppCode\Class1.cs
 
   using System;
   using System.Data;
   using System.Data.SqlClient;
   using System.Text;
 
   namespace WebApplication9.App_Code
   {
      public class Class1
      {
         public static DataTable GetData()
         {
            String connectionString1 = "Data Source=.\\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI";
            SqlConnection con1 = new SqlConnection(connectionString1);
            con1.Open();
 
            StringBuilder sb = new StringBuilder();
            sb.Append("SELECT * FROM Team;");
 
            SqlDataAdapter Adapter = new SqlDataAdapter(sb.ToString(), con1);
            DataSet ds = new DataSet();
 
            Adapter.Fill(ds);
 
            ds.Tables[0].TableName = "Team";
            ds.Tables[0].Columns[0].ColumnName = "Team ID";
            ds.Tables[0].Columns[1].ColumnName = "Team Name";
            ds.Tables[0].Columns[2].ColumnName = "League ID";
 
            con1.Close();
            con1.Dispose();
 
            return ds.Tables[0];
         }
      }
   }
 

 
   註: 係 "Class1.cs" 既 Properties – Build Action 要係 "Content" , 唔係 "Compile"
 

 

   Default.aspx
 
   <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
   TypeName="WebApplication9.App_Code.Class1" SelectMethod="GetData" />
 
   <asp:GridView ID="GridView1" runat="server"
   DataSourceID="ObjectDataSource1" />