datagridview not populating from stored procedure

[TG]

Hi!

I am using VB 2008 with SQL Server 2000 and SQL Server 2005 (depending
which server the user selects to connect to).

I have a listbox in which the user select the server to connect to.

Another listbox that shows the databases in that particular server.

Another listbox with the filesets from the selected database above.

When the user clicks on button 3, I want the datagridview to populate
data from a stored procedure passing 2 parameters in sql server.

At the moment the datagridview does not populate anything, neither
does it throw an error message. I have no clue what is wrong and I am
new to VB.

Your help will be greatly appreciated.

Thanks!

Tammy
Code for button 3:

Private Sub Button3_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button3.Click

Dim cn As New SqlConnection(" Data Source=" &
lstServers.Sele ctedValue & ";Initial Catalog=" &
lstDatabases.Se lectedValue & ";Integrate d Security=SSPI")

Dim cmd As New SqlCommand("usp _DR_Spam_BB_Sea rch_get_recs",
cn)

Dim dt As New DataTable()

cmd.CommandTime out = 0
cmd.CommandType = CommandType.Sto redProcedure

cmd.Parameters. AddWithValue("@ Matter",
lstDatabases.Se lectedItem)
cmd.Parameters. AddWithValue("@ FileSet",
lstFileSets.Sel ectedItem)

cn.Open()
Dim reader As SqlDataReader = cmd.ExecuteRead er()
DataGridView1.D ataSource = reader
End Sub

[Rich P]

Greetings,

Try something like this:

Dim da As New SqlDataAdapter, ds As New Dataset
Dim conn As New SqlConnection

conn.Connection String = "Data Source=yourServ er;Initial
Catalog=yourDB; Integrated Security=True"

da.SelectComman d = New SqlCommand
da.SelectComnma nd.Connection = conn
da.SelectComman d.CommandType = CommandType.Sto redProcedure
da.SelectComman d.CommandText = "store procedure name"
da.Fill(ds, "tbl1")
Datagridview1.D ataSource = ds.Tables("tbl1 ")

Rich

*** Sent via Developersdex http://www.developersdex.com ***