推荐订阅源

1   数据访问层获得数据表

public DataSet GetBraData()

         {    SqlCommand command = new SqlCommand(); 
              command.CommandText = "GetBraInf";
              command.Connection = con;
              command.CommandType = CommandType.StoredProcedure;
              commandAdp.SelectCommand = command;
              DataSet data = new DataSet();
              commandAdp.Fill(data);
              return data;
         }
2   业务逻辑层对数据访问层访问

public DataTable GetBraTB()  
         {
              DataTable table ;          
              MrBranch BraAccess = new MrBranch();//实例化数据访问层的类
              {
                  table = BraAccess.GetBraData().Tables[0]；//调用该类的方法
              }
             return table;
         }
3   WEB层绑定数据表
         private void Page_Load(object sender, System.EventArgs e)
         {
              if(!Page.IsPostBack)
              {
                   DataBind();
              }    
         }
         public DataTable BraTB
         {
              get
              {
                   return (new Branch()).GetBraTB();
              }
         }
4     在HTML中将其绑定到数据源表    DataSource= "<%# BraTB >"      DataKeyField="branchid"
通过字段值重定向到 新的页面
dataGrid添加一超级连接列，设定URL,   和URL格式字符串 如:EmpArchive.aspx?ArcID={0}