42 Topics
|
|
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 … |
|
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 … |
|
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 … |
|
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. … |
|
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. :( |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
hey, i need to insert a row into datagridview meanwhile it has to be updated in the database(backend) using oledb. thanks inadvance |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 … |
The End.