grid单元格编辑后能执行保存但无法重新绑定数据，无法刷... - FineUI 官方论坛

页面代码：
<x:PageManager ID="PageManager1" runat="server" />
<x:Grid ID="Grid1" ShowBorder="true" ShowHeader="true" Title="课程管理" Width="800px" Height="465px"
runat="server" DataKeyNames="c_Id" AllowCellEditing="true" EnableColumnLines="true" ClicksToEdit="2" EnableRowNumber="True" OnRowCommand="Grid1_RowCommand" AllowPaging="True" OnPageIndexChange="Grid1_PageIndexChange" PageSize="15">
<Toolbars>
<x:Toolbar ID="Toolbar1" runat="server" >
<Items>
<x:Button ID="btnNew" Text="新增数据" Icon="Add" EnablePostBack="false" runat="server">
</x:Button>
<x:ToolbarFill ID="ToolbarFill1" runat="server">
</x:ToolbarFill>
</Items>
</x:Toolbar>
</Toolbars>
<Columns>
<x:RenderField ColumnID="course_Name" Width="200px" DataField="course_Name" FieldType="String"
HeaderText="课程">
<Editor>
<x:TextBox ID="tbxEditorName" Required="true" runat="server">
</x:TextBox>
</Editor>
</x:RenderField>
<x:RenderField ExpandUnusedSpace="true" ColumnID="course_Desc" DataField="course_Desc" FieldType="String"
HeaderText="课程备注">
<Editor>
<x:TextBox ID="tbxEditorDesc" runat="server">
</x:TextBox>
</Editor>
</x:RenderField>
<x:LinkButtonField HeaderText="删除" Width="50px" ConfirmText="你确定要这么做么？"
CommandName="Delete" Icon="Delete" ConfirmTarget="Parent" />
</Columns>
</x:Grid>
<x:Button runat="server" ID="btnSave" Text="保存数据" OnClick="btnSave_click"></x:Button>
后台代码：
public partial class admin_a_CourseManage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
InitInsert();
BindGrid();
}
}
private void BindGrid()
{
DataTable table = DALCourse.dtList();
Grid1.DataSource = table;
Grid1.DataBind();
}
//点击新增一条显示数据
private void InitInsert()
{
JObject defaultObj = new JObject();
defaultObj.Add("course_Name", "请输入课程名称");
defaultObj.Add("course_Desc", "描述");
// 第一行新增一条数据
btnNew.OnClientClick = Grid1.GetAddNewRecordReference(defaultObj,false);
}
//数据保存
protected void btnSave_click(object sender, EventArgs e)
{
Dictionary<int, Dictionary<string, string>> modifiedDict = Grid1.GetModifiedDict();
for (int i = 0, count = Grid1.Rows.Count; i < count; i++)
{
if (modifiedDict.ContainsKey(i))
{
Dictionary<string, string> rowDict = modifiedDict[i];
string id = Grid1.Rows[i].DataKeys[0].ToString();
string courseName = "", courseDesc = "";
if (rowDict.ContainsKey("course_Name"))
{
courseName = rowDict["course_Name"];
}
else
{
courseName = Grid1.Rows[i].Values[0];
}
if (rowDict.ContainsKey("course_Desc"))
{
courseDesc = rowDict["course_Desc"];
}
else
{
courseDesc = Grid1.Rows[i].Values[1];
}
DALCourse.update(courseName, courseDesc, id);
}
}
// 2. 再新增数据
List<Dictionary<string, string>> newAddedList = Grid1.GetNewAddedList();
for (int i = newAddedList.Count - 1; i >= 0; i--)
{
DALCourse.Insert(newAddedList[i]["course_Name"], newAddedList[i]["course_Desc"]);
}
BindGrid();
Alert.Show("数据保存成功");
}
//行命令--删除
protected void Grid1_RowCommand(object sender, FineUI.GridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string id = Grid1.Rows[e.RowIndex].DataKeys[0].ToString();
DALCourse.Delete(id);
BindGrid();
Alert.ShowInParent("删除数据成功!");
}
}
//分页
protected void Grid1_PageIndexChange(object sender, FineUI.GridPageEventArgs e)
{
Grid1.PageIndex = e.NewPageIndex;
}
}
DALCourse类中的更新代码(update 方法)：
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="courseName">课程名称</param>
/// <param name="courseDesc">课程描述</param>
/// <param name="id"></param>
public static void update(string courseName, string courseDesc,object id)
{
string sql = "update t_course set <A href="mailto:course_Name=@courseName,course_Desc=@courseDesc">course_Name=@courseName,course_Desc=@courseDesc</A> where <A href="mailto:c_Id=@id">c_Id=@id</A>";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@courseName", courseName),
new SqlParameter("@courseDesc", courseDesc) ,
new SqlParameter("@id", id)
};
helper.Exexute(sql, paras);
}

复制代码