Hi I am having problems making the update datagrid property working. It still uses the old value, and I have followed the example in "ASP.NET in three weeks" and it won't work... here is my code:

firs the cs code behind:

PHP Code:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb; 

namespace WebApplication12
{
    /// <summary>
    /// Summary description for WebForm1.
    /// </summary>
    public class WebForm1 : System.Web.UI.Page
    {
        protected System.Data.DataSet ds;
        protected System.Web.UI.WebControls.DataGrid DataGrid1;
    
        private void Page_Load(object sender, System.EventArgs e)
        {
            
            
            if(!Page.IsPostBack )
            {
            
                BindData(); 
            }
        }

        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }
        
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {    
            this.ds = new System.Data.DataSet();
            ((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
            this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
            this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
            this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
            // 
            // ds
            // 
            this.ds.DataSetName = "ds";
            this.ds.Locale = new System.Globalization.CultureInfo("sv-SE");
            this.Load += new System.EventHandler(this.Page_Load);
            ((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();

        }
        #endregion

        public void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            DataGrid1.EditItemIndex = e.Item.ItemIndex;
            BindData();
        }

        public void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            DataGrid1.EditItemIndex = -1;
            BindData();
        }

        public void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            ds.AcceptChanges(); 
 
            DataGrid1.DataSource = ds; 

            BindData(); 
             
        }

        public void BindData()
        {
            OleDbConnection myConn = new OleDbConnection("Provider=SQLOLEDB;data source=4647117000N26;initial catalog=Northwind;persist security info=False;user id=logger;password=logger;workstation id=WS1321;packet size=4096"); 
            string sqlQuery = "SELECT * FROM Customers";
            
            //DataSet ds = new DataSet(); 
            OleDbDataAdapter objCmd = new OleDbDataAdapter(sqlQuery,myConn);
            OleDbCommandBuilder cmdB = new OleDbCommandBuilder(objCmd);      
            objCmd.Fill(ds, "Customers");
            DataGrid1.DataSource = ds;
            Page.DataBind(); 
        }
    }
} 
And then there is my aspx page

PHP Code:
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="WebApplication12.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>WebForm1</title>
        <meta name="GENERATOR" Content="Microsoft Visual Studio 7.0">
        <meta name="CODE_LANGUAGE" Content="C#">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        <form id="Form1" method="post" runat="server">
            <asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 149px; POSITION: absolute; TOP: 95px" runat="server" Width="627px" Height="428px" AutoGenerateColumns="False" OnEditCommand="DataGrid1_EditCommand" OnUpdateCommand="DataGrid1_UpdateCommand" OnCancelCommand="DataGrid1_CancelCommand" DataSource="<%# ds %>">
                <AlternatingItemStyle BackColor="#C0C0FF"></AlternatingItemStyle>
                <Columns>
                    <asp:BoundColumn DataField="CustomerID" HeaderText="Kund-ID"></asp:BoundColumn>
                    <asp:BoundColumn DataField="ContactName" HeaderText="Namn"></asp:BoundColumn>
                    <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Uppdatera" HeaderText="Ändra" CancelText="Avbryt" EditText="Ändra"></asp:EditCommandColumn>
                </Columns>
            </asp:DataGrid>
        </form>
    </body>
</HTML> 
This is C# syntax, but the pricipal is the same in vb.net.
I am pretty sure I do something wrong in the update event, but I am not sure what to do really. I want to make the changes to my dataset and then use an OLEDBCOMMANDBUILDER object to update the database with the changes made to the local dataset. Then I want to update the datagrid with the new data...


HEEELP!

kind regards
Henrik