DataGrid Update

Hi,
I have this code for my DataGrid_Update where in I am trying to update a field, which is kind of acting up, as it is urgent if someone can take a lokk at it i will really appreciate it.

Thanks,

Here is the whole code.

      private void Page_Load(object sender, System.EventArgs e)
            {
                  DateTime DtDate = new DateTime();
                  DtDate = DateTime.Now;
                  FText.Value = DtDate.ToShortDateString();
                  TText.Value = DtDate.AddDays(13).ToShortDateString();
            }

            #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.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_Cancel);
                  this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_Edit);
                  this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_Update);
                  this.Load += new System.EventHandler(this.Page_Load);

            }
            #endregion

            public void GetRecs_Click(object sender, System.EventArgs e)
            {
                  BindData();
            }

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

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

            private void DataGrid1_Select(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
            {
                  Label2.Text +=DataGrid1.SelectedItem.Cells[0].Text;
                  //BindData();
            }

            private void DataGrid1_Update(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
            {
                  string StrConnection;
                  System.Web.UI.WebControls.TextBox cName = new System.Web.UI.WebControls.TextBox();
                  cName = (System.Web.UI.WebControls.TextBox)e.Item.Cells[6].Controls[0];
StrConnection = "Password=xxx;Persist Security Info=True;User ID=sa;Initial Catalog=Duc;Data Source=SQL001";
                  SqlConnection myConnection = new SqlConnection(StrConnection);
                  SqlCommand myCommand = new SqlCommand("SP_UpdateQty", myConnection);
                  myCommand.CommandType = CommandType.StoredProcedure;
//                  myCommand.Parameters.Add(new SqlParameter("@product", SqlDbType.VarChar,20));
//                  myCommand.Parameters["@product"].Value = cName.Text;
//                  myCommand.Parameters.Add(new SqlParameter("@harvest_date", SqlDbType.DateTime,8));
//                  myCommand.Parameters["@harvest_date"].Value = cName.Text;
//                  myCommand.Parameters.Add(new SqlParameter("@prod_size", SqlDbType.Int,4));
//                  myCommand.Parameters["@prod_size"].Value = cName.Text;
            myCommand.Parameters.Add(new SqlParameter("@quantity", SqlDbType.Int,4));
                  myCommand.Parameters["@quantity"].Value = cName.Text;
                  myConnection.Open();
                  myCommand.ExecuteNonQuery();
                  myConnection.Close();
                  DataGrid1.EditItemIndex = -1;
                  BindData();
            }

            public void BindData()
            {
                  string StrConnection;
string selectCmd = "select * from harvest1 where quantity > 0 and product = @product and harvest_Date Between @FText and @TText";

StrConnection = "Password=xxx;Persist Security Info=True;User ID=sa;Initial Catalog=Duc;Data Source=SQL001";
                  SqlDataAdapter myCommand = new SqlDataAdapter(selectCmd, StrConnection);

      myCommand.SelectCommand.Parameters.Add(new SqlParameter("@product", SqlDbType.VarChar, 20));
                  myCommand.SelectCommand.Parameters["@product"].Value = MySelect.Value;

      myCommand.SelectCommand.Parameters.Add(new SqlParameter("@FText", SqlDbType.SmallDateTime, 8));
                  myCommand.SelectCommand.Parameters["@FText"].Value = FText.Value;

      myCommand.SelectCommand.Parameters.Add(new SqlParameter("@TText", SqlDbType.SmallDateTime, 8));
                  myCommand.SelectCommand.Parameters["@TText"].Value = TText.Value;

                  DataSet ds = new DataSet();
                  myCommand.Fill(ds, "Harvest1");

                  DataGrid1.DataSource = ds.Tables["Harvest1"].DefaultView;
                  DataGrid1.DataBind();

            }