Stop DataGridView from re-drawing itself?

Hey everyone. I know this is probably a stupid question but it's been bugging me for several days now and I could really use some help. OK. I have a DataGridView on a windows form listing student names, majors, etc. If the user double-clicks on that datagrid, a separate form opens up with the fields for the user to be able to edit that record. Here is the code I use to fill the datagridview (on the main form):

Public Sub GetStudentList()

Dim builder As New SqlConnectionStringBuilder()

builder.ConnectionString = strDBConn

dsStudents.Clear()

Using connection As New SqlConnection(builder.ConnectionString)

Dim command As New SqlCommand("admin_sp_GetStudentList", connection)

command.CommandType = CommandType.StoredProcedure

Try

connection.Open()

Using drStudents As SqlDataReader = command.ExecuteReader()

dsStudents.Load(drStudents, LoadOption.OverwriteChanges, New String() {"Students"})

End Using

FormatStudents()

Catch ex As Exception

MessageBox.Show(ex.Message)

Finally

If connection.State <> ConnectionState.Closed Then

connection.Close()

End If

End Try

End Using

End Sub

On the second form, I have the following stuff:

Private callingForm As frmMain

Public Sub New(ByVal newCallingForm As frmMain)

MyBase.New()

InitializeComponent()

callingForm = newCallingForm

End Sub

Private Sub frmStudent_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

AcceptButton = btnAddEdit

CancelButton = btnCancel

FillStudentControls()

End Sub

Private Sub FillStudentControls()

Cursor = System.Windows.Forms.Cursors.WaitCursor

Dim dv As DataView = frmMain.dsStudents.Tables(0).DefaultView

dv.RowFilter = "studID = " & intStudID

txtStudFName.Text = dv(0)("studFName").ToString

txtStudLName.Text = dv(0)("studLName").ToString

txtEmail.Text = dv(0)("studEmail").ToString

' - more fields (there are 10 textboxes on this form plus 2 comboboxes)

txtStudFName.Focus()

dv.RowFilter = "studID > 0"

Cursor = System.Windows.Forms.Cursors.Default

End Sub

I'm not sure if using a dataview is the best approach but it's the only one I know of. Unfortunately what is happening is this. Because it (the dataview) is using the same dataset as the datagridview, when the new form is loaded, the datagridview on the main form is getting redrawn (and have the first row selected). That is why I added that second to last line in the "FillStudentControl" procedure (to make the datagridview still show all the Students and not just the one that is selected .

How would I go about NOT having the datagridview on the main form redraw itself when the other form pops up Should I do it differently (not using the dataview on the second form) If so, how do I go about getting the fields from the dataset that I need

Sorry if this is all newbie 101 questions but that is kind of what I am. So any and all help would be greatly appreciated. Oh, and for the record, this is not a school project or anything. I am building this little program just to teach myself VB/SQL Server/ etc. I don't know if that matters but another post I made on a different board was discarded because the moderator thought I was asking for help with my homework :).

Answer this question