Re: databinding a datagridview

Tech-Archive recommends: Speed Up your PC by fixing your registry

Jim,

In ASPNet you can bind the datareader to the grids. It is in fact one
direction. In windowforms you have to bind a collection. In the case of
ADONET a datatable or a dataset.

Cor

"Jim in Arizona" <tiltowait@xxxxxxxxxxx> schreef in bericht
news:ul2GyE$bHHA.4488@xxxxxxxxxxxxxxxxxxxxxxx
Sorry for the x-post. There seems to be very little if any activity on the
windowsforms group.

Nearly all my experience so far has been with web forms so I'm just
learning to work with windows forms.

I'm trying to bind data do a datagridview but dont' know how. This is what
I have so far.

========================================

Public Class frmSearch

Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnSearch.Click
Dim strConnection, strStoredProc, strSQL As String
Dim strInput As String = "%" & txtSearch.Text & "%"
Dim NoMatch As Boolean = False
strConnection =
"server=sqlwebserver;database=directory;trusted_connection=true"
strStoredProc = "sp_getemployee"
Dim objConnection As New SqlConnection(strConnection)
Dim objCMD As New SqlCommand(strStoredProc, objConnection)
objCMD.CommandType = CommandType.StoredProcedure

Dim objEmpName As New SqlParameter("@EmpName", SqlDbType.VarChar)
objEmpName.Value = strInput
objEmpName.Direction = ParameterDirection.Input
objCMD.Parameters.Add(objEmpName)

Try
objConnection.Open()
frmResults.dgvResults.DataSource = objCMD.ExecuteReader()

frmResults.Show()
frmResults.Visible = True
frmResults.dgvResults.Visible = True

objConnection.Close()

Catch ex As Exception
frmErrorMessages.txtErrorMessage.Text = ex.Message.ToString
frmErrorMessages.Show()
End Try

End Sub
End Class

========================================
The application connects to the database ok. When I click the button, the
form with the datagridview shows up but the datagridview control is empty.
I do know that data is being returned since I run the same stored
procedure on a web form that works great. On a web form, however, I would
have to bind the data to the control after I set the Datasource property.
I don't know how that works with a web form though. Examples that I find
on the net are old and much more complicated than what it probably should
be (using data sets and sqlcommandbuilders and such).

TIA,
Jim


.

Quantcast