Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. SQL problem

SQL problem

Scheduled Pinned Locked Moved C#
databasecsharphelpquestion
4 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    printscreen12345
    wrote on last edited by
    #1

    Hi I have an SQL query which can be run in the Microsoft Visual C# 2005 Express Edition. But when I put that query in my program, it doesn't get run and it throws an exception saying "No given value for one or more required parameters". Anybody knows how it could happen? Thanks

    N G 2 Replies Last reply
    0
    • P printscreen12345

      Hi I have an SQL query which can be run in the Microsoft Visual C# 2005 Express Edition. But when I put that query in my program, it doesn't get run and it throws an exception saying "No given value for one or more required parameters". Anybody knows how it could happen? Thanks

      N Offline
      N Offline
      Not Active
      wrote on last edited by
      #2

      printscreen12345 wrote:

      "No given value for one or more required parameters". Anybody knows how it could happen?

      Just a guess, but I'd say you have parameters in your SQL statement that are not being set.


      only two letters away from being an asset

      M 1 Reply Last reply
      0
      • N Not Active

        printscreen12345 wrote:

        "No given value for one or more required parameters". Anybody knows how it could happen?

        Just a guess, but I'd say you have parameters in your SQL statement that are not being set.


        only two letters away from being an asset

        M Offline
        M Offline
        mikone
        wrote on last edited by
        #3

        it would be useful to: - know the query - know what you mean when talking about "my program" did you ever read this "how to ask questions the smart way"-guide? :P

        1 Reply Last reply
        0
        • P printscreen12345

          Hi I have an SQL query which can be run in the Microsoft Visual C# 2005 Express Edition. But when I put that query in my program, it doesn't get run and it throws an exception saying "No given value for one or more required parameters". Anybody knows how it could happen? Thanks

          G Offline
          G Offline
          gus_br
          wrote on last edited by
          #4

          did you try to debug your application and then take the generated SQL query to execute directly on SQL Server or "Server Connections" in VS, for instance?

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups