How to update column in a gridview after saving data through text box?

Question

I have one grid view with 4 columns(UserId,Description,Password,Change Password). when i click on change password the panel with 3 textboxes(UserID,New Password,Confirm Password) and save button appears. after changing password the panel disappears but the password in the gridview remains same as previous. i want to update the password column.
The code is in C# and back end is MySQL DB Server.. please help..

Abhijit barua · Answer

select query on the table then only u will get the change ok...

Abumiyan Muqri · Answer

Problem solved. Just created a method RefreshGridview and copied the code of search button which is in another page. Thanks..

Abumiyan Muqri · Answer

which query i have to write there? Update query or Select Query? i have written separate methods in a class file for updation and selection of data. Please suggest me something to get out of this.

Abhijit barua · Answer

at your save button where u call BindGridView() comment it and write like below. datatable dt=new datatable(); string sqlStatement = your sql query; SqlCommand sqlCmd = new SqlCommand(sqlStatement connection); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlDa.Fill(dt); gvPassInfo.DataSource = dt; gvPassInfo.DataBind();

Abumiyan Muqri · Answer

Can u show me some code to bind gridview from database directly?

Abhijit barua · Answer

u are binding by datatable in session..like dt = (DataTable)Session[userinfo];. after save you again call BindGridView(); so it bind with old data. if possible bind gridview from database directly. or use other option to reflect the change.

Abumiyan Muqri · Answer

there is no button click event. below is my code. protected void BindGridView() { try { DataTable dt = new DataTable(); dt = (DataTable)Session[userinfo]; gvPassInfo.DataSource = dt; gvPassInfo.DataBind(); } catch (Exception ex) { //lblMessage.Text = DataObjects.Error_Message(); } } protected void gvPassInfo_RowCommand(object sender GridViewCommandEventArgs e) { if (e.CommandName == change) { panelChangePassword.Visible = true; } } protected void gvPassInfo_RowEditing(object sender GridViewEditEventArgs e) { string user = gvPassInfo.DataKeys[e.NewEditIndex].Value.ToString(); Session[user] = user.ToString(); panelChangePassword.Visible = true; txtUserid.Enabled = false; //txtUserid.Text = gvPassInfo.SelectedRow.Cells[0].Text; txtUserid.Text = user.ToString(); } protected void btnSave_Click(object sender EventArgs e) { clsUser objuser = new clsUser(); //string user = Session[user].ToString(); string user = txtUserid.Text; string NewPassword = txtNewPassword.Text; string ConfirmPassword = txtConfirmNewPassword.Text; Response.Write( alert('Password Changed Successfully...'); document.location=' + ResolveClientUrl(~\PasswordInformation_Details.aspx) + '; ); BindGridView(); panelChangePassword.Visible = false; }

Abhijit barua · Answer

call again bind method(or where u write code to bind at gridview) at button_click. then modified information will show at gridview.