Customise SQL Query RRS feed

  • General discussion

  • Actually my code is like


    da As New OleDb.OleDbDataAdapter("SELECT * FROM EmpDetails WHERE department='Production'", cnn)

    Now I want customise query means I want to take column name & search kewords through textbox,
    If I am getting variables through Textbox it will give me String in "Column Name" but after WHERE I require variable in single quote 'Search Keyword' , So how can I conver "String Variable" in to 'String Variable'
    • Moved by Paul Zhou Monday, November 28, 2011 5:25 AM move for better support (From:Common Language Runtime)
    Sunday, November 27, 2011 6:42 AM

All replies