sql queries

  1. hpbhathiya

    Question SQL nonQuery execution error

    Dim cmd2 As New SqlCommand("INSERT INTO Passengers (FlightNo, TravelDate, FName, LName, Age, Gender, Class, SeatPref, MealPref, SSR, Status) VALUES ('" & flightNo & "','" & dateStr & "','" & fnametxt.Text & "','" & lnametxt.Text & "','" & agetxt.Text & "','" & genderdropdown.Text & "','" &...
    • hpbhathiya
    • Thread
    • mssql sql connection sql queries visual basic 2005
    • Replies: 2
    • Forum: SQL Server
  2. B

    Stored Procedure Problem

    First post here.. So here is the thing, I'm working on a school project which is a fleet-management system with GPS-devices. No problems so far, the GPS etc is working like a charm. I'm currently working on charts, to which i need to fill a xml file from a datatable. The chart I want to make...
    • bbbarry
    • Thread
    • sql sql queries sql server 2005
    • Replies: 1
    • Forum: SQL Server
  3. tgf-47

    Question How do I use variables in a SQL statement

    I got this in my SQL statement. I "BOLDED" the problem. SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders WHERE CustomerID = @CustomerID I saw a video tutorial...
    • tgf-47
    • Thread
    • sql sql queries vb.net 2008
    • Replies: 1
    • Forum: ADO.NET
  4. S

    Active Query Builder .NET Edition 1.9 is released

    Active Database Software announces the new version of Active Query Builder .NET Edition, the leading solution for SQL query building, parsing, analysis and modification. Active Query Builder .NET Edition allows your end-users to build complex SQL queries via an intuitive visual interface. It's...
Back
Top