高考问答社保查询密码是几位数:那位编程高手能帮我把下面的代码补全呀？
来源：百度文库 编辑：高考问答 时间：2024/05/03 05:45:05
<UpdataInfo Date="06/04/04"/>
<AddInfo>
<AddRecord ID=543456>
<Fields>
<Name>Name</Name>
<Type>Char</Type>
<Value>王小兵</Value>
</Fields>
<Fields>
<Name>Age</Name>
<Type>Integer</Type>
<Value>24</Value>
</Fields>
....
</AddRecord>
....
</AddInfo>
<ModifyRecord ID=257886>
<Fields>
<Name>Name</Name>
<Type>Char</Type>
<OldValue>张三</OldValue>
<NewValue>李四</NewValue>
</Fields>
<Fields>
....
</ModifyInfo>
<DeleteRecord ID=563821>
<DeleteRecord ID=436535>
....
</DeleteInfo>
</UpdateInfo>
还有：在ASP.NET里，要达到数据更新的目的，下面各个按钮的代码怎么写呀？急要!按钮如下：修改、删除、取消、新增、提交的代码怎么写呀？要和XML关联起来。如：新增的代码如下：XmlDocumet uddoc＝newXmlDocument（）；uddocLoad（update.xml）；XmlNodeList addRecList＝uddoc GetEelmentsByTagName("AddRecord");String name,type,value;
.....
}
}
--和XML关联
DataSet ds = new DataSet();
DataBindToDataGrid
{
ds.ReadXml("你的XML文件路径");
dgUserInfo.DataSource = ds;
dgUserInfo.DataBind();
}
如果按钮已绑定事件,绑定事件方法实现如下:
---修改:
private void dgUserInfo_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.dgUserInfo.EditItemIndex=e.Item.ItemIndex;
this.DataBindToDataGrid();
}
--取消:
private void dgUserInfo_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.dgUserInfo.EditItemIndex=-1;
this.DataBindToDataGrid();
}
--提交:
private void dgUserInfo_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string uId=this.dgUserInfo.DataKeys[e.Item.ItemIndex].ToString();
string uName=((TextBox)(e.Item.Cells[1].Controls[0])).Text.Trim();
....
SqlConnection conn=DB.CreateDB();
conn.Open();
SqlCommand updateCmd=new SqlCommand("update Users SET UserName=@userName,...",conn);
updateCmd.Parameters.Add("@userId",SqlDbType.Int,4);
...
updateCmd.ExecuteNonQuery();
this.dgUserInfo.EditItemIndex=-1;
this.DataBindToDataGrid();
}
--删除:
private void dgUserInfo_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlConnection conn=DB.CreateDB();
conn.Open();
SqlCommand deleteCmd=new SqlCommand("delete from Users where UserId=@UserId",conn);
deleteCmd.Parameters.Add("@UserId",SqlDbType.Int,4);
deleteCmd.Parameters["@UserId"].Value=this.dgUserInfo.DataKeys[(int)e.Item.ItemIndex];
deleteCmd.ExecuteNonQuery();
this.DataBindToDataGrid();
}
--新增
DataRow dr = ds.NewRow();
dr.Add("", );//将控件里的值插入到数据集中
...
//保存到XML
XmlDataDocument doc = new XmlDataDocument(ds);
myXml.Document = doc;
doc.Save("您要保存的路径和文件名");
我现在没有装.NET,没有测试了,错误难免.