Link to home
Start Free TrialLog in
Avatar of mathieu_cupryk
mathieu_cuprykFlag for Canada

asked on

Need to put from vb.net to sql format.

 I would like to put the following in a sql format. If someone can help me that would be awesome.


 Public Function GetTicketDevices(ByVal ticketID As String) As SqlDataReader
        Dim sql As New StringBuilder()
        sql.Append("SELECT  TOP 100 ")
        sql.Append("tbl_index_ticket_devices.TicketSolutionComponentIndexID, ")
        sql.Append("tbl_index_ticket_devices.DeviceID, ")
        sql.Append("tbl_index_ticket_devices.TicketID, ")
        sql.Append("tbl_index_ticket_devices.DateAdded, ")
        sql.Append("tbl_index_ticket_devices.AgentAdded, ")
        sql.Append("tbl_company.Company, ")
        sql.Append("tbl_devices.DeviceID, ")
        sql.Append("tbl_devices.FriendlyName, ")
        sql.Append("tbl_lookup_type_devices.DeviceVendor, ")
        sql.Append("tbl_lookup_type_devices.DeviceModel, ")
        sql.Append("tbl_lookup_type_devices.DeviceDescription ")
        sql.Append("FROM tbl_devices ")
        sql.Append("Join tbl_index_ticket_devices ")
        sql.Append("ON tbl_devices.DeviceID = tbl_index_ticket_devices.DeviceID ")
        sql.Append("Join tbl_company ")
        sql.Append("ON tbl_devices.EnterpriseID = tbl_company.EnterpriseID ")
        sql.Append("Join tbl_lookup_type_devices ")
        sql.Append("ON tbl_devices.DeviceTypeID = tbl_lookup_type_devices.DeviceTypeID ")
        sql.Append("WHERE tbl_index_ticket_devices.TicketID = '" & ticketID & "' ")
        sql.Append("ORDER BY tbl_index_ticket_devices.DateAdded ")
        Dim dr As SqlDataReader
        Dim conn As New SqlConnection(connectionString)
        If conn.State <> ConnectionState.Open Then conn.Open()
        Dim cmd As New SqlCommand(sql.ToString(), conn)
        cmd.CommandTimeout = 900
        dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
        SqlConnection.ClearPool(conn)
        Return dr
ASKER CERTIFIED SOLUTION
Avatar of wht1986
wht1986
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mathieu_cupryk

ASKER

both of u are on the right track just the ticket ID need to be created,