CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Threaded View

  1. #1
    Join Date
    Mar 2008
    Posts
    142

    Stored Procedures

    i m writting an application in which i add,delete and edit the records
    i m using sql server
    i have one table called Contacts in the database and few stored procedures in the database
    i have method RetreiveContacts()
    Code:
    Private Sub RetrieveContacts()
            Dim conn As New SqlConnection(My.Settings.AddressBookConnection)
            Dim adapter As New SqlDataAdapter("Contacts_AllContacts_Select", conn)
            Dim dt As New DataTable("Contacts")
            adapter.Fill(dt)
            dgContacts.DataSource = dt
        End Sub
    when i run my project ...error comes on following line
    Code:
     adapter.Fill(dt)
    and error says"Could not find stored procedure 'Contacts_AllContacts_Select'"
    but i have added this stored procedure into the database
    i m attaching code and database files,kindly tell me the solution
    thanks
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured