存储过程调用

新建存储过程
create proc ckmx
@djbm varchar(20)
as
select * from 出库明细 where 单据编号 like '%'+@djbm+'%' and 出库性质='退货'
go
vb.net调用存储过程代码
Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click
 Try
   Dim da As New SqlDataAdapter
   da.SelectCommand = New SqlCommand("ckmx", cn)
   da.SelectCommand.CommandType = CommandType.StoredProcedure
   da.SelectCommand.Parameters.Add("@djbm", SqlDbType.VarChar, 50).Value = banjiao(TextBox1.Text)
            Dim ds As New DataSet
            da.Fill(ds, "出库明细")
            dgv_rk.AutoGenerateColumns = False
            dgv_rk.DataSource = ds.Tables("出库明细").DefaultView
            cn.Close()
            cn.Dispose()
            da.Dispose()
            ds.Dispose()
   Catch ex As Exception
   End Try
End Sub