Procedure datagrid stock - VB.Net

[Janet J]

Hi all,

Here I want to put information in a Datagrid view from a stored procedure (which I call at a click of a button)
My DGV must fill.

Reader but when I execute my procedure it gets stuck, and I like error "Incorrect syntax near 'dbo'."

'Declare the connection 
          Sunday Connect As New System. Data. SqlClient. SqlConnection ( "Persist Security Info = False; Integrated Security = False; ccnetdev = uid, password = pw; Initial Catalog = UniversalActionLog; mydatabase = server") 
          'Open the Connection 
          Sunday myrow As DataRow 

          Connect. Open () 

          'SQL query, procedure call 
          Sunday myCommand As New SqlCommand ( "dbo.PS_LOG_Viewer", Connect) 
          Sunday myReader As SqlDataReader 

          Sunday myparam As SqlParameter 
          myparam = New SqlParameter ( "@ area", ComboBox_Area. SelectedItem) 
          myCommand. Parameters. Add (myparam) 

          Sunday myparam1 As SqlParameter 
          myparam1 = New SqlParameter ( "@ ACTION", ComboBox_Action. SelectedItem) 
          myCommand. Parameters. Add (myparam1) 

          Sunday myparam2 As SqlParameter 
          myparam2 = New SqlParameter ( "@ subactifs" ComboBox_SubAction. SelectedItem) 
          myCommand. Parameters. Add (myparam2) 


        
          myReader = myCommand. ExecuteReader () '<= This is where the error starts 
          Do While myReader. Read () 

              Myrow = GLOG. NewRow 
              GLOG. Rows. Add (myrow) 
       

          Loop 
          myReader. Close () 
          Connect. Close () 
  End Sub

Maybe you could enlighten me on my settings I do not know if it really like that make it work

Best regards

[Shell]

itself before you put exec dbo.maprocstock either you set CommandType to "StoredProcedure" on SqlCommand for the parameters is best typer, it is possible to set the value on the same line using the following syntax

 parameters. Add ( "@ p", nvarchar). value = the value

[Janet J]

Thank you, Shell

What you gave me is perfect

 Sunday myCommand As New SqlCommand ( "dbo.PS_LOG_Viewer", Connect) 
          myCommand. CommandType = CommandType. StoredProcedure

Parameter and also

 myCommand. Parameters. Add ( "@ area", SqlDbType. NVarChar). Value = ComboBox_Area. SelectedItem

This works even if my other procstoc that works perfectly I have called this way

 Sunday myCommand As New SqlCommand ( "dbo.PS_ACTION", Connect) 
          Sunday myReader As SqlDataReader

Strange that the other did perfect
Thank you again

[Shell]

I said rather strange that there have to spend ...

[Janet J]

Maybe because they are very small procedures that only return data from a column with a simple Select and From in a combobox

[Shell]

this is not an excuse, sql server request something he can understand just a name stored procedure, it does not exec proc stock includes select from it also CommandType to save the stored procedure allows the addition of implicit exec SqlCommand does not analyze the stored procedure.