Results 1 to 12 of 12

Thread: How to shift from straight query to parametrized one at module level

Threaded View

  1. Apr 20th, 2013, 12:21 AM #5
    ADQUSIT
    ADQUSIT is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2010
    Posts
    965

    Re: How to shift from straight query to parametrized one at module level

    Hi Kebo.

    Code:
    cmd.CommandText = "SELECT * FROM <tableName> WHERE Name=@name and City=@city"
    In this line of code, you have particularized 2 fields, received to the function. But in my case, everytime the function receives random number of fields, so how to cope with this?
    Last edited by ADQUSIT; Apr 20th, 2013 at 12:25 AM.
    Jmcilhinney post for Retrieving and Saving Data in Databases
    Browse Button
    Problem with Link in my signature
    GOT & LOST FOCUS, ENTER & LEAVE EVENT
    How to alter my DB Tables and add the old data into new structure table
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width