18 Solved Topics
Remove Filter | |
I am currently creating a product lookup system for a project of mine, however from reading around it has come to my attention that an OLEDB connection will not handle the SQL query below as it will not handle more than a simple "SELECT, FROM". Table: tbl_ProductInformation Field: Product_Name CurrentEntry … | |
Hello everyone! I am posting this code for anyone who may be having issues with connecting to a database. Feel free to use this code as you wish. This will be using the OLEDB library. [CODE] 'Imports Imports System.Data.OleDb Public Class Form1 'Declarations Dim con As OleDbConnection Dim cmd As … | |
Okay, I'm pulling my hair out. I'm getting NO error on the following code: Dim cmd As New OleDb.OleDbCommand("CREATE TABLE [" + empTableName + "] ([ID] DOUBLE, " & _ "[LnameFname] TEXT(255), " & _ "[Location] TEXT(255), " & _ "[SalaryOld] DOUBLE, " & _ "[FtePercentage] DOUBLE, " & _ … | |
I have the code below in VS 2012. It dynamically allocates a DataGridView and an Update button, then it binds the grid to MS Access database table. That all works well. When I click the Update button btnUpdate_Click() is called, which calls the DataAdapter's Update() method. That produces the syntax … | |
Hi, I seem to be having a problem when attempting to insert a new record into my database through vb.net. From what I can gather, there seems to be an error in the code that the command builder (cBuilder) is creating for me. Here's a copy of the code for … | |
I am totally new to vb.net, still I am planning to try it for a project, in which there will be standalone machine using an access database to query and update different tables. While in VB6 I was able to define recordsets using Microsoft.jet.oledb.4.0, in VB.net I have become a … | |
Hi guys need help again hope you can help me.. I have a database and i want to Compute all the Total Calls of my 2nd Column I wonder how can i do that? can you give me an example? I'm using Oledb Connection? Thanks in advance. | |
Hey Guys, I'm an A level student studdying Computer science, and hence using VB.NET for my coursework. Therefore I'm very novice at VB! While trying to update Data in a Microsoft Office, Access table (Office 2010) - I get this error. (In VB) Bare in mind, I've read all this … | |
Hello all I am writing a solicitor allocation application that will be used by multiple users at one time. Because of this, the database needs to be updated with every change. This is my code when a solicitor is chosen for allocation: private void FindSolicitor(int type, bool stype) { table … | |
Hoi At the moment I'm learing Databases. this is some code that I'm using. The question that I have is, can I insert a row without ID. I mean that the database increase the ID number itself. Thanks in advance. command = new OleDbCommand(); command.Connection = connect; command.CommandText = "INSERT … | |
Hello Friends. Im having a problem in identifying the Provider for my MSSQL Server 2008. Can anyone address me the location of this information because I have to initialize it in my VB.et. As I understand for Ms Access it is something like [CODE]"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="[/CODE] Can I know where to … | |
Hi, I have this program that uses OLEDB connection to import excel file to data table then use it in other functions. Now I have this question: What are the possible limitations of OLEDB when it reads the Excel file. The File is on xls format, and I want to … | |
Hi, I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data. Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection … | |
Hello! i wanna to create a game that will use a mdb database file to store things and upload them while the gema will need them the thing is i dont want that the player could touch the file and easily cnange things with access.. there is a way to … | |
I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the … | |
The program is currently trying to pull information from three different database tables and compiling the information onto one screen, to do this i am using three different connections and a function to handle the data at each stage. The issue is as my code hits PageLoadStage of "2" and … | |
what's up when i call the function below i get an error that says that oledb is not regstered on this machine i am calling the function like this [CODE] ListBox1.Items.Add(getAllTableNames) [/CODE] [CODE] Public Shared Function getAllTableNames() As String() Dim con As OleDb.OleDbConnection Dim com As New OleDbCommand Dim i … | |
As the title suggests, i am trying to pull a bitmap image stored in a table location with an OLEObject type to my picture box on the form. The code i am using is as following: [CODE=VB.NET]img_ProductPicture.Image = DS.Tables("LocationInfo").Rows(0).Item(5)[/CODE] The error i am receiving is an InvalidCastException: Unable to cast … |
The End.