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();