sql

  1. N

    Question SQL Update Query issue

    Hey guys, so I have a bit of problem regarding my current coding within my project, this issue being that I am struggling to get this code to run when trying to update an already existing record within an Access database, any assistance given would be highly appreciated...
  2. SmokyRick

    Answered Create Database problem in SQL

    I am currently going through a tutorial book called Visual Basic and Databases by Philip Conrod and Lou Tylee. I am doing well with it and learning a lot from it. However, I have got to a point where I can not figure out what my computer is doing. I am trying to create a database using the...
  3. D

    Question VS2013 Table Adapter Syntax Error: Expecting identifier or quoted identifier

    If I am posting this is the wrong area, I apologize. I am trying to add a table adapter to one of my datasets. The dataset has oracle as its datasource using ODP.NET. When I put in the query (which works elsewhere) I get this error (Syntax Error: Expecting identifier or quoted identifier)...
  4. H

    Question Recipes relationship diagram module.

    Hello people. I have been struggling for some time now with drawing up a relationship diagram module for my scenario. I have three tables as of now. 1) Recipes 2) Ingredients 3) RecipesIngredients Recipes --(one to many) ---|> RecipesIngredients <|-----(many to one) --- Ingredients...
  5. J

    ORA-00936: missing expression

    So below is the code I wrote yesterday. I don't often work in VB and I haven't had to insert a BLOB before. However, the error at least at this moment isn't BLOB specific but syntax. I'm getting the error from Oracle - 'Missing expression' I can't see what's missing but honestly I've been...
  6. M

    Question how to improve my code for loading more faster in datagrid view

    Dim db = New database Dim dt As New DataTable With db .sqlStr = "Select itemprod_id as ProductID, item_name as BrandName, item_description as ItemDescreption, company_id as Company, quantity_stock as Stock, stock_alertcntr as alert, wprice as CompanyPrice, price as RetailPrice...
  7. shawne

    Question SMO & System.Data.Sql.SqlDataSourceEnumerator broken in Windows 10?

    I have a dialog I wrote which is nothing more than a SQL server / database selector. It provides a graphical interface for a user to select their SQL server, database and authentication methods. Anyway, this worked fine prior to moving to Windows 10. Since moving to Windows 10 I'm unable to...
  8. K

    Question In Studio Express 2015 i get decimal with "." but in MySQL i get it in ","

    In Studio Express 2015 i get decimal with "." but in MySQL i get it in "," Hi All! I am writing an application where i can calculate different prices, but i hit a barrier. When i read values from the database they are displayed like "1,6" but when i convert it to Double to get another value...
  9. Hytek

    Question ASP.NET ODBC Query with String parameter

    I am using a tableadapter to query a database using ODBC. The query is being created by the VS2015 Query Builder. If I make the SQL statement with a variable parameter then the result comes back blank. If I replace the parameter (the question-mark) with a hardcoded parameter then the result...
  10. irvank

    Question Delay Upload Query

    Hi Guys, I have a question about .net programming, this is what i have to do i need to build a cashier app and this app have connection with sql server at other place, so the main point is can i keep the thing that have been sold when internet down, and when internet up its automatically...
  11. G

    Question update from sql table where maximum date

    I am building a VB.NET Windows Application form, and as a newbie cannot figure out an issue. I have two sql tables, which are not joined. I wish to update one (skedulering) from another (ontledings) where I have certain "WHERE" clauses as in the following code : opdraginvoer.Connection =...
  12. R

    Question Assign Sequence NextVal to textbox

    Hi guys I am designing a simple windows form application using typed datasets. My requirement is to assign a sequential value from a database SEQUENCE to one of the textboxes available with the form while default navigator "Save" button is clicked. My Database level Sequence name is...
  13. I

    Question Navigation Menu Question

    I have this database driven menu for a client, I don't remember why I set it up like this, but now they want a change that I can't seem to implement. Here's the code: Sub PopulateMenu() Dim dst As System.Data.DataSet = GetMenuData() For Each masterRow As System.Data.DataRow...
  14. 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...
  15. S

    Question SIMPLE question on JOINS, getting "NAME" from "ID"

    I really am trying to figure this out but just cannot get it right. I have 2 tables, "tblSalesMain" and "tblRepMain". I am trying to return to a combobox a reps first and last name instead of an "ID". For example, when a sale is selected it will show all of the info of the sale in different...
  16. C

    How to Insert String In To SQL Express Database Field

    Hello Community, I currently has a cluster of example code that I would like to combine. My current challenge is inserting a string from my GPIB bus into my SQL Database field. My working code looks something like this: Dim vpp1 As String vpp1 = GpibDevice.ReadString() MsgBox("Current Voltage...
  17. P

    Help me to deploy application with database

    I had a vb.net application with database connection. I am using Microsoft visual studio 2010 for developing windows application and Microsoft SQL Server 2008 for database access. My question is how to deploy the application and how to install it in other computers. I've tried a step but when...
  18. M

    Insert into single column multiple textboxes from WinForm

    Hi all, Maybe You will find a solution - how to save (insert into statement) multiple textboxes in one column in SQL table? Well, what I have is a winform with 20 textboxes (each is for one metric). Table is build like: Team | GSDate | GSGroup | GSMetric | GSValue |...
  19. Y

    Question How to import excel xlsx file to sql with changing header location and name

    How to import data from excel xlsx files to sql database if in some files the row and content of the headers are changing (even if they change they point the same data, see example)? I work in Visual basic environment with VS 2012 Here is the example: The problem is number of headers are...
  20. M

    Question Multi-completion of SQL table with form

    Hi everyone!, I'm trying to create a project, so that I will have the opportunity to refill the table on SQL server. The table is created and it has several columns. I searched the internet, but did not come across to the the solution I'm looking for. Maybe, I will explain first what would my...
Top Bottom