Hi..No need to refresh the whole page to display last inserted record...?Follow these steps :
First use the ajax update panel for gridview
Next,call the grid binded method after the cmd.executenonquery()..see the example below
SqlCommand cmd = new SqlCommand("exec insertDepartement @DepartmentName", con);
cmd.Parameters.AddWithValue("@DepartmentName", TextBox1.Text);
con.Close();
con.Open();
cmd.ExecuteNonQuery();
bindgrid();
create a method called bindgrid()
public void bindgrid()
{
sqlcommand com=new sqlcommand("select * from table");
sqladapter da=new sqladapter(com,con);
da.Fill(ds)
gridview1.datasource=ds;
gridview1.databind();
}