LinkButton Update does not work in DataGrid RSS

• • Reply
  

  istvan

  Member

  2 Points

  2 Posts

  LinkButton Update does not work in DataGrid

  Mar 03, 2012 11:06 AM|LINK

  I have an editable DataGrid with an EditCommandColumn  (asp .net c# mysql):
  

  <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" CancelText="Cancel" EditText="Edit" Visible="True"></asp:EditCommandColumn>
  <asp:ButtonColumn Text="Delete" CommandName="Delete"></asp:ButtonColumn>
  

  The problem is that after a row goes into edit mode by clicking Edit button in DataGrid , the Update button does not work, does not send the values in database and does not cancel the edit mode of the row. Only the Cancel button closes the edit mode without to update the database.  The browser does not return any error message. What would cause this and how do I fix it?

  Also is a button, not in DataGrid, to send some values in database , this button works:
  <asp:Button ID="Button1" runat="server" Text="Submit" onserverclick="Button1_Click" EnableViewState="True" />
  

  • Moved by tmorton on Mar 04, 2012 07:29 PM
• • Reply
  

  asheejtk

  Participant

  1114 Points

  200 Posts

  Re: LinkButton Update does not work in DataGrid

  Mar 03, 2012 12:04 PM|LINK

  Hi,

  You should have some code under ItemsGrid_Update event to update the data,

  void ItemsGrid_Update(Object sender, DataGridCommandEventArgs e)
  {
  //Update code
  }

  Please refer MSDN for sample code: http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.editcommandcolumn.aspx

  Regards,
  Asheej T K
  
  Dotnet Galaxy
  • Edited by asheejtk on Mar 03, 2012 12:04 PM
  • Marked as answer by peter pi - msft on Mar 09, 2012 08:03 AM
• • Reply
  

  istvan

  Member

  2 Points

  2 Posts

  Re: LinkButton Update does not work in DataGrid

  Mar 03, 2012 12:42 PM|LINK

  Hi asheejtk,

  Yes I have  for Update event the below code:

  private void InitializeComponent()
          {
              .............................
              
  this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
              ..........................
              
  this.Load += new System.EventHandler(this.Page_Load);
          }
  
          private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
          {
              try
              {
                  int cUsrID;
                  int cUsrKundennr;
                  string strTyp;
                  string strArt;
                  string strMarke;
                  string strModell;
                  int cUsrBaujahr;
                  int cUsrKilometerstand;
                  int cUsrTuren;
                  int cUsrPreis;
                  int cUsrLeistung;
                  Literal ltID;
                  TextBox txtTempKundennr;
                  TextBox txtTempTyp;
                  TextBox txtTempArt;
                  TextBox txtTempMarke;
                  TextBox txtTempModell;
                  TextBox txtTempBaujahr;
                  TextBox txtTempKilometerstand;
                  TextBox txtTempTuren;
                  TextBox txtTempPreis;
                  TextBox txtTempLeistung;
                  TextBox txtTempKraftstoff;
                  TextBox txtTempGetriebe;
                  TextBox txtTempBeschreibung;
                  TextBox txtTempAirbag;
                  CheckBox txtTempAbs;
                  CheckBox txtTempAllrad;
                  CheckBox txtTempEsp;
                  CheckBox txtTempEinparkhilfe;
  
  ............................
  
                  ltID = (System.Web.UI.WebControls.Literal)e.Item.Cells[0].FindControl("Label");
                  cUsrID = Convert.ToInt32(ltID.Text);
                  txtTempKundennr = (System.Web.UI.WebControls.TextBox)e.Item.Cells[1].FindControl("TextBox1");
                  string strKundennr = txtTempKundennr.Text;
                  cUsrKundennr = Convert.ToInt32(strKundennr);
                  txtTempTyp = (System.Web.UI.WebControls.TextBox)e.Item.Cells[2].FindControl("Textbox2");
                  strTyp = txtTempTyp.Text;
                  txtTempArt = (System.Web.UI.WebControls.TextBox)e.Item.Cells[3].FindControl("Textbox15");
                  txtTempAbs = (System.Web.UI.WebControls.CheckBox)e.Item.Cells[15].FindControl("CheckBox1");
                  if (txtTempAbs.Checked)
                  {
                      cUsrAbs = 1;
                  }
                  txtTempAllrad = (System.Web.UI.WebControls.CheckBox)e.Item.Cells[16].FindControl("CheckBox2");
  
  
  ....................................
  
  UpdateInfo(cUsrID, cUsrKundennr, strTyp, strArt, strMarke, strModell, cUsrBaujahr, cUsrKilometerstand, cUsrTuren, cUsrPreis, cUsrLeistung, strKraftstoff, strGetriebe, strBeschreibung, cUsrAirbag, cUsrAbs, cUsrAllrad, cUsrEsp, cUsrNebelscheinwerfer, cUsrTraktionskontrolle, cUsrWegfahrsperre, cUsrZentralverriegelung, cUsrEinparkhilfe, cUsrElektrische_fenster, cUsrElektrische_sitze, cUsrKlima, cUsrKlimaautomatik, cUsrLeder, cUsrSchiebedach, cUsrServolenkung, cUsrSitzheizung, cUsrStandheizung, cUsrTempomat, cUsrXenonscheinwerfer, cUsrBordcomputer, cUsrRadio, cUsrMp3, cUsrCd, cUsrDvdvideo, cUsrNavigationssystem, cUsrAnhangerkupplung, cUsrAlufelgen, cUsrDachreling, cUsrRuckfahrkamera);
  
                  DataGrid1.EditItemIndex = -1;
                  BindDataGrid();
              }
              catch (Exception ex)
              {
                  strerrorMsg = ex.Message.Replace("'", @"""");
                  strscriptString = "<script language = Javascript>";
                  strscriptString += "window.status = '" + strerrorMsg + "';";
                  strscriptString += "</script>";
                  RegisterStartupScript("clientScript", strscriptString);
              }
          }
  
  
          private void UpdateInfo(int id, int kundennr, string typ, string art, string marke, string modell, int baujahr, int kilometerstand, int turen, int preis, int leistung, string kraftstoff, string getriebe, string bescreibung, int airbag, int abs, int allrad, int esp, int nebelscheinwerfer, int traktionskontrolle, int wegfahrsperre, int zentralverriegelung, int einparkhilfe, int elektrische_fenster, int elektrische_sitze, int klima, int klimaautomatik, int leder, int schiebedach, int servolenkung, int sitzheizung, int standheizung, int tempomat, int xenonscheinwerfer, int bordcomputer, int radio, int mp3, int cd, int dvdvideo, int navigationssystem, int anhangerkupplung,int alufelgen, int dachreling, int ruckfahrkamera)
          {
              using (MySqlConnection con = new MySqlConnection(ConnStr))
  
              using (MySqlCommand cmd = new MySqlCommand("UPDATE daten SET kundennr = @kundennr,typ = @typ, art = @art, marke = @marke, modell = @modell, baujahr = @baujahr, kilometerstand = @kilometerstand, turen= @turen, preis = @preis, leistung = @leistung, kraftstoff = @kraftstoff, getriebe = @getriebe, beschreibung = @beschreibung, airbag = @airbag, abs = @abs, allrad = @allrad, esp = @esp, nebelscheinwerfer = @nebelscheinwerfer, traktionskontrolle = @traktionskontrolle, wegfahrsperre = @wegfahrsperre, zentralverriegelung = @zentralverriegelung, einparkhilfe = @einparkhilfe, elektrische_fenster = @elektrische_fenster, elektrische_sitze = @elektrische_sitze, klima = @klima, klimaautomatik = @klimaautomatik, leder = @leder, schiebedach = @schiebedach, servolenkung = @servolenkung, sitzheizung = @sitzheizung, standheizung = @standheizung, tempomat = @tempomat, xenonscheinwerfer = @xenonscheinwerfer, bordcomputer = @bordcomputer, radio = @radio, mp3 = @mp3, cd = @cd, dvdvideo = @dvdvideo, navigationssystem = @navigationssystem, anhangerkupplung = @anhangerkupplung, alufelgen = @alufelgen, dachreling = @dachreling, ruckfahrkamera = @ruckfahrkamera WHERE id = @id", con))
    
              {
                  cmd.Parameters.Add("@id", MySqlDbType.Int64).Value = id;
                  cmd.Parameters.Add("@kundennr", MySqlDbType.Int64).Value = kundennr;
                  cmd.Parameters.Add("@typ", MySqlDbType.VarChar, 255).Value = typ;
                  cmd.Parameters.Add("@art", MySqlDbType.VarChar, 255).Value = art;
                  cmd.Parameters.Add("@marke", MySqlDbType.VarChar, 255).Value = marke;
                  cmd.Parameters.Add("@modell", MySqlDbType.VarChar, 255).Value = modell;
                  cmd.Parameters.Add("@baujahr", MySqlDbType.Int64).Value = baujahr;
                  cmd.Parameters.Add("@kilometerstand", MySqlDbType.Int64).Value = kilometerstand;
   ......................................
                  con.Open();
                  cmd.ExecuteNonQuery();
              }
          }