42 Topics

Member Avatar for
Member Avatar for Mike Askew

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 …

Member Avatar for Carmelo_1
0
13K
Member Avatar for ddanbe

After reading this excellent [code snippet](https://www.daniweb.com/software-development/csharp/code/492766/display-excel-data-in-a-datagridview) by djjeavons, and just trying to learn WPF, I decided: "Well, let's translate that to WPF!". It was a bit harder than I thought, but a great learning experience! Her's how my screen in action looks: ![WPFscreen.png](/attachments/small/1/ac05d33ccd8a190d0576fa063e54749f.png "align-left") Things that changed compared to the …

Member Avatar for ddanbe
1
538
Member Avatar for dennis254

Hi, I have been looking for several hours for code that automatically checks if Microsoft acess database engine is installed. If not it reinstalls the database driver by first detecting architechture(32/64 bit). It then automatically installs the driver. I am using Ms Access database 2007 as data source for my …

Member Avatar for cgeier
0
1K
Member Avatar for vickey66

Hi, I am new to VB programming. I am using Aceess 2010 database with VB 2010. I have one main table which stores information of company details. The details are broken down in seven different tables with codes to avoid data duplication and keep the main table less bulky. e.g. …

Member Avatar for vickey66
0
297
Member Avatar for babyluxe03

Im having difficulties in making a connection with my database. Can someone help me to resolve my problem. It says "Unrecognized database file format". I am using vb2010 ultimate and ms acess2013. :(

Member Avatar for cgeier
0
165
Member Avatar for Begginnerdev

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 …

Member Avatar for Reverend Jim
2
873
Member Avatar for kindofsudden

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, " & _ …

Member Avatar for kindofsudden
0
249
Member Avatar for Ancient Dragon

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 …

Member Avatar for Ancient Dragon
0
831
Member Avatar for pwolf

I have been trying to get my database insert and delete to work for a long time now, and I still cant get it working. I now have just 2 hours left before I absolutely have to have it finished and I can only insert numeric values. I suspect im …

Member Avatar for pwolf
0
225
Member Avatar for collin_ola

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 …

Member Avatar for Reverend Jim
0
5K
Member Avatar for P.manidas

Dear sir/Madam, In my codes CmdDisplay button display only first record from the table and button2 add the all name (Ename field) to combobox1 from the table. How can i show FirstRecord, PreviousRecord, NextRecord and LastRecord using OleDbCommand and OleDBdataReader. Please guide me. [CODE] Dim cn As OleDbConnection Dim cmd …

Member Avatar for G_Waddell
0
2K
Member Avatar for dhani09

Hi, I have a database (OLEDB) on which i perform operations like insert, delete and update. When i carry out these operations, the changes are reflected in the database during runtime but when i close the form everything goes back to normal. How can i get these modifications to relfect …

Member Avatar for dhani09
0
209
Member Avatar for Baradaran

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 …

Member Avatar for Baradaran
0
230
Member Avatar for ImZick

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.

Member Avatar for ImZick
0
173
Member Avatar for Tobyjug2222

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 …

Member Avatar for Tobyjug2222
0
569
Member Avatar for tet3828

I can't seem to wrap my head around this. I'll need a seasoned programmer to push in the right direction. I have a listView with 7 sub items. What I'm looking to do is populate a table in an .mdb file with the data. The listView box is almost the …

Member Avatar for riahc3
0
220
Member Avatar for //Gonz

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 …

Member Avatar for //Gonz
0
283
Member Avatar for mohana_61

hey, i need to insert a row into datagridview meanwhile it has to be updated in the database(backend) using oledb. thanks inadvance

Member Avatar for Begginnerdev
0
156
Member Avatar for G_Waddell

Hi, I've written a routine for a customer to import sales orders into their Sage system. Everything was going well but the client has come back with a particular excel sheet that is not importing. He is getting a message to tell him the sheet is not in a valid …

Member Avatar for G_Waddell
0
505
Member Avatar for superjj

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 …

Member Avatar for superjj
0
257
Member Avatar for crazyvonzipper

Dear Daniweb members. I am having quite a troublesome time here with OleDb. What I am trying to achieve is to allow my users to connect to an uploaded Excel workbook, then to be able to select data from the sheets. I have a query designer in the front end …

0
171
Member Avatar for ashley24

Imports System.Data.SqlClient Imports System Imports System.Data Imports System.Collections Imports System.Windows.Forms Imports System.Resources Imports System.Data.OleDb Imports System.Drawing Imports System.Net.Mail Imports System.Configuration Imports System.Web Imports System.Web.Security Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.WebParts Imports System.Web.UI.HtmlControls Public Class Form1 Inherits System.Windows.Forms.Form Dim counter As Int32 = 0 Private Sub Form1_Load(ByVal sender As System.Object, ByVal …

Member Avatar for M.Waqas Aslam
0
2K
Member Avatar for mhmd3210

In C# ... How can i search my access database by some column(other than the primary key).. for example if i want user to search entries by Entring last name in a textbox .. and this could have more than one entry and show the results in the grid view …

Member Avatar for Mitja Bonca
0
197
Member Avatar for clausont

I asked this basic question a couple of days ago but I probably didn't include enough information in my question. Sorry for reposting, but I am really lost here. This is a web application in VB.net connecting to an Access database on a 2003 server. The problem: I have a …

Member Avatar for clausont
0
228
Member Avatar for Bheeman89

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 …

Member Avatar for Jx_Man
0
269
Member Avatar for jbutardo

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 …

Member Avatar for jbutardo
0
1K
Member Avatar for jbutardo

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 …

Member Avatar for jbutardo
0
245
Member Avatar for Peter Hers

Hi Looking for some general advice: I have taken over support of a large and complex web site, which uses multiple Access databases. At present it makes use of the MS Jet database engine (Provider=Microsoft.Jet.OLEDB.4.0). (as well as MySQL, used in a Snitz forum). After solving many specific problems I …

Member Avatar for ChrisPadgham
0
279
Member Avatar for galhajaj

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 …

Member Avatar for thines01
0
194
Member Avatar for AndyPants

Hello, im working on a project that works with an access database but i dont know how to edit an existing record... here is the code that i use for reading the database: [CODE]Public Function ask() Dim dt As New DataTable Dim ds As New DataSet ds.Tables.Add(dt) con.Open() Dim da …

Member Avatar for AndyPants
0
176

The End.