Please help !!!
if we delete a record from the table it does not bind in grid view but in dataset it shows the exact records but after refreshing the page only its binds

Thanks in advance

protected void dgrMilkRecord_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int intId = Convert.ToInt16(e.CommandArgument.ToString());

ds = new DataSet();
cmd = new SqlCommand("agent_collection_delete_both_sp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@intp_id", dgrMilkRecord.Rows[intId].Cells[0].Text);
cmd.Parameters.AddWithValue("@inta_id", DropAgentCode.Text);
cmd.Parameters.AddWithValue("@varcollection_date", txtcollection_date.Text);
da.SelectCommand = cmd;

da.Fill(ds);
cmd = new SqlCommand("select_agent_record_sp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dttransdate", txtcollection_date.Text);
cmd.Parameters.AddWithValue("@intam_agentid", DropAgentName.SelectedValue);
cmd.Parameters.AddWithValue("@intpm_agentid", DropPMAgent.SelectedValue);
da.SelectCommand = cmd;
da.Fill(ds, "agentrec");

dgrMilkRecord.DataSource = ds.Tables["agentrec"];
dgrMilkRecord.DataBind();
}

}