BEGIN TRY
INSERT INTO TABLE_NAME (...) VALUES (...)
SELECT A, B, C FROM TABLE_NAME
WHERE CRITERIA = @CRITERIA
END TRY
BEGIN CATCH
RAISERROR('ROW COULD NOT BE INSERTED',10,1)
END CATCH
After this code. Just run it as a stored procedure and get result set. After finding the resultset with you, just bind your grid with it.
Grid will be updated after every insertion.
i.e.
DataSet ds = DataAccess.Students.InsertStudent(objStudent);
if(ds != null && ds.Tables.Count >0)
{
Grid.DataSource = ds;
Grid.DataBind();
}