By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,945 Members | 1,354 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,945 IT Pros & Developers. It's quick & easy.

storedProcedure (sp_Customer) is in sQL server- program access the server correctly.

P: 1
Dim command As New SqlCommand
command.Connection = con
command.CommandText = "sp_Customer"

command.CommandType = CommandType.StoredProcedure

command.Parameters.Add(New SqlParameter("@Type", x))

Dim adapter As New SqlDataAdapter
Dim ds As New DataSet
Dim tb As DataTable

adapter.SelectCommand = command
adapter.Fill(ds, 1, 4, "Cus")

Exception=Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
tb = ds.Tables("cus")
Sep 18 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.