动态创建表格行

 1)function AddFamilyInfo() {
             
              var tab = document.getElementById("familyTable");
              var tbd = document.createElement('TBODY');
              var row = document.createElement("TR");
              var NameTD = document.createElement("TD");
              var RelationTD = document.createElement("TD");
              var WorkUnitTD = document.createElement("TD");
              var PositionTD = document.createElement("TD");
              var FamilyAddressTD = document.createElement("TD");
              var TelTD = document.createElement("TD");
              NameTD.innerHTML ="<input type='text'/>";
              RelationTD.innerHTML ="<input type='text'/>";
              WorkUnitTD.innerHTML ="<input type='text'/>";
              PositionTD.innerHTML="<input type='text'/>";
              FamilyAddressTD.innerHTML ="<input type='text'/>";
              TelTD.innerHTML ="<input type='text'/>";
              row.appendChild(NameTD);
              row.appendChild(RelationTD);
              row.appendChild(WorkUnitTD);
              row.appendChild(PositionTD);
              row.appendChild(FamilyAddressTD);
              row.appendChild(TelTD);
              tbd.appendChild(row);
              tab.appendChild(tbd);
          }

 

2)protected DataTable CreateDataTableData(SqlDataReader dr)
    {
        DataTable dt = new DataTable();
        ///创dt的列
        foreach (DataRow row in dr.GetSchemaTable().Rows)
        {   ///需要列的名称和数据类型
            dt.Columns.Add(new DataColumn(row["ColumnName"].ToString(), (Type)row["DataType"]));
        }
        ///读取数据
        while (dr.Read())
        {   ///创建一个新行
            DataRow newrow = dt.NewRow();
            foreach (DataRow row in dr.GetSchemaTable().Rows)
            {   ///读取数据
                newrow[row["ColumnName"].ToString()] = dr[row["ColumnName"].ToString()];
            }
            ///添加新行
            dt.Rows.Add(newrow);
        }
        ///关闭读取器
        // dr.Close();
        return (dt);
    } 

3) public DataTable ExecuteBySQL(string sql)
    {
        string con = ConfigurationManager.ConnectionStrings["eHRCONNECTIONSTRING"].ConnectionString;
        SqlConnection myCon = new SqlConnection(con);
        SqlCommand myCmd = new SqlCommand(sql, myCon);
        SqlDataReader dr = null;
        DataTable dt = null;
        try
        {
            myCon.Open();
            dr = myCmd.ExecuteReader();
            dt =CreateDataTableData(dr);
            dr.Close();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
        finally
        {
            myCon.Close();
        }
        return dt;       
       
    }

4)DataTable dt =ExecuteBySQL("select psfa_relative_name,psfa_relation,psfa_company,psfa_occupation,psfa_relative_address,psfa_relative_tel from iv_person_family where ps_id='"+iv.ps_id.ToString().Trim()+"'");

5)for (int i = 0; i < dt.Rows.Count; i++)
            {
                HtmlTableRow row = new HtmlTableRow();
                for(int j=0;j<dt.Columns.Count;j++)
                {
                    HtmlTableCell cell = new HtmlTableCell();
                    TextBox tb = new TextBox();
                    tb.Text = dt.Rows[i][j].ToString();
                    cell.Controls.Add(tb);
                    row.Cells.Add(cell);
                }
                this.familyTable.Rows.Add(row);
            }