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

[nadeekaMIT]

Dim command As New SqlCommand
command.Connect ion = con
command.Command Text = "sp_Custome r"

command.Command Type = CommandType.Sto redProcedure

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


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

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

Exception=Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
tb = ds.Tables("cus" )