Editable DataGrid Shows Old Values "After" Update

[Kevin Pedersen]

Hello, I am using an editable datagrid. After I save the changes the
datagrid shows the old values.

I've read the posts about the Page_Load and not binding the datagrid
each time. The SQL that is being sent to the database is correct and
the changes are eventually being made. If I refresh the page after the
update then the new values appear.

I noticed that when I put a breakpoint in my update handler everything
works fine. When I take out the breakpoint, I get the old values. It's
like the update isn't happening fast enough. I'm updating then
selecting before the update is finished. Or am I way off base and I'm
doing something else wrong?

Help.

Thanks in advance,
Kevin

[Teemu Keiski]

Do you rebind the grid *after* update has been done? Post some code.

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
"Kevin Pedersen" <ke************ @hotmail.com> wrote in message
news:20******** *************** *@posting.googl e.com...

Hello, I am using an editable datagrid. After I save the changes the
datagrid shows the old values.

I've read the posts about the Page_Load and not binding the datagrid
each time. The SQL that is being sent to the database is correct and
the changes are eventually being made. If I refresh the page after the
update then the new values appear.

I noticed that when I put a breakpoint in my update handler everything
works fine. When I take out the breakpoint, I get the old values. It's
like the update isn't happening fast enough. I'm updating then
selecting before the update is finished. Or am I way off base and I'm
doing something else wrong?

Help.

Thanks in advance,
Kevin

[Frank Oquendo]

Kevin Pedersen wrote:

Hello, I am using an editable datagrid. After I save the changes the
datagrid shows the old values.

Once you've acquired the row to be updated, follow these steps:

1) Call DatRow.BeginEdi t()
2) Change the values in the DataRow
3) Call DataRow.EndEdit ()
4) Connect to the database
5) Call DataAdapter.Upd ate(DataTable)
6) Call DataTable.Accep tChanges()
7) Rebind your DataGrid

--
There are 10 kinds of people. Those who understand binary and those who
don't.

http://code.acadx.com
(Pull the pin to reply)

[Kevin Pedersen]

Here's the code. At least the stuff I thought was relevant.

<asp:datagrid id="details" runat="server"
visible="False"
datakeyfield="e ntity_id"
autogeneratecol umns="False"
headerstyle-font-bold="True"
font-size="10pt"
font-name="Verdana"
oneditcommand=" onEdit"
oncancelcommand ="onCancel"
onupdatecommand ="onUpdate"

<columns>
<asp:boundcolum n headertext="ID" datafield="enti ty_id"
readonly="True" />

<asp:templateco lumn headertext="Nam e">
<itemtemplate >
<asp:label runat="server" id="lblName"
text='<%# DataBinder.Eval ( Container.DataI tem, "entity_nam e"
) %>' />
</itemtemplate>

<edititemtempla te>
<asp:textbox id="txtName" runat="server" font-name="Verdana"
text='<%# DataBinder.Eval ( Container.DataI tem, "entity_nam e"
) %>' />
</edititemtemplat e>
</asp:templatecol umn>

<asp:templateco lumn headertext="Num ber">
<itemtemplate >
<asp:label id="lblNumber" runat="server"
text='<%# DataBinder.Eval ( Container.DataI tem,
"street_num ber" ) %>' />
</itemtemplate>

<edititemtempla te>
<asp:dropdownli st id="ddlNumber" runat="server"
datasource='<%# getStreetNumber s() %>'
datatextfield=" street_number"
datavaluefield= "id"
onprerender="se tItemIndex" />
</edititemtemplat e>
</asp:templatecol umn>

<asp:templateco lumn runat="server" headertext="Str eet">
<itemtemplate >
<asp:label runat="server" text='<%#
DataBinder.Eval ( Container.DataI tem, "street_nam e" ) + " "
+
DataBinder.Eval ( Container.DataI tem, "street_typ e" ) %>' />
</itemtemplate>
</asp:templatecol umn>

<asp:templateco lumn runat="server" headertext="Pho ne 1">
<itemtemplate >
<asp:label id="lblPhone1" runat="server"
text='<%# DataBinder.Eval ( Container.DataI tem, "phone1" )
%>' />
</itemtemplate>

<edititemtempla te>
<asp:textbox id="txtPhone1" runat="server"
text='<%# DataBinder.Eval ( Container.DataI tem, "phone1" )
%>'
width="80" />
</edititemtemplat e>
</asp:templatecol umn>

<asp:templateco lumn runat="server" headertext="Pho ne 2">
<itemtemplate >
<asp:label id="lblPhone2" runat="server"
text='<%# DataBinder.Eval ( Container.DataI tem, "phone2" )
%>' />
</itemtemplate>

<edititemtempla te>
<asp:textbox id="txtPhone2" runat="server"
text='<%# DataBinder.Eval ( Container.DataI tem, "phone2" )
%>'
width="80" />
</edititemtemplat e>
</asp:templatecol umn>

<asp:templateco lumn runat="server" headertext="Typ e">
<itemtemplate >
<asp:label id="lblType" runat="server"
text='<%# DataBinder.Eval ( Container.DataI tem, "type" ) %>'
/>
</itemtemplate>

<edititemtempla te>
<asp:dropdownli st id="ddlType" runat="server"
datasource='<%# getTypes() %>'
datatextfield=" type"
datavaluefield= "id"
onprerender="se tItemIndex"
/>
</edititemtemplat e>
</asp:templatecol umn>

<asp:templateco lumn runat="server" headertext="Sub Type 1">
<itemtemplate >
<asp:label id="lblSubType1 " runat="server"
text='<%# DataBinder.Eval ( Container.DataI tem, "subtype1" )
%>' />
</itemtemplate>

<edititemtempla te>
<asp:dropdownli st id="ddlSubType1 " runat="server"
datasource='<%# getSubTypes() %>'
datatextfield=" type"
datavaluefield= "id"
onprerender="se tItemIndex"
/>
</edititemtemplat e>
</asp:templatecol umn>

<asp:templateco lumn runat="server" headertext="Sub Type 2">
<itemtemplate >
<asp:label id="lblSubType2 " runat="server"
text='<%# DataBinder.Eval ( Container.DataI tem, "subtype2" )
%>' />
</itemtemplate>

<edititemtempla te>
<asp:dropdownli st id="ddlSubType2 " runat="server"
datasource='<%# getSubTypes() %>'
datatextfield=" type"
datavaluefield= "id"
onprerender="se tItemIndex"
/>
</edititemtemplat e>
</asp:templatecol umn>

<asp:editcomman dcolumn
edittext="Edit"
canceltext="Can cel"
updatetext="Sav e" />

<asp:buttoncolu mn
buttontype="Lin kButton"
commandname="De lete"
text="Delete" />
</columns>
</asp:datagrid>

private void Page_Load(objec t sender, System.EventArg s e)
{
// Put user code to initialize the page here
if( !IsPostBack )
{
streetId = "1";
bindGrid();
}
else {
// Get the current selection from the list box
streetId = streetList.sele ctedItemValue == "" ? "1" :
streetList.sele ctedItemValue;

// Show results
details.Visible = true;
street_image.Vi sible = true;
}
}

private void bindGrid()
{
string connectString =
System.Configur ation.Configura tionSettings.Ap pSettings[
"connectStr ing" ];

// Create connection and set connection string
OleDbConnection cnn = new OleDbConnection ( connectString );

string sql = "SELECT entity.id AS entity_id, entity.name AS
entity_name, " +
"block_address. id AS block_address_i d,
block_address.s treet_number, street.name AS street_name, " +
"street.typ e AS street_type, entity.phone1, entity.phone2, "
+
"(SELECT type FROM entity_type WHERE id = entity.type ) AS
type, " +
"(SELECT type FROM entity_sub_type WHERE id =
entity.sub_type 1 ) AS subtype1, " +
"(SELECT type FROM entity_sub_type WHERE id =
entity.sub_type 2 ) AS subtype2, " +
"block_address. block_id " +
"FROM entity INNER JOIN " +
"( block_address INNER JOIN street " +
"ON block_address.s treet_id = street.id) " +
"ON entity.block_ad dress = block_address.i d " +
"WHERE street.id = " + streetId;

OleDbCommand cmd = new OleDbCommand( sql, cnn );
cmd.CommandType = CommandType.Tex t;
cnn.Open();

details.DataSou rce = cmd.ExecuteRead er();
details.DataBin d();
cnn.Close();
}

public void onUpdate( Object source, DataGridCommand EventArgs e )
{
string name = ((TextBox)e.Ite m.Cells[1].Controls[1]).Text;
string addressId = ((DropDownList) (e.Item.FindCon trol( "ddlNumber"
))).SelectedIte m.Value;
string phone1 = ((TextBox)e.Ite m.Cells[4].Controls[1]).Text;
string phone2 = ((TextBox)e.Ite m.Cells[5].Controls[1]).Text;
string type = ((DropDownList) (e.Item.FindCon trol( "ddlType"
))).SelectedIte m.Value;
string subType1 = ((DropDownList) (e.Item.FindCon trol( "ddlSubType 1"
))).SelectedIte m.Value;
string subType2 = ((DropDownList) (e.Item.FindCon trol( "ddlSubType 2"
))).SelectedIte m.Value;

int entityId = e.Item.ItemInde x;
string sql = "UPDATE entity SET " +
"name = '" + name + "', " +
"block_addr ess = " + addressId + ", " +
"phone1 = '" + phone1 + "', " +
"phone2 = '" + phone2 + "', " +
"type = " + type + ", " +
"sub_type1 = " + subType1 + ", " +
"sub_type2 = " + subType2 + " " +
"WHERE id = " + details.DataKey s[entityId];

string connectString =
System.Configur ation.Configura tionSettings.Ap pSettings[
"connectStr ing" ];

// Create connection and set connection string
OleDbConnection cnn = new OleDbConnection ( connectString );

OleDbCommand cmd = new OleDbCommand( sql, cnn );
cnn.Open();
cmd.ExecuteNonQ uery();

details.EditIte mIndex = -1;
bindGrid();
}

Thanks,
Kevin

"Teemu Keiski" <jo****@aspalli ance.com> wrote in message news:<#i******* *******@TK2MSFT NGP11.phx.gbl>. .. Do you rebind the grid *after* update has been done? Post some code.

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
"Kevin Pedersen" <ke************ @hotmail.com> wrote in message
news:20******** *************** *@posting.googl e.com...

Hello, I am using an editable datagrid. After I save the changes the
datagrid shows the old values.

I've read the posts about the Page_Load and not binding the datagrid
each time. The SQL that is being sent to the database is correct and
the changes are eventually being made. If I refresh the page after the
update then the new values appear.

I noticed that when I put a breakpoint in my update handler everything
works fine. When I take out the breakpoint, I get the old values. It's
like the update isn't happening fast enough. I'm updating then
selecting before the update is finished. Or am I way off base and I'm
doing something else wrong?

Help.

Thanks in advance,
Kevin