c# DataGrid edit problem

[Misha]

Hi!

I have the folloving strange problem with editing data in the DataGrid. I can pull data from the database, show them and put in to the edit mode. Let's say I have to change some record from "green" to "red". When I change value in the text box and click update, data is updated in the database, and it has new "red" value, but on the screen I still see the old value "green". If I click on update again, the newly submited value "red" appears in the text box. Please, take a look at the code below. Thank you in advance!

 

void Page_Load(Object sender, EventArgs e)

{

SqlConnection myConnection = new SqlConnection("server=**;user=**;password=**;database=**;");

SqlDataAdapter myCommand = new SqlDataAdapter("SELECT * from Interface WHERE ID= " + recID, myConnection);

DataSet EditDS = new DataSet();

myCommand.Fill(EditDS, "RoomEdit");

EditDW = new DataView();

EditDW = EditDS.Tables["RoomEdit"].DefaultView;

EditGrid.DataSource = EditDW;

if (!Page.IsPostBack)

{

EditGrid.DataBind();

}

}

 

void BindGrid()

{

EditGrid.DataSource = EditDW;

EditGrid.DataBind();

}

 

void EditGrid_Update(Object sender, DataGridCommandEventArgs e)

{

TextBox RoomUseDescTextB = (TextBox)e.Item.Cells[9].Controls[0];

TextBox RoomUseCdTextB = (TextBox)e.Item.Cells[10].Controls[0];

 

String newRoomUseCd = RoomUseCdTextB.Text;

String newRoomUseDesc = RoomUseDescTextB.Text;

 

SqlConnection connUpdate = new SqlConnection("server=**;user=**;password=**;database=**;");

connUpdate.Open();

String sql_edit = "UPDATE Interface " +

"SET RoomUseCode = '" + newRoomUseCd + "', " +

"RoomUseDesc = '" + newRoomUseDesc + "'" +

" WHERE ID = " + e.Item.Cells[0].Text;

SqlCommand sqlCommandUpdate = new SqlCommand(sql_edit,connUpdate);

sqlCommandUpdate.ExecuteNonQuery();

connUpdate.Close();

 

EditGrid.EditItemIndex = -1;

BindGrid();

}

[Cassio]

The code on the page_load runs before the update function, so when you call the BindGrid() function the datagrid source has already been defined in the page_load. You should put the data access code in the BindGrid() function instead, and call this function from the page_load too.

[Misha]

Thank you! I changed the code and it works fine now.