Hierarchy 的主从表绑定 和 update 主从表数据

protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

    {

        string str = "select * from Users" ;

        DataTable dt = AspnetDbConnector .GenerateDataTable(str);

        RadGrid1.DataSource = dt;

    }

    protected void RadGrid1_detaildata(object sender, GridDetailTableDataBindEventArgs e)

{

// 从 GridDetailTable 获取 GridDataItem 的 item 标示

        GridDataItem dataItem = (GridDataItem )e.DetailTableView.ParentItem;

// 得到主表的 userId

  string userId = dataItem.OwnerTableView.Items[dataItem.ItemIndex].GetDataKeyValue("userId" ).ToString();

        string str2 = "select * from TeamUser where userId='" + userId + "'" ;

        DataTable dt2 = AspnetDbConnector .GenerateDataTable(str2);

        e.DetailTableView.DataSource = dt2;

 

       

    }

 

    protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)

{

// 判断事件是来自主表还是从表

        if (e.Item.OwnerTableView.Name=="Master" )

        {

            string userId = e.Item.OwnerTableView.Items[e.Item.ItemIndex].GetDataKeyValue("userId" ).ToString();

            TextBox tb = (TextBox ) e.Item.FindControl("tb1" );

            string loginname = tb.Text;

 

            string updateSql1 = "update Users set loginname='" + loginname + "' where userId='" + userId + "'" ;

            AspnetDbConnector .runSql(updateSql1);

        }

        else if (e.Item.OwnerTableView.Name=="Detail" )

        {

            string teamuserId = e.Item.OwnerTableView.Items[e.Item.ItemIndex].GetDataKeyValue("teamuserId" ).ToString();