ASP.NET2003中DataGrid中的增,删,修改功能代码,越详细越好!急!!!

答案：
</Columns>
<asp:TemplateColumn HeaderText="余额">
  <ItemTemplate>
    <asp:Label runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Balance","{0:c}") %>'>
    </asp:Label>
  </ItemTemplate>
  <EditItemTemplate>
    <asp:TextBox runat="server" ID="Balance" Width="60" Text='<%# DataBinder.Eval(Container, "DataItem.Balance") %>'>
    </asp:TextBox>    
  </EditItemTemplate>
</asp:TemplateColumn>
<asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="取消" EditText="编辑">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:EditCommandColumn>
</Columns>

.cs部分
private void Datagrid1_UpdateCommand(object source,System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string temp2= ((TextBox) e.Item.FindControl("Balance")).Text.Trim();

if(temp2.Trim()=="") 
temp2="0";

string key=Datagrid1.DataKeys[e.Item.ItemIndex].ToString(); 
string myQuery="UPDATE [T_Item] SET [Balance]=@1 WHERE [ID]='"+key+"'"; 

SqlConnection myConnection = new SqlConnection(myCS);

SqlCommand myCommand= new SqlCommand(myQuery,myConnection);
myConnection.Open();
myCommand.Parameters.Add("@1", SqlDbType.Money); 
myCommand.Parameters[0].Value =temp2;

myCommand.ExecuteNonQuery();
myConnection.Close(); 
this.Datagrid1.EditItemIndex = -1; 
Bind(); 
}
private void Datagrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.Datagrid1.EditItemIndex = e.Item.ItemIndex; 
Bind();
}

private void Datagrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.Datagrid1.EditItemIndex = -1; 
Bind(); 
}

上一个：谁有<ASP.NET信息管理系统开发实例导航>(c#)书中的代码？急需
下一个：asp.net鎶ラ敊锛氭帶浠跺寘鍚唬鐮佸潡(鍗?<% ... %>),鍥犳鏃犳硶淇敼鎺т欢闆嗗悎銆?- 宸茶В鍐?- 鎼滄悳闂棶