Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: Need Help IN VB.net

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorhardy
    • CommentTimeNov 2nd 2006
     
    SELECT
    Type,
    Delivary_Date,
    Author,
    Address,
    Ph_No
    FROM
    request
    WHERE
    (? LIKE ?) ORDER BY Type

    This is the quarry I wrote in the data adapter, and the corresponding code in the form is

    OleDbDataAdapter5.selectcommand.parameters(0).value=text1.text
    OleDbDataAdapter5.selectcommand.parameters(1).value=text2.text
    OleDbDataAdapter5.Fill(DataSet71)


    But it is not working with the First Parameter. If I write

    SELECT
    Type,
    Delivary_Date,
    Author,
    Address,
    Ph_No
    FROM
    request
    WHERE
    (Author LIKE ?) ORDER BY Type

    It is working, I mean to say , this type of quarry is working with only one parameter. Plz give me an alternate solution.
  2.  
    hI,

    dO SOME THING LIKE THIS, Create a string and put your sql query in to it and then execute it. This is how i do in Ado Record set. Just try this in your application.

    for instance if there are 4 or more options you have give to the user what i do is.

    strSql = soemSqlQuerry & Where condition & more where condition


    and then exequte this sql. I dont use command object.

    I use Command object for SP's alone.

    Hope this will solve your problem

1 to 2 of 2

  1.