Can anyone help me, i was trying to set my record result which got from
executing one storedProcedure by the SQLDataAdapter, and
then the result will set to the Data Set Object which also will be bind
together with DataGrid.
Is it possible ? My problem is i can't set the fill argument as a
storedprocedure which has the parameter
Dim nwindConn As SqlConnection = New SqlConnection("Data
Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind")
selectCMD.CommandTimeout = 30
Dim custDA As SqlDataAdapter = New SqlDataAdapter
custDA.SelectCommand = selectCMD
Dim custDS As DataSet = New DataSet
My stored procedure is :
Can anyone advise me ? for now i still getting the error which tell me the
'StoredProcedurName' wasn't recognized.