Hi,

 I am trying to write some code to update/edit/delete records in a GridView but I am having problems. The GridView is populated through a stored procedure. Here is the code and the error I am getting. I have been doing searches over the net for the last two days and could not find an explanation that works. Can someone be so kind and explain me how can I write some code that will do just that?

Store Procedure (GetAgendaHoje)
SELECT CONVERT(VARCHAR(10), e.data_evento, 103) as Data, e.hora_evento Hora, c.nome Utilizador, e.local_evento Local, e.descricao Descrição, id_registo
from customers c, registo e
where e.data_evento = convert(char(10),getdate(),112)
order by 1,2,3  

-----

<asp:GridView ID="dgAgenda" runat="server" AutoGenerateColumns="False"
BorderColor="Black" BorderStyle="Solid"
BorderWidth="2px" CellPadding="4" ForeColor="#333333"
OnRowDataBound="dgAgenda_RowDataBound"
datakeynames="id_registo"
Width="714px" style="text-align: left" onrowupdated="dgAgenda_UpdateCommand">
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="Data" HeaderText="Data" />
<asp:BoundField DataField="Hora" HeaderText="Hora" />
<asp:BoundField DataField="Utilizador" HeaderText="Utilizador" />
<asp:BoundField DataField="Local" HeaderText="Local" />
<asp:BoundField DataField="Descri‡ão" HeaderText="Descri‡ão" />
<asp:BoundField DataField="id_registo" HeaderText="id_registo" ShowHeader="False" Visible="False"/>
<asp:CommandField HeaderText="Edit" ShowEditButton="True" ShowHeader="True" />
</Columns>
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>

-----

Here's my guess, for what it's worth.

You are using onrowupdated="dgAgenda_UpdateCommand" with GridViewUpdateEventArgs e when onrowupdated should use GridViewUpdatedEventArgs so, try either changing GridViewUpdateEventArgs to GridViewUpdatedEventArgs or onrowupdated to onrowupdating.

Hope this helps.

Thanks that worked but now when I press the Edit button on the grid nothing happens, it wasn't supose to get the Update and Cancel buttons? any ideas? Here is the code:

<asp:GridView ID="dgAgenda" runat="server" AutoGenerateColumns="False"
BorderColor="Black" BorderStyle="Solid"
BorderWidth="2px" CellPadding="4" ForeColor="#333333"
OnRowDataBound="dgAgenda_RowDataBound"
datakeynames="id_registo"
Width="714px" style="text-align: left" onrowupdating="dgAgenda_UpdateCommand"
onrowediting="editgrid_click">
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="Data" HeaderText="Data" />
<asp:BoundField DataField="Hora" HeaderText="Hora" />
<asp:BoundField DataField="Utilizador" HeaderText="Utilizador" />
<asp:BoundField DataField="Local" HeaderText="Local" />
<asp:BoundField DataField="Descri‡ão" HeaderText="Descri‡ão" />
<asp:BoundField DataField="id_registo" HeaderText="id_registo" ShowHeader="False" Visible="False"/>
<asp:CommandField HeaderText="Edit" ShowEditButton="True" ShowHeader="True" />
</Columns>
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>

In your posted code, I don't see anything that looks like it could cause what you are describing, so guess #2:

something in updateGrid(); is goofing it up.

 The handler for the Edit button is editgrid_click, but in that handler all that happens is that the editindex is set to -1.  So, the user selects a row to edit -- EditIndex = row number -- and then the handler deselects it -- EditIndex = -1.  Is that your intent? Am I misunderstanding your issue?

You are right, I have changed the editgrid_click method. Let me try to explain what I need.

When the form is first displayed I am running a stored procedure to get all the records for TODAYS date. On the form I have a calendar where the user can select a new date. When that happens I run the updategrid() to get the records for that particular day. But now the grid is not responding correctly. If I select a different day from the calendar and the press Edit strange things start to happen. Please check all the code behind

public partial class regista_evento : System.Web.UI.Page

SqlConnection conn = new SqlConnection(strLiga());
SqlCommand cmd4 = new SqlCommand("getNome", conn);

// define store proc.

// Passa paremtro do primeiro PT na DropDownList

// carrega parametro

cmd4.ExecuteNonQuery();
cmd4.UpdatedRowSource = UpdateRowSource.OutputParameters;
string nome = cmd4.Parameters["@nome"].Value.ToString();

SqlCommand cmd45 = new SqlCommand("GetAgendaDiaSel", conn);

SqlCommand cmd44 = new SqlCommand("GetAgendaHoje", conn);

e.Row.Cells[0].Text = "";

// Carrega liga‡ão … base de dados do web.config

DateTime dt = Convert.ToDateTime(dataText.Text);

// cria instancia de comando e liga‡ão

cmd22.CommandType = CommandType.StoredProcedure;

cmd22.Parameters.Add(new SqlParameter("@data", SqlDbType.DateTime));

cmd22.Parameters.Add(new SqlParameter("@local", SqlDbType.VarChar,250));

string hora = ddlHora.SelectedValue.ToString();

// carrega parametro

//Label1.Text = "escolhi o dia" + Calendar1.SelectedDate;

// cria instancia de comando e liga‡ão

cmd3.CommandType = CommandType.StoredProcedure;

// cria instancia de comando e liga‡ão

cmd2.CommandType = CommandType.StoredProcedure;

cmd2.Parameters.Add("@hora", SqlDbType.Time).Value = ((TextBox)dgAgenda.Rows[e.RowIndex].Cells[1].Controls[0]).Text;

cmd2.Parameters.Add("@local", SqlDbType.VarChar, 250).Value = ((TextBox)dgAgenda.Rows[e.RowIndex].Cells[3].Controls[0]).Text;

//protected void gridedit_DeleteCommand(object sender, GridViewDeletedEventArgs e)

//{

// // cria instancia de comando e liga‡ão

// SqlConnection conn = new SqlConnection(strLiga());

// conn.Open();

// SqlCommand cmd3 = new SqlCommand("deleteRegisto", conn);

// cmd3.CommandType = CommandType.StoredProcedure;

// int U_ID = (int)dgAgenda.DataKeys[(int)e.RowIndex];

// cmd3.Parameters.Add("@id", SqlDbType.Int).Value = ((TextBox)dgAgenda.Rows[e.RowIndex].Cells[5].Controls[0]).Text.ToString();

// cmd3.ExecuteNonQuery();

// cmd3.ExecuteNonQuery();

// cmd3.Connection.Close();

// dgAgenda.EditIndex = -1;

// inicializa();

//}

}

}

 I read through the code a couple of times and I don't see anything in particular that would be an issue.  It looks like this would correctly update the dgAgenda after the selected date changes.  Are you sure that it's posting back when the date changes? What are the strange things that are happening?

Inittilay the grid appears correctly but if I select a diff date the grid dissapears. If I select de initial date the grid reappears with a row selected for update. It's really odd. 

 It sounds to me like there is no data for the second date you select.  The intial date has data and data appears, the second has no data so nothing appears.  You go back to the first date and data appears.

So, are you absolutely certain that there is data associated with teh second date? If so, try looking for something in how the data is acquired, something in the stored procedure or in the parameter you pass.  Don't know what it might be.

Personally, my next step would be to run this through a debugger step by step so I could see what's happening.  Like I said, it sounds like there's no data for that second date.