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 & "','" &...
  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...
  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...
  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...