sql command

  1. musimu

    Question Need help in SQL format please

    Below is a SQL sql query that I want to run in vb.net. How should I be writing this SQL to be accepted in VB.net please? Select F.CF_ITEM_NAME As Folder_Name, r.RN_CYCLE_ID As Test_Set_Id, t.ts_name As Instance, "test_set_folder"."CF_ITEM_NAME" AS "Test Set Folder 1", "test_set"."CY_CYCLE"...
  2. K

    SQL - Between Command - Date range

    Hi, VB.net 2010, Windows 7 I need to filter records according date Range from mysql table. I tried to use following command. Public DtRpt As New DataTable("DTReport") DtRpt = Nothing DtRpt = GetDataFromTable("SELECT * FROM tblTransaction WHERE TransDate BETWEEN '" & DTPFrom.Value & "' AND '"...
    • kelum2000
    • Thread
    • data access sql command
    • Replies: 2
    • Forum: MySQL
  3. C

    Question Exporting SQL data to Word

    Hello, My aim is to export data from my SQL database into a word document. I have managed to export data into the word document from my database however if I was to go back onto the word form and type another service ID from the database and click export to word document it would export the...
    • cooxy
    • Thread
    • dataset sql sql command word export
    • Replies: 2
    • Forum: MySQL
Back
Top