data grid fails to update!

[rcoco]

hi,
I've tried to update my database using my datagrid but there is no
change. here is the code I'm using:

private void Update_dataGrid (object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)

{

System.Web.UI.W ebControls.Text Box cstaff=new
System.Web.UI.W ebControls.Text Box();

cstaff=(System. Web.UI.WebContr ols.TextBox)e.I tem.Cells[1].Controls[0];

SqlCommand myCommand=new SqlCommand("upd ate isp_email.staff set
stafflevel=@sta fflevel where id=id",con);

myCommand.Param eters.Add(new
SqlParameter("@ stafflevel",Sql DbType.VarChar, 45));

myCommand.Param eters["@staffleve l"].Value=cstaff.T ext;
con.Open();

myCommand.Execu teNonQuery();

con.Close();

dgupdate.EditIt emIndex=-1;

BindData();

}

ould some one help me?

[Amanda V]

OK, I've been searching for an answer to a similar problem. I am using
VB 6.0 though, so I have no idea if the solution I used, will apply/ be
helpful to you at all. I will just throw it out there in case it helps
someone...

I think the DataGrid has a property called 'DataChanged'.

If you set the property to True, then all of the update / validating
stuff should happen.

I had a problem with when I changed values in my datagrid, it didn't
propogate through to the underlying recordset unless I moved to another
record (which in effect, checks the record you were previously on, and
if changes were made, then sets the DataChanged property to true and
does whatever validating is necessary).

Basically I just made a button, that when clicked, sets
DataGrid.DataCh anged = True ... and BAM... my underlying recordset was
updated.

Hope it helps someone... :)
rcoco wrote:

hi,
I've tried to update my database using my datagrid but there is no
change. here is the code I'm using:

private void Update_dataGrid (object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)

{

System.Web.UI.W ebControls.Text Box cstaff=new
System.Web.UI.W ebControls.Text Box();

cstaff=(System. Web.UI.WebContr ols.TextBox)e.I tem.Cells[1].Controls[0];

SqlCommand myCommand=new SqlCommand("upd ate isp_email.staff set
stafflevel=@sta fflevel where id=id",con);

myCommand.Param eters.Add(new
SqlParameter("@ stafflevel",Sql DbType.VarChar, 45));

myCommand.Param eters["@staffleve l"].Value=cstaff.T ext;
con.Open();

myCommand.Execu teNonQuery();

con.Close();

dgupdate.EditIt emIndex=-1;

BindData();

}

ould some one help me?

[mark carew]

Hi,

Is dgupdate your datagrid?
Then you need to execute databind for it and for its datasource

e.g.
dgupdate.sqldat asource1.databi nd();
dgupdate.databi nd();

The datagrid has no knowledge that you have updated its underlying data
source. It is just a static snapshot of the data as it previously was
before you changed it.

You have to refresh the datagrid by calling its datasource databind method
and then databind the newly refreshed datasource to the datagrid to re-sync
the data being displayed.

HTH
Mark Carew

On 7 Dec 2006 04:51:19 -0800, rcoco wrote:

hi,
I've tried to update my database using my datagrid but there is no
change. here is the code I'm using:

private void Update_dataGrid (object source,
System.Web.UI.W ebControls.Data GridCommandEven tArgs e)

{

System.Web.UI.W ebControls.Text Box cstaff=new
System.Web.UI.W ebControls.Text Box();

cstaff=(System. Web.UI.WebContr ols.TextBox)e.I tem.Cells[1].Controls[0];

SqlCommand myCommand=new SqlCommand("upd ate isp_email.staff set
stafflevel=@sta fflevel where id=id",con);

myCommand.Param eters.Add(new
SqlParameter("@ stafflevel",Sql DbType.VarChar, 45));

myCommand.Param eters["@staffleve l"].Value=cstaff.T ext;
con.Open();

myCommand.Execu teNonQuery();

con.Close();

dgupdate.EditIt emIndex=-1;

BindData();

}

ould some one help me?

[Phil H]

Is dgupdate your datagrid?

Then you need to execute databind for it and for its datasource

e.g.
dgupdate.sqldat asource1.databi nd();
dgupdate.databi nd();

Sorry Mark but there is no such property as sqldatasource1 in the
DataGrid class and DataBind() is a member of DataGrid not the
DataSource property.

In the code submitted there is a statement:

BindData();

Presumably that is a function defined elsewhere which contains the
necessary commands to bind the ammended data to the grid.

Could the author show it please?